cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shatokhinslava
New Member

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

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.

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

[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]

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,222)