This report writer has multiple report formats containing different shipping information to be constructed and printed. Multiple sort sequences and control breaks can be produced in this report. All rows and columns can be user defined. Total level prints and page breaks can also be user defined. The definitions of the reports and the default panels for each report are defined in TMSPU/RPT-ID, TMSPU/RPT-DFT, TMSPU/RPT-ROW and TMSPU/RPT-COL.
The following TMSPU Control files establish the user defined variables for rows and column for the report writer. This report writer links to PUSHJ00P detail file.
- TMSPU/RPT-ID (Shipment report ID) – this control file lists the various user defined report names and descriptions.
- TMSPU/RPT-DFT (Default panel for selected report ID) – this control file defines the default panel for the selected report ID. The lines are system defined and there should be one panel of 11 lines for each report ID. This default panel can be overridden when running the shipping report. This Shipment Report can be run as part of the EOM using the run parameters in this control file.
- TMSPU/RPT-COL (Report column definition) – this file is user defined. There must be at least one column definition for each report ID. Columns are landing cost type. Maximum number of column is 14 and can be Trade, Base or Quantity. Multiple cost types listed on one line will add together. There is provision for nine landing cost types per column. If your system exceeds this number then repeat the column number to add the remaining cost types.
- TMSPU/RPT-ROW (Report row definition) – this control file is user defined and determines the rows are to appear on each report. There must be at least one row nominated for each report ID. The rows report on record types held in the PUSHJ00P detail file. The maximum is 9 with calculation of (+-*/%) and non printing line if required. Also included in this control file is a selection to print given various selection criteria, Print group condition: 1=Zero, 2=Not Zero. This can be used to minimise the number of pages to be printed by not printing a group if a line nominated has a value of nil. For example if you created a report with 3 lines comparing receipts with actual invoices. If you insert 2=Not Zero against the receipt line it will only print these lines if receipts are not equal to zero.
The following are system defined record types.
- Shipping Invoice + other inventory costs at standard
- Goods Received
- Accruals
- Actual
- PPV expensed to P&L
- PPV capitalized to inventory
- Volume variance expensed to P&L
- Exchange variance on payment Non Posting
- Exchange var. expensed
- Exchange var. capitalized
- Purchase Order Value
- Purchase order variance
- In the menu, expand Base Modules > Distribution > Inventory Management > Purchasing > Shipping and double-click PU Shipment Report. PUR100 Shipment Report selection panel appears.
- Specify the required division and click OK. PUR100 Shipment Report panel to specify the report criteria appears.
- Enter the required selection criteria.
- Click OK to produce the report.
