The data flow from SalesTable and SalesLine tables to customer invoicing and ledger posting in Dynamics 365 Finance & Operations (D365 F&O) involves several steps and multiple tables. Here's a comprehensive and accurate outline of the data flow, along with the names of the tables involved and the key processes:
1. Sales Order Creation
- Tables Involved:
- SalesTable: Stores header-level information of the sales order (e.g., order number, customer, dates).
- SalesLine: Stores line-level details of the sales order (e.g., item numbers, quantity, price).
- Process: Sales order entry.
2. Sales Order Confirmation
- Tables Involved:
- SalesTable (updated): Status is updated to "Confirmed."
- SalesLine (updated): Status is updated to "Confirmed."
- SalesParmTable: Stores parameter data for the sales order confirmation.
- SalesParmLine: Stores line-level information for the confirmation.
- Process: Sales order confirmation.
3. Packing Slip Posting
- Tables Involved:
- CustPackingSlipJour: Stores the header information for the packing slip (shipment).
- CustPackingSlipTrans: Stores line-level details of the packing slip.
- InventTrans: Tracks inventory transactions for the shipped items.
- Process: Posting the packing slip (shipment) to indicate that goods have been shipped.
4. Invoice Posting
- Tables Involved:
- CustInvoiceJour: Stores the header information of the customer invoice.
- CustInvoiceTrans: Stores line-level details of the customer invoice.
- CustTrans: Tracks the customer transactions related to the invoice.
- CustSettlement: Tracks settlement details of the invoice and payment.
- CustPostInvoiceJour: Stores detailed posting information about the customer invoice.
- CustTransOpen: Tracks open (outstanding) transactions, such as unpaid invoices.
- LedgerJournalTrans: Records financial postings related to the invoice.
- InventTrans (updated): Inventory is adjusted upon invoice posting.
- Process: Customer invoicing.
5. Ledger Posting (Financial Integration)
- Tables Involved:
- LedgerJournalTable: Stores header information about the general ledger journals.
- LedgerJournalTrans: Stores the actual journal entries related to the invoice (account postings for revenue, cost of goods sold, taxes, etc.).
- CustTrans (updated): Customer transaction is recorded in financials.
- VendTrans (if related to intercompany transactions): Tracks vendor transactions.
- Process: Ledger postings for financial accounting purposes.
6. Payment and Settlement
- Tables Involved:
- CustTrans (updated): Updated when the payment is received.
- CustSettlement (updated): Settlement between the invoice and payment.
- CustTransOpen (updated): Closed once the payment is fully settled.
- LedgerJournalTrans: Records journal entries for the payment and settlement.
- Process: Customer payment and invoice settlement.
Summary of Key Tables:
- Sales Order:
- SalesTable, SalesLine
- Order Confirmation:
- SalesParmTable, SalesParmLine
- Packing Slip Posting:
- CustPackingSlipJour, CustPackingSlipTrans
- Invoice Posting:
- CustInvoiceJour, CustInvoiceTrans, CustTrans, CustPostInvoiceJour
- Ledger Posting:
- LedgerJournalTable, LedgerJournalTrans
- Payment and Settlement:
- CustTrans, CustSettlement, CustTransOpen
This is the typical flow of data from the sales order to invoicing and payment settlement in D365 F&O.