Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Account Optional 2 - Database Profiles |
Article Number: 1396 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 3:29 PM
|
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. |
Attachments
![]() There are no attachments for this article.
|
Account Invoicing (Sales Ledger) - Database Profiles
Viewed 2520 times since Mon, Jul 2, 2012
Manually Generate Payments - Purchase Ledger
Viewed 2126 times since Mon, Jul 2, 2012
Invoice Document Clear Down Options
Viewed 2021 times since Fri, Jun 8, 2012
Disputed Transactions - Record Reason for Dispute
Viewed 2437 times since Fri, Jun 8, 2012
Credit Control Manager / Next Action Facility
Viewed 2857 times since Mon, Jun 11, 2012
System Status - Application User Facilities
Viewed 1794 times since Mon, Jul 2, 2012
Record Groups as Items in Discount and Supplier Matrix
Viewed 2747 times since Fri, May 27, 2016
Change Due Dates
Viewed 2042 times since Mon, Jul 2, 2012
Period End & Year End
Viewed 2192 times since Mon, Jul 2, 2012
Edit System Status Display
Viewed 1939 times since Mon, Jul 2, 2012
|