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 ensure 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 to resolve this issue.
Note: this solution can also apply to the Actual tables if the Actual transactions are not being loaded.
- Multi-company 4x