webERP Forum
What and Where Spent With Supplier - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: How To ? (/forumdisplay.php?fid=6)
+--- Thread: What and Where Spent With Supplier (/showthread.php?tid=8139)



What and Where Spent With Supplier - VortecCPI - 03-16-2018 11:33 PM

Before I try to do this on my own I figured I would ask in here first...

Here is what I need... Total spend with Supplier with breakdown as follows:

+ Amount applicable to Sales Orders
+ Amount applicable to Promotions
+ Amount applicable to Inventory

Getting Amounts for Sales Orders is easy via Cost of Sales (4900+5000-5200).
Getting Amounts for Promotions is easy via Promotion (6150).

Getting Amounts for Inventory is easy via Finished Goods Inventory (1460) BUT the results do not match a hand calculation of Total Spend - Sales Orders - Promotions. The numbers from 1460 are slightly lower for some reason.

Am I missing something here? Is this an Item Cost vs. Item Value issue? Could I have an error in my GL Journal?


RE: What and Where Spent With Supplier - VortecCPI - 03-19-2018 08:15 AM

This was a Cost vs. Value issue. The Supplier had a price mistake (too low) and when i received the goods the new price was used to value the inventory item.

The good news is this is exactly how the system should have worked and it did. The value of our inventory is actually higher than the cost of all the line items on all the POs.

Very good little lesson for me right there!