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

Trans Optional 3 - Database Profiles

Datafile Software

Trans Optional 3 - Database Profiles

Data Item Type Alternative Notes

EC Country X (3) Copied from accounts file; needed for EC reports

EC Tax Reg X (15) Copied from accounts file; needed for EC reports

EC Acquis Tax L K Purchase Ledger only. EC acquisition tax calculated when transaction posted

Last alloc amt L K The last amount allocated; used for printing remittance advices

Pay disc taken L K Actual payment discount taken, used for printing remittance advices

Date allocated D E Purchase Ledger only (Sales ledger has this on Transaction Optional 1 screen) This holds the date the transaction was fully allocated.

Due "AsAt" Date D E Purchase Ledger Only. Used for special forward dating terms

Qty (calc goods) K L, M Purchase Ledger Only. To allow quantity times price for gross, and saved for stock update this item holds the quantity.

Price (calc goods) K L, M Purchase Ledger Only. This item holds the cost price.

Alloc comment X (20) Optional comment when making allocations

Job Reference X (16) Sales Ledger Only. (Purchase Ledger holds this on Trans Optional 2) This holds the job reference for the transaction.

Job cost updated ? Sales Ledger Only. This is flagged to show the job file has been updated from this transaction.

Sett disc amt (2) L K, *-type Order Processing systems can calculate a second set of settlement terms for giving a smaller discount if the transaction is paid outside the first settlement period.This and the next two items store these values for memo purposes (they are not available within the allocations input)

Sett disc days (2) N T, X

Sett disc date (2) D E

Payment Type N T Sales Ledger Only. Holds the payment type when using multiple payment analysis.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Transaction Summary
Viewed 1766 times since Mon, Jul 2, 2012
Ledger Control Summary
Viewed 1827 times since Mon, Jul 2, 2012
Include Notes on Unallocated Transaction Reports
Viewed 1991 times since Fri, Jun 8, 2012
ADD – Adding a New Account
Viewed 2404 times since Fri, Jun 29, 2012
Credit Restocking Fee (SOP Only)
Viewed 141 times since Thu, Jan 2, 2025
Additional Features on Transaction Look-Up (P/L only)
Viewed 1968 times since Wed, Jun 13, 2012
Aged Analysis – Select to Age on Invoice or Due Date
Viewed 40 times since Wed, Oct 16, 2024
Account Optional 2 - Database Profiles
Viewed 2315 times since Mon, Jul 2, 2012
Sales/Purchase Accounts File – Item Screen Design
Viewed 1360 times since Mon, Jul 2, 2012
Trans Mandatory - Database Profiles
Viewed 2240 times since Mon, Jul 2, 2012