Skip to Content
0
Former Member
May 08, 2009 at 12:42 PM

GL Changes in DET_ACCOUNT

17 Views

Hi all,

Can you provide any advice on changing Prod Category-GL code links in the DET_ACCOUNT table.

As we know this table is used to determine the GL code for a Product category.

We are using UNSPSC codes and have loaded about 17,000 codes into the config.

After running with these for about 2 years our "accounting experts" decided that they required some of the assignments changing to provide improved spend analysis on GL codes.

As a trial we modified 3 links to determine what problems that may arise.

Now all new shopping carts and PO's generated use the new GL codes and everything is OK until a user attempts to modify an old PO that still has the original GL code.

They either want to reduce the quantity to remove a commitment in the backend ECC system, or want to adjust an item price to release a blocked invoice.

Neither change is possible as they receive an error message that the GL code is incorrect and to enter a the new GL.

This cannot be done because the PO already has FI documents posted against it e.g. Confirmations and invoices and the Account assignment GL field is locked.

Consequently we have blocked invoices that cannot be released and commitments that cannot be reduced.

Can any one suggest a way that we can overcome these problems.

We are using SRM 5.5 with SP13

Regards

Allen Brooks

SRM BPO

Sunderland City Council