Declarations >  Audit >  Portugal >  Processes >  Inventory extraction  

Display all Hide all

This function is used to generate the XML file regarding the previous FY inventory and to declare it to the State.
Once the XML is generated, the user will be able to upload it in the AT site.

Once the stock period is closed, the calculation has been processed and the reference date matches with the last day of a certain fiscal year, the user can export the XML file.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Presentation

The header information is used to specify the main selection criteria to generate the data.

  • The Company: this is mandatory information once we need to create one file per company. The process will group all the quantities per item code from all the sites existeing in the company.
  • Reference date: this is a required field and it must correspond to the last day of the fiscal year if the purpose is to generate the XML file.
  • Origin: this will determine the source of the data that will be calculated that can be by inquire of stock to date or by inventory physical counts.
  • Range of dates (just for inventory count origin)
  • WIP: this will generate an additional calculation which loop on the work orders in progress and add these quantities to the file

Once the record is created, it is displayed some additional info using the colours icons:

Closing period:

    • Green icon: If the stock period is closed for the selected company regarding the main ledger
    • Yellow icon: If the stock period is closed but the reference date isn’t the same as the fiscal year closing date.
    • Orange icon: If the stock period is open for the main ledger of the company or if the fiscal year is not defined for the reference date.

Calculation status:

    • Green icon: Everything is OK and the file can be exported (the button “xml file“ is enabled)
    • Yellow icon: There is data stored for that date /company but if the data source is inventory and there are records that were not uploaded in this calculation, we need to recalculate the data again.
    • Orange icon: It means there is not data yet. It requires a calculation


Close

 

Fields

The following fields are present on this tab :

Information

Enter the company code or use the Look up tool to search for and select the code.
  • Reference date (field REFDAT)

Reference date of the processing.
  • Description (field DES)

 
  • Origin (field ORIGIN)

Select Counts or Stock by date to determine how the data is calculated.

  • Counts
    • Counts from sites belonging to the company
    • Counts within the date range
    • Stock count sessions with a Closed status
    • If there is more than one stock count for the same stock characteristics in different inventory lists, only the last stock count is included.
    • If there are stock counts sessions (inventory sessions) with a status other than Closed, a warning message displays in the log file with the session numbers.
  • Stock by date
    • The criteria is based on the company and the reference date.
    • The calculation includes all the products managed in stock on sites from that company.
  • Start date (field STRDAT)
  • field ENDDAT

 
  • WIP (field WIPFLG)

Select this check box to include work orders in progress to the calculation and add these quantities to the file.
  • Closing period (field PERCLO)

 
  • field ICO2

 
  • Calculate (field CALC)

 
  • field ICO1

 

Grid Counts

  • Count in progress (field CUNLISNUM)

 
  • Description (field CUNLISDES)

 

Close

 

Reports

By default, the following reports are associated with this function :

  P-INVENTORY : Counts

This can be changed using a different setup.

The report P-INVENTORY is available and it's based on the data calculation grouped by company and product and an accumulator on the quantity.

Specific buttons

This function is used to trigger the quantities for each product existing at the reference date.
If there is already data calculated for that company and reference date and the user press the button “load data”, all the existing records will be deleted and rewritten again.
There are 2 different ways of seeking the data:

  • 1/ Origin Source = “Inventory”

The button “load data” should seek for all the inventory physical counts records regarding the following criteria:

    • Counts from sites belonging to the company input;
    • Counts where the date belongs to the range of the date entered.
    • Stock count sessions with status closed (CUNSSSSTA=3)
    • If there is more than one stock count for the same stock characteristics in different inventory lists, we should take the last stock count only.

If there are stock counts sessions (inventory sessions) with the status different than “closed”, a warning message should be written in a trace with the session numbers alerting for the current status.

  • 2/ Origin Source = “Stock by date”
    • The data will be based on the process related to the inquire “stock by date” .
    The criteria will be the company and the reference date. The process should loop over all the products managed in stock on sites from that company.

This function allows to generate the XML file.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation