What and Where Spent With Supplier

[VortecCPI]

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?