Hi there,
To those who have undoubtedly treaded 1000 steps ahead of me...:
What I am doing:
Building my own sales report by going directly into the database and using a selection of tables.
My report needs to answer:
"what are we selling, to whom, from what location and which is the most profitable"
My Question simply is...
Which are the main fact tables to use in order to create this report
A History of what tried:
- First I used the Sales History table. But in this table, there were a lot of Items which had zero cost. Which obviously isn't helpful when you need to report on margin.
- So then I read these articles here and here, and saw that the "Shipping Table" (Posting Journal table) has more information about cost. Hooray.
- But then I saw that although the total revenue from sold items in both tables (Sales History and Posting Journal) matched, the total qty of sold items differed. I had more in my Sales History table.
- So then I posted a question here about how the SalesHistory and PostingJournal work together, I was way off track, and Dana B. Stidsen kindly put me back.
- And now my question remains, which fact table do I use, if not SalseHistory or the PostingJournals, to create the report I need to create.
As always, thank you to anyone who got to the bottom of my thread.
Michelle