Summary:
This article troubleshoots an issue that occurs when running the Multi-Company Load (applies only to GP customers).
Symptoms:
When a user runs the MCL, a message indicates that the load completed successfully but did not load any of the budget data.
Causes:
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.
Resolution:
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.
Properties:
Multi-company 4x