10.4 Sales Order Invoicing, Billing Classifications & Prepayments
Key Takeaways
- The Sales Order Invoicing Lifecycle moves through distinct physical (Packing slip: Deferred COGS / Inventory physical clearing) and financial (Invoice: AR summary debit, Revenue credit, COGS debit, Inventory issue credit) posting stages.
- Customer Prepayments can be processed via Prepayment Sales Order lines or Customer Payment Journals, utilizing dedicated Prepayment Posting Profiles to manage deposit liabilities and sales tax on prepayments before final order fulfillment.
- When the final sales order invoice is posted, Dynamics 365 Finance automatically applies open prepayment settlements, reducing the net balance due on the customer subledger.
- Billing Classifications and Billing Codes provide structured invoice classification and predefined line templates for specialized commercial and public sector billing workflows.
- Customer Foreign Currency Revaluation (Accounts receivable > Periodic tasks > Foreign currency revaluation) revalues open AR invoices using updated exchange rates, posting unrealized gains or losses to the General Ledger.
10.4 Sales Order Invoicing, Billing Classifications & Prepayments
Quick Summary: In modern enterprise commerce, revenue recognition and invoice fulfillment encompass far more than simple one-click billing. Functional consultants must configure and manage the complete Sales Order Invoicing Lifecycle—including physical packing slip accruals, financial invoice commitments, and credit memo return logistics. For capital equipment and custom manufacturing, organizations require robust Customer Prepayment Frameworks (advances and down payments) that capture statutory sales taxes and automatically settle against final invoices. Furthermore, global and public-sector operations require Billing Classifications, Intercompany Customer Invoicing, and periodic Foreign Currency Revaluations to ensure compliance and financial precision.
1. The Sales Order Invoicing Lifecycle & Accounting Mechanics
The sales order processing lifecycle transitions through two distinct accounting milestones: Physical Update (Packing Slip) and Financial Update (Sales Order Invoice).
+---------------------------------------------------------------------------------------------------------+
| Sales Order Invoicing Lifecycle Flow |
+---------------------------------------------------------------------------------------------------------+
| |
| [ Sales Order: Open Order ] |
| | |
| v |
| [ 1. Pick & Pack ] --------> [ 2. Post Packing Slip (Physical Update) ] |
| | |
| +---> Dr. Deferred COGS (Physical) |
| +---> Cr. Inventory Physical Clearing |
| | |
| v |
| [ 3. Post Invoice (Financial Update) ] |
| | |
| +------------------------------+------------------------------+ |
| | | |
| v v |
| REVERSE PHYSICAL ACCRUALS POST FINANCIAL IMPACT |
| - Dr. Inventory Physical Clearing - Dr. AR Summary Control (Posting Prof)|
| - Cr. Deferred COGS (Physical) - Cr. Sales Revenue (Inv Posting Tab) |
| - Cr. Sales Tax Payable (Ledger Group) |
| - Dr. Cost of Goods Sold (COGS) |
| - Cr. Inventory Issue (Inv Asset) |
+---------------------------------------------------------------------------------------------------------+
Detailed Voucher Walkthrough: Physical vs. Financial Postings
Consider an enterprise selling 10 units of an industrial generator at a sales price of $10,000.00 each (Total Sales = $100,000.00, Cost of Goods Sold = $6,000.00 each / $60,000.00 total, Sales Tax = 8% / $8,000.00).
Stage 1: Posting Packing Slip (Physical Milestone)
- Trigger: Goods physically leave the warehouse (
Sales order > Pick and pack > Post packing slip). - Ledger Posting (if 'Post physical inventory' is enabled in Inventory parameters):
- Debit: Deferred COGS - Physical (
140200) -> $60,000.00 - Credit: Inventory - Physical Clearing (
140190) -> $60,000.00
- Debit: Deferred COGS - Physical (
Stage 2: Posting Sales Order Invoice (Financial Milestone)
- Trigger: Commercial invoice generated (
Sales order > Invoice > Generate > Invoice). - Ledger Voucher Entries:
+---------------------------------------------------------------------------------------------+
| Sales Order Invoice Financial Voucher |
+---------------------------------------------------------------------------------------------+
| Account Description | Main Account | Debit Amount | Credit Amount |
| ------------------------------------ | ------------ | --------------- | ------------------- |
| **Physical Accrual Reversal:** | | | |
| Inventory - Physical Clearing | `140190` | $60,000.00 | |
| Deferred COGS - Physical | `140200` | | $60,000.00 |
| ------------------------------------ | ------------ | --------------- | ------------------- |
| **Financial Inventory & COGS:** | | | |
| Cost of Goods Sold (COGS) | `500100` | $60,000.00 | |
| Inventory Asset Issue | `140100` | | $60,000.00 |
| ------------------------------------ | ------------ | --------------- | ------------------- |
| **Financial Revenue & Receivables:** | | | |
| Accounts Receivable (Customer) | `130100` | $108,000.00 | |
| Sales Revenue | `401100` | | $100,000.00 |
| Sales Tax Payable (8%) | `220100` | | $8,000.00 |
| **TOTAL BALANCED VOUCHER** | | **$228,000.00** | **$228,000.00** |
+---------------------------------------------------------------------------------------------+
2. Customer Prepayments & Down Payment Framework
For high-value, make-to-order, or long-lead products, businesses require advance deposits prior to manufacturing or delivery. Dynamics 365 Finance provides a fully integrated Customer Prepayment Framework.
Prepayment Architecture & Setup Requirements
- Prepayment Posting Profile: Configured under
Accounts receivable > Setup > Customer posting profiles(e.g., ProfilePREPAY). Its Summary account points to a balance sheet Customer Advances / Prepayment Liability account (e.g.,210200) rather than trade accounts receivable. - Accounts Receivable Parameters Link: Under
Accounts receivable > Setup > Accounts receivable parameters > Ledger and sales tax FastTab, set Prepayment posting profile =PREPAYand toggle Sales tax on prepayment =Yes(if required by local tax statutory rules).
+---------------------------------------------------------------------------------------------------------+
| Customer Prepayment End-to-End Workflow |
+---------------------------------------------------------------------------------------------------------+
| |
| [ 1. Sales Order: $100,000 Total Order ] |
| | |
| v |
| [ 2. Define Prepayment Term on Order: $20,000 (20% Advance) ] |
| | |
| v |
| [ 3. Post Prepayment Invoice ] -------------------------------------------------------------+ |
| - Creates Open CustTrans for Prepayment ($20,000 + $1,600 Tax = $21,600) | |
| - Dr. AR Prepayment Summary / Cr. Prepayment Liability / Cr. Sales Tax Prepayment | |
| | | |
| v | |
| [ 4. Customer Pays Prepayment via Payment Journal ] | |
| - Dr. Bank $21,600 / Cr. AR Prepayment Summary $21,600 | |
| - Prepayment Invoice is Settled and marked 'Paid' | |
| | | |
| v | |
| [ 5. Ship Goods & Post Final Sales Order Invoice ($100,000 + $8,000 Tax) ] | |
| | | |
| v | |
| [ 6. Automatic Prepayment Settlement Application ] <----------------------------------------+ |
| - Prepayment Liability ($20,000) reverses and offsets Final AR Invoice |
| - Sales Tax Prepayment ($1,600) reverses against final Sales Tax Payable |
| - Net Remaining Customer Balance Due = $86,400.00 |
+---------------------------------------------------------------------------------------------------------+
Detailed Numerical Prepayment Walkthrough
- Order Total: $100,000.00 + 8% Sales Tax ($8,000.00) = $108,000.00
- Prepayment Deposit: 20% = $20,000.00 + 8% Tax ($1,600.00) = $21,600.00
Step A: Post Prepayment Invoice ($21,600.00)
- Debit: Accounts Receivable - Prepayment (
130180) -> $21,600.00 - Credit: Customer Prepayments Liability (
210200) -> $20,000.00 - Credit: Sales Tax on Prepayments (
220150) -> $1,600.00
Step B: Customer Payment Received ($21,600.00)
- Debit: Operating Bank Account (
110100) -> $21,600.00 - Credit: Accounts Receivable - Prepayment (
130180) -> $21,600.00
Step C: Post Final Sales Order Invoice & Apply Prepayment Settlement
- When the final invoice is posted, the open prepayment is applied:
- Debit: Accounts Receivable Summary - Trade (
130100) -> $108,000.00 - Credit: Sales Revenue (
401100) -> $100,000.00 - Credit: Sales Tax Payable (
220100) -> $8,000.00 - Settlement Reversal Entry:
- Debit: Customer Prepayments Liability (
210200) -> $20,000.00 - Debit: Sales Tax on Prepayments (
220150) -> $1,600.00 - Credit: Accounts Receivable Summary - Trade (
130100) -> $21,600.00
- Debit: Accounts Receivable Summary - Trade (
- Net Remaining Customer Open AR Balance: $108,000.00 − $21,600.00 = $86,400.00.
3. Billing Classifications & Billing Codes
Billing Classifications and Billing Codes are specialized Accounts Receivable structures (widely used in public sector and commercial service organizations) that standardize, control, and secure customer invoices.
Navigation
- Path:
Accounts receivable > Setup > Billing classificationsandAccounts receivable > Setup > Billing codes
+---------------------------------------------------------------------------------------------------+
| Billing Classification Architecture |
+---------------------------------------------------------------------------------------------------+
| Billing Classification: [ GRANTS_FED ] Description: Federal Research Grants |
| Terms of Payment: [ Net45 ] Interest Code: [ (None - Exempt) ] |
| Collection Letter Sequence: [ (None) ] Posting Profile: [ GOV_AR ] |
+---------------------------------------------------------------------------------------------------+
| Associated Billing Codes: |
| Billing Code | Description | Default Unit Price | Revenue Main Account | Tax Group |
| ------------ | ----------------------- | ------------------ | -------------------- | ------------ |
| `DIR_LABOR` | Direct Research Labor | $125.00 / Hr | `410100` | `EXEMPT_GOV` |
| `IND_COST` | Indirect Overhead Admin | $45.00 / Hr | `410200` | `EXEMPT_GOV` |
| `LAB_EQUIP` | Specialized Lab Usage | $500.00 / Day | `410300` | `EXEMPT_GOV` |
+---------------------------------------------------------------------------------------------------+
Key Benefits of Billing Classifications
- Standardized Line Entry: Billing codes allow non-financial users to select descriptive service items (e.g.,
DIR_LABOR) that automatically populate the correct GL main account, unit price, and sales tax group. - Custom Credit & Collection Rules: Invoices under specific billing classifications can be exempted from interest notes and collection letter sequences.
- Restricted Access & Number Sequences: Separate number sequences and security privileges can be enforced per billing classification.
4. Intercompany Customer Invoicing
In multi-company enterprise environments, goods sold from one legal entity (e.g., manufacturing company USMF) to a sister subsidiary (e.g., distribution company DEMF) utilize automated Intercompany Trading Relationships.
+---------------------------------------------------------------------------------------------+
| Intercompany Customer Invoicing Automation |
+---------------------------------------------------------------------------------------------+
| |
| LEGAL ENTITY USMF (Selling Entity) LEGAL ENTITY DEMF (Buying Entity) |
| [ Intercompany Sales Order: SO-0092 ] <=====> [ Intercompany Purchase Order: PO-0041 ] |
| | | |
| v v |
| [ Post Sales Order Invoice ] |
| - Dr. Intercompany AR (USMF) |
| - Cr. Intercompany Revenue (USMF) |
| | |
| +=============================================> [ Automated Action ] |
| - Automatically creates & |
| posts Vendor Invoice in |
| DEMF (AP Subledger) |
| - Dr. Inventory / Expense |
| - Cr. Intercompany AP (DEMF)|
+---------------------------------------------------------------------------------------------+
Intercompany Configuration Essentials
- Path:
Accounts receivable > Customers > All customers > General tab > Intercompany - Direct Invoice Creation: Configuring the intercompany policy with Post invoice automatically = Yes ensures that posting the sales invoice in
USMFimmediately posts the vendor invoice inDEMF, maintaining perfect intercompany ledger synchronization.
5. Customer Foreign Currency Revaluation
When a customer is invoiced in a foreign currency (e.g., a US entity invoices a European customer in EUR), fluctuations in exchange rates between the invoice date and balance sheet reporting dates generate currency gains or losses.
Navigation
- Path:
Accounts receivable > Periodic tasks > Foreign currency revaluation
+---------------------------------------------------------------------------------------------+
| Customer Foreign Currency Revaluation Dialog |
+---------------------------------------------------------------------------------------------+
| Parameters: |
| - Method: [ Standard ] - Considered Date: [ 08/31/2026 ] |
| - Date of Rate: [ 08/31/2026 ] - Posting Profile: [ GEN ] |
| - Dimension: [ Table ] - Print Report: [ Yes ] |
+---------------------------------------------------------------------------------------------+
Revaluation Mechanics & Accounting Entries
- Scenario: Customer invoiced on August 1 for €100,000 at exchange rate $1.10 USD/EUR (Recorded AR = $110,000 USD).
- On August 31 (Month-End Revaluation), the spot exchange rate moves to $1.15 USD/EUR (Current Value = $115,000 USD).
- Foreign Currency Revaluation Entry (Unrealized Gain):
- Debit: Accounts Receivable Summary Control (
130100) -> $5,000.00 - Credit: Unrealized Exchange Gain (
701100) -> $5,000.00
- Debit: Accounts Receivable Summary Control (
- Subledger Audit: The customer transaction (
CustTrans) records an open foreign currency adjustment line without altering the underlying €100,000 EUR document balance.
6. Exam Traps & Real-World Best Practices
[!WARNING] Exam Trap: Prepayment Settlement vs. Standard Settlement On the MB-310 exam, pay close attention to whether sales tax on prepayments is enabled. If Sales tax on prepayment = Yes in AR Parameters, the system generates sales tax transactions on the prepayment invoice and reverses them during final invoicing. If disabled, tax is calculated solely on the final sales order invoice.
[!IMPORTANT] Consultant Pro-Tip: Storno Accounting on Credit Memos In European jurisdictions (e.g., Germany, Poland, Czech Republic), credit memos must be posted using Correction (Storno) Accounting (
Credit note as correction = Yes). Instead of posting an opposite debit/credit (which artificially inflates gross trial balance turnover), Storno accounting posts negative debits and negative credits to the original revenue and AR accounts.
An enterprise creates a $50,000 sales order that requires a 30% prepayment ($15,000). The prepayment invoice is posted and paid in full by the customer. When the warehouse ships the full order and the billing clerk posts the final $50,000 sales order invoice with prepayment application enabled, what is the net open balance remaining in the customer's Accounts Receivable subledger?
A US-based legal entity (Accounting Currency USD) posts a customer invoice for €50,000 EUR on October 1 when the exchange rate is 1.05 USD/EUR (Recorded AR = $52,500 USD). On October 31, the customer has not yet paid, and the financial controller runs the Customer Foreign Currency Revaluation periodic job using the month-end spot rate of 1.10 USD/EUR ($55,000 USD value). What General Ledger accounting voucher is generated by the revaluation process?
When a sales order packing slip is posted in Dynamics 365 Finance with physical ledger integration enabled, which of the following accounts is credited to record the physical issue of goods prior to financial invoicing?