Item inventory report for Portuguese tax authorities

In the Print Company - Item Inventory (whwmd4400m100) session, you can print a report that meets these requirements of the Portuguese tax authorities:

• A specific layout. For this purpose, the Portugal Layout check box must be selected.

• For the relevant items:

  • The inventory available on the last date of the previous year is listed.
  • The applicable product category is specified. See the table.
  • The WIP (work in process) inventory available on this date is added to the inventory on hand quantity for items with product category T - Products and work in process.

To compose this report:

• For the relevant items, the applicable product category must be specified in one of these fields in the Items (tcibd0501m000) session:

  • Product Type
  • Product Class

  • Product Line

    See Report layout.

• At least one of the companies within the selection range must be located in Portugal.

• In the Print Company - Item Inventory (whwmd4400m100) session, these check boxes must be selected:

  • Work in Process, if the report includes items with product category T - Products and work in process.
  • Portugal Layout

Report layout

By default, the Portugal Layout report is printed if the product category of the item is specified in the Product Type field of the Items (tcibd0501m000) session.

If your organization specifies the product category in the Product Class field or the Product Line field of the Items (tcibd0501m000) session, the detail layout of the wmd440041100 report titled Item Inventory (Flat File Portugal) must be customized in the Report Layouts (ttadv3131s000) session.

If the product category is specified in the:

• Product Class field, in the Report Layouts (ttadv3131s000) session, the Layout Type Detail number 10 must be set to 0 and Detail number 20 must be set to 1.
• Product Line field, in the Report Layouts (ttadv3131s000) session, the Layout Type Detail number 10 must be set to 0 and Detail number 30 must be set to 1.

How LN calculates the WIP inventory

1. For the relevant items, retrieve the Job Shop Control production orders that are Completed or Active on the reference date, but have material issues before the reference date. The reference date is the last date of the previous year, which is required by the Portuguese tax authorities.
2. For each retrieved Job Shop Control production order, determine the quantity of end items received on the reference date.
3. Determine the quantity of the materials issued to manufacture the received and the yet to be completed end items. These materials are issued either on or before the reference date.
4. Calculate the quantity of materials required to manufacture the received end items. To calculate this quantity, the estimated quantities of the retrieved production orders are used.
5. Subtract this quantity from the quantity of materials issued for the received and the yet to be completed end items.