You’re offline. This is a read only version of the page.
782
Hello Experts
I have develop page bind with item ledger entry table i am trying to display the following fields on my page
Item NO. , Lot No, LocationID and quantity from item ledger entry table on my custom page.
It is working fine but now i am trying to stop the line repetitions.
EG;
Item No. Lot No. LocatonID Quantity
ITM-001 lOT-01 GREEN 2
ITM-001 lOT-01 GREEN 2
ITM-001 lOT-01 GREEN 3
ITM-001 lOT-01 GREEN 1
Now i am trying if item no , lot no and locationid is same then just display the line one time ?
Just ignore the quantity because it is calculating perfectly just want to show the line one time .
Is there any possible way to do it if yes then how ?
That what i want to achieve
Item No. Lot No. LocatonID Quantity
ITM-001 lOT-01 GREEN 8
*This post is locked for comments
I have the same question (0)
Use a temporary Item Ledger Entry table.
Do a REPEAT UNTIL on Item Ledger Entry table, summarize the data, and insert it into the temporary table.
You can then use that temporary table to display.
Share
Report
All responses (
Answers (
