GL Changes in DET_ACCOUNT

[Former Member]

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

[Former Member]

As there have been no replies to this message I will update and close it.

The only way we found to resolve our old PO's where the GL code is now incorrect is to close our system down to users, revert the GL code in the DET_ACCOUNT table back to the GL on the old PO's.

Change the old PO to unblock invoices reduce commitments etc.

When complete, switch the DET_ACCOUNT table back to correct GL and then open the system again for users.

We had to do all this for 56 Purchase orders outside normal working hours and it was a pain.

SAP should really find a way to resolve this as Accountants often want to re-organize their GL's for better accounts or simply because they made a mistake when assigning a UNSPSC code to a particular GL in the first place.

Regards to all

Hope this helpd someone else

Allen