Dynamics Community Forum Thread Details

creating sales order using AL code

i created a middleware between business central and shopify and it works perfectly i can create customers and products in both way but the problem is creating sales order, i need to get the customers i added from business central to shopify and assign the relative information of the customer to sales order, but i cant get the customer id in business central, I only have the name, is there any way I can get the customer using Name, I tried setting filter using name but it did not work.

Example:

I created order in Shopify POS this is the order object https://shopify.dev/api/admin-rest/2021-10/resources/order#resource_object

when i get this object in AL I cant get the customer id , and when i create sales order i use this code

Order.Init();

Order."No." := '';

order."Quote No." := Order."No.";

order."Document Type" := order."Document Type"::Order;

order.Insert(true);

then i insert other data and modify

also I need to insert in the lines i use this code in a loop through Shopify object

lines.Init();

lines.SetRange("Document No.", order."No.");