Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
FIFO Calculation in Netsuite
Hi All,
We have tested item using FIFO costing method.
I have set up in accounting preference> item inventory for FIFO
In Inventory Item using FIFO method.
I am using dummy data/ amount.
1st Inventory Balance
01/01.2026 quantity: 1000 and unit price 500,000 = 500,000,000
Inventory In
10/01/2026 quantity 300 and unit price 550,000 = 165,000,000
then Inventory out
12/01/2026 quantity 500 means -500 took the first price e.g 500,000
on 12/01/2026 inventory out -550 means
500 * 500,000 = 250,000,000
50*550,000 = 27,500,000
Total = 277,500,000
but why in the report: inventory valuation shown 282,500,000 ?
Did i do the wrong calculation ?
0