Cash Sales Bill with Net value zero

[Former Member]

Hi All,

I have a cash sale scenario where after sales order is punched, auto delivery is created and PGI and Invoice follow. In the sales order it self, I have proper Net value for the document. when I create invoice, at item level, all the prices are flowing properly from Sales order but at header , the Net value of Bill shows zero. Surprisingly, in SE11-VBRK, the field NETWR shows correct value but in display, the Bill always shows zero net value. I have gone though number of threads on this and can not resolve. Please advise what could be wrong.

Thanks,

Binita

[Former Member]

Hi Binita,

Not sure if your system is a pure standard sandbox. Because if the sand box contains pre-configured industry solutions, there will be plenty of enhancements in program SAPLV61A SAPLV69A.

Please help yourself to check in these two programs, check if any codes contians KSTAT = 'X'.

This is the control field for item statistical.

Another simple way to check, access T-code VOFA, change the SD document category of your billing type to 'U', and billing again, check if you can see the net value.

Regards

Vincent

[Former Member]

Hi Vincent,

Thanks for this valuable input. your answers :

Not sure if your system is a pure standard sandbox. Because if the sand box contains pre-configured industry solutions, there will be plenty of enhancements in program SAPLV61A SAPLV69A.

in the suggested two programs, I got XKOMV-KSTAT = 'X' at countless places. it would help if the search becomes a little more precise for where to look at.

Please help yourself to check in these two programs, check if any codes contians KSTAT = 'X'.

This is the control field for item statistical.

Another simple way to check, access T-code VOFA, change the SD document category of your billing type to 'U', and billing again, check if you can see the net value.

in VOFA , i changed the SD doc category to 'U' proforma Invoice and still the net value does not appear.

Reazuddin/Vincent, let me know one thing precisely, in my pricing procedure, should i have to have the 'CalType' mentioned against my Net value condition ?

Regards,

Binita

[reazuddin_md]

Yes,

its because, system isnt intelligent enough to understand which value is considered as "Net Value" & there are many conditions amount available in a given documnet.

You have to declare condition value in specific step, you are deciding as "Net value".

Regards,

Reazuddin MD

[Former Member]

Hi Reazuddin,

Strangely, in my pricing procedure, if I put cal type '2' against Z100 condition (net value) , the net value becomes zero at sales order level itself. if I dont give cal type anywhere, the net value appears at sales order but not at Invoice level. No Clue what is happening!

Thanks anyway for all the guidance,

Binita

[reazuddin_md]

Hi,

Sometimes its difficult to hit the exact spot of the issue without seeing the actual problem.

Needless to mention that, put the breakpoint @ net value field in billing program & debug . - as you are well verse in techincal part.

Update the forum for future reference, if you are able to resolve the issue.

Regards,

Reazuddin MD

[former_member655751]

Hi,

Can you please check the configaration screen (VOV7) of your item category, by changce if you have maintained "Y" under statistical value. If yes please make it blank.

Regards

Ranganath

[Former Member]

Reazuddin, full marks for guessing, I am a technical consultant moved to functional field and confused as never before. Have checked the standard setting as well. there has to be some bug in pricing procedure itself but then it left two questions 1) the same pricing procedure works at sales order level, there the net value comes. 2) correct net value is passing to accounting document and in the table VBRK as well. what could be wrong with the screen display?

your questions--

- which value is suppoosed to consider as net value & which one is gross value -seems, alt cal type = 4 ( Net value + Tax) is not used to derive the net value.

100% of net value condition (z100) is the net value

-is this issue with all the documents or only certain doc's ?- do you have previous doc's where net value is appearing as expected?

no, ever since the process is configured, the net value for all Bill with different item/customer combination, shows zero only.

Ranganathan, the statistical value in vov7 is blank as you said.

Thanks,

Binita

Edited by: Binita Joshi on Dec 14, 2010 9:25 AM

[reazuddin_md]

My First "Guess" is right .

As per my experience in SAP, its just like Mathematics, if you like to solve problems, you will be enjoying the real flavour of SAP. ( personal opinion only) & have fun and as a Consultant should always welcome the ISSUES, which is the first step to explore new things in SAP.

Coming to your issue-

- In pricing procedure, against Cond type:Z100 is there any Alt Cal type maintained in tx:V/08?

- Else, let us know, against which step , this Alt.Cal Type is maintained?

There should be routine assigned as "4= netvalue" , which is actually considered & displayed as net value in sales doc.

Another way is,

Try to test with new cash sales order or create different orders ( other than cash sales) with diff customers & materials. check the results.

may not exactly address your requirement, hope you may get a clue to proceed further.

Good Luck

Regards,

Reazuddin MD

[Former Member]

Hi

Might be the problem with copy controls Check the settings

Regards

Chandrasekhar

[Former Member]

copy control is OK. Quantity, Pricing header all are as in Sales Order. the control is copied from standard BV cash sales type.

[Former Member]

hi Binita,

Can you please confirm is this happening for some perticuler materials or for all materials???

If for some materials then can you please confirm what is the UOM for material and what is the condition record UOM for material???

[Former Member]

Hi Trupti and Vishal,

Thank you both for responding.

1) It happens for all material, all customers.

2) I do get proper records in VK13.

4) The validity of this condition record is perpetual.

3) If anything was missing, the net value would not have appeared at sales order header it self. It does appear at sales order header. after automatic Delivery and manual PGI, when I create invoice , the net value comes as zero. at item level in invoice, I do get values as in Sales order.

4) One thing I want to know is, based on the pricing procedure, how the net value is determined in any document? is there any setting based on which system determines net value of document? this would help me understand if anything is missing.

Thanks,

Binita

[reazuddin_md]

Hi,

Not sure whether it can helps you or not, but go through the check list, which may give hint for further investigation,

- Check in V/08 - against price conditions, statistical indicator is marked?

-Check in V/06- in cond type details - accruals is marked agianst the price condtions by mistake.

- in V/08- check the net value =4 in alt ctype is maintained in Gross value

- check ist happening only for few line items or all the line items

Regards,

Reazuddin MD

[jignesh_mehta3]

Hello,

Net Value is a system derived feild.

It is basically summation of all the feilds which are other than "Taxes" (Condition Classification in Condition Type Defination)

Hope this helps...

Thanks,

Jignesh Mehta

[Former Member]

Reazuddin, Thanks for responding. trying my bit to answer your queries. though I have not fully understood:

- Check in V/08 - against price conditions, statistical indicator is marked?

No. against the Total value condition, the statistical indicator is not marked.the condition shows correct value

-Check in V/06- in cond type details - accruals is marked against the price condtions by mistake.

I am not sure against which condition should i check this. in my pricing procedure, I have the following step:

*step Condition From To Statistical

85 Z100(Total value) 80 Not ticked

90 JLST(Tax) 85 Not ticked

100 Amount inclusive of Tax 85 99 Not ticked

140 Payment thru Cash Not ticked (this is manual condition)

150 Payment thru Card Not ticked (this is manual condition)

160 Total payment 140 159 TIcked

170 Difference (this is calculation formula with step 100 minus 160) Not Ticked.

Now, please tell me whether this setting is correct? in v/06, against any of this conditon, accrual is not marked.

- in V/08- check the net value =4 in alt ctype is maintained in Gross value

where should i set this looking at the previous answer?

- check ist happening only for few line items or all the line items

this happens irrespective of number of items in invoice.

Thanks,

Binita

[reazuddin_md]

As per my guess, you are a technical consultant moved to functional.

Bit confused by looking @ your pricing procedure.

- which value is suppoosed to consider as net value & which one is gross value

-seems, alt cal type = 4 ( Net value + Tax) is not used to derive the net value.

-is this issue with all the documents or only certain doc's ?

- do you have previous doc's where net value is appearing as expected?

Please study the std pricing procedure & maintain the relevant settings wherever missing.

my assumption , there is issue in pricing structure.

Regards,

Reazuddin MD

[Former Member]

Hi,

Have u checked pricing condition in vk13, check price is maintained on which key combination and check the validity period for the same.

hope will help u.

Trupti