Inventory Availability by Lot No ?

(0) Share

Report

Posted on by Muhammad Arif Maseed

768

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 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

All responses (1)

Answers (0)

Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

RE: Inventory Availability by Lot No ?

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.