cancel
Showing results for 
Search instead for 
Did you mean: 

How to get Opening Balance for Stock Report in Crystal Report?

former_member1133820
Participant
0 Kudos

Dear Experts,

I am using SAP B1 8.82.

I am new to crystal report and now trying to do a monthly stock report with the following format:

Species  BatchNum   OpeningBal   QtyInKD    QtyInRD    QtyInCD   Adj    ClosingBal

ABC       T1234          17.43           10.16         17.43        0.00         0.00   10.16

ClosingBal = OpeningBal + QtyInKD - QtyInRD - QtyInCD + Adj

Parameters:

- DateFrom

- DateTo

- WarehouseFrom

- WarehouseTo

I am having problem in defining formula to get the opening balance for each item. The report is grouped by species, whscode & batchNum.

Anyone please share with me how to write the formula for opening balance in stock report.

Thanks.

Best Regards,

Leng

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member205766
Active Contributor
0 Kudos

Hi

Check the below discussion it may helps you

With Regards

Balaji Sampath