How is Sales Value calculated in FD32?

[ali-sd]

Dear Experts,

Please guide me on how system calculates sales value in FD32.
I know as per definition, F1 says

Below are efforts to find the same. I am not sure whether or not this is correct. Please correct me if I am wrong.

Refreshed Sales Value in FD32To verify whether this sales value equals to VA05NVA05N -> Customer (101667) -> Total of Net Value = 2,069,640.78

Therefore, this total of Net Value can not be considered to tally with Sales Value in FD32. Because certain SO types (part of this total Net Value) are not relevant for credit check. Below pic shows the same.


Later we debugged and found how this sales value is calculated in FD32.
So, Sales Value = S066-OEIKW + S067-OLIKW + S067-OFAKW

Below is the detailed calculation of S066-OEIKW (Open Order credit)
SE11 -> S066 -> Display -> Customer (XXXX) -> Open order (> 0) -> ExecutedBut I do not know how to further find out from where these values are coming...



Please guide me further

[ali-sd · Accepted solution]

Dear JP sir,

I further digged deep into your shared link. And I found the answer for my above query. Below updated is the same.

And there was one more problem for wrong sales value in FD32. It was incorrect configuration of pricing procedure. SubTotal (A) was assigned at wrong step which does not calculated Net+Tax

I am closing the ticket. Thanks JP sir for sharing wonderful link.

[jpfriends079]

I don't know whether anytime you got chance to look that the below SAP Community Wiki, if not then do look at that.

https://wiki.scn.sap.com/wiki/display/SD/How+does+the+credit+update+work

This wiki clearly explains how "Credit update works"

Moreover, don't forget to look at the further information section at the bottom of that wiki.

Thanks,
JP

[ali-sd]

Dear JP sir,

Thanks for the link shared. I have gone through it.

But I have few queries wrt to update group 000012 (which is mapped with the co code)
Below are the open sales orders (whose SO type is credit enabled and item category is credit enabled). But these SO have not been considered in sales value in FD32 although there is open qty for these SOs.

FD32 should have considered the Net+Tax for open qty each SO wise.

Kindly clarify.

[sez41]

Sales value = Open sales order (delivery not created) + Open deliveries (not billed) + Open billing documents (not released to accounting).

[ali-sd]

Hi Kivanc,

I really appreciate for your comment. I am aware of what you mentioned. But how do I validate the same in the system (prove in the system that Sales Value = Open orders + Open deliveries + Open billing). My above comments shows my efforts to validate this but I failed. There could be some more logic. Please guide further.

[sez41]

Hi mmak,

But you have already found this out. These values are not calculated on the fly, but rather stored on LIS tables S066 and S067. Anytime a credit check is supposed to be made, only these tables are taken into account, and these tables are updated upon every save of sales documents.

[ali-sd]

Hi Kivanc,

Yes. I found it out. But my question is on what logic S066 and S067 stores these values? When I checked the total Net value (credit check relevant SO type wise) in VA05N + Net Value of their relevant bill types wise in VF05N, sum of these Net Values do not match the values in S066+S067. Please guide here.

[sez41]

I'm pretty sure you must have missed something along the line. Bear in mind that credit check is also activated per item category, and not only on header level.

[maximiliano_isoba]

Hi,

Have you checked only the open sales orders for that customer?

Also, have you create a new customer and documents so that you could see how credit control works?

Regards,