How To Make/See Inventory Balance sheet 1

[SumitERP]

Dear Experts..

I'm new on this forum, but like to be a valuable team member.

I've One Query, we are planning to make Inventory balance sheet, means a report which shows three sections namely
1. Opening Balance
2. Receipts
3. Issues
4. closing Balance

and each section will have 3 heading, i.e Item number, Cost, Qty

We get some standard report from IC Valuation, Aged Inventory, and then with lots of work we can make this happen in EXCEL but its prone to lots of error & mismatches.

can you help me in developing report? I'm modernly known to Crystal Report

 

[Jay Converse]

1. Get data from ICHIST
2. With a hidden subreport, get opening balances by summing everything <= start date
3. Display receipts and issues
4. Sum up to closing balance

Make sure ICHIST is never cleared.

 

[SumitERP]

Hi..
thanks for valuable suggestion.

I'll try this and let you know ASAP!!

Regards
sumit

 

[ettienne]

You can also work backwards from the current balance and deduct the activity to get the opening balance. The end result will be the same, whichever is easier for you.