Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Account Optional 3 - Database Profiles |
Article Number: 1397 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 3:29 PM
|
Datafile Software Account Optional 3 - Database Profiles Data Item Type Alternative Notes Allocation letter X (1) Holds last letter used to mark transactions making up a particular allocation. It is advanced by one letter after each allocation Alloc-in-progress ?-type A custom field, i.e. not in general use, that allows transactions to be entered against an account when allocations are in progress but block the account being allocated by more than one user at once. First job record Y (6) N, Y (5) Sales Ledger only Last job record Y (6) N, Y (5) Sales Ledger only. These last two prompts hold the record numbers of the first and last job records for this account in the job costing system Autopay amount L K Purchase Ledger only. This holds the amount to be paid from the last automatic payment run. Autopay disc amt L K Purchase Ledger only. This item holds the discount taken on the last automatic payment run. Autopay tx no Y(6) N, Y(5–8) Purchase Ledger only. Generated payment transaction (used by cheque run) Retain doc days N Where text copies of documents are held on file for use with the DeskTop Ledger Enquiriesfacility, you can set a limit to the number of days they are held for each account. Delete at year-end ?-type If set to Y, then account removed by batch delete facility at year end, if no balance or outstanding orders. Memo Reference Y(6) Holds reference number of any memo attached to an account. Add two-digit application code (SL/PL) plus company suffix for filename Discount Group N T Used for discount matrix if present EC Country X (2) Two-character country code as determined by EC EC Tax Reg X (15) VAT code of customer/supplier O/s Orders L K Value of orders outstanding on order processing system Fwd O/S Orders L K Value of orders with a F-Forward status on order processing system. Due-Date D of Wk N X, Y, T If present, then rounds up due date to the specified day of the week, where 1 = Sunday, 2 = Monday, and so on Sett Disc % (2) K L Holds the second set of settlement terms for use in Order Processing. This holds the settlement rate. Sett Days (2) X (4) N This holds the settlement days. |
Attachments
![]() There are no attachments for this article.
|
Set Split Period Posting by Account
Viewed 125 times since Wed, Oct 16, 2024
Document Design Manager
Viewed 2217 times since Mon, Jul 2, 2012
Nominal Analysis
Viewed 1821 times since Mon, Jul 2, 2012
Account Statements (Sales Ledger) - Database Profiles
Viewed 2477 times since Mon, Jul 2, 2012
Sub-Contractor Accessory - Transaction Entry
Viewed 1816 times since Mon, Jul 2, 2012
Trans Optional 3 - Database Profiles
Viewed 1774 times since Mon, Jul 2, 2012
Change Order Status - Stock Record Locking
Viewed 73 times since Thu, Jan 2, 2025
Aged Analysis - Debtor Memo and Transaction Notes to Excel
Viewed 11600 times since Fri, Jun 8, 2012
Automatic Payments – Set Transaction Description from Account
Viewed 35 times since Wed, Oct 16, 2024
Save Turnover and Cost Values for Previous Years
Viewed 1655 times since Fri, May 27, 2016
|