Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Accounts do not show i...

Accounts do not show in FRX trial balance

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have two accounts that do not show up in the FRX trial balance, when I try to Edit/ Add rows from chart of accounts in consistently misses these two accounts.

I am selecting the ALL&&& for each segment.

I have run a financial accounts checklinks. I have a XXXX-XX-XXX format. I have tried deleting the .g32 in the sysdata folder. I have also set the trial balance to include zero balance accounts. When I print the missing account exception report these two accounts show.

The only way I can get these to come in is manually add them every time, which as we add accounts this is not ideal.

What else can I do to get FRX to recognize these accounts as valid and pull them in?

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Accounts do not show in FRX trial balance

Found the solution. My frl_acct_code table in GP was corrupted/incomplete and needed to be rebuilt. FRX_67_Server_Based_Index_Scripts_Combined_GP.sql script is found on the FRX 6.7 disk. This script rebuilds this table.