We wrote a custom report that will backfill General Ledger Entries with dimension values. When we run the report on our copy of the client’s db it works perfectly. However, when we run the report on their live system it does not handle the data. We have determined it is not a license or permissions issue as we have a super user running it and we tried with our license as well. There are no error messages; the report seems to run. However, when we look at the tables it is supposed to backfill they are untouched on the live system. Any ideas? We have several years Navision experience and are really struggling with this one. Our client is on 3.10 with SQL database.
Did you Setup the global dimensions on the User Site and define the “Global Dimension 1 Code” and “Global Dimension 2 Code” in the General Ledger Setup, before running the custom report? Also did you setup the dimension values before inserting into G/L entry? Naveen Jain
We have come across this kind of problems couple of times.working perfectely in local but not in live with same developer license and super user rights. one was due to report permissions and other was due to a problem with table data having an empty record. Best regards, Anu
Hi Greg, What is the reason you are updating the G/L Entry directly? Always use journals to insert G/L Entry. This is correct way for importing or writing into a G/L Entry. Secodnly, the Dimension values you fill in can only be 2 the global dimensions like Naveen mentioned. You will also need to fill the Ledger Entry Dimensions table. Regarding the Update, what are the conditions you are using, its difficult for any body to give you a solution if you do not completely present the problem.
If nothing worksout then delete the ZUP file, and then try again