Account determination Error during billing reversal

[kennethchee]

Hi Experts,

I encounter error during reverse billing document. It shows "cancel invoice (s1) status is open". Once I checked on acct. determination analysis - revenue accounts I found the error show below.

I try compare another successful posted billing document (different document type) , as shown below. Why does the exclamation mark mean? how to rectify this issue? Please advise,

[ravi_kumar100 · Accepted solution]

Hi,

The billing document has not been released to accounting . Release it to accounting and attempt to cancel it in VF11.

Check your Customer Master - Acct assgmt group whether empty or not. Cross check for the G/L 's in VKOA for the corresponding key.

Regards,

SRK

[kennethchee · Accepted solution]

Thanks SR Kumar.

[VeselinaPeykova]

Hello.

In the first screen you show unsuccessful determination for ZMOH condition type.

In your second screen you show an unsuccessful determination for ZMOH, but for the second access.

I guess you have successful determination on a different level for the second billing document - e.g. Material group/Account key or Account key and this is why the document was posted to accounting. It does not mean that it is correct, just that there was such combination found.

An exclamation mark in account determination means that there is no value for the field found. Usually the value is taken from the master data, but can also be taken from other sources, sometimes you can also change it in the billing document before posting to accounting. For example if I see that the customer account group in the document is incorrect, I can go to VF02->header and change it to the correct one in the billing document and release to FI. The same is valid for billing item level - if the material account assignment group was wrong at the time of sales order creation.

I would suggest to review very carefully the account determination for both documents. It is not a very common practice to determine all postings only based on material groups and account keys. It is very disturbing to see customers without maintained account groups in a productive environment. Please check with your consultant and with master data specialists - for all trade customers used as payers you should have account assignment group maintained as obligatory field. It is possible that the wrong partner was maintained as a payer and it has an account group, where the account assignment group is not obligatory. If the payer is wrong in your successfully posted document this can be a very bad news for the accounting department.

Regarding VKOA:

when you introduce a new pricing condition for a given process and you want to generate a posting to FI, it gets an account key - in your case it is ZMH. You can specify based on what criteria to determine the G/L account - could be customer/material/assignment to controling object/some other criteria that you need based on the business process. You have to provide the exact criteria when requesting the changes from your consultant. For each combination of sales organization and chart of accounts you can specify different rules.

• If the condition should not be determined - check with the pricing expert.
• If the master data is wrong - request that master data team fixes tha problem and you have to maintain the correct groups in the billing manually.
• If the master data is correct, but somebody changed the data in the preceding document - you can change it in the billing.
• If the account assignment to controlling object is wrong - check if you are supposed to maintain manuallu an internal order/wbs element etc. in the sales order.
• If all data is correct, but you still do not get a G/L account determined - request the combinations from the SD consultant for this specific sales organization. You probably have a template that you are supposed to fill.