If, when adding fluid dispenser transactions to a WIP, you modify the quantity of dispensed fluid issued on the WIP (in the Issue now field), the variance created means you must carry out a batch adjustment. You need not do it immediately after every such action. However, you must carry it out prior to a stock check. It is normally carried out daily or weekly by a service manager.
To batch adjust variances in fluid dispenser transactions:
On the Service Point-of-Sale form, create a new WIP with the batch adjustment sales ledger account (specified in fluid parameters) entered into Account code on the Account tab.
Select the fluid dispenser franchise in the New product drop-down list.
The EPC command is added to the Links sub-menu on the menu bar and, if you are using an Autoline revision 8.30 system, an EPC button is added to the toolbar.
Click the EPC toolbar button (Autoline revision 8.30) or select Links > EPC from the menu bar (Autoline revision 8.30 and 8.20).
If the message There are no WIPs requiring batch adjustment is displayed, no further action is required.
Otherwise, the Batch Adjustment form is displayed, indicating that WIPs require batch adjustment because they contain actioned fluid dispenser log records. They must have a non-zero variance quantity where WIP line order status is X, blank, or D.
Ensure that the variances listed relate to the correct transactions, checking the details if necessary by right-clicking their grid rows. (That is, simply right-click. There is no shortcut menu to select from.)
Details of the selected fluid transaction are displayed and, when you click Close, you are returned to the Batch Adjustment form.
Select the Selected check boxes in rows corresponding to the transactions for which variances are to be written-off and click OK.
Note: When you select or de-select the Selected column of a grid row below the top three rows, the grid refreshes, redisplaying the top three rows. To see the changed row, scroll down to it.
If not all grid rows are selected when you click OK, a RETURN box displays the warning There are more transactions requiring batch adjustment, in which case click OK.
You are returned to the Point-of-Sale form with the transactions added as WIP lines in the grid.
The Batch Adjustment form is displayed by creating a new WIP in the Point-of-Sale form, entering the Sales Ledger adjustment account code (specified in the fluid dispenser Parameter Setup form) in the Account code on the Account tab, then selecting the fluid dispenser franchise from the drop-down menu in the New product section of the Point-of-Sale form and clicking the EPC toolbar button (or if your Autoline system is revision 8.20, selecting Links > EPC from the menu bar). It is only displayed if any actioned transactions exist that have been actioned with variances.
The form contains three grids:
Transactions actioned with variance where WIP deleted or costed (N)
Unactioned transactions where WIP deleted or costed (N)
Unactioned transactions (N)
GRIDS:
All three grids have these column headings.
Note: The number in brackets appended to each grid title (N) is the number of WIP records contained as rows in the grid. The visible segment of each grid is only three rows deep and the effect of scrolling down may not be immediately apparent.
Wip No: Number identifying the WIP record to which the transaction is linked
Part No: Code identifying the type of fluid dispensed. Codes are defined in the fluid mapping file.
Qty Disp.: Quantity dispensed as measured by the fluid dispenser hardware. Standard units are litres.
Qty Iss.: Quantity added to the WIP as a part line
Qty Adj.: Quantity written off in a batch adjustment
Qty Var.: Variance quantity. This is the difference between the amount dispensed (Qty Disp.) and the quantity added to the WIP (Qty Iss.), less the quantity written off (Qty Adj.)
Wip status: Same as the WIP status field of the Point-of-Sale form
Selected: If this check box is selected, the transaction is adjusted when you click the OK button. This is the only column of grid rows that can be modified.
Note: When you select or de-select the Selected column of a grid row below the top three rows, the grid refreshes, redisplaying the top three rows. To see the changed row, scroll down to it.
PUSH BUTTONS:
OK: Exits the form, adjusting variances on selected transactions
Cancel: Exits the form, undoing any changes made to this form, including actioning
Select all: Selects the Selected check box for all transaction rows
Select none: Clears Selected check boxes