You use this program to produce a report enabling you to verify the value of items receipted into inspection, those accepted, scrapped and reworked and the value of items remaining in inspection.
WIP inspection transactions are created using the WIP Inspection Maintenance program.
| Field | Description |
|---|---|
| Current period | This indicates the current period and year of your Work in Progress module. |
| Trial balance as of | |
| Current month | Select this to produce the report for the current period displayed above. |
| Previous month 1 | Select this to produce the report for the previous period. |
| Previous month 2 | Select this to produce the report for two periods ago. |
| Report sequence | |
| Stock code | Select this to generate the report in stock code sequence |
| Job |
Select this to generate the report in job sequence. If you select to generate a detailed report in job sequence, then the accumulated totals per WIP inspection reference, stock code, G/L code and warehouse are printed for each job. This enables you to reconcile the WIP Trial Balance to the Inventory journals and to the General Ledger. |
| Report type | |
| Summary |
Select this to print the information by stock code. One line is printed for each stock code and a report total is printed at the end. |
| Detail |
Select this to print the information by stock code/inspection reference. The inspection reference details are listed for each stock item. A total is printed for each stock code and a report total is printed at the end. |
| Completed inspection references |
Inspection references are marked as complete when: Quantity accepted + Quantity scrapped + Quantity reworked = Quantity manufactured. The period in which the final transaction for the inspection reference was processed is taken as the period in which the inspection reference was completed. The period in which the first transaction was processed against the inspection reference is taken as the period in which the reference was created. |
| Include |
Select this to include completed inspection references in the report. If you selected to generate the report for the current month, then the reference is included if it was completed in the current month. If a reference was completed before the month for which you are generating the report, it is excluded from the report. If a reference is completed after the month for which you are generating the report, but it was created in or before the selected month, it is included in the report. |
| Exclude |
Select this to exclude completed inspection references from the report. If you select to exclude completed references and you are printing the report for the current period, then the reference is excluded if it was completed in the current or in a previous month. However, if the reference was completed in the current month and you select to generate the report for a previous month, then the reference is included in the report. This is because the reference is only set to complete after the period for which you selected to run the report. |
| Only |
Select this to print only completed inspection references in the report. If you selected to generate the report for the current month, then the reference is included if it was completed in the current month. If a reference was completed before the month for which you are generating the report, it is excluded from the report. If a reference is completed after the month for which you are generating the report, but it was created in or before the selected month, it is included in the report. |
| Field | Description |
|---|---|
| WIP inspection reference selection | Indicate the WIP inspection reference(s) you want to include in the report. |
| Stock code selection | Indicate the stock code(s) you want to include in the report. |
| Job selection | Indicate the job(s) you want to include in the report. |
| Warehouse selection | Indicate the warehouse(s) you want to include in the report. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
The value which is in inspection for a reference is calculated as:
Value originally taken into WIP inspection for the reference less negative receipts against the reference less the values of transactions for acceptance, rework, scrap and accept as different stock code.
The Report total is the total of all the items (detail lines) printed on the report.
The totals on the second page indicate the difference between the Report total and what was issued to WIP. The totals indicated on the line with the General Ledger code should be balanced to the General Ledger.
The variances for WIP Inspection references include changes in cost made to a stock item after it was taken into WIP inspection, if the option Capture lots at end of WIP inspection is selected (Work in Progress Setup).
If you print a full report (i.e. you make no range or single selections), then the last page printed at the end of the report lists the total amounts for the WIP inspection ledger account.