cancel
Showing results for 
Search instead for 
Did you mean: 

Account Determination Error in Reverse Price Calculation

0 Kudos

Hi SCN,

Our client had a requirement of Reverse price calculations. We did it successfully, all the prices are flowing as desired by the client.

But we came across an issue, that is once the billing document is saved the accounting documents are not getting generated and showing an - Accounting Determination Error.

This is how we configured the pricing procedure.

This screenshot shows how the pricing is working.

And the error is as below-

We used condition "NETW" for calculating the Base amount - VAT with routine 25 in Cal.type. Values are flowing correctly, but here if you can see the above screenshot error is coming of condition "NETW".

As per the requirement we need to post the net value to GL i.e., Accoutn key is given to the "ZBAO".

I tried to check in SCN but I am unsuccessful in finding. Can someone help in this regard. 

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Kumar,

If you don't want to post NETW value in to accounts please select statistical indicator against this condition in pricing procedure.

Thanks,

0 Kudos

Hi Babu,

I tried the same, in the above screen shot you can see that if it is marked as statistical total calculations are going wrong.

Former Member
0 Kudos

Hi Kumar,

I didn't see Net amt VAT-EXCISE as subtotal in your pricing procedure screen shot, how come you got that line in calculation screen.

actually check the from and to options again, it should work.


0 Kudos

Hi Babu,

This is working from the routine 2 assigned in calculation type for that condition.

former_member182378
Active Contributor
0 Kudos

VSN,

From screenshot, we see that there is an error in account determination for price condition type NETW. Maintain the records in VKOA, for G/L account determination, for this condition type.


As per the requirement we need to post the net value to GL i.e., Accoutn key is given to the "ZBAO".

Net value is represented by which condition type?

TW

0 Kudos

Hi TW,

Netvalue is represented by the condition "ZBAO" which is in step 440.

Here the NETW is used for calculating the VAT from step 200 and subtract the 14.5% of JIVP       (step 210), gives the value in NETW.

former_member182378
Active Contributor
0 Kudos

VSN,

The account determination issue is caused by NETW, according to the screenshot.

Have you solved this?

What is the requirement?

Also give screenshot, of revenue account analysis, expand ZBAO.

TW

Former Member
0 Kudos

This message was moderated.

0 Kudos

Hi TW,

Not yet solved.

Requirement is reverse price calculation. We configured the pricing procedure as per the screenshot shown.

This condition had GL, but still NETW is asking for GL which is not required in my scenario.

former_member182378
Active Contributor
0 Kudos

VSN,

If you make a condition type statistical, then it will not ask for a G/L account.

TW

0 Kudos

I even tried the same, but other values are not calculating from NETW.

Did all the possible ways, but unsuccessful.

former_member182378
Active Contributor
0 Kudos

VSN, please elaborate, which condition types?

TW

0 Kudos

Can you go through my screenshots, as suggested i did but the values are not correctly flowing.

If I don't make condition(NETW) statistical below are the values calculated.

If i make the condition statistical below are values.

former_member182378
Active Contributor
0 Kudos

VSN,

Your pricing procedure, condition type NETW might be incorrect!

In RVAA01, see row Net Value 2, this does not have a condition type, it has only description.

Same way in your pricing procedure NETW should be removed, and only keep description. By this way - 1. accounting issue will be solved & 2. the net value will not get impacted.

TW