Dynamics Community Forum Thread Details

Issue with Unit Price Calculation in "Purchase order lines V2" via DMF

Hi,

I am encountering an issue when creating Purchase Order lines via the "Purchase order lines V2" data entity through an integration or DMF import.

The Issue:
The purchase price is not recalculating based on the imported Unit of Measure (UoM). It seems to default to the item's base unit price regardless of the unit passed in the payload.

Example Scenario:

Item: Item1
Default Unit: Each (Price: 100)
Secondary Unit: KG (Price: 200)

Observed Behavior:

Manual Creation (UI): If I create the line manually and change the unit from 'Each' to 'KG', the price correctly updates from 100 to 200.
DMF Import: If I import the line with Unit 'KG', the system incorrectly sets the price to 100 (the price for 'Each') instead of 200.

Expected Behavior:
When importing via DMF, the system should trigger the trade agreement/unit conversion logic and apply the correct price (200) for the specific unit defined in the import, similar to the standard UI behavior.

Could you please advise if I am missing a specific setup or parameter to trigger this price calculation during import?

in excel i am paasing the value for field "PURCHASEUNITSYMBOL"

Thanks,
VK

Categories:

Dynamics 365 Finance

Quick Links