Recently I have had several clients with problems importing their new budgets. They receive the message that the number of period columns do not match the Excel columns. Well, simple to fix right? For sure someone has edited the format of the spreadsheet; added a column, hid a column, removed the blank row at the top…something …
Category Archive: GP Financials
Sep
27
Difference between a Bank Transaction and Bank Transfer in Microsoft Dynamics GP
The following information shows the difference between a Bank Transaction and a Bank Transfer within Microsoft Dynamics GP through a real-life example. WFB CHG and WFB SVGS are 2 checkbooks set up with the application. Janice noticed that her Checkbook (which is a totally separate module from the General Ledger) did not tie in total …
Sep
13
Manually changing SysData location
Recently, after installing FRx 6.7 with the media for GP 10 (the media that includes SP9), I ran into an issue changing the SysData location. Typically, when trying to change the location through the back end, I would modify the FRx32.cfg file and make the change in here. However, when trying to do it with …
Sep
13
Error message when you start Microsoft FRx after applying a service pack: “Runtime Error 32797: Application Defined or Object Defined Error”
Ran into an issue today installing a fresh installation of FRx. This is on a 32-bit version of Windows 7, using the download that includes SP9 and applying SP12 after the install. When launching Report Designer, I get the following error: Runtime Error 32797: Application Defined or Object Defined Error And, unfortunately, FRx will not …
Dec
17
Microsoft Dynamics GP Fixed Assets Year End Closing Procedures
The Fixed Assets year end close is not a date sensitive process. All transactions for the current year need to be entered and processed before entering/processing transactions for the new year. This includes: additions, disposals and running depreciation for the last period of the year. Once all current year activity has been processed for Fixed …
Nov
24
Microsoft Dynamics GP Receivables Management Year End Closing procedures
Receivables Management has a date sensitive year end close process. Even though it is date sensitive there are SmartList objects that are not. We recommend closing Receivables Management before posting any transactions in the new year. Below are the steps for closing the fiscal and/or calendar year: Post all sales transactions for the current year. …
Nov
22
Microsoft Dynamics GP Year End Closing procedures
Year end is a busy time for all of us! Let’s make it a bit less stressful by reviewing the year end closing procedures for Microsoft Dynamics GP before you need to close! As Microsoft releases articles that are specific to year end closing of each module we will post them on our web site. …
Nov
11
MDA (Multidimensional Analysis) is not Dead!
Have you heard? Multidimensional Amalysis (MDA) is going away. Well, this is only PARTIALLY true. For Dynamics GP Customers that already own MDA, they will be able to continue using it even with future releases and upgrades! However, NEW CUSTOMERS to Dynamics GP, starting with Version 10, will NOT have access to MDA.  They will utilize Analytical Accounting. …