| Item inventory report for Portuguese tax authoritiesIn 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 |
---|
Code | Description |
---|
M | Goods | P | Raw materials and
consumables | A | Finished goods and
intermediate products | S | By -products,
waste and scrap | T | Products and work in
progress |
How LN calculates the WIP inventory - 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.
- For each retrieved Job Shop Control production order, determine the
quantity of end items received on the reference date.
- 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.
- 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.
- 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.
| |