Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Account Optional 1 - Database Profiles |
Article Number: 1395 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 3:30 PM
|
Datafile Software Account Optional 1 - Database Profiles Data Item Type Alternative Notes Address line 1 X (30) Up to 64 characters each. Up to 4 lines are used by the program for confirming a customer name and address. The accounts file also contains a separate item for post code that isn’t included in the profiles. Address line 2 X (30) Second address line Address line 3 X (30) Third address line Address line 4 X (30) Fourth address line Prospect Ident X (1) ?-type Sales Ledger only. A "Y” (or any other value which you define under system profiles) tells the program that this account is a prospect and not a live account. Suspended account X (1) ?-type Purchase Ledger only. Equivalent of the prospect flag for the purchase ledger. First active trans Y (6) N, Y (5–8) This must be present if fully-allocated transactions are to be retained after period-end. Holds record number of first active transaction for this account Tax code X (1) Y (1) Tax code normally used for each customer. Used as the default tax code when posting invoice transactions Credit days X (4) N, T If present, program uses it to calculate date when invoice is due. If N-type field then holds number of days (e.g.30). If X (4), then it can be used to hold more complex payment terms. It works in conjunction with Last trading day item — see below Credit limit L K, *-type Used in credit checking at invoice posting or if creating invoice Account on stop ?-type If account is on stop (this data item is set to Y) then you are prevented from posting any invoice transaction to it Line discount % K L, M, *-type Used only by invoicing and sales order processing programs, the line discount rate is used as default discount rate when entering customer’s invoice or order Overall discount % K L, M, *-type Again used only by the invoicing and order processing programs, overall discount rate is used as default overall discount rate when entering the account’s invoice or order Which Price no. X(1) Y(1) Sales Ledger only. Used by invoicing and sales order processing to determine appropriate product price displayed during invoicing Settlement disc % K L, *-type These items permit different settlement discounts and time periods to be defined for each account. This contains the discount percentage. Settlement days N T, X This contains the number of days the settlement discount is to be allowed for. Date set up D E When account is created, system date is entered into this field |
Attachments
![]() There are no attachments for this article.
|
Nominal Analysis
Viewed 2310 times since Mon, Jul 2, 2012
Save Turnover and Cost Values for Previous Years
Viewed 2169 times since Fri, May 27, 2016
Authority Level for Debtors Memo Access
Viewed 2004 times since Tue, Jun 12, 2012
Include Currency Accounts in Auto-Payment Procedures
Viewed 1844 times since Fri, May 27, 2016
Save Statement Balance to Account / Transactions
Viewed 2093 times since Fri, Oct 26, 2012
Security and User Manager
Viewed 2054 times since Mon, Jul 2, 2012
Additional Notes on Transactions
Viewed 2469 times since Tue, Jun 12, 2012
Account Invoicing (Sales Ledger) - Database Profiles
Viewed 2564 times since Mon, Jul 2, 2012
Credit Restocking Fee (SOP Only)
Viewed 271 times since Thu, Jan 2, 2025
Edit System Status Display
Viewed 1980 times since Mon, Jul 2, 2012
|