Skip to Content
0
Jan 11, 2012 at 05:54 PM

Alternative Account number - using as a custom field/Issues in reports pull

481 Views

Hi All,

Requirement:

Create a new field in the GL master that will link through to a new 8 to 10 character new Chart of Accounts (COA).

We are presently using the "Group Account number" field from the GL master for reporting purposes through a Group COA. So this won't be available for our new purpose. Instead of creating a custom field and pulling the data, I'm thinking to use Country Chart of Accounts to fill this gap by using "Alternative Account Number" in GL Control data tab.

I created a new Country COA and assigned it to Operational COA. Created new GL account (FS00) and also created a new Country Chart of Accounts (FSP0) at Chart of Accounts level and assigned this to the created GL (FS00). In this process I got couple of issues

1) System didn't allow me to assign Country COA GL if already has the balance, and tried to change this error message in OBA5 without success. How can I add newly crated Alternative a/cs to the existing (balanced) GL A/cs?

2) This time I created brand new GL a/c and added the alternative a/c and created new Financial Statement Version (FSV) assigned the newly crated a/cs but I couldn't run the reports on this new COA, getting following error message "Company codes and charts of accounts entered are incompatible" when executing F.01/F.08.

3) May be silly to ask - why we are not maintaining the Alternative a/c at Company Code level (FSS0)? Why we are only maintaining at Chart of Accounts level (FSP0)?

Would be glad if any one touch this area deep enough to understand easily