ALL: Exporting and Importing Inventory Items (Codes) from RHO to BOS

ALL: Exporting and Importing Inventory Items (Codes) from RHO to BOS

The following procedure can we used when initial inventory items were not replicated or imported correctly during the station installation.
If some item codes are missing from the BOS, supplier matrix definitions and price update documents created in RHO will not replicate. An error similar to the one below will be shown in the replication log:


In order to solve this, go to Bnz_HO in RHO, menu Defitions -> Inventory Definitions -> Inventory Items. Press Records menu and Export:


Choose Promax file format, select where to save the file and press export:


Copy the saved exported file from RHO to BOS.
On BOS, go to Code Definitions -> Inventory Definitions -> Inventory Items. Press Records menu and Import:


Select the file previously exported and copied from RHO, use Skip in order to skip existing item codes (this will only import the missing ones):


Once this steps are finished, the replication process can be forced in order to clear the errors and start processing the missing supplier matrix.


    • Related Articles

    • ALL: Importing DRY inventory taking document from flat file

      In order to import an inventory document in Benzin from a flat file, the following steps need to be taken: 1. Make sure to have InitStock.109 import format file that is used for importing initial stock. It is found in ProMax/EDI/Stg folder: 2. For ...
    • How to import a xlsx file for price update

      Excel file fields: Station column - Text StationList column - Text ItemCode column - Text ItemName column - Text Price column - Number PriceNumber column - Text WaitForEOD column - Text ActivateTime column - Custom: d/m/yyyy hh:mm VatablePrice column ...
    • SASCO: Generation of CMS Offline Transactions in Bnz_HO

      Generating a CMS Offline Transaction is usually done when a CMS payment was not received by RHO for various reasons. This basically means that the transaction exists and is available in RHO (receipt) but the CMS payment (Bnz_FuelTrnXxx) is missing. A ...
    • SASCO: Adding new LIGO station in replication

      1. Go to C/A Codes and add the new station in case it was not part of the initial master data: 2. Go to Store Definitions and select the station from the drop-down list and fill-in Server LIGO, Destination LIGO and REP.CODE=STORE CODE (leave the ...
    • ALL: Adding recipients for Replication email alerts

      Go to the Database Server, navigate to Jobs, select Replication_EmailAlert Click on Properties -> Steps -> Edit: In the command window, add or remove emails by maintaining the correct punctuation: each email is separated by semicolon ; all the ...