This option is mainly used to set the status of selected lines in Purchase transaction file to X, thereby enabling the consolidation program to delete them if necessary.
Note: This report would only be run to clear zero value lines that would not be subject to verification.
Warning: This is an update report generator only available at Priority 7 or higher. The check for marking the status to X is not performed on the net value of the whole GRN, but only on individual lines. Therefore, if the GRN had 2 lines with RECDVAL (received value) as positive and negative, this option will not mark the lines for deletion.
However, if you had manually amended the quantity field in the receipting cycle to zero for some lines, making the line value as zero, those lines would be marked to status X. Additionally the system checks the corresponding entries in the parts log file (logpa) and sets the status on those to X as well.
The data, displayed by Order number, is as follows:
Order Number
Part Number
Description
GRN Number
GRN Date
Account Number
Supplier Name
Note: This report uses overlay PC/ovK14. This must be resident in the program library to enable this report to function correctly.
To produce a list of, and clear, zero value GRNs:
From the Rev.8 Master Menu select the Purchase Control Module and the Company you require.
The PURCHASE CONTROL Menu is displayed.
Select the Reports & enquiries option.
The PC REPORTS AND ENQUIRIES menu is displayed.
Select the Report generator option.
The REPORT GENERATOR menu is displayed.
Select the Run report generator option.
The Report selection form is displayed.
Select the required Output type, select K14 Clear Zero GRN's from the Report Definition drop-down and click OK.
Tip: If you leave the Output type set to All, the system uses the default setting of Print.
The Clear zero value GRN's (PC) form is displayed.
Complete the form and click OK.
A report status is displayed (if the report is printed), and the report is output in the selected format.
Click Close.
You are returned to the REPORT GENERATOR menu.
This form is displayed when you select K14 Clear Zero GRN's from the Report Definition drop-down on the Report selection form and click OK. The form allows you to clear zero-valued GRNs from the system for specified suppliers, individual GRNs or all.
Output type: Select an output type for the report from one of the following:
Print: Prints the report to the currently selected printer
Display: Displays the report
HTML: Outputs the report to file in Hyper-Text Markup Language (HTML) format, to be viewed via the default browser
Note: The default setting for Output type is Print.
Supplier code to be cleared: Supplier code
GRN to be cleared: GRN number
Internal refno to be assigned: Internal reference number to assign
Tip: Leave all the fields blank to clear all zero-valued GRNs.
PUSH BUTTONS:
OK: Outputs the report in the selected format
Cancel: Returns you to the REPORT GENERATOR menu
Help: Displays help on the current program in your default company browser
Note: The following buttons are not available when the Output type Display is selected.
Schedule: Displays the Timed Operations scheduler
Add to batch: Displays an Add report to batch form in which a report may be batched for printing in a report group
