Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Trans Optional 3 - Database Profiles |
Article Number: 1409 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 3:26 PM
|
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. |
Attachments
![]() There are no attachments for this article.
|
Split Period Updating for Nominal Journals
Viewed 1381 times since Mon, Mar 2, 2020
Record Groups as Items in Discount and Supplier Matrix
Viewed 2529 times since Fri, May 27, 2016
Amend Status Flags - Purchase Ledger
Viewed 1770 times since Mon, Jul 2, 2012
STOP – Flag Accounts with Stop Status
Viewed 1121 times since Mon, Jul 2, 2012
Include Payments within Currency Revaluations
Viewed 93 times since Thu, Oct 17, 2024
Document Parameters - Document Design Manager
Viewed 25841 times since Mon, Jul 2, 2012
Sales / Purchase Transactions - Application User Facilities
Viewed 1962 times since Mon, Jul 2, 2012
Increased Size of User-2 / User-3 Items
Viewed 1764 times since Wed, Jun 13, 2012
System Profiles Screen 4 (excluding Compact)
Viewed 1761 times since Mon, Jul 2, 2012
Automatic Payments – Set Transaction Description from Account
Viewed 35 times since Wed, Oct 16, 2024
|