How to convert purchase quantity to inveotry quantity if UoM different using X++ ?

(0) Share

Report

Posted on by Ken Manhattan

558

Hi all,

How to convert purchase quantity to inventory quantity if UoM different using X++ ? is there a built-in function for it and how to use it ?

Thanks

All responses (3)

Answers (1)

Sort by

Verified answer

André Arnaud de Cal... 307,224 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi Ken,

Depending on your exact requirement, there are various methods available on the PurchLine table:

- modifyPurchQty

- initPurchQty

- unitConvertPurch2Invent

- unitConvertInvent2Purch
Ken Manhattan 558 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Thank you very much. I wish I knew sooner.

I'm going "extra mile" before reading your reply and using this rather complex way :

InventQty = PurchQty * UnitOfMeasureConversion::findByConversion(
                                                            UnitOfMeasure::unitOfMeasureIdBySymbol(InventTable::find(purchLine.ItemId).inventTableModulePurch().UnitId),
                                                            UnitOfMeasure::unitOfMeasureIdBySymbol(InventTable::find(purchLine.ItemId).inventTableModuleInvent().UnitId)
                                                            ).Factor;

But thanks, I will use yours from now on
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Ken,
You can check out this article for PO Quantity vs. Inventory Quantity, although it doesn't use the X++ method.
You can also view related information about the purchline table:
Quantities in purchase order and inventory transaction - Microsoft Dynamics 365 Blog
PurchLine in WorksheetLine - Common Data Model - Common Data Model | Microsoft Learn
Best Regards,
Hana