Sales Order API

The Sales Order consists of five key tables used for data storage:

• bl_fi_generic_doc_hdr

  • Compulsory table: This table must be included in any sales order.

  • It contains essential details such as the sales order number, billing, and delivery information.

• bl_fi_generic_doc_line

  • Contains information about the items involved in the sales order transaction, including voucher details.

• bl_fi_generic_doc_ext

  • Stores additional information that is not included in the bl_fi_generic_doc_hdr table.

• bl_fi_generic_doc_event

  • Used for report tracking purposes. For example, it records when a sales order has been successfully synced from a marketplace.

• bl_fi_generic_doc_link

  • This table links the generic document to other documents, such as sales orders, sales invoices, etc.

API Operations

Create Sales Order

Learn how to create a sales order using the provided API endpoint.

Update Sales Order

Instructions for updating an existing sales order.

Get All Sales Orders

Retrieve all sales orders from the system.

Get Sales Orders by GUID

Retrieve a sales order using its unique GUID.

• What if there are membership points to be rewarded?

• To understand the difference between the txn_class = PNS vs STL_MTHD

• See this google spreadsheet https://docs.google.com/spreadsheets/d/1_1ETNP4arvLpL5T_fI2A3xrnyfq7Lw8g7X-v46XdVyg/edit#gid=0

Frequently Asked Questions

PNS vs STL_MTHD

• PNS (Product and Services): This transaction type involves the sale of products or services.

• STL_MTHD (Settlement Method): Refers to how the payment is made, such as cash, debit card, or voucher.

When a sales order is created, it is considered PNS since it involves the sale of a product. When the customer pays (e.g., via cash), the receipt is issued, which is considered STL_MTHD.

To better understand the difference, please watch the video here.

Can Sales Orders be Edited Multiple Times?

Once a sales order is finalized, it cannot be edited. To determine if a sales order is finalized, check the posting_status column in the bl_fi_generic_doc_hdr table. If the value is FINAL, the data cannot be edited, except for the remarks fields.