Declarations > Audit > Portugal > Processes > Inventory extraction 

Use this function to generate the XML file for the previous fiscal year inventory. After the stock period is closed, the calculation has been processed and the reference date matches the last day of the fiscal year, you can export the XML file.

Note: For each product listed in the product code tag, <ns: ProductCode></ns: ProductCode>, there is a corresponding tag with the closing stock quantity, <ns: ClosingStockQuantity></ns: ClosingStockQuantity>, and one for the closing stock value rounded to 2 decimal places, <ns: ClosingStockValue></ns: ClosingStockValue>.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Fields

    The following fields are present on this tab :

    Information

    Enter or select the company to create a single file for the company that groups all the quantities per item code from all company sites.

    • Reference date (field REFDAT)

    Enter the reference date for the calculation. This date must match the last date of the fiscal year to generate the XML file for export.


    • Origin (field ORIGIN)

    Select the source date for the calculation.

    Counts

    Select this option to search all inventory by physical counts according to the following criteria:

    • Counts from all company sites
    • Counts within the date range
    • Closed stock count sessions

    If there are multiple stock counts for identical items in different inventory lists, only the last stock count is included.

    If there are stock counts sessions with the status other than closed, you received a warning message.

    Stock by date

    Select this option to search by the company and the reference date. This includes all products managed in stock on company sites.

    • Start date (field STRDAT)

    Enter a date range to include stock counts within this range.

    • field ENDDAT

     

    • WIP (field WIPFLG)

    This generates additional calculations on the work orders in progress and adds these quantities to the file.

    • Closing period (field PERCLO)

    This icon shows if there are any problems in the calculation related to the period.

    Green icon: The stock period is closed for the selected company regarding the main ledger.

    Orange icon: The stock period is closed but the reference date does not match the fiscal year closing date.

    Red icon: The stock period is open for the main ledger of the company, or the fiscal year is not defined for the reference date.

    • field ICO2

     

    • Calculate (field CALC)

    This displays the calculation status:

    Green icon: The file can be exported and the Export button is available.

    Orange icon: The data is stored for the selected date and company, but if the data source is inventory and there are records that were not included in this calculation, you need to recalculate the data.

    Red icon: There is no data. You need to run the calculation.

    • field ICO1

     

    Grid Counts

    • Count in progress (field CUNLISNUM)

     

    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

    Select this action to calculate the stock quantities for each product relative to the reference date.

    If there is data for the selected company and reference date, recalculating deletes and replaces the existing data.

    The calculation method is based on the Origin field value.

    Select this action to generate the XML file for export.

    If the Calculation status does not display a green icon, this action is not available.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation