Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Account Mandatory - Database Profiles

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.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
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