has anyone experienced COGS issues using Lot Numbe...
# inventoryb
blue
03/30/2021, 9:55 AMhas anyone experienced COGS issues using Lot Numbered Costing method? My COGS in my Item Fulfillments always uses Average Cost despite the Item record using Lot Numbered costing method. Ex. I tried receiving quantities in three lots then selling from 1 lot but the COGS is computed based on the avg cost of the three lots, not based on that specific lot.
k
KevinJ of Kansas
03/30/2021, 12:20 PMHow long did you give it to compute?
KevinJ of Kansas
03/30/2021, 12:20 PMAny costing calculations running in a closed period?
b
blue
03/30/2021, 12:25 PMThe transactions were made about 2 hours ago and in the Inventory Costing Preferences, I have the costing calculation set to After Transaction Entry. Am I supposed to run the closing task for the COGS to appear correctly?
k
KevinJ of Kansas
03/30/2021, 1:33 PMNo.
KevinJ of Kansas
03/30/2021, 1:33 PMSometimes the costing engine takeas a while to run - this is doubly true if using Lot, Serial, FIFO, or LIFO settings
KevinJ of Kansas
03/30/2021, 1:34 PMDoes your account that you are doing this in have older transactions?
KevinJ of Kansas
03/30/2021, 1:34 PMCosting Engine runs sequentially. If its stuck on an earlier transaction, it won't process on your newer ones.
b
blue
03/30/2021, 1:37 PMI'm not sure if previous periods still have pending cost engine calculations. Is there any way to check that? In the period I'm working on, if I check the Review Inventory Cost Accounting closing task, there are no items left for cost calculation.
blue
03/30/2021, 1:39 PMnever mind it's updated now. I guess it just takes a while. Any tips on how to monitor the cost engine calculation?
k
KevinJ of Kansas
03/30/2021, 1:43 PMThat's probably easiest way to check - the other way to do that is to run an inventory valuation report with report title displayed
b
blue
03/30/2021, 1:50 PMCan you elaborate more on how the inventory valuation report helps check the cost calculations? It might be difficult to check valuation per transaction if there's a lot. Also what do you mean with report title displayed?
k
KevinJ of Kansas
03/30/2021, 1:51 PMSearch in Suite answers for how to check. I don't know the SA article number.
b
blue
03/30/2021, 1:57 PMI'll have a look thanks for the tips
blue
03/30/2021, 1:59 PMI think I found what you're talking about SA 21161
blue
03/30/2021, 2:01 PMJust tried it out and it does say it in the report. Neat trick! 👍
a
Adam K
04/01/2021, 4:01 AMoften add on the Item Record per location the field cost accounting status...
b
blue
04/01/2021, 5:15 AMthanks! will explore it too
2 Views