webERP Forum

Full Version: What and Where Spent With Supplier
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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?
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!
Reference URL's