Dear Experts,
I'd like to combine 2 report in 1 report and show data as u can see in photo below,
I don't know if i have to create a customize BO to create a report to show summary of material by selected period from the screen, so now i know the data of each item is shown in "Display/Reverse Goods And Activity Confirmation" was saved in GoodsAndActivityConfirmation BO.
I have some problem
1. I can't find where I can get Ending QTY(shown in Inventory) to combine with Confirmation Journal. Do i have to calculate it? or what BO should i search for?
2. I found some Conf. ID in "Confirmation Journal" aren't shown in "Display/Reverse Goods And Activity Confirmation", so what's wrong with data? as u can see pic below ->
May u recommend some solution?
Best regards,
Thanarat