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

Information

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

Company (field CPY)

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)
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)

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

Calculate

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.

Export

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