...
These are two different standard Catalogs - Companies and Contracts of the system.
Thus, the system must establish a correspondence - the company loaded from the Excel file must be correlated with the company from the Companies catalog, secondly, the system must not only match the data from the Excel file with the elements of the Contracts catalog by the contract name, but also select a contract associated with a specific company. The standard functionality for loading data into an Invoice document does not contain this handler, so the standard template loads as follows: the company is selected from the directory system catalog according to the one specified in the Excel file. However, the contract from the file is not taken into account, by default the contract is substituted, which is marked as the main contract for this company.
...
Therefore, for cases of non-linear data loading - that is, data from related reference books, analytics linked to GL accounts and other related objects, it is necessary to develop a corresponding handler (making changes to the program code, which is performed by the system developers) - that is, adding rules to the loading handler, according to which related data will be loaded.
If user need to create new elements that are not in the Catalogs (item, company, employee, etc.), it is needed to develop a handler. These handlers are written by the technical team. You need to contact your Accounts manager or send to Hotline for further additional customization.
Thank you for being FirstBit Customer!
...