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:

  • 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
Product categories
CodeDescription
MGoods
PRaw materials and consumables
AFinished goods and intermediate products
SBy -products, waste and scrap
TProducts and work in progress

 

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:

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.
Example

Item A consists of 10 components.

The reference date is 28 December.

A production order to manufacture 5 items A is created on 12 December.

45 components are issued on 16 December.

3 items A are received in the warehouse on 18 December.

The WIP (work in process) inventory is 45 - 30 = 15. 30 is the number of components of which the three received items A consist.

Note
  • If inventory is available for a component item with multiple cost components, the first cost component is used to determine the quantity when creating financial transactions.
  • Quarantine inventory is not included when calculating WIP (work in process) inventory.
  • Conversion factors are not used when calculating the number of component items required to manufacture an end item. For example, if the estimated quantity of components required to manufacture an end item of 10 kg is 120 pieces, the calculated estimated quantity is 12 if the conversion factor between kg and pieces is not used.