Tuesday, 27 August 2024

Sales Order Tables and Classes

 

SalesOrder Classes and Tables:

SalesTableType and SaleslineType classes will get called while creating the Sales Orders.

SalesFormLetter_Confirm

SalesFormLetter_PickingLlst

SalesFormLetter_PackingSlip

SalesFormLetter_Invoice

 classes will be used to post the sales order at various document status (packing, invoice etc).


Tables used to create sale order

SalesTable contains all SalesOrder headers regardless whether they have been posted or not.

SalesLine  contains all sales order line details regardless whether they have been posted or not.

CustTable Contains the customer related information 

InventTable contains item related information

Inventdim holds the dimension (Inventsite, warehouse, location) related information 

The SalesParmTable and SalesParmLine contains detailed information regarding posting sales headers and Lines.

Sales order confirmations:
CustConfirmJour and CustConfirmTrans tables contains all Sales Confirmation headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.

Packing slip journal:
CustPackingSlipJour and CustPackingSlipTrans tables contains all sales PackingSlip headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.

Invoice journal:
CustInvoiceJour and CustInvoiceTrans tables contains all Sales Invoice headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines.

 

No comments:

Post a Comment

workflow business event configuration with power automate flow in d365 FO

  https://www.linkedin.com/pulse/purchase-order-approvals-d365fo-power-automate-ahmed-ali-el-bardisy-jyssf/