Cannot see Budget name in Frx Column

This is a common problem when setting up budgets for the new year.  The MS Techknowledge lists about 15 things that can cause this.  Try this first.

Locate your Sysdata directory.  Delete the g32 file for the compnay in question.  ItF will be a file that looks something like this:  TWO08.g32

This is taken from the MS Techknowledge on the subject.

Resolution 4

Re-create the link to the general ledger. To do this, follow these steps:

1. Click Start, point to All Programs, point to FRx 6.7, and then click Report Designer.
2. When the Database Login window appears, click Cancel.
3. When the Select a Company to Work With window appears, click Cancel.
4. Click Admin, click Organization, and then click SysData.
5. Select the path in the Current location field, right-click the path, and then click Copy. If you cannot copy the path, note the exact path that appears.
6. Click Start, click Run, paste or type the path of the SysData folder, and then click OK.
7. Close all the instances of Microsoft FRx that are running, and then delete or rename all the files in the SysData folder that have the following extensions:

.g32
.ldb
.lck
8. Start Microsoft FRx. To do this, follow steps 1-2.
9. Click Company, and then click Information.
10. Select a company that is listed in the window. Click Set as Default, and then log on. Then, repeat this step for the next company that is listed in the window until you have repeated the step for all the companies.
Posted in Frx

Frx default fonts

In the Frx row format you can set the font for a row.  Here is an example.  Click on Font style: to select the font.

Frx row font

In the column headings and in the column detail you can set the font.  Here is an example.

Frx column font

I like to use the setting of Default Font.  To change the setting of Default, open the Catalog of Reports.  Select a report, click Page Options, then Page Setup.  Set the default font style you want for the report.

When setting fonts remember a row font setting overrides a column setting.  The column setting would override the Page Setup setting.  So for example, I might setup Page Setup default font to Arial 10.  Then in the column I might set one column only to print as Arial 16 bold, italic,red.

Posted in Frx

Frx Service packs for MS Dynamics GP

If you are on service pack 9, 6.7.9111, you should stop there and wait for service pack 12.  Do not put on service pack 10 or 11.

You should only consider service pack 10 or 11 if you have identified a specific issue solved in the service pack.

From MS Technical support:

“First I would like to say that the information you saw is correct. However there have been some things that were broke from SP11 and SP10. I suggest that if you are currently not running into any issues that you remain on SP9. If you run into an issue at that point I would suggest moving up to SP11. Also SP12 will be available sometime in the first quarter of the new year, so you will want to keep this in mind as well.”

 

Posted in Frx

Invalid drive specified for work file when launching Frx

Frx is famous for work files and paths to the server or local drives for certain folders like Sysdata and IOdata.  Launch Frx, go to Admin, then Processing Options.  Change the work folder to a network drive you know the user has rights to.  This is the best option.  Here is additional info.

Resolution 1

To resolve this problem, set a valid path for the optional work drive. To do this, follow these steps.

Note The folder that is specified for the optional work drive must exist before you perform these steps.

1. Click Start, point to All Programs, point to FRx 6.7, and then click FRx Designer.
2. Click Admin, and then click Processing Options.
3. In the Optional Work Drive box, type the location of the Temp folder. Or, you can click the arrow to open the “Browse for Folder” window, and then click the Temp folder.
4. Note the path of the folder.

Resolution 2

To resolve this problem, verify that the Everyone group has full control to the folder that is specified for the optional work drive. To do this, follow these steps:

1. Log on to the workstation as an Administrator.

Note You cannot log on as only a user who has administrator rights.

2. Right-click Start, and then click Explore.
3. Delete the path in the Address box.
4. In the Address box, type the path of the folder.
5. Delete the file name from the end of the path, and then click Go.
6. Right-click the folder, and then click Properties.
7. Click the Security tab, and then verify that the Everyone group has full control.
8. If the Everyone group does not exist, go to step 10.
9. If the Everyone group exists but it does not have full control, go to step 12.
10. Click Add, and then type Everyone.
11. Click Check Names, and then click OK.
12. Click Everyone, and then select Allow for the Full Control permission.
13. Click Apply, and then click OK.
Posted in Frx