Sales & Receivables Setup #311

Setup table in Microsoft Dynamics 365 Business Central. 105 fields, 1 records in Cronus demo.

105

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Primary Key.

All fields (105)

Sales & Receivables Setup — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Primary Key PK	Code	Normal
2	Discount Posting	Option	Normal
4	Credit Warnings	Option	Normal
5	Stockout Warning	Boolean	Normal
6	Shipment on Invoice	Boolean	Normal
7	Invoice Rounding	Boolean	Normal
8	Ext. Doc. No. Mandatory	Boolean	Normal
9	Customer Nos.	Code	Normal	→ No. Series #308
10	Quote Nos.	Code	Normal	→ No. Series #308
11	Order Nos.	Code	Normal	→ No. Series #308
12	Invoice Nos.	Code	Normal	→ No. Series #308
13	Posted Invoice Nos.	Code	Normal	→ No. Series #308
14	Credit Memo Nos.	Code	Normal	→ No. Series #308
15	Posted Credit Memo Nos.	Code	Normal	→ No. Series #308
16	Posted Shipment Nos.	Code	Normal	→ No. Series #308
17	Reminder Nos.	Code	Normal	→ No. Series #308
18	Issued Reminder Nos.	Code	Normal	→ No. Series #308
19	Fin. Chrg. Memo Nos.	Code	Normal	→ No. Series #308
20	Issued Fin. Chrg. M. Nos.	Code	Normal	→ No. Series #308
21	Posted Prepmt. Inv. Nos.	Code	Normal	→ No. Series #308
22	Posted Prepmt. Cr. Memo Nos.	Code	Normal	→ No. Series #308
23	Blanket Order Nos.	Code	Normal	→ No. Series #308
24	Calc. Inv. Discount	Boolean	Normal
25	Appln. between Currencies	Option	Normal
26	Copy Comments Blanket to Order	Boolean	Normal
27	Copy Comments Order to Invoice	Boolean	Normal
28	Copy Comments Order to Shpt.	Boolean	Normal
29	Allow VAT Difference	Boolean	Normal
30	Calc. Inv. Disc. per VAT ID	Boolean	Normal
31	Logo Position on Documents	Option	Normal
32	Check Prepmt. when Posting	Boolean	Normal
33	Prepmt. Auto Update Frequency	Option	Normal
35	Default Posting Date	Option	Normal
36	Default Quantity to Ship	Option	Normal
38	Post with Job Queue	Boolean	Normal
39	Job Queue Category Code	Code	Normal	→ Job Queue Category #471
40	Job Queue Priority for Post	Integer	Normal
41	Post & Print with Job Queue	Boolean	Normal
42	Job Q. Prio. for Post & Print	Integer	Normal
43	Notify On Success	Boolean	Normal
44	VAT Bus. Posting Gr. (Price)	Code	Normal	→ VAT Business Posting Group #323
45	Direct Debit Mandate Nos.	Code	Normal	→ No. Series #308
46	Allow Document Deletion Before	Date	Normal
47	Report Output Type	Option	Normal
49	Document Default Line Type	Option	Normal
50	Default Item Quantity	Boolean	Normal
51	Create Item from Description	Boolean	Normal
52	Archive Quotes	Option	Normal
53	Archive Orders	Boolean	Normal
54	Archive Blanket Orders	Boolean	Normal
55	Archive Return Orders	Boolean	Normal
56	Default G/L Account Quantity	Boolean	Normal
57	Create Item from Item No.	Boolean	Normal
58	Copy Customer Name to Entries	Boolean	Normal
61	Ignore Updated Addresses	Boolean	Normal
65	Skip Manual Reservation	Boolean	Normal
160	Disable Search by Name	Boolean	Normal
175	Allow Multiple Posting Groups	Boolean	Normal
176	Check Multiple Posting Groups	Option	Normal
200	Quote Validity Calculation	DateFormula	Normal
201	Sales Invoice Journal Template	Code	Normal	→ Gen. Journal Template #80
202	Sales Cr. Memo Journal Template	Code	Normal	→ Gen. Journal Template #80
203	Sales Prep. Invoice Template Name	Code	Normal	→ Gen. Journal Template #80
204	Sales Prep. Cr. Memo Template Name	Code	Normal	→ Gen. Journal Template #80
205	IC Sales Invoice Template Name	Code	Normal	→ Gen. Journal Template #80
206	IC Sales Cr. Memo Template Name	Code	Normal	→ Gen. Journal Template #80
207	Finance Charge Journal Template Name	Code	Normal	→ Gen. Journal Template #80
208	Reminder Journal Template Name	Code	Normal	→ Gen. Journal Template #80
209	Reminder Journal Batch Name	Code	Normal
210	Copy Line Descr. to G/L Entry	Boolean	Normal
211	Finance Charge Journal Batch Name	Code	Normal
393	Canceled Issued Reminder Nos.	Code	Normal	→ No. Series #308
395	Canceled Issued Fin. Charge Memo Nos.	Code	Normal	→ No. Series #308
1690	Bank Deposit Nos.	Code	Normal	→ No. Series #308
1691	Post Bank Deposits as Lump Sum	Boolean	Normal
5329	Write-in Product Type	Option	Normal
5330	Write-in Product No.	Code	Normal
5775	Auto Post Non-Invt. via Whse.	Option	Normal
5800	Posted Return Receipt Nos.	Code	Normal	→ No. Series #308
5801	Copy Cmts Ret.Ord. to Ret.Rcpt	Boolean	Normal
5802	Copy Cmts Ret.Ord. to Cr. Memo	Boolean	Normal
6600	Return Order Nos.	Code	Normal	→ No. Series #308
6601	Return Receipt on Credit Memo	Boolean	Normal
6602	Exact Cost Reversing Mandatory	Boolean	Normal
7000	Price Calculation Method	Option	Normal
7001	Price List Nos.	Code	Normal	→ No. Series #308
7002	Allow Editing Active Price	Boolean	Normal
7003	Default Price List Code	Code	Normal	→ Price List Header #7000
7005	Use Your Custom Lookup	Boolean	Normal
7101	Customer Group Dimension Code	Code	Normal	→ Dimension #348
7102	Salesperson Dimension Code	Code	Normal	→ Dimension #348
7103	Freight G/L Account No.	Code	Normal	→ G/L Account #15
7104	Link Doc. Date to Posting Date	Boolean	Normal
10500	Posting Date Check on Posting	Boolean	Normal
10501	Reverse Charge VAT Posting Gr.	Code	Normal	→ VAT Business Posting Group #323
10502	Domestic Customers	Code	Normal	→ VAT Business Posting Group #323
10503	Invoice Wording	Text	Normal
10507	Reverse Charge VAT Posting Gr.	Code	Normal	→ VAT Business Posting Group #323
10508	Domestic Customers	Code	Normal	→ VAT Business Posting Group #323
10509	Invoice Wording	Text	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (8)

Tables referenced by fields on the Sales & Receivables Setup table through TableRelation properties.

No. Series

#308 · Other · via Customer Nos., Quote Nos., Order Nos., Invoice Nos., Posted Invoice Nos., Credit Memo Nos., Posted Credit Memo Nos., Posted Shipment Nos., Reminder Nos., Issued Reminder Nos., Fin. Chrg. Memo Nos., Issued Fin. Chrg. M. Nos., Posted Prepmt. Inv. Nos., Posted Prepmt. Cr. Memo Nos., Blanket Order Nos., Direct Debit Mandate Nos., Canceled Issued Reminder Nos., Canceled Issued Fin. Charge Memo Nos., Bank Deposit Nos., Posted Return Receipt Nos., Return Order Nos., Price List Nos.

Job Queue Category

#471 · Other · via Job Queue Category Code

VAT Business Posting Group

#323 · Other · via VAT Bus. Posting Gr. (Price), Reverse Charge VAT Posting Gr., Domestic Customers, Reverse Charge VAT Posting Gr., Domestic Customers

Gen. Journal Template

#80 · Other · via Sales Invoice Journal Template, Sales Cr. Memo Journal Template, Sales Prep. Invoice Template Name, Sales Prep. Cr. Memo Template Name, IC Sales Invoice Template Name, IC Sales Cr. Memo Template Name, Finance Charge Journal Template Name, Reminder Journal Template Name

Price List Header

#7000 · Pricing & Discounts · via Default Price List Code

Dimension

#348 · Dimensions · via Customer Group Dimension Code, Salesperson Dimension Code

G/L Account

#15 · General Ledger · via Freight G/L Account No.