Create Sales order line in D365 Finance and Operations. Inventory LotId is required.

(0) Share

Report

Posted on by Power Platform Comm...

Hello,

I am trying to create a new Sales order line in the Power App canvas application. I am using the following formula:

Patch(SalesOrderLines, Defaults(SalesOrderLines), {'Sales order':"SO0001",'Item number': "ITEMNUMBER", Quantity:1, Company:"usmf"}).

But I am getting the error: InventoryLotId: Field 'InventoryLotId' is required.

However, I can create a Sales order line manually, as well as by Excel Add-in. In both cases, the system assigns a new Lot ID automatically according to the number sequence. What is wrong with my formula?

Appreciate any help!

Slava.

All responses (1)

Answers (0)

Suggested answer

Fernando Acevedo 65 on at

Like (0)

Report

RE: Create Sales order line in D365 Finance and Operations. Inventory LotId is required.

[quote user="Power Platform Communities"]
Hello,

I am trying to create a new Sales order line in the Power App canvas application. I am using the following formula:

Patch(SalesOrderLines, Defaults(SalesOrderLines), {'Sales order':"SO0001",'Item number': "ITEMNUMBER", Quantity:1, Company:"usmf"}).

But I am getting the error: InventoryLotId: Field 'InventoryLotId' is required.

However, I can create a Sales order line manually, as well as by Excel Add-in. In both cases, the system assigns a new Lot ID automatically according to the number sequence. What is wrong with my formula?

Appreciate any help!

Slava.
[/quote]