Hi everyone - I am trying to figure out how to extract something from Netsuite and so far we are stumped. I was wondering if you all might be able to help. Basically, I want to extract COGS data via a saved search that looks at our inventory balance sheet ledger and splits out the data into single line items (see pic below) for each product x region that we have, daily. From what I understand, the way that Netsuite aggregates the data, it calcs everything and then generates a final running value for the ledger, but what I would need is the intermediary part of the calculation before it is completely aggregated up. The data is all in there, so I know it must be possible somehow to do this, but ideally, I want to avoid having to go into the 1000s of individual tables and re-calculate all the inventory balancing that Netsuite has already done in order to give us our total number... Any help would be massively appreciated!!

Hey. It's not fully clear to me what you're asking for. It's a report of all items sold within a certain time frame with the units sold but then the COGS amounts of those units that were sold? So it's a combination of fulfillment info (for units sold) and then tracing those items back to their receipts for the costs? Are these lot/serial items? Or you can't trace the costs back to the specific units sold but rather you need an average? fifo/lifo? But perhaps this isn't what you're asking for.

I sense it's a combination of SA32289 for the financial COGS and the for Inventory SOH SUMOVER technique

Thank you both! We will try your suggestion above re SOH SUMOVER and the SA32289 report and let you know if that worked! Anthony, to answer your question, I am basically trying to get what you described, a report of fulfilled items and the the costs of fulfilling them on a daily basis, with each product & country permutation broken out. In terms of averaging, I would just want the average cost per item x location per day, even if there were multiple transactions for the same item with different associated costs. This basically exists in the form of the p&l, but I understand from my team that we can't get the breakdown of the different line items that go into the COGs value separated by individual item and country. They also mentioned that the period of the P&L is not possible to split into a daily view. They suggested the inventory ledger as the place to look instead. I'm not sure what you mean re lot / serial items?