The Data Items Cross Reference screen is used to correlate the input file items (on the left) to the stock transaction file (shown of the right). All 160 items may be cross-referenced through this procedure, in up to ten screens of sixteen items. <ESC> abandons the input, <END> complete the input and <Page-Up>/<Page-Down> allows you to move through the ten screens.
For imports from ASCII files the system displays the input sequence number and asks for the stock transaction item to update. For imports from Datafile databases the system displays the name of the data item to be imported and then asks for the stock transaction item to update.
It is very important how items are cross-referenced and you must complete these screens with great accuracy. The batch update will not perform calculations such as tax amount and will reject the use of any definition where mandatory items have not been cross-referenced.
Mandatory items for the Stock Batch Update are the ‘Stock Code’ and the ‘Quantity’.
Article ID: 1693
Created On: Thu, Jul 5, 2012 at 10:13 AM
Last Updated On: Wed, Jun 14, 2023 at 4:09 PM
Online URL: https://kb.datafile.co.uk/article/data-items-cross-reference-stock-batch-update-1693.html