Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Account Mandatory - Database Profiles |
Article Number: 1394 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 3:30 PM
|
Datafile Software Account Mandatory - Database Profiles Data Item Type Alternative Notes Account code X (10) X, Y Maximum size of 10 characters Account name X (30) X, & Up to 64 characters. You could specify separate data items for title, initials and surname, grouped to give full name Balance b/forward L K Holds the balance brought forward (whether open-item or balance-forward account) as at the end of the previous period Current balance L K Holds the current balance of the account, including forward transaction values (a separate field holds the value of forward transactions, see later) Unallocated total L K Holds the total value of credits (whether payments, credit notes, or invoice adjustments) which have yet to be allocated to debit transactions. It is not used in balance-forward accounts. It also includes any unallocated credit amounts in forward transactions Open item ?-type Set to Y if account is open-item, N or blank indicating balance-forward. If application system profile (see appendix B) specifies all accounts to be open-item, then is set to Y automatically Analysis code T N, X, Y Used by Customer Analysis Report to analyse customer turnover (for example) by county, salesman, TV region or other characteristic assigned to the analysis code First transaction Y (6) N, Y (5–8) If transaction file likely to exceed 1M, then make Y (8) Last transaction Y (6) N, Y (5–8) If transaction file likely to exceed 1M, then make Y (8). Pointers used internally to access transaction chain in transaction file.Record numbers of the first and last transactions are held here. |
Attachments
There are no attachments for this article.
|
Application Screen Layouts
Viewed 1980 times since Mon, Jul 2, 2012
Set Auto Expand Data Files
Viewed 1581 times since Mon, Jul 2, 2012
Supplier Payments Due (Purchase Ledger)
Viewed 1557 times since Mon, Jul 2, 2012
Trans Optional 1 - Database Profiles
Viewed 1628 times since Mon, Jul 2, 2012
Credit Control Manager Apply Colour Highlighting Rules Sales Ledger
Viewed 1645 times since Fri, May 27, 2016
Add Debtor / Creditor Control Memo from Ledger Enquiry
Viewed 3943 times since Fri, Jun 8, 2012
Configuration
Viewed 1532 times since Mon, Jul 2, 2012
Contact Management - Copy Items from Activity to Accounts and Contacts
Viewed 3769 times since Tue, Mar 3, 2020
System Status - Application User Facilities
Viewed 1483 times since Mon, Jul 2, 2012
Provide for Bad Debts - Sales Ledger
Viewed 1695 times since Mon, Jul 2, 2012
|