Sales Order API
Sales order consists of five tables for data storing which are:
-
bl_fi_generic_doc_hdr
-
compulsory table that need to be passed
-
consist of details of sales order including sales order number, billing and and delivery details
-
-
bl_fi_generic_doc_line
-
consists of details ofitem including voucher involve in sales order transaction
-
-
bl_fi_generic_doc_ext
-
this table store extra information which not stored in bl_fi_generic_doc_hdr
-
-
bl_fi_generic_doc_event
-
this table for report tracking purpose. For example when sales order successfully synced from marketplace, the row will be inserted to indicate the syncing process happened
-
-
bl_fi_generic_doc_link
-
this table to link the generic document. It can link from any server doc type such sales order, sales invoice etc
-
Get sales order by guid
-
What if there’s 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
-
Athirah, please get the video recording of this google spreadsheet discussion from Aida and paste here.
-
Frequently Asked Question
PNS VS STL_MTHD
PNS(product and services) is txn_type which involve the transaction of product or service while STL_MTHD is the settlement method involved payment in any kind of form such as cash, debit card, or voucher. Once there is order created, that is considered PNS as it involve sales of the product. When the customer pay by cash, the receipt is issued and this is considered as STL_MTHD. To understand further, you may watch the video in the link https://drive.google.com/file/d/1rzXKlOXaXKT2ADwugYIrjJvxbQGYuKMY/view
Can sales order being edited multiple times?
Sales order can not be edited once the sales order is finalized. In order to know if the sales order is finalized, you may refer to column bl_fi_generic_doc_hdr.posting_status. If the column is 'FINAL', the data can not be edited except for remarks column.