After running the Multi-company load, the message indicates that the load completed successfully but did not load any of the budget data:
One possible cause for this is that in the MCL we use the "YEAR1" column values inside of GP tables to create a "period" value to search for. When querying the GL00201 table in GP for the budget data, if the "YEAR1" column is not set to a valid year this can cause problems for MCL as this could cast the "period" value to a single integer. This means that those transactions will not be pulled in because the MCL will be looking for a "period" value 201001, for example.
In order to assure that the tables are being combined properly, check the "YEAR1" column GL00201 to make sure that it is set to a valid year for all transactions.
For example: "0" or "1" is not a valid year. Please consult your ERP consultant for resolving this issue.
Note: this solution can also apply to the Actual tables if the Actual transactions are not being loaded.
- Multi-company 4x