Tips & Tricks Dynamics GP

Year End Closing for Dynamics GP Module must be done in following order A)  Inventory B)  Receivable C)  Payables D)  Fixed Assets E)  GL Year End GL Year End Close should be done after you have completed you Year End Closing for all above Module in above order. Let see go Module wise Year End Close procedure and its affects. A)  Inventory GOTO-->Tools-->Routines-->Inventory-->Year End Close Inventory Year End Close affects i) Transfers all summarized current-Year Quantity, Cost and Sales Amounts to last-year for the Items for which you have been keeping summarized sales history ii) Updates each item’s beginning Quantity from the Quantity on hand at each site iii) Zeros the Quantity sold field in the Item Quantities maintenance (Cards-->Inventory-->Quantities/sites) for each site iv) Give you the Option to: Remove Discontinued Items, remove sold Receipts, Remove Sold Lot Attributes, and update Item’s Standard cost. Key Points to remembe

On the Company menu, click Specification Sets. The Specification Sets dialog box appears. Note the location and file name for the Specification Set. Make a copy or backup of that file. Click Close. On the Admin menu, click Organization. The Organization Information dialog box appears. Click the SysData button. The SysData Directory dialog box appears. Note the location of the SysData folder and click OK. Browse out to the SysData folder and then make a copy or backup of the FrxSys32.mdb file.Verify that all other Microsoft FRx users have closed Microsoft FRx. On the File menu, click Compact FRx Database. Select either Current Spec Set Database, FRx System Database or FRx Queue Database. When prompted to Compact Now, click Yes.

FRx has been around forever and is the most often recommended tool to do financial statements for the Dynamic GP and SL. The life span is coming to an end in the distant future but will still be around for many years. Over the past several years I've made a most common technical support list for FRx. FRx buzz has a top 12 tips list you can check out as well. Here is my top trouble shooting list in no particular order: Can't launch FRx from GP (Reports>>financial>>FRx) - Tech doc 850786 - The path to FRx is stored in the FRXDYN.INI file in the Great Plains directory on the workstation. If the path was entered incorrectly rename the FRXDYN.INI file, launch FRx again from Great Plains, and choose the correct path to the FRX32.exe file on your particular workstation. Missing accounts in BS or P & L (or financials don't tie) - FRx does not automatically update accounts added in GP. Run exception report in FRx then add accounts that are missing or dupli