Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Trans Optional 2 - Database Profiles |
Article Number: 1408 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 3:26 PM
|
Datafile Software Trans Optional 2 - Database Profiles Data Item Type Alternative Notes Job Reference X (10) Y Purchase Ledger Only. This item used to hold the job code if ledger linked to job costing. Job Code Analysis X (10) Y Purchase Ledger Only. Holds the cost code reference Job cost updated ? Purchase Ledger Only. Set to Y when updated into job costing Forward trans. ?-type Set to Y if this is a transaction for the next period. Forward allocation L K Holds the value of this transaction that is allocated against a forward transaction. Period Number N Accounting period of transaction; mandatory if forward transactions Stock/Product X (10) Y For stock code if using ledger lookup to stock (see System Profiles) Del-Add Account X (10) Y Holds the delivery address account code that the transaction was entered for. Stm-Add Account X (10) Y Holds the statement address account code that the transaction is to be reported to. Grp-Add Account X (10) Y Holds the group address account code for the head office. Alt Desc / Inv-docs X & The invoice enquiry on the Desktop Ledger Enquiry uses the transaction description as the description for the invoice. This option allows you to nominate an alternate item to use instead.Note: that changing this will not affect previously generated documents. Alt Desc in Alloc X & Allocation process normally displays description (amongst other items) to identify transactions. Any other field can be specified instead of description, including (say) concatenated field of several items to help identify transaction Alt Desc in Enquiry X & Similar to above, when defining ledger enquiry Allocation Letter X (1) Transactions allocated at one time can all be flagged with same letter in this field for future identification Allocation X-Ref X(10) Y This is the reference field of the credit (payment or credit note) against which this invoice has been allocated. Where more than one credit is used in an allocation, then the reference number used is that of the most recent of the ones being allocated. Only applies to invoice transactions Flag (B C D P U) X (1) Y Flagged Status of the transaction B Bad debt (sales ledger only) C Contra to account in other ledger D Transaction in dispute P Marked for payment (purchase ledger only) U Unauthorised (purchase ledger only) X Ignore on statement if fully allocated Flag by USERID X (6) If present, any time record is flagged, the user id of the user who does so is posted into this field. |
Attachments
![]() There are no attachments for this article.
|
Automatic Generation of Payments (P/L only)
Viewed 1890 times since Wed, Jun 13, 2012
Set Proposed Payments, Generate Payments Automatically - Purchase Ledger
Viewed 1827 times since Mon, Jul 2, 2012
Change Due Dates
Viewed 1970 times since Mon, Jul 2, 2012
VAT Adjustments - Post-Dated Purchase Invoices
Viewed 3908 times since Thu, Oct 11, 2018
Cost Price Checks - Omit Warning if No Change in Selling Price (SOP Only)
Viewed 126 times since Thu, Jan 2, 2025
Account Reports - Application User Facilities
Viewed 2335 times since Mon, Jul 2, 2012
Enter Invoiced & Paid
Viewed 1977 times since Mon, Jul 2, 2012
Credit Control Manager / Accounts On-Stop List
Viewed 2582 times since Mon, Jun 11, 2012
Change Account Code
Viewed 2237 times since Mon, Jul 2, 2012
Allocation Actions – Omit Exclusive File Locks
Viewed 896 times since Fri, Jun 19, 2020
|