This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hey guys, I noticed COGS\Inventory Asset Account gets updated as soon as the Item Fulfillment is created, opposed to when the IF becomes shipped.  Does anyone know if there is a setting or some way to change that?  I don't want these accounts to be updated until we actually deduct the quantity from inventory which only happens once the IF becomes shipped.  I also want to get the COST at the time it ships, rather than at the item the IF was created.

The "Posting" should equal No on the GL Impact screen upon IF creation.  When it's marked as Shipped it becomes Yes and that is when inventory is reduced and cost allocated

<@UB67425QA> thanks, that's helpful, but what if the Average cost of the item has changed from when the IF was created?  When the "posting" becomes YES, it doesn't seem to get a new cost

my scenario is that an IF is created for an assembly on 8/1 and the cost says 0, on 8/2 an assembly build is created, and later in the day on 8/2 the IF becomes shipped

The order goes in with a 0 cost, as if i went to a negative position.  Netsuite does go back and adjust the account, but the transaction looks like it had a 0 cost

<@UHQ6BDUAX> check the Assembly, you will see a "Cost of Sales" adjustment. Essentially, the COGS gets posted there, rather than the IF

<@UDJDXB0EB> Thanks, I see that too, but doing an inventory valuation of the Assembly, or checking the gross profit of the invoice still shows the cost of the item on 8/1, which was 0, as opposed to the cost on 8/2 when the IF became shipped.

Netsuite is updating the accounts correctly, so my asset account and COGS are correct in total, but analyzing the item or the transaction doesn't get me good data

There are no options/settings for NS to behave differently

any way to go back, or manually specify the cost at the time of the transaction?

myeah a worksheet. Or if you delete both transactions and recreate them in order, so the stock is correct before the IF occurs... neither very attractive options

yuck, i've thought about both already....at least option 2 is scriptable.  Worksheets still can't be scripted from what I can tell.

i considered option 3, also gross, a custom transaction to replace item fulfillment....yuck.

was hoping some magical checkbox out there would solve this for me...

<@UHQ6BDUAX> I'm guessing you have "Items" that need work orders to assemble and put into inventory before Fulfillment ? Do you have to create the IF before you do the assembly? A bit odd that you'd have to begin the IF process before an item is built/ assembled?

<@UC5J25UQ4> So that's my underlying problem that I ultimately need to resolve.  We create IFs before WOs are actually built because of time constraints.  We need the IFs to generate UCC labels which is where we need to focus.  If we can change our shipping process based off of some custom record that exists BEFORE the IF and only have IFs created once it's shipped, then our costing would be correct.  I was really just hoping there was something in netsuite that would allow me to choose at which status of the IF we should actually put the GL entries in.  Looks like I can't change that....oh well, thanks all for the help