Stock items history report!
Dear Sir,
I hope you are all well.
I am very keen to use fast report from Quick Report.
I have a Table storing items(ItemNo Key), Description);
I have a Table for stock Adjustments for beginning balances or any adjustments can increase or decrease (Item, Adjusted date, Adjusted quantity)
I have another table for new purchases (ItemNo, Qty bought, date purchased). increase stock
I have another Table for Sold items(Item No, Qty, Qty Sold, date sold)j decreases stock
I would like to print a report listing all the items in the stock item say Item A, Item B, Item C but for each item it should list
all the Items Adjusted and a field below for Total, All the Items Purchased and a field below for Total, All the items sold and a field below for Total, and below the remaing balance obtained from Total Adjusted Qty+Total PurchasedQuantity-Total SoldQuantity. I can get these datasets from Queries no problem, but how to generate this report with all the totals calculated correctly?
The example result should look like
Item A
Adjsted items: A qty=2
A qty=3
Total=5
Purchase items: A qty=10
A qty=20
Total=30
Sold Items: A qty=10
A qty=10
Total=20
On Hand=15 i.e (5+30-20) and continues below for all other items in the same maner
Item B... then
Item C until all items are exhausted.
My question is what objects to use on my report, how many Master Bands, how many subreports, how to arrange them, what kind of script to put on which OnBefore events?
I look forward to hearing from you.
Best regards
I hope you are all well.
I am very keen to use fast report from Quick Report.
I have a Table storing items(ItemNo Key), Description);
I have a Table for stock Adjustments for beginning balances or any adjustments can increase or decrease (Item, Adjusted date, Adjusted quantity)
I have another table for new purchases (ItemNo, Qty bought, date purchased). increase stock
I have another Table for Sold items(Item No, Qty, Qty Sold, date sold)j decreases stock
I would like to print a report listing all the items in the stock item say Item A, Item B, Item C but for each item it should list
all the Items Adjusted and a field below for Total, All the Items Purchased and a field below for Total, All the items sold and a field below for Total, and below the remaing balance obtained from Total Adjusted Qty+Total PurchasedQuantity-Total SoldQuantity. I can get these datasets from Queries no problem, but how to generate this report with all the totals calculated correctly?
The example result should look like
Item A
Adjsted items: A qty=2
A qty=3
Total=5
Purchase items: A qty=10
A qty=20
Total=30
Sold Items: A qty=10
A qty=10
Total=20
On Hand=15 i.e (5+30-20) and continues below for all other items in the same maner
Item B... then
Item C until all items are exhausted.
My question is what objects to use on my report, how many Master Bands, how many subreports, how to arrange them, what kind of script to put on which OnBefore events?
I look forward to hearing from you.
Best regards