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.
|
Ledger Enquiry – View Documents from Transaction List
Viewed 5091 times since Wed, Jun 13, 2012
Additional Transaction Reports
Viewed 2073 times since Tue, Jun 12, 2012
ADD – Adding a New Account
Viewed 2404 times since Fri, Jun 29, 2012
Customers / Suppliers
Viewed 1877 times since Fri, Jun 29, 2012
Save Aged Analysis
Viewed 1786 times since Mon, Jul 2, 2012
Sales/Purchase Document Facilities
Viewed 1822 times since Mon, Jul 2, 2012
Cheque Printing (Purchase Ledger) - Application User Facilities
Viewed 2250 times since Mon, Jul 2, 2012
Disputed Transactions - Record Reason for Dispute
Viewed 2339 times since Fri, Jun 8, 2012
UPDATE – Amend an Existing Account
Viewed 1212 times since Mon, Jul 2, 2012
Allocations by Account - Purchase Ledger
Viewed 1939 times since Mon, Jul 2, 2012
|