Job Costing transactions can be created from the Sales Ledger, Purchase Ledger, Cashbook, Invoicer, Sales Order Processing, Purchase Order Processing and, of course, Job Costing itself and it can be useful sometimes to identify where the transaction was created from. This new feature allows for a ‘source’ flag similar to that used in the Nominal Ledger and Cashbook to be recorded on the transactions.
Installation
Database Changes
A new ‘Source’ data item is required on the job transaction file. To create select Installation from the main menu followed by Application Manager and then Restructure a Database. Select the Job Costing application and choose to update the live files before selecting the Job Cost File. Once the items are listed move down to blank entry and press <Enter> to add the item below:
Item Name Type Description
SOURCE X
(3) Three character flag
updated with the details of the source of the transaction – S/L, P/L, CBP, INV,
SOP, POP or JOB
Once the item has been created press <ESC> and select to update the database changes.When prompted confirm the extract of existing records and the extract of any table definitions. Once the live file has been updated you will be prompted to update the base file – respond as required, if choose to update then insert the same item as above at the same item number in the base file.
Datafile Database Profiles
The new ‘Source’ item needs to be referenced within
the Datafile Database Profiles for Job Costing.From the main menu select Installation followed by Application Manager and
then Set Database Profiles. Select the Job Costing application and the new source item is referenced on
the Cost Trans Items 2 parameter
screen.
The new ‘Source’ data item reference needs to be referenced against the ‘Source’ prompt on the left of the screen.
Article ID: 201
Created On: Tue, Jun 12, 2012 at 11:15 AM
Last Updated On: Mon, Jun 19, 2023 at 10:48 PM
Online URL: https://kb.datafile.co.uk/article/record-source-on-job-transactions-201.html