It’s that scary time of year again for ghosts, goblins, and budgets. Gives me chills just thinking about it.
But it doesn’t have to be too scary. I’ve been working with several companies on their budgets and have found some things that you may want to keep in mind when importing your budgets.
1) What version of Microsoft Office are you using? We have seen where Microsoft Office 2010 has the ability to hide data in cells and could possibly be masking data. Sometimes you may not know that data is hiding until you export to a text file. This is not something that happens all the time, but if you find that you have issues importing it could be hidden data.
2) Naming of Fiscal Periods: Typically you would go to Cards->Financial->Budgets and follow the steps in the wizard to create your Budget Template in an Excel spreadsheet. This gives you the default format that Dynamics GP is expecting when you are ready to import your new budget figures.
If you‘ve made changes to the Period Name by going to Microsoft Dynamics GP -> Tools -> Setup-> Company -> Fiscal Periods, you will want to make those same changes to your exported spreadsheet columns. The export will have the original Period Names for each period, not the changes that you made, and the import will fail because it can’t reconcile the changes for the import.
The error you receive will mention incorrect number of fiscal periods, but the real issue is that you renamed the period descriptions, and those have not exported with your Budget export to excel, and it cannot match up those columns when importing back into Dynamics GP.
Hopefully this saves you some time and effort, because we definitely know how hectic this time of year can be.
