I need some advice for my inventory report..
I need to compare inventory values between BigCommerce and Acumatica to make sure I see any discrepancies. The problem is that in BigCommerce I see the parent SKU... not the child SKUs that the acumatica is presenting. So if I saw this in Acumatica:
01-10-0001-LG-BK-NP-C = 1
01-10-0001-LG-CH-NP-C = 0
01-10-0001-LG-DCB-NP-C = 12
01-10-0001-LG-TO-NP-C = 5
01-10-0001-MD-BK-NP-C = 1
01-10-0001-MD-CH-NP-C = 1
In BigCommerce it would show this:
01-10-0001 = 20
So I need the data from Acumatica that matches the data in that CSV from BigCommerce. I need some sort of automated report that is fairly straightforward to run that will show me the available inventory for in Acumatica and also the Inventory for the variations in BigCommerce.
Any idea how I can aggregate this?
Best answer by smarenichView original