Did you try changing quantity or unit price manually to see if the net amount is calculating ? In your file line amount looks blank , try giving amount over there and see if the import is successful. May be the entity is not doing the calculation logic.
Thanks Sukrut. After importing I did change unit price/Qty and yes the net amount does then calculate. Also I included a net amount on the data entity file and the result after importing is that unit price disappears. This is standard functionality though. The client does not want to lose visibility to the unit price. They are using Exflow to import their PO's. They will want to leave net amount blank so that it calculates after the integration import.
Thats weird that when you include line amount and quantity and unit price ,unit price disappears. I haven't tested this entity for a while so quite not sure what's happening but here is what you can do , check entity in visual studio to understand the logic. Most probably when you specify unit price and quantity logic of calculating line amount is not getting triggered. In that scenario you might have to write logic in mapentitytodatasource method.
One more point , just opening form does not recalculate line amount , you have to change either quantity or unit price so that line amount gets recalculated.
Hi Barry,
After importing lines , try confirming the PO and see if it calculates Net amount. This is general issue most of the times due to refresh. If it does not work , please raise to MS , they will definately fix this.
This thread is pretty old, but in 2022 we are having the exact same issue. To add some additional information. the purchase order lines v2 entity has a CALCULATELINEAMOUNT column. We've tried both Yes and No with the same result: LINEAMOUNT is set the the unit price.
Confirmation does not force a recalculation of the PO line. We are importing a large number of open POs from a legacy system, it really isn't an option to touch each line item to force the recalculation.
It is also tough to explain to new users how the fancy new system can't do simply math.
Hi Mark. You might consider opening a support ticket with Microsoft and suggest that this is a bug. Perhaps you can be the catalyst to get this fixed!
We found the magic to get this to work correctly. There are two quantity fields in the Purchase order lines v2 data entity: ORDEREDPURCHASEQUANTITY and PURCHASEPRICEQUANTITY. We were setting both fields to the same value. With the CALCULATELINEAMOUNT field set to Yes, the net amount on the imported PO line was always equal to the unit price. We removed the PURCHASEPRICEQUANTITY from the import file and the Net amount now calculated successfully (Quantity * Unit Price). I will confess that I don't know how PURCHASEPRICEQUANTITY should be used, but I can't conceive that it should result in the net amount on the PO Line to be set to the unit price.
One further note: when he CALCULATELINEAMOUNT is set to No, the Quantiy and Net Amount on the PO Line are set to the ORDEREDPURCHASEQUANTITY and LINEAMOUNT from the file respectively, however the Unit price on the PO line item is blank (PURCHASEPRICE from the file is ignored). This looks strange on the PO, but perhaps is correct. It is in essence saying the quantity value is informational only and only the Net price will be considered.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 796
André Arnaud de Cal... 721 Super User 2025 Season 2
Sohaib Cheema 530 User Group Leader
