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

Account Optional 2 - Database Profiles

Datafile Software

Account Optional 2 - Database Profiles

Data Item Type Alternative Notes

Del-Add xref to A/c X(10) Y Delivery address not blank: — this account record is merely a delivery address for account specified here.Orders may be created, but sales transactions are posted to the account specified here

Stm-Add xref to A/c X(10) Y Statement address not blank: — this is a true account, but statements are sent to the account whose code is entered here. The account address is also printed on the statement

Grp-Add xref to A/c X(10) Y Group address not blank: — this is a true account, but code written here is also written to the transaction.You can sort and select analyses and reports using this code

Date last trans D E Dates of the last transaction of any type posted

Date last invoice D E Date of the last invoice transaction posted

Date last payment D E Date of the last payment transaction posted

Last Statement date D E Date when a statement was last printed for this account, only applicable if statement set to update the date. (P/L only, S/L option on ‘Account Statements’ profile screen.

Statement page no N Keeps running statement page number, so customer can file in strict page number sequence, again only applicable if statement set to maintain this. (Again, P/L only, S/L on ‘Account Statements’).

Last trading day N T Day in month which represents cut-off for payment due.E.g. if invoices dated to 19th of month should be paid by 10th of following month, then last trading day is "20”. Ledger itself may have default last trading day, but individual customers can have a different day

Forward Balance L K Where forward postings are allowed this holds the outstanding value of these forward transactions.

Forward Unalloc. L K This holds the unallocated value of any forward payment or credit transactions.

Forward Turnover L K This holds the turnover value of any forward transactions.

Forward Cost L K Sales Ledger only. This holds the cost of sales value of any forward transactions.

Default analysis N T, C Holds default analysis to be prompted for customer transactions

Default nominal X (10) Y Holds default nominal to be prompted for this accounts transactions

Open year balance L K Item updating with the open year balance for balance b/f accounts.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Reprint Period Invoices
Viewed 2037 times since Mon, Jul 2, 2012
Recalculate Debtor/Creditor Control
Viewed 1971 times since Mon, Jul 2, 2012
Additional Lookups on Account Maintenance
Viewed 2191 times since Wed, Jun 13, 2012
Credit Control Manager Apply Colour Highlighting Rules Sales Ledger
Viewed 1963 times since Fri, May 27, 2016
Moving, Deleting and Amending Items - Document Design Manager
Viewed 2036 times since Mon, Jul 2, 2012
Automatic Payments – Set Transaction Description from Account
Viewed 61 times since Wed, Oct 16, 2024
VAT Form 100 - Group VAT Registration
Viewed 3847 times since Tue, Oct 9, 2018
List All Transactions
Viewed 1798 times since Mon, Jul 2, 2012
Account Aged Analysis - Database Profiles
Viewed 1901 times since Mon, Jul 2, 2012
Ledger Control Summary
Viewed 1868 times since Mon, Jul 2, 2012