BC Observatoryunofficial, made by waldo
tablePurchasing & Payablesofficial - Microsoftderived - from the source, no model text

Table 312 "Purchases & Payables Setup"

Base Application · Microsoft.Purchases.Setup

Open in Claude312.mdSource on GitHub

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC251 fields added
  4. BC267 fields removed, 2 procedures added
  5. BC272 fields changed, 1 fields added
  6. BC2866 fields changed, 1 fields added
  7. BC291 fields changed
  8. BC30unchanged

Neighbourhood 23 connected objects and pages

Table 308 "No. Series" (relates to, 15 links)No. SeriesTable 80 "Gen. Journal Template" (relates to, 6 links)Table 15 "G/L Account" (relates to, 2 links)G/L AccountTable 471 "Job Queue Category" (relates to)Job Queue CategoryTable 7000 "Price List Header" (relates to)Price List HeaderPage 460 "Purchases & Payables Setup" (pages and codeunits on it, 3 links)Purchases & Payables SetupPage 1402 "Purchase No. Series Setup" (pages and codeunits on it)Purchase No. Series SetupTable extension 6162 "E-Doc. Purch. Payables Setup" (extended by)E-Doc. Purch. Payables SetupTable extension 6796 "Withholding Purch Setup Ext" (extended by)Withholding Purch Setup ExtCodeunit 6103 "E-Document Subscribers" (event subscribers, 2 links)E-Document SubscribersAnalyze data in lists with Copilot (preview) (Learn pages)Analyze data in lists with C…Analyze list page and query data using data analysis (Learn pages)Analyze list page and query …Apply Entries in Different Currencies (Learn pages)Apply Entries in Different C…Archive sales, purchase, project, and service documents (Learn pages)Archive sales, purchase, pro…Create number series (Learn pages)How to work with VAT on sales and purchases (Learn pages)How to work with VAT on sale…Overview of tasks to manage to purchase (Learn pages)Overview of tasks to set up purchasing (Learn pages)Register a new vendor (Learn pages)Set up a posting date warning [GB] (Learn pages)Set up invoice rounding (Learn pages)Set up prepayments (Learn pages)Set up prices and discounts (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Purchases.Setup · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 460 “Purchases & Payables Setup” (13 Learn pages).

Properties

Property Value
Caption Purchases & Payables Setup
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
1 Primary Key Δ BC26 Code[10] —
2 Discount Posting Δ BC28 Option Specifies the type of purchase discounts to post separately. No Discounts: Discounts are not posted separately but instead will subtract the discount before posting. Invoice Discounts: The invoice discount and invoice amount are posted simultaneously, based on the Purch. Inv. Disc. Account field in … OptionCaption: No Discounts,Invoice Discounts,Line Discounts,All Discounts
6 Receipt on Invoice Δ BC28 Boolean Specifies that a posted receipt and a posted invoice are automatically created when you post an invoice.
7 Invoice Rounding Δ BC28 Boolean Specifies if amounts are rounded for purchase invoices. Rounding is applied as specified in the Inv. Rounding Precision (LCY) field in the General Ledger Setup window.
8 Ext. Doc. No. Mandatory Δ BC28 Boolean Specifies if it is mandatory to enter an external document number in the External Document No. field on a purchase header or the External Document No. field on a general journal line.
9 Vendor Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to vendors. TableRelation Table 308 “No. Series” (No. Series)
10 Quote Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to purchase quotes. TableRelation Table 308 “No. Series” (No. Series)
11 Order Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to purchase orders. TableRelation Table 308 “No. Series” (No. Series)
12 Invoice Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to purchase invoices. To see the number series that have been set up in the No. Series table, click the field. TableRelation Table 308 “No. Series” (No. Series)
13 Posted Invoice Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to posted purchase invoices. TableRelation Table 308 “No. Series” (No. Series)
14 Credit Memo Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to purchase credit memos. To see the number series that have been set up in the No. Series table, click the field. TableRelation Table 308 “No. Series” (No. Series)
15 Posted Credit Memo Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to posted purchase credit memos. TableRelation Table 308 “No. Series” (No. Series)
16 Posted Receipt Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to posted receipts. TableRelation Table 308 “No. Series” (No. Series)
17 Posted Self-Billing Inv. Nos. + BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to posted self-billing purchase invoices. TableRelation Table 308 “No. Series” (No. Series)
19 Blanket Order Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to blanket purchase orders. To see the number series that have been set up in the No. Series table, click the field. TableRelation Table 308 “No. Series” (No. Series)
20 Calc. Inv. Discount Δ BC28 Boolean Specifies if the invoice discount amount is automatically calculated with purchase documents. If this check box is selected, then the invoice discount amount is calculated automatically, based on purchase lines where the Allow Invoice Disc. field is selected.
21 Appln. between Currencies Δ BC28 Option Specifies whether it is allowed to apply vendor payments in different currencies. None: All entries involved in one application must be in the same currency. EMU: You can apply entries in euro and one of the old national currencies (for EMU countries/regions) to one another. All: You can apply entri… OptionCaption: None,EMU,All
22 Copy Comments Blanket to Order Δ BC28 Boolean Specifies whether to copy comments from blanket purchase orders to purchase orders.
23 Copy Comments Order to Invoice Δ BC28 Boolean Specifies whether to copy comments from purchase orders to purchase invoices.
24 Copy Comments Order to Receipt Δ BC28 Boolean Specifies whether to copy comments from purchase orders to receipts.
25 Allow VAT Difference Δ BC28 Boolean Specifies whether to allow the manual adjustment of VAT amounts in purchase documents.
26 Calc. Inv. Disc. per VAT ID Δ BC28 Boolean Specifies whether the invoice discount is calculated according to the VAT identifier that is defined in the VAT posting setup. If you choose not to select this check box, the invoice discount will be calculated based on the invoice total.
27 Posted Prepmt. Inv. Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to posted purchase prepayment invoices. TableRelation Table 308 “No. Series” (No. Series)
28 Posted Prepmt. Cr. Memo Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to purchase prepayment credit memos. TableRelation Table 308 “No. Series” (No. Series)
29 Check Prepmt. when Posting Δ BC28 Boolean Specifies that you cannot receive or invoice an order that has an unpaid prepayment amount.
33 Prepmt. Auto Update Frequency Δ BC28 Option Specifies how often the job must run that automatically updates the status of orders that are pending prepayment. OptionCaption: Never,Daily,Weekly; DataClassification SystemMetadata
35 Default Posting Date Δ BC28 Δ BC29 Enum “Default Posting Date” Specifies the default posting date for purchase documents that you create manually. If you select Work Date, the Posting Date is set to the current work date when you create a document. If you select No Date, the Posting Date is left blank and must be entered before posting. Does not apply to purcha… enum Enum 35 “Default Posting Date”
36 Default Qty. to Receive Δ BC27 Option Specifies the default value for the Qty. to Receive field on purchase order lines and the Return Qty. to Ship field on purchase return order lines. If you choose Blank, the quantity to receive is not automatically calculated. OptionCaption: Remainder,Blank
38 Post with Job Queue Δ BC28 Boolean Specifies if you use job queues to post purchase documents in the background.
39 Job Queue Category Code Δ BC28 Code[10] Specifies the code for the category of the job queue that you want to associate with background posting. TableRelation Table 471 “Job Queue Category” (Job Queue Category)
40 Job Queue Priority for Post Integer —
41 Post & Print with Job Queue Δ BC28 Boolean Specifies if you use job queues to post and print purchase documents in the background.
42 Job Q. Prio. for Post & Print Integer —
43 Notify On Success Δ BC28 Boolean Specifies a setting that has no effect. Legacy field.
46 Allow Document Deletion Before Δ BC28 Date Specifies if and when posted purchase invoices and credit memos can be deleted. If you enter a date, posted purchase documents with a posting date on or after this date cannot be deleted.
47 Report Output Type Δ BC28 Enum “Setup Report Output Type” Specifies the output of the report that will be scheduled with a job queue entry when the Post and Print with Job Queue check box is selected. enum Enum 483 “Setup Report Output Type”
49 Document Default Line Type Δ BC28 Enum “Purchase Line Type” Specifies the default value for the Type field on the first line in new purchase documents. If needed, you can change the value on the line. enum Enum 39 “Purchase Line Type”
51 Default G/L Account Quantity + BC25 Δ BC28 Boolean Specifies that Quantity is set to 1 on lines of type G/L Account.
52 Archive Quotes Δ BC28 Option Specifies if you want to automatically archive purchase quotes when: deleted, processed or printed. OptionCaption: Never,Question,Always
53 Archive Orders Δ BC28 Boolean Specifies if you want to automatically archive purchase orders when: deleted, posted or printed.
54 Archive Blanket Orders Δ BC28 Boolean Specifies if you want to automatically archive purchase blanket orders when: deleted, processed or printed.
55 Archive Return Orders Δ BC28 Boolean Specifies if you want to automatically archive purchase return orders when deleted or posted.
56 Ignore Updated Addresses Δ BC28 Boolean Specifies if changes to addresses made on purchase documents are copied to the vendor card. By default, changes are copied to the vendor card.
57 Create Item from Item No. Δ BC27 Δ BC28 Boolean Specifies if the system will suggest to create a new item when no item matches the number that you enter in the No. Field on purchase lines. obsolete Pending 27.0; #if not CLEANSCHEMA29
58 Copy Vendor Name to Entries Δ BC28 Boolean Specifies if you want the name on vendor cards to be copied to vendor ledger entries during posting.
59 Copy Inv. No. To Pmt. Ref. Δ BC28 Boolean Specifies if the value of the Vendor Invoice No. field must be copied to the Payment Reference field during posting unless the Payment Reference field is not blank.
160 Disable Search by Name Δ BC28 Boolean Specifies that you can change the names of vendors on open purchase documents. The change applies only to the documents. DataClassification SystemMetadata
175 Allow Multiple Posting Groups Δ BC28 Boolean Specifies if multiple posting groups can be used for the same vendor in purchase documents. DataClassification SystemMetadata
176 Check Multiple Posting Groups Δ BC28 enum “Posting Group Change Method” Specifies implementation method of checking which posting groups can be used for the vendor. enum Enum 960 “Posting Group Change Method”; DataClassification SystemMetadata
200 P. Invoice Template Name Δ BC28 Code[10] Specifies that you can select the journal template to use for posting purchase invoices. TableRelation Table 80 “Gen. Journal Template” (“Gen. Journal Template” where(Type = filter(Purchases)))
201 P. Cr. Memo Template Name Δ BC28 Code[10] Specifies that you can select the journal template to use for posting purchase credit memos. TableRelation Table 80 “Gen. Journal Template” (“Gen. Journal Template” where(Type = filter(Purchases)))
202 P. Prep. Inv. Template Name Δ BC28 Code[10] Specifies which general journal template to use for purchase prepayment invoices. TableRelation Table 80 “Gen. Journal Template” (“Gen. Journal Template” where(Type = filter(Purchases)))
203 P. Prep. Cr.Memo Template Name Δ BC28 Code[10] Specifies which general journal template to use for purchase prepayment credit memos. TableRelation Table 80 “Gen. Journal Template” (“Gen. Journal Template” where(Type = filter(Purchases)))
204 IC Purch. Invoice Templ. Name Δ BC28 Code[10] Specifies the intercompany journal template to use for purchase invoices. TableRelation Table 80 “Gen. Journal Template” (“Gen. Journal Template” where(Type = filter(Intercompany)))
205 IC Purch. Cr. Memo Templ. Name Δ BC28 Code[10] Specifies the intercompany journal template to use for posting purchase credit memos. TableRelation Table 80 “Gen. Journal Template” (“Gen. Journal Template” where(Type = filter(Intercompany)))
210 Copy Line Descr. to G/L Entry Δ BC28 Boolean Specifies that the description on document lines of type G/L Account will be carried to the resulting general ledger entries. DataClassification SystemMetadata
1217 Debit Acc. for Non-Item Lines Δ BC28 Code[20] Specifies the G/L account that is automatically inserted on purchase lines of type debit that are created from electronic documents when the incoming document line does not contain an identifiable item. Any incoming document line that does not have a GTIN or the vendor’s item number will be converte… TableRelation Table 15 “G/L Account” (“G/L Account” where(“Direct Posting” = const(true), “Account Type” = const(Posting), Blocked = const(false)))
1218 Credit Acc. for Non-Item Lines Δ BC28 Code[20] Specifies the G/L account that is automatically inserted on purchase lines of type credit that are created from electronic documents when the incoming document line does not contain an identifiable item. Any incoming document line that does not have a GTIN or the vendor’s item number will be convert… TableRelation Table 15 “G/L Account” (“G/L Account” where(“Direct Posting” = const(true), “Account Type” = const(Posting), Blocked = const(false)))
5775 Auto Post Non-Invt. via Whse. Δ BC28 Enum “Non-Invt. Item Whse. Policy” Specifies if non-inventory item lines in a purchase document will be posted automatically when the document is posted via warehouse. None: Do not automatically post non-inventory item lines. Attached/Assigned: Post item charges and other non-inventory item lines assigned or attached to regular items… enum Enum 5775 “Non-Invt. Item Whse. Policy”
5800 Posted Return Shpt. Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to posted return shipments. TableRelation Table 308 “No. Series” (No. Series)
5801 Copy Cmts Ret.Ord. to Ret.Shpt Δ BC28 Boolean Specifies that comments are copied from the purchase return order to the posted return shipment.
5802 Copy Cmts Ret.Ord. to Cr. Memo Δ BC28 Boolean Specifies whether to copy comments from purchase return orders to purchase credit memos.
6600 Return Order Nos. Δ BC28 Code[20] Specifies the number series that is used to assign numbers to new purchase return orders. TableRelation Table 308 “No. Series” (No. Series)
6601 Return Shipment on Credit Memo Δ BC28 Boolean Specifies that a posted return shipment and a posted purchase credit memo are automatically created when you post a credit memo.
6602 Exact Cost Reversing Mandatory Δ BC28 Boolean Specifies that a return transaction cannot be posted unless the Appl.-to Item Entry field on the purchase order line specifies an entry.
7000 Price Calculation Method Δ BC28 Enum “Price Calculation Method” Specifies the price calculation method that will be default for purchase transactions. enum Enum 7000 “Price Calculation Method”
7001 Price List Nos. Δ BC28 Code[20] Specifies the code for the number series that will be used to assign numbers to purchase price lists. TableRelation Table 308 “No. Series” (No. Series)
7002 Allow Editing Active Price Δ BC28 Boolean Specifies it the existing active purchase price line can be modified or removed, or a new price line can be added to the active price list. DataClassification SystemMetadata
7003 Default Price List Code Δ BC28 Code[20] Specifies the code of the existing purchase price list that stores all new price lines created in the price worksheet page. TableRelation Table 7000 “Price List Header” (“Price List Header” where(“Price Type” = const(Purchase), “Source Group” = const(Vendor), “Allow Updating Defaults” = const(true)))
7004 Link Doc. Date To Posting Date Δ BC28 Boolean Specifies whether the document date changes when the posting date is modified. DataClassification SystemMetadata
10500 Posting Date Check on Posting + BC27 Δ BC28 Boolean Specifies if you want to see a warning when you post a purchase document with a posting date that is different from the Work Date.
11320 Check Doc. Total Amounts + BC26 Boolean Specifies if you want the Doc. Amount Incl. VAT field in Purchase Invoice and Purchase Credit Memo to be compared to the sum of the VAT amounts fields in the purchase lines. If the amounts are not the same, you will be notified when posting the document. The totals will always be checked for invoice…

Keys

  • Key1: Primary Key (clustered)

Events published

  • OnAfterShouldDocumentTotalAmountsBeChecked(PurchaseHeader: Record "Purchase Header"; var ShouldDocumentTotalAmountsBeChecked: Boolean) + BC26 (integration): Event to customize whether the document total amounts should be checked or not. If the system is configured to check the document totals, it will be checked regardless of the code executed in this event. When using this event, consider that it can have multiple subscribers: it’s a good practice to c…
  • OnCanDocumentTotalAmountsBeEditable(PurchaseHeader: Record "Purchase Header"; var CanDocumentTotalAmountsBeEdited: Boolean) + BC26 (integration): Event to customize whether the document total amounts can be edited or not. By default, if the amounts are shown in the document they can be edited, however we provide an event to allow extensions to change this behavior. When using this event, consider that it can have multiple subscribers: it’s a …

Procedures

  • GetRecordOnce()
  • JobQueueActive(): Boolean
  • ShouldDocumentTotalAmountsBeChecked(PurchaseHeader: Record "Purchase Header"): Boolean + BC26
  • CanDocumentTotalAmountsBeEdited(PurchaseHeader: Record "Purchase Header"): Boolean + BC26

Relations

Pages and codeunits on this table

Extended by

Recent changes

Countries that replace it

AT, AU, CA, CH, DE, ES, FI, GB, IT, MX, NO, NZ, RU, SE, US

Deprecations

  • field Create Item from Item No.: Pending 27.0 (#if not CLEANSCHEMA29), “Discontinued function”

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). 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: "Purchases & Payables Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources