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

(0) Share

Report

Posted on by Ken Manhattan

552

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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (1)

Report

Hi Ken,

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

- modifyPurchQty

- initPurchQty

- unitConvertPurch2Invent

- unitConvertInvent2Purch

Was this reply helpful? Yes No
Ken Manhattan 552 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates