Small and medium business | Business Central, N...

Which tables are affected when creating an order via the SOAP API?

(0) Share

Report

Posted on by Waltavista

Hello,
there are a lot of pages in NAV that have a reference to sales orders. See list below.

Which Pages do I need to populate if I want to create a customer orders via the API?

I have read elsewhere that these are only the pages salesorder_order and salesorder_orderline.

What about customer?

I use SOAP and C# and have no problems with writing and reading the API. I just don't know which tables to use.

List of pages related to orders:

order_headers
order_lines
salesorder_list
salesorder_orderSalesLines

salesorder_order
salesorder_orderline
customer

webshop_salesorder_order
webshop_salesorder_orderline
webshop_customer

salescredit_credit
salescredit_creditline
salesinvoice_invoice
salesinvoice_invoiceline

All responses (6)

Answers (0)

Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Which tables are affected when creating an order via the SOAP API?

If the customer for the order is already in NAV you will only have to use the sales header and sales line tables.

If the customer is a new customer you will have to create the customer in the customer table before you create the sales order.
Suggested answer

Waltavista 5 on at

Like (0)

Report

RE: Which tables are affected when creating an order via the SOAP API?

stackoverflow.com/.../75246563

Order and OrderLine should be enough to create the order. Credit is when you creating the return for items previously sold, and Invoice is a posted order (not editable).

As for the customer, it depends whether you are willing to create customers or you are going to use some predefined one. Cuz customer is an essential field. So if you are going to create new customers you need to publish page for them as well. And this goes for any other entity that is related to order. Like Items or Accounts.
Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

RE: Which tables are affected when creating an order via the SOAP API?

Hi, In Web Service page, you should be able to find these custom pages and their Object ID.

Then open Development Environment

Find the ID:

Right click and chosse Design (development license is required)

Choose Property

Then you can see source table

Hope this helps.

Thanks.

ZHU
Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: Which tables are affected when creating an order via the SOAP API?

hi

you can use Page api in Dynamics nav (REST)

community.dynamics.com/.../microsoft-dynamics-nav-2018-api-part-4-develop-custom-api

DAniele
Waltavista 5 on at

Like (0)

Report

RE: Which tables are affected when creating an order via the SOAP API?

Thank you very much for your answers. I know there is no page "CustomerOrders". I added a list of all pages probably affected by creating an order below my post. SalesOrder_Order is linked to Customer with Sell_to_Customer_No and Bill_to_Customer_No
Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: Which tables are affected when creating an order via the SOAP API?

NAV does not have Customer Orders. Maybe you mean Sales Orders only.