We use FIFO account method and found this on a recent fulfillment when looking at the GL Impact.
We sold 5000 of an item. Most of the time we purchase them for .34 each. There was one instance where we needed to pay .4808 ea for 1000 of them due to a freight matter. On the GL impact Netsuite used a price of .4808 for COGS for the entire 5000 even though we had only brought 1000 of them into inventory at that price. Therefore Netsuite is overstating the COGS in the general ledger.
Has anyone else found this to be an issue and is there a resolution? This appears to be a major flaw in Netsuite reporting and creates doubt that the data that we review and report is correct coming from this platform.