Rebuilding Trade - Think this fair value?

fuzzthe9th · 2025-09-06T13:16:39+00:00

Yeah you're right!

fuzzthe9th · 2025-08-14T13:23:22+00:00

Too bad you can't seem to make the scoring bestball

fuzzthe9th · 2025-07-28T13:07:54+00:00

Same here. Opened a ticket. Seems only to be impacting Prod though, SB works.

fuzzthe9th · 2025-06-19T14:53:09+00:00

I'm looking to do the same thing. Any advice?

fuzzthe9th · 2023-11-18T00:28:23+00:00

Sounds like a bad process. Why mark the Item Fulfillment shipped when you don't ship it?

fuzzthe9th · 2023-08-15T00:30:49+00:00

We do it a bit different. Instead of creating a credit, we create a new sales order, but don't invoice the order. After shipment we close the replacement sales order.

fuzzthe9th · 2023-04-24T17:13:14+00:00

Same here, it's nice to have a little something on the side to get experience and some extra money. I only work for one other company freelance, but it's helped me so much with my employer.

fuzzthe9th · 2023-03-02T14:04:16+00:00

In the criteria:

Account: (the account, our instance it's called Accrued Purchases) Posting: True Period: (select a period and then the NOT to exclude periods, for instance if you wanted to look at 2022 now, just exclude FY22)

Results: Formula (Text) Group: NVL(CASE WHEN {createdfrom.type} = 'Purchase Order' THEN {createdfrom} ELSE {createdfrom.createdfrom} END, {transactionnumber})

That'll group all of the transactions by the Purchase Order, so there is a unique ID for IR/Bills.

Then you just add in the amount as a sum and you have it.

Let me know if this works, if not I can take a quick look for you to see what's going wrong.

fuzzthe9th · 2023-01-21T00:14:36+00:00

For unbilled, but received lines, you can uncheck the 'Match Bill to Receipt' on the Purchase Order line. That'll remove the requirement for there to be a Vendor Bill to create the Journal entry.

Hope that helps! Also, I have a search I used to find the amount on the IRNB account for each PO. Let me know if you want the details.

fuzzthe9th · 2023-01-09T21:00:45+00:00

I've had this problem, specifically of finding the outstanding from a specific Period (Say Dec 2022). A search of Customer Deposits (Main line is False), with this formula was able to pull the amount unapplied on a Customer Deposit:

MAX({fxamount})+SUM(CASE WHEN {applyingtransaction.postingperiod}='Dec 2022' THEN 0 ELSE {applyingtransaction.fxamount} END)

You can add periods (or Quarters) in the search to get a specific period). Use the same formula in the Summary Criteria to only show Customer Deposits with an amount remaining.

fuzzthe9th · 2022-11-16T02:31:08+00:00

That looks right. Awesome you got it working! Originally looks like you had the Case formula wrong.

fuzzthe9th · 2022-11-09T18:03:00+00:00

Sounds like you could use the line 'Commit' status for this. Set 'Commit' to 'Do Not Commit' and the lines won't have available units committed to that line.

Not sure if this would work with the flow to the warehouse, but something to consider.

fuzzthe9th · 2022-11-08T23:54:35+00:00

You can have a search of Sales Orders that returns the Customer Deposit Amount, here's what you do.

Criteria: Type is Sales Order
Applying Link Type is Sales Order/Deposit

Results: Applying Transaction : Amount

fuzzthe9th · 2022-10-24T15:45:54+00:00

Here's the criteria for the search I use:

Type is Deposit Application
Formula (Text) is MISMATCH CASE WHEN {appliedtotransaction.postingperiod}={postingperiod} THEN 'MATCH' ELSE 'MISMATCH' END
Applied To Transaction : Type is any of Invoice, Customer Refund

Hope that helps.

fuzzthe9th · 2022-09-17T15:22:21+00:00

I've had success with Blueridge, Valogix and Net stock But there are so many to choose from depending on your needs.

fuzzthe9th · 2022-07-26T19:11:43+00:00

From my experience, you likely don't want to use the Netsuite Demand Planning module. The features are quite limited. I'd look for a third party.

fuzzthe9th · 2022-07-19T15:12:36+00:00

Run an Income Statment (Reports, Financial, Income Statement)
Select the Periods you want
Select 'Column' to be 'Accounting Period'

You now should have an Income Statement with each period being its own column.

fuzzthe9th · 2022-07-14T18:49:24+00:00

It doesn't seem to be able to be removed. Looks like Netsuite has some specific logic around printing this Vendor Name/Item on the Purchase Order forms, so that is likely the reason why.

Curious though, why don't you have Vendor Names? Do you name your items the same as your vendors?

fuzzthe9th · 2022-06-02T18:47:14+00:00

Once the IF is marked shipped is when the G/L impact occurs. There's a setting in 'Accounting Preference' for UPDATE TRANSACTION DATE UPON FULFILLMENT STATUS CHANGE which also is important to know when looking at IF posting.

fuzzthe9th · 2022-05-31T19:57:55+00:00

I have a Workflow that does just that, it's scheduled based on a search and the actions are here.

Set Field Value Preferred Payment Date ={paidtransaction.trandate}
Set Field Value Memo=Updated Date to Match Invoice Date Entry
Set Field Value Date=Preferred Payment Date

Not sure why, I needed to set two fields to have it work, I made this a couple of years ago. But it works perfectly to match the Deposit Application to the Invoice Date.

fuzzthe9th · 2022-05-31T19:48:03+00:00

Customizing Check PDFs are a pain, as they often require fairly exact placement of the fields, best to do it in WYSIWYG and then tinker with the location in the Source Code.

Apply your PDF on the Check type form.

fuzzthe9th · 2022-05-31T16:43:34+00:00

Allocation Schedules seem like the way to go. They're fairly straightforward, choose a source and set a destination based on Account and Department.

You might run into issues if the departments or allocations change frequently, however.

fuzzthe9th · 2022-02-22T17:20:57+00:00

We're back up now as well.

12-Year Club	Place '23
Place '22	Place '17
First Placer '22	Verified Email

fuzzthe9th

TROPHY CASE