Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Trans Mandatory - Database Profiles |
Article Number: 1406 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 3:26 PM
|
Datafile Software Trans Mandatory - Database Profiles Data Item Type Alternative Notes Transaction
type Y(1) X(1) Holds
the type of the transaction record.: 2 Payment transaction 3 Credit note transaction 4 Invoice adjustment transaction 5 Payment adjustment The
valid analysis types are: 7 Revaluation difference — Foreign currency ledgers; the effect of a holding rate revaluation on an account, must be updated to the nominal ledger 8 Temporary provisional amount; used in bad debt provisions, and also foreign currency spot-rate revaluations (provisional transactions in nominal ledger) Transaction date D E Date given to transaction Account code X (10) X, Y Must be the same data item type and size as given for the account code in the account file Reference X (6) X, Y Can be increased to Y(8), or X(10) Description X (20) X, Y Up to maximum of 28 characters Amount L K Net amount excluding tax Tax code X (1) Y (1) Holds tax code number or letter used for this transaction Tax amount L K Tax amount. Payment discount L K Payment discount Total *-type Calculated data item. Elements in calculation are goods amount, plus tax, plus discount —one of the latter two items is always zero Allocation amount L K In an open item a/c transaction, this shows amount allocated so far. For £100 invoice, if it shows £100 then invoice is fully paid; if it shows £20, there is £80 outstanding; if zero, the full invoice is outstanding Account record no Y (6) N,Y (5) Record no. in accounts file of account record Next transaction Y (6) N,Y(5–8)? Record number of next transaction for account in transaction file Outstanding *-type Total less allocated amount |
Attachments
![]() There are no attachments for this article.
|
Application Screen Layouts
Viewed 2245 times since Mon, Jul 2, 2012
Multi-Period Allocations
Viewed 2144 times since Wed, Jun 13, 2012
Sales/Purchase Document Facilities
Viewed 1846 times since Mon, Jul 2, 2012
Cheque Printing (Purchase Ledger)
Viewed 1855 times since Mon, Jul 2, 2012
Aged Analysis – Select to Age on Invoice or Due Date
Viewed 51 times since Wed, Oct 16, 2024
Credit Control Manager - Selection Criteria for Accounts
Viewed 2552 times since Fri, Jun 8, 2012
Sales / Purchase Transactions - Application User Facilities
Viewed 2048 times since Mon, Jul 2, 2012
Transaction / Detail Enquiries
Viewed 13571 times since Mon, Jul 2, 2012
Contact Management - List Activities in LIFO Order
Viewed 1780 times since Tue, Mar 3, 2020
Which Price Matrix Entries
Viewed 2152 times since Fri, May 20, 2016
|