Account Assignment group is blank in billing dcoument !

[Former Member]

Hi,

In some order Account assignment group is blank in billing document which led to Account determination error in production system .
I have checked account assignment group is already maintained for material(mm03) and customer(xd03) in the PEC.

In VF02 for only one item in order AAG is coming as blank . that is why in account determination analysis for that item 'No G/L account found in Account determination type KOFK' is coming . And User is getting Account determination error . I have checked in VKOA G/L account is maintained.

I know manually I can enter the value of AAG in VF02 for the item &  error will get resolved but I want to find the reason since it is in PEC system.

Can anyone provides solution k why AAG comes blank for  billing document that led to  account determination error. ?

thanks in adv.

Reg,

Rahul.

[former_member204407]

Hi,

have you tried like this?..

'No G/L account found in Account determination type KOFK' is coming .

- Give your billing document in VF02 and try to release it to accounting(shift+F4)

it will show the error message where you need fix the error.

-. with the above error check with FI consultant any CO related  settings to config for KOFK with ERL account Key in VKOA

Thanks,

Krishna.

[Former Member]

Hi Rahul,

There are basically two places where account determination settings are maintained.

(1) For revenue account determination

(2) For reconciliation account determination.

Since you mentioned that the account assignment key is not determined for the condition type KOFK, I assume that you are facing the issue with the reconciliation account determination.

I have faced this issue in the past and more times than not, the condition table being used for account determination (assign G/L account) is not the correct one that is assigned in the access sequence. I hence suggest that you check the whole condition technique thoroughly, starting right from the procedure assigned to the billing type, the condition type assigned to the procedure, the access sequence, right through the condition table/tables maintained.

This should hopefully solve your issue. It did in my case

Regards,

Sumita Mittra

[Former Member]

Pls check what condition type is assigned to your sales order.is that EK01 or EK02,

Regards

RAM

[Former Member]

Thanks for reply.

I have checked the material &  customer both the places AAG is maintained. In vf20 also the combination is available .

Can you suggest where/how to check all condition table which is being used to determine G/L account . Since here functional consultant r not available ?

In  SAP DBM How/ on wht condition the AAG is picked for a material group ?

Still not able to find the reason why  AAG value is  blank in Billing document after invoicing.

Regards,

- Rahul.

[Former Member]

Hi Rahul,

Please check under Sales & Distribution- Account assignment & costing-Revenue account determination- Assign G/L accounts. This is where the combinations are assigned to the right tables.

However, to be able to check what your right table is, in the same path as above go to "Define access sequence and account determination types". In this choose "Define access sequence" and for your access sequence, see what table(s) have been used.

You should have maintained the correct combination of account assignment groups/application/chart of account to the right table for the revenue account determination to work.

Hope this helps.

Regards,

Sumita Mittra

[former_member245533]

Hi Rahul,

Kindly refer the answers below:

Q. Can you suggest where/how to check all condition table which is being used to determine G/L account

A. After creating the invoice, go to VF02 transaction code by providing your billing document nnumber and enter it. In main menu bar, you need to choose Environment --> Acc.determ.analysis --> revenue Accounts. Here you will get on what level GL code is getting determined. Further in transaction VKOA, you can check on what basis / selection parameters G/L codes are aligned. In VKOA initial screen, you will have the table column. If table is showing as 230, that means in SE16 transaction code, it will be C230.

Q. Why  AAG value is  blank in Billing document.

Regards. 

[former_member184701]

is that particular item category relevant for billing ? check your config

[former_member212707]

Check if it has flown into the sales order first. If not as Srinu mentioned it could be the question of timing.

Thanks,
Ravin

[srinu_s1]

Can anyone provides solution k why AAG comes blank for  billing document that led to  account determination error. ?

There could be a reason that by the time user creating the billing document, in the material master AAG is maintained blank, later that could have been maintained with relevant field in material master.

The sames rule would apply for the customer (if it is header level AAG in billing) as well in XD02

The changes in material master you can find out by going to change log of the material also for the customer in XD02

thanks,

Srinu.