Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
What and Where Spent With Supplier
03-16-2018, 11:33 PM, (This post was last modified: 03-17-2018, 01:08 AM by VortecCPI.)
What and Where Spent With Supplier
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?

Messages In This Thread
What and Where Spent With Supplier - by VortecCPI - 03-16-2018, 11:33 PM

Forum Jump:

Users browsing this thread: 1 Guest(s)