Small and medium business | Business Central, N...

Add a new column on Item Ledger Entries

(0) Share

Report

Posted on by Reni

In Item Ledger Entries, the Quantity column converts the amount from invoices according to the Base Unit of Measure set in the Item Card. Add a new column in Item Ledger Entries to display the converted Quantity according to the Sales Unit of Measure specified in the Item Card.
Can you help me with this code

Categories:

Dynamics 365 Business Central

All responses (6)

Answers (0)

Sort by

Suggested answer

Mohana Yadav 61,248 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Please share the code that you have tried.
Suggested answer

Amit Baru 3,043 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Pls use the below link

https://erpconsultors.com/update-item-ledger-entry-fields-at-the-time-of-purchase-receipt-posting/

Regards

Amit Sharma

www.erpconsultors.com
Reni 50 on at

Like (0)

Report
Copy link

Link copied!
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

Your repeat loop will not do anything in this case.

Do you want to handle all the Item Unit of Measures used of only the default sales UOM as it shows on your item card?
Reni 50 on at

Like (0)

Report
Copy link

Link copied!

yes
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!
I think this code should do it for you:

var Item: Record Item; ItemUnitOfMeasure: Record "Item Unit of Measure"; Sassia: Decimal; begin Item.Get(rec."Item No."); If ItemUnitOfMeasure.Get(Item."No.", rec."Unit of Measure Code") then Sassia := rec.Quantity / ItemUnitOfMeasure."Qty. per Unit of Measure" else Sassia := rec.Quantity * rec."Qty. per Unit of Measure"; end;