Home » Categories » Solutions by Business Process » Utilities

Data Items Cross Reference - Job Costing Batch Update

Datafile Software

Data Items Cross Reference - Job Costing Batch Update

The Data Items Cross Reference screen is used to correlate the input file items (on the left) to the job costing transaction definition (shown on the right). All 160 items may be cross-referenced through this procedure, in up to ten screens of 16.<ESC> abandons the input, <END> completes the input and <Page-Up> and <Page-Down> allows you to move through the cross-reference screens.

For imports from ASCII files the system displays the input sequence number and asks for the job costing transaction item to update. For imports from Datafile databases the system displays the name of the data item to be imported and asks for the job costing transaction item to update.

It is very import how items are cross-referenced and you must complete these screens with great accuracy. The update will not perform calculations such as value. The update will reject any definition where mandatory items have not been cross-referenced (job code and cost code/analysis) but care should be taken that the items that are normally set through manual transactions are cross-referenced.

Notes

If the input transaction type is not referenced then all transactions are recorded as per the default set in optional features. If the transaction date is not referenced then all transactions are recorded as per the run-time date confirmed.

You must reference the quantity and price (if not type 4-Invoiced Amount) and value fields. The system will not calculate the value for you. To update job costs you must cross-reference the cost value item (this is the total cost of the transaction).

For timesheet input you must cross-reference the payroll minutes data item to update hours on the job file. If payroll company/employee number not cross-referenced then these are copied from the cost code record provided the employee cost code is referenced, if pay number not cross-referenced then this is set as 1-standard

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Warehouse Tablet - Sales / Purchase Order Picks - Save User / Date / Time
Viewed 10 times since Tue, Mar 24, 2026
Report Specification - Job Costing Batch Update
Viewed 2312 times since Thu, Jul 5, 2012
System Status - Sales/Purchase Batch Updates
Viewed 2031 times since Thu, Jul 5, 2012
Confirm Input File and Date - Sales/Purchase Batch Updates
Viewed 2552 times since Thu, Jul 5, 2012
Confirm Printer - Sales/Purchase Batch Updates
Viewed 2490 times since Thu, Jul 5, 2012
Confirm Input File and Date - Job Costing Batch Update
Viewed 4073 times since Thu, Jul 5, 2012
End of Batch Update - Job Costing Batch Update
Viewed 2459 times since Thu, Jul 5, 2012
Import Payment Transactions and Summarise
Viewed 2396 times since Tue, Jun 12, 2012
Confirm Date for Generated Orders - Order Processing Batch Updates
Viewed 2100 times since Thu, Jul 5, 2012
Confirm Update Definition - Sales/Purchase Batch Updates
Viewed 2466 times since Thu, Jul 5, 2012