Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #1
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?

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


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

Forum Jump:


User(s) browsing this thread: 1 Guest(s)