Table 112 "Sales Invoice Header"
Base Application · Microsoft.Sales.History
- 137fields
- 50procedures
- 15events
- 6Learn pages
- 14countries replace it
- 26fields reference it
- 7event subscribers
- 8objects it calls
Across versions
- BC23present
- BC244 fields added, 4 fields removed
- BC257 fields added
- BC263 fields changed, 3 fields removed
- BC273 fields changed
- BC2881 fields changed
- BC29-30unchanged
Neighbourhood 98 connected objects and pages
Base Application · Microsoft.Sales.History · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 132 “Posted Sales Invoice” (3 Learn pages), Page 143 “Posted Sales Invoices” (3).
Properties
| Property | Value |
|---|---|
| Caption | Sales Invoice Header |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 2 | Sell-to Customer No. Δ BC26 | Code[20] | Specifies the number of the customer that you shipped the items on the invoice to. | TableRelation Table 18 “Customer”; NotBlank |
| 3 | No. Δ BC28 | Code[20] | Specifies the posted sales invoice number. Each posted sales invoice gets a unique number. Typically, the number is generated based on a number series. | |
| 4 | Bill-to Customer No. Δ BC26 | Code[20] | Specifies the number of the customer that you send or sent the invoice to. | TableRelation Table 18 “Customer”; NotBlank |
| 5 | Bill-to Name Δ BC28 | Text[100] | Specifies the name of the customer that you send or sent the invoice or credit memo to. | |
| 6 | Bill-to Name 2 Δ BC27 | Text[50] | Specifies an additional part of the name of the customer that you send or sent the invoice to. | |
| 7 | Bill-to Address Δ BC28 | Text[100] | Specifies the address of the customer that the invoice was sent to. | |
| 8 | Bill-to Address 2 Δ BC28 | Text[50] | Specifies additional address information. | |
| 9 | Bill-to City Δ BC28 | Text[30] | Specifies the city of the customer on the sales document. | TableRelation Table 225 “Post Code” (“Post Code”.City) |
| 10 | Bill-to Contact Δ BC28 | Text[100] | Specifies the name of the contact person at the customer’s billing address. | |
| 11 | Your Reference Δ BC28 | Text[35] | Specifies the customer’s reference. The contents will be printed on sales documents. | |
| 12 | Ship-to Code Δ BC28 | Code[10] | Specifies the address on purchase orders shipped with a drop shipment directly from the vendor to a customer. | TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Sell-to Customer No.”))) |
| 13 | Ship-to Name Δ BC28 | Text[100] | Specifies the name of the customer at the address that the items are shipped to. | |
| 14 | Ship-to Name 2 Δ BC28 | Text[50] | Specifies an additional part of the the name of the customer that you delivered the items to. | |
| 15 | Ship-to Address Δ BC28 | Text[100] | Specifies the address that the items on the invoice were shipped to. | |
| 16 | Ship-to Address 2 Δ BC28 | Text[50] | Specifies additional address information. | |
| 17 | Ship-to City Δ BC28 | Text[30] | Specifies the city of the customer on the sales document. | TableRelation Table 225 “Post Code” (“Post Code”.City) |
| 18 | Ship-to Contact Δ BC28 | Text[100] | Specifies the name of the person you regularly contact at the address that the items were shipped to. | |
| 19 | Order Date | Date | — | |
| 20 | Posting Date Δ BC28 | Date | Specifies the date on which the invoice was posted. | |
| 21 | Shipment Date Δ BC28 | Date | Specifies when items on the document are shipped or were shipped. A shipment date is usually calculated from a requested delivery date plus lead time. | |
| 22 | Posting Description Δ BC28 | Text[100] | Specifies any text that is entered to accompany the posting, for example for information to auditors. | |
| 23 | Payment Terms Code Δ BC28 | Code[10] | Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount on the sales document. | TableRelation Table 3 “Payment Terms” (Payment Terms) |
| 24 | Due Date Δ BC28 | Date | Specifies the date on which the invoice is due for payment. | |
| 25 | Payment Discount % Δ BC28 | Decimal | Specifies the payment discount percent granted if payment is made on or before the date in the Pmt. Discount Date field. | |
| 26 | Pmt. Discount Date Δ BC28 | Date | Specifies the date on which the amount in the entry must be paid for a payment discount to be granted. | |
| 27 | Shipment Method Code Δ BC28 | Code[10] | Specifies the code that represents the shipment method for the invoice. | TableRelation Table 10 “Shipment Method” (Shipment Method) |
| 28 | Location Code Δ BC28 | Code[10] | Specifies the code for the location from which the items were shipped. | TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false))) |
| 29 | Shortcut Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 30 | Shortcut Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 31 | Customer Posting Group Δ BC28 | Code[20] | Specifies the customer’s market type to link business transactions to. | TableRelation Table 92 “Customer Posting Group” (Customer Posting Group); not editable |
| 32 | Currency Code Δ BC28 | Code[10] | Specifies the currency code of the invoice. | TableRelation Table 4 “Currency”; not editable |
| 33 | Currency Factor Δ BC28 | Decimal | — | |
| 34 | Customer Price Group | Code[10] | — | TableRelation Table 6 “Customer Price Group” (Customer Price Group) |
| 35 | Prices Including VAT | Boolean | — | |
| 37 | Invoice Disc. Code | Code[20] | — | |
| 40 | Customer Disc. Group | Code[20] | — | TableRelation Table 340 “Customer Discount Group” (Customer Discount Group) |
| 41 | Language Code | Code[10] | — | TableRelation Table 8 “Language” |
| 42 | Format Region | Text[80] | — | TableRelation “Language Selection”.“Language Tag” |
| 43 | Salesperson Code Δ BC28 | Code[20] | Specifies which salesperson is associated with the invoice. | TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser) |
| 44 | Order No. Δ BC28 | Code[20] | Specifies the number of the related order. | |
| 46 | Comment | Boolean | — | FlowField: exist(“Sales Comment Line” where(“Document Type” = const(“Posted Invoice”), “No.” = field(“No.”), “Document Line No.” = const(0))); not editable |
| 47 | No. Printed Δ BC28 | Integer | Specifies how many times the document has been printed. | not editable |
| 51 | On Hold | Code[3] | — | |
| 52 | Applies-to Doc. Type | Enum “Gen. Journal Document Type” | — | enum Enum 6 “Gen. Journal Document Type” |
| 53 | Applies-to Doc. No. | Code[20] | — | |
| 55 | Bal. Account No. | Code[20] | — | TableRelation Table 15 “G/L Account”, Table 270 “Bank Account” (if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account”) |
| 60 | Amount Δ BC28 | Decimal | Specifies the total, in the currency of the invoice, of the amounts on all the invoice lines. The amount does not include VAT. | FlowField: sum(“Sales Invoice Line”.Amount where(“Document No.” = field(“No.”))); not editable |
| 61 | Amount Including VAT Δ BC28 | Decimal | Specifies the total of the amounts, including VAT, on all the lines on the document. | FlowField: sum(“Sales Invoice Line”.“Amount Including VAT” where(“Document No.” = field(“No.”))); not editable |
| 70 | VAT Registration No. Δ BC28 | Text[20] | Specifies the customer’s VAT registration number for customers. | |
| 72 | Registration Number + BC24 | Text[50] | Registration No. caption | |
| 73 | Reason Code | Code[10] | — | TableRelation Table 231 “Reason Code” (Reason Code) |
| 74 | Gen. Bus. Posting Group | Code[20] | — | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 75 | EU 3-Party Trade Δ BC28 | Boolean | Specifies whether the invoice was part of an EU 3-party trade transaction. | |
| 76 | Transaction Type | Code[10] | — | TableRelation Table 258 “Transaction Type” (Transaction Type) |
| 77 | Transport Method Δ BC28 | Code[10] | Specifies the transport method of the sales header that this line was posted from. | TableRelation Table 259 “Transport Method” (Transport Method) |
| 78 | VAT Country/Region Code | Code[10] | — | TableRelation Table 9 “Country/Region” (Country/Region) |
| 79 | Sell-to Customer Name Δ BC28 | Text[100] | Specifies the name of the customer that you shipped the items on the invoice to. | |
| 80 | Sell-to Customer Name 2 Δ BC27 | Text[50] | Specifies an additional part of the name of the customer who will receive the products and be billed by default. | |
| 81 | Sell-to Address Δ BC28 | Text[100] | Specifies the address of the customer that the items on the invoice were shipped to. | |
| 82 | Sell-to Address 2 Δ BC28 | Text[50] | Specifies additional address information. | |
| 83 | Sell-to City Δ BC28 | Text[30] | Specifies the city of the customer on the sales document. | TableRelation Table 225 “Post Code” (“Post Code”.City) |
| 84 | Sell-to Contact Δ BC28 | Text[100] | Specifies the name of the contact person at the customer’s main address. | |
| 85 | Bill-to Post Code Δ BC28 | Code[20] | Specifies the postal code of the customer’s billing address. | TableRelation Table 225 “Post Code” (Post Code) |
| 86 | Bill-to County Δ BC28 | Text[30] | Specifies the state, province or county as a part of the address. | |
| 87 | Bill-to Country/Region Code Δ BC28 | Code[10] | Specifies the country or region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 88 | Sell-to Post Code Δ BC28 | Code[20] | Specifies the postal code of the customer’s main address. | TableRelation Table 225 “Post Code” (Post Code) |
| 89 | Sell-to County Δ BC28 | Text[30] | Specifies the state, province or county as a part of the address. | |
| 90 | Sell-to Country/Region Code Δ BC28 | Code[10] | Specifies the country or region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 91 | Ship-to Post Code Δ BC28 | Code[20] | Specifies the postal code of the address that the items are shipped to. | TableRelation Table 225 “Post Code” (Post Code) |
| 92 | Ship-to County Δ BC28 | Text[30] | Specifies the state, province or county as a part of the address. | |
| 93 | Ship-to Country/Region Code Δ BC28 | Code[10] | Specifies the country or region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 94 | Bal. Account Type | enum “Payment Balance Account Type” | — | enum Enum 96 “Payment Balance Account Type” |
| 97 | Exit Point Δ BC28 | Code[10] | Specifies the point of exit through which you ship the items out of your country/region, for reporting to Intrastat. | TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point) |
| 98 | Correction | Boolean | — | |
| 99 | Document Date Δ BC28 | Date | Specifies the date on which you created the sales document. | |
| 100 | External Document No. Δ BC28 | Code[35] | Specifies the external document number that is entered on the sales header that this line was posted from. | |
| 101 | Area Δ BC28 | Code[10] | Specifies the area code used in the invoice. | TableRelation Table 284 “Area” |
| 102 | Transaction Specification Δ BC28 | Code[10] | Specifies the transaction specification that was used in the invoice. | TableRelation Table 285 “Transaction Specification” (Transaction Specification) |
| 104 | Payment Method Code Δ BC28 | Code[10] | Specifies how the customer must pay for products on the sales document. | TableRelation Table 289 “Payment Method” (Payment Method) |
| 105 | Shipping Agent Code Δ BC28 | Code[10] | Specifies which shipping agent is used to transport the items on the sales document to the customer. | TableRelation Table 291 “Shipping Agent” (Shipping Agent) |
| 106 | Package Tracking No. Δ BC24 Δ BC27 Δ BC28 | Text[50] | Specifies the shipping agent’s package number. | |
| 107 | Pre-Assigned No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 108 | No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series); not editable |
| 110 | Order No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 111 | Pre-Assigned No. Δ BC28 | Code[20] | Specifies the number of the sales document that the posted invoice was created for. | |
| 112 | User ID | Code[50] | — | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 113 | Source Code | Code[10] | — | TableRelation Table 230 “Source Code” (Source Code) |
| 114 | Tax Area Code Δ BC28 | Code[20] | Specifies the tax area that is used to calculate and post sales tax. | TableRelation Table 318 “Tax Area” (Tax Area) |
| 115 | Tax Liable Δ BC28 | Boolean | Specifies if the customer or vendor is liable for sales tax. | |
| 116 | VAT Bus. Posting Group | Code[20] | — | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 119 | VAT Base Discount % Δ BC28 | Decimal | — | |
| 121 | Invoice Discount Calculation | Option | — | OptionCaption: None,%,Amount |
| 122 | Invoice Discount Value Δ BC28 | Decimal | — | |
| 131 | Prepayment No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 136 | Prepayment Invoice | Boolean | — | |
| 137 | Prepayment Order No. | Code[20] | — | |
| 151 | Quote No. Δ BC28 | Code[20] | Specifies the number of the sales quote document if a quote was used to start the sales process. | not editable |
| 163 | Company Bank Account Code Δ BC28 | Code[20] | Specifies the bank account to use for bank information when the document is printed. | TableRelation Table 270 “Bank Account” (“Bank Account” where(“Currency Code” = field(“Currency Code”))) |
| 166 | Alt. VAT Registration No. + BC25 | Boolean | Alternative VAT Registration No. caption | not editable |
| 167 | Alt. Gen. Bus Posting Group + BC25 | Boolean | Alternative Gen. Bus. Posting Group caption | not editable |
| 168 | Alt. VAT Bus Posting Group + BC25 | Boolean | Alternative VAT Bus. Posting Group caption | not editable |
| 171 | Sell-to Phone No. | Text[30] | — | |
| 172 | Sell-to E-Mail | Text[80] | Email caption | |
| 179 | VAT Reporting Date Δ BC28 | Date | Specifies the VAT date on the invoice. | not editable |
| 180 | Payment Reference Δ BC28 | Code[50] | Specifies the payment of the sales invoice. | |
| 185 | Last Email Sent Time − BC24 + BC25 | DateTime | — | FlowField: max(“Email Related Record”.SystemCreatedAt where(“Table Id” = const(Database::“Sales Invoice Header”), “System Id” = field(SystemId))) |
| 186 | Last Email Sent Message Id + BC25 | Guid | — | FlowField: lookup(“Email Related Record”.“Email Message Id” where(SystemCreatedAt = field(“Last Email Sent Time”))) |
| 200 | Work Description | BLOB | — | |
| 210 | Ship-to Phone No. + BC25 Δ BC28 | Text[30] | Specifies the telephone number of the company’s shipping address. | |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 600 | Payment Service Set ID | Integer | — | |
| 710 | Document Exchange Identifier | Text[50] | — | |
| 711 | Document Exchange Status Δ BC28 | Enum “Sales Document Exchange Status” | Specifies the status of the document if you are using a document exchange service to send it as an electronic document. The status values are reported by the document exchange service. | enum Enum 711 “Sales Document Exchange Status” |
| 712 | Doc. Exch. Original Identifier | Text[50] | — | |
| 720 | Coupled to CRM Δ BC26 | Boolean | Coupled to Dynamics 365 Sales caption | obsolete Removed 26.0; #if not CLEANSCHEMA26; not editable |
| 721 | Coupled to Dataverse Δ BC28 | Boolean | Specifies that the posted sales order is coupled to a sales order in Dynamics 365 Sales. | FlowField: exist(“CRM Integration Record” where(“Integration ID” = field(SystemId), “Table ID” = const(Database::“Sales Invoice Header”))); not editable |
| 1200 | Direct Debit Mandate ID Δ BC28 | Code[35] | Specifies the direct-debit mandate that the customer has signed to allow direct debit collection of payments. | TableRelation Table 1230 “SEPA Direct Debit Mandate” (“SEPA Direct Debit Mandate” where(“Customer No.” = field(“Bill-to Customer No.”))) |
| 1302 | Closed Δ BC24 Δ BC28 | Boolean | Specifies if the posted invoice is paid. The check box will also be selected if a credit memo for the remaining amount has been applied. | FlowField: - exist(“Cust. Ledger Entry” where(“Entry No.” = field(“Cust. Ledger Entry No.”), Open = filter(true))); not editable |
| 1303 | Remaining Amount Δ BC28 | Decimal | Specifies the amount that remains to be paid on the sales invoices that are due next week. | FlowField: sum(“Detailed Cust. Ledg. Entry”.Amount where(“Cust. Ledger Entry No.” = field(“Cust. Ledger Entry No.”))); not editable |
| 1304 | Cust. Ledger Entry No. | Integer | — | TableRelation Table 21 “Cust. Ledger Entry” (“Cust. Ledger Entry”.“Entry No.”); not editable |
| 1305 | Invoice Discount Amount Δ BC28 | Decimal | — | FlowField: sum(“Sales Invoice Line”.“Inv. Discount Amount” where(“Document No.” = field(“No.”))); not editable |
| 1310 | Cancelled Δ BC28 | Boolean | Specifies if the posted sales invoice has been either corrected or canceled. | FlowField: exist(“Cancelled Document” where(“Source ID” = const(112), “Cancelled Doc. No.” = field(“No.”))); not editable |
| 1311 | Corrective Δ BC28 | Boolean | Specifies if the posted sales invoice is a corrective document. | FlowField: exist(“Cancelled Document” where(“Source ID” = const(114), “Cancelled By Doc. No.” = field(“No.”))); not editable |
| 1312 | Reversed | Boolean | — | FlowField: lookup(“Cust. Ledger Entry”.Reversed where(“Entry No.” = field(“Cust. Ledger Entry No.”))); not editable |
| 1340 | Dispute Status + BC24 | Code[10] | Specifies if there is an ongoing dispute for this Invoice via Page 132 “Posted Sales Invoice” | TableRelation Table 142 “Dispute Status” (Dispute Status) |
| 1341 | Promised Pay Date + BC24 Δ BC28 | Date | Specifies the date on which the customer have promised to pay this invoice. | |
| 5050 | Campaign No. | Code[20] | — | TableRelation Table 5071 “Campaign” |
| 5052 | Sell-to Contact No. Δ BC28 | Code[20] | Specifies a unique identifier for the contact person at the customer the invoice was sent to. | TableRelation Table 5050 “Contact” |
| 5053 | Bill-to Contact No. Δ BC28 | Code[20] | Specifies the number of the contact the invoice was sent to. | TableRelation Table 5050 “Contact” |
| 5055 | Opportunity No. | Code[20] | — | TableRelation Table 5092 “Opportunity” |
| 5700 | Responsibility Center Δ BC28 | Code[10] | Specifies the code of the responsibility center associated with the user who created the invoice, your company, or the customer in the sales invoice. | TableRelation Table 5714 “Responsibility Center” (Responsibility Center) |
| 5794 | Shipping Agent Service Code + BC25 Δ BC28 | Code[10] | Specifies which shipping agent service is used to transport the items on the sales document to the customer. | TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”))) |
| 7000 | Price Calculation Method | Enum “Price Calculation Method” | — | enum Enum 7000 “Price Calculation Method” |
| 7001 | Allow Line Disc. | Boolean | — | |
| 7200 | Get Shipment Used | Boolean | — | |
| 8001 | Draft Invoice SystemId | Guid | — | DataClassification SystemMetadata |
| 8010 | Dispute Status Id + BC24 | Guid | — | TableRelation Table 142 “Dispute Status” (“Dispute Status”.SystemId) |
Keys
- Key1: No. (clustered)
- Key2: Order No.
- Key3: Pre-Assigned No.
- Key4: Sell-to Customer No., External Document No.
- Key5: Sell-to Customer No., Order Date
- Key6: Sell-to Customer No.
- Key7: Prepayment Order No., Prepayment Invoice
- Key8: Bill-to Customer No.
- Key9: Posting Date
- Key10: Document Exchange Status
- Key11: Due Date
- Key12: Salesperson Code
- Key13: SystemModifiedAt
Events published
OnBeforeCheckNoPrinted(var SalesInvoiceHeader: Record "Sales Invoice Header"; var IsHandled: Boolean)(integration): Raised before checking if the invoice has been printed.OnBeforeEmailRecords(var ReportSelections: Record "Report Selections"; var SalesInvoiceHeader: Record "Sales Invoice Header"; DocTxt: Text; var ShowDialog: Boolean; var IsHandled: Boolean)(integration): Raised before emailing sales invoice records to customers.OnBeforePrintRecords(var ReportSelections: Record "Report Selections"; var SalesInvoiceHeader: Record "Sales Invoice Header"; ShowRequestPage: Boolean; var IsHandled: Boolean)(integration): Raised before printing sales invoice records.OnBeforeDoPrintToDocumentAttachment(var SalesInvoiceHeader: Record "Sales Invoice Header"; var ShowNotificationAction: Boolean; var IsHandled: Boolean)(integration): Raised before printing to document attachment for the sales invoice.OnBeforeSendProfile(var ReportSelections: Record "Report Selections"; var SalesInvoiceHeader: Record "Sales Invoice Header"; DocTxt: Text; var IsHandled: Boolean; var DocumentSendingProfile: Record "Document Sending Profile")(integration): Raised before sending the sales invoice using the document sending profile.OnBeforeSendRecords(var ReportSelections: Record "Report Selections"; var SalesInvoiceHeader: Record "Sales Invoice Header"; DocTxt: Text; var IsHandled: Boolean)(integration): Raised before sending sales invoice records.OnBeforeShowCanceledOrCorrCrMemo(var SalesInvoiceHeader: Record "Sales Invoice Header"; var IsHandled: Boolean)(integration): Raised before showing the cancelled or corrective credit memo related to this invoice.OnBeforeShowCorrectiveCreditMemo(var SalesInvoiceHeader: Record "Sales Invoice Header"; var IsHandled: Boolean)(integration): Raised before showing the corrective credit memo that cancelled this invoice.OnBeforeShowCancelledCreditMemo(var SalesInvoiceHeader: Record "Sales Invoice Header"; var IsHandled: Boolean)(integration): Raised before showing the cancelled credit memo when this invoice is a corrective invoice.OnBeforeSetSecurityFilterOnRespCenter(var SalesInvoiceHeader: Record "Sales Invoice Header"; var IsHandled: Boolean)(integration): Raised before setting security filter on responsibility center for the sales invoice.OnGetPaymentReference(var PaymentReference: Text)Δ BC24 (integration): Raised to retrieve the payment reference for the sales invoice.OnGetPaymentReferenceLbl(var PaymentReferenceLbl: Text)(integration): Raised to retrieve the payment reference label for display.OnLookupAppliesToDocNoOnAfterSetFilters(var CustLedgEntry: Record "Cust. Ledger Entry"; SalesInvoiceHeader: Record "Sales Invoice Header")(integration): Raised after setting filters when looking up the applies-to document number.OnPostedSalesInvoiceFullyOpen(var SalesInvoiceHeader: Record "Sales Invoice Header"; var FullyOpen: Boolean; var IsHandled: Boolean)(integration): Raised to determine whether the posted sales invoice is fully open.OnBeforeGetWorkDescription(var SalesInvoiceHeader: Record "Sales Invoice Header")(integration): Raised before retrieving the work description text for the sales invoice.
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 1173 “Document Attachment Mgmt” DeleteAttachedDocumentsOnAfterDeleteSalesInvoiceHeader, Codeunit 5477 “Sales Invoice Aggregator” OnAfterDeleteSalesInvoiceHeader, Codeunit 8028 “Usage Based Contr. Subscribers” RemoveDocumentNoFromUsageDataBillingOnAfterDeleteSalesInvHeader
- OnAfterInsertEvent: Codeunit 1637 “Office Document Handler” OnPostInvoice, Codeunit 5477 “Sales Invoice Aggregator” OnAfterInsertSalesInvoiceHeader
- OnAfterModifyEvent: Codeunit 5477 “Sales Invoice Aggregator” OnAfterModifySalesInvoiceHeader
- OnAfterRenameEvent: Codeunit 5477 “Sales Invoice Aggregator” OnAfterRenameSalesInvoiceHeader
Procedures
IsFullyOpen(): Boolean: Checks if the invoice is fully open (no payments applied).CheckNoPrinted(): Validates that the invoice has been printed at least once.SendRecords(): Sends the invoice records using the customer’s document sending profile.SendProfile(var DocumentSendingProfile: Record "Document Sending Profile"): Sends the invoice using a specific document sending profile.PrintRecords(ShowRequestPage: Boolean): Prints the selected invoice records.UpdateDisputeStatus()+ BC24: Updates the Dispute Status field from the Dispute Status Id.UpdateDisputeStatusId()+ BC24: Updates the Dispute Status Id from the Dispute Status code.PrintToDocumentAttachment(var SalesInvoiceHeader: Record "Sales Invoice Header"): Prints the invoices and saves them as document attachments.EmailRecords(ShowDialog: Boolean): Sends the invoice records by email.GetDocTypeTxt(): Text[50]: Gets the full document type text for the invoice.LookupAdjmtValueEntries(): Opens a page showing value entries with adjustments for this invoice.GetCustomerVATRegistrationNumber(): Text: Gets the customer’s VAT registration number.GetCustomerVATRegistrationNumberLbl(): Text: Gets the label for the VAT registration number field.GetCustomerGlobalLocationNumber(): Text: Gets the customer’s global location number (GLN).GetCustomerGlobalLocationNumberLbl(): Text: Gets the label for the GLN field.GetSellToCustomerFaxNo(): Text: Gets the sell-to customer’s fax number.GetPaymentReference(): Text: Gets the payment reference for the invoice.GetPaymentReferenceLbl(): Text: Gets the label for the payment reference field.GetLegalStatement(): Text: Gets the legal statement from sales setup for printing on invoices.GetRemainingAmount(): Decimal: Gets the remaining amount from the associated customer ledger entry.ShowDimensions(): Shows the dimension set entries for this invoice.SetSecurityFilterOnRespCenter(): Sets a security filter based on the user’s responsibility center.GetDocExchStatusStyle(): Text: Gets the style class for displaying the document exchange status.ShowActivityLog(): Shows the activity log entries for this invoice.StartTrackingSite(): Opens the shipping agent’s tracking website for this shipment.GetSelectedPaymentsText(): Text: Gets the text describing the selected payment services for this invoice.GetWorkDescription(): Text: Gets the work description text from the blob field.GetCurrencySymbol(): Text[10]: Gets the currency symbol for display purposes.DocExchangeStatusIsSent(): Boolean: Checks if the invoice has been sent via document exchange.ShowCanceledOrCorrCrMemo(): Shows the credit memo that canceled or corrected this invoice.ShowCorrectiveCreditMemo(): Opens the credit memo that corrected this cancelled invoice.ShowCancelledCreditMemo(): Opens the credit memo that was cancelled by this corrective invoice.GetDefaultEmailDocumentName(): Text[150]: Gets the default document name for email purposes.
Plus 1 local procedures.
Triggers
OnDelete
Relations
- drill-down page Page 143 “Posted Sales Invoices”
- lookup page Page 143 “Posted Sales Invoices”
- Shipment Method Code: TableRelation Table 10 “Shipment Method”
- Amount: CalcFormula Table 113 “Sales Invoice Line”
- Amount Including VAT: CalcFormula Table 113 “Sales Invoice Line”
- Invoice Discount Amount: CalcFormula Table 113 “Sales Invoice Line”
- Direct Debit Mandate ID: TableRelation Table 1230 “SEPA Direct Debit Mandate”
- Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
- Location Code: TableRelation Table 14 “Location”
- Dispute Status: TableRelation Table 142 “Dispute Status”
- Dispute Status Id: TableRelation Table 142 “Dispute Status”
- Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Bill-to Customer No.: TableRelation Table 18 “Customer”
- Sell-to Customer No.: TableRelation Table 18 “Customer”
- Cancelled: CalcFormula Table 1900 “Cancelled Document”
- Corrective: CalcFormula Table 1900 “Cancelled Document”
- Closed: CalcFormula Table 21 “Cust. Ledger Entry”
- Reversed: CalcFormula Table 21 “Cust. Ledger Entry”
- Cust. Ledger Entry No.: TableRelation Table 21 “Cust. Ledger Entry”
- Ship-to Code: TableRelation Table 222 “Ship-to Address”
- Bill-to City: TableRelation Table 225 “Post Code”
- Bill-to Post Code: TableRelation Table 225 “Post Code”
- Sell-to City: TableRelation Table 225 “Post Code”
- Sell-to Post Code: TableRelation Table 225 “Post Code”
- Ship-to City: TableRelation Table 225 “Post Code”
- Ship-to Post Code: TableRelation Table 225 “Post Code”
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Transaction Type: TableRelation Table 258 “Transaction Type”
- Transport Method: TableRelation Table 259 “Transport Method”
- Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
- Company Bank Account Code: TableRelation Table 270 “Bank Account”
- Exit Point: TableRelation Table 282 “Entry/Exit Point”
- Area: TableRelation Table 284 “Area”
- Transaction Specification: TableRelation Table 285 “Transaction Specification”
- Payment Method Code: TableRelation Table 289 “Payment Method”
- Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
- Payment Terms Code: TableRelation Table 3 “Payment Terms”
- No. Series: TableRelation Table 308 “No. Series”
- Order No. Series: TableRelation Table 308 “No. Series”
- Pre-Assigned No. Series: TableRelation Table 308 “No. Series”
- Prepayment No. Series: TableRelation Table 308 “No. Series”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- Customer Disc. Group: TableRelation Table 340 “Customer Discount Group”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Remaining Amount: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
- Currency Code: TableRelation Table 4 “Currency”
- Comment: CalcFormula Table 44 “Sales Comment Line”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Bill-to Contact No.: TableRelation Table 5050 “Contact”
- Sell-to Contact No.: TableRelation Table 5050 “Contact”
- Campaign No.: TableRelation Table 5071 “Campaign”
- Opportunity No.: TableRelation Table 5092 “Opportunity”
- Coupled to Dataverse: CalcFormula Table 5331 “CRM Integration Record”
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
- Customer Price Group: TableRelation Table 6 “Customer Price Group”
- Language Code: TableRelation Table 8 “Language”
- Last Email Sent Message Id: CalcFormula Table 8909 “Email Related Record”
- Last Email Sent Time: CalcFormula Table 8909 “Email Related Record”
- Bill-to Country/Region Code: TableRelation Table 9 “Country/Region”
- Sell-to Country/Region Code: TableRelation Table 9 “Country/Region”
- Ship-to Country/Region Code: TableRelation Table 9 “Country/Region”
- VAT Country/Region Code: TableRelation Table 9 “Country/Region”
- Customer Posting Group: TableRelation Table 92 “Customer Posting Group”
Referenced by
26 fields in 18 objects relate to this table (TableRelation or CalcFormula).
- Table 5107 “Sales Header Archive”: Last Posting No., Last Prepayment No., Last Prepmt. Cr. Memo No.
- Table 18 “Customer”: Bill-To No. of Pstd. Invoices, No. of Pstd. Invoices
- Table 1900 “Cancelled Document”: Cancelled By Doc. No., Cancelled Doc. No.
- Table 36 “Sales Header”: Last Posting No., Last Prepayment No.
- Table 5109 “Purchase Header Archive”: Last Prepayment No., Last Prepmt. Cr. Memo No.
- Table 8064 “Billing Line Archive”: Correction Document No., Document No.
- Table 9060 “SB Owner Cue”: Overdue Sales Invoices, Unpaid Sales Invoices
- Table 113 “Sales Invoice Line”: Document No.
- Table 1313 “Activities Cue”: Sales Inv. - Pending Doc.Exch.
- Table 181 “Posted Gen. Journal Line”: Applies-to Invoice Id
- Table 30124 “Shpfy Payment Transaction”: Invoice No.
- Table 30133 “Shpfy Order Transaction”: Posted Invoice No.
- Table 30154 “Shpfy Suggest Payment”: Invoice No.
- Table 5875 “Phys. Invt. Order Header”: Last Posting No.
- Table 5992 “Service Invoice Header”: Last Posting No.
- Table 7190 “Sales Shipment Buffer”: Document No.
- Table 8061 “Billing Line”: Correction Document No.
- Table 9053 “Sales Cue”: Sales Inv. - Pending Doc.Exch.
Pages and codeunits on this table
- Page 1163 “Sales Invoices Due Next Week” (source table)
- Page 132 “Posted Sales Invoice” (source table)
- Page 1355 “Posted Sales Inv. - Update” (source table)
- Page 143 “Posted Sales Invoices” (source table)
- Page 397 “Sales Invoice Statistics” (source table)
- Page 6169 “E-Document QR Code Viewer” (source table)
- Page 9970 “Posted Sales Invoice API” (source table)
- Codeunit 1303 “Correct Posted Sales Invoice” (codeunit runs on it)
- Codeunit 1322 “Correct PstdSalesInv (Yes/No)” (codeunit runs on it)
- Codeunit 1323 “Cancel PstdSalesInv (Yes/No)” (codeunit runs on it)
- Codeunit 1409 “Sales Inv. Header - Edit” (codeunit runs on it)
- Codeunit 30362 “Shpfy Posted Invoice Export” (codeunit runs on it)
- Codeunit 315 “Sales Inv.-Printed” (codeunit runs on it)
Extended by
- Table extension 30102 “Shpfy Sales Invoice Header”
- Table extension 5027 “Serv. Decl. Sales Inv. Header”
- Table extension 6166 “Posted Sales Invoice with QR”
- Table extension 6238 “Sust. Sales Invoice Header”
- Table extension 8055 “Sales Invoice Header”
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 452 “Report Distribution Management” (4 calls:
EmailRecords → GetFullDocumentTypeText,GetDocTypeTxt → GetFullDocumentTypeText,SendProfile → GetFullDocumentTypeText, …) - Codeunit 10 “Type Helper” (2 calls:
GetWorkDescription → LFSeparator,GetWorkDescription → TryReadAsTextWithSepAndFieldErrMsg) - Codeunit 363 “PostSales-Delete” (2 calls:
OnDelete → DeleteSalesInvLines,OnDelete → IsDocumentDeletionAllowed) - Codeunit 4100 “Temp Blob” (2 calls:
GetWorkDescription → CreateInStream,GetWorkDescription → FromRecord) - Codeunit 700 “Page Management” (2 calls:
ShowCancelledCreditMemo → PageRun,ShowCorrectiveCreditMemo → PageRun) - Codeunit 1535 “Approvals Mgmt.” (1 call:
OnDelete → DeletePostedApprovalEntries) - Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 5700 “User Setup Management” (1 call:
SetSecurityFilterOnRespCenter → GetSalesFilter)
Countries that replace it
AU, BE, CA, ES, FI, FR, IT, MX, NL, NO, NZ, RU, SE, US
Deprecations
- field Coupled to CRM: Removed 26.0 (#if not CLEANSCHEMA26), “Replaced by flow field Coupled to Dataverse”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Sales Invoice Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.