I have an Inventory table that keeps records of goods. It includes [manufacturer],[Quantity],[Cost],[Item #], Description],[sold to #] and so on.............
Then I have a Sales Table that controls the customer's data such as [sales order #][customer name],[address],[sales date],[tax],[unit selling price],[extended price],[sale total], [fabric protection],[deposit],[balance] and so on....
the two tables are related in that [sales order #]from sales table <--->[Sold to #] from Inventory table.......with that relationship i can basically mark and item sold form the inventory table from the sales table..
Anyhow.... What i would like to do in my reporting is the following.
I want to create a Daily sales report that is done Daily based on the dates of the sales order date. And also a report that does a weekly report.
What I would like the report to have is an amount of total Sales for that Day, what the cost of those goods are, the profit, the % of profit, total deposits, total balances, total frabic protection sold.
here are the basic mathematical thinking that i am following.
to get Daily Sales Totals I would just do a Sum[Sales Total]
to get The Cost of sold goods would be something like Sum[sold goods cost]
to get the Gross Profit it would be something like [Sales Totals] - [sold goods cost]
to get the Gross % Margin =([sales totals]-[sold goods cost]) / [sales total] * 100
then at the bottom of the report i would like to have a total to date of total sales and totals of every thing....
and so on..they are really basic things.. but i just cant figure out how to put it all together..
it would be nice to have a report that i just click on and tell me this stuff in a nice, neat and organized matter....
Then I have a Sales Table that controls the customer's data such as [sales order #][customer name],[address],[sales date],[tax],[unit selling price],[extended price],[sale total], [fabric protection],[deposit],[balance] and so on....
the two tables are related in that [sales order #]from sales table <--->[Sold to #] from Inventory table.......with that relationship i can basically mark and item sold form the inventory table from the sales table..
Anyhow.... What i would like to do in my reporting is the following.
I want to create a Daily sales report that is done Daily based on the dates of the sales order date. And also a report that does a weekly report.
What I would like the report to have is an amount of total Sales for that Day, what the cost of those goods are, the profit, the % of profit, total deposits, total balances, total frabic protection sold.
here are the basic mathematical thinking that i am following.
to get Daily Sales Totals I would just do a Sum[Sales Total]
to get The Cost of sold goods would be something like Sum[sold goods cost]
to get the Gross Profit it would be something like [Sales Totals] - [sold goods cost]
to get the Gross % Margin =([sales totals]-[sold goods cost]) / [sales total] * 100
then at the bottom of the report i would like to have a total to date of total sales and totals of every thing....
and so on..they are really basic things.. but i just cant figure out how to put it all together..
it would be nice to have a report that i just click on and tell me this stuff in a nice, neat and organized matter....
