Sales order net amount not tally with tables

[Former Member]

Hi Gurus,

I am reconciling some figures of Sales order.

I compare VBAK,VBAP, KONV AND KONP. The figures doesn't seems to tie. E.g. the sales order net amount display on screen is 100.00. When I total in table VBAP the net amount of all the items, the figures does not tally e.g. 98.00.

I then go to KONV and total up all the document condition and the figures also different e.g. 97.00.

[Former Member · Accepted solution]

hi,

the reason may be Rounding rule maintained for some condition type,

for example :

pr00 : 97.47 eur may be converted to 97 eur

for all the condition joined together the difference may be 2 or 3 eur

regards

senya

[Former Member]

Hi Bern

Can you please also advice the exact fields that you are looking at in VBAP and KONV?

Best Regards

SVP

[Former Member]

Hi SVP,

I am basically comparing field NETPR in table VBAK, VBAP & KONV.

After some thorough analysis, I found user have made changes i.e. a reject reason code was entered to some items. Hence, if I take those with reject reason, the figures should tie.

But I only puzzle how the reject code was entered since it was billed. Any other way to enter the reject reason codes to the line items after billing was done because I can go to VA02 to change mode to enter after billing?

Regards

PSK

[Former Member]

Hi Bern

Please check that whether you have any tax conditions ,etc in your sales orders apart from the basic value.

Because the field NETWR will only consider the Basic Value and not Tax values.

I hope it might be of some help.

R/

Sanjeev