rounding off issue

[Former Member]

Dear Sir,

we have to round off the net value so for that we use the DIFF condition type and also maintained the alternative calculation for condition base value as 17 and also maintained T100R as 100 in TCODE OB90.

Now assume our net value is 927.35 and due to the rounding off our net value is 927.00 Now this value of 927 should only flow to FI and not 927.35 when an invoice is created.

In my case 927.35 is getting posted to accounts

we need the 927 to be flowed to the FI posting so that when the customer makes a payment for the same and the diffrence amount of 0.35 to the difference GL.

The diff condition type maintained in pricing is maintained but the value its showing is sale order is zero value.It is not picking the 0.35 amount which can flow to account key ERL

what must be the problem

Thanks

ajay

[eduardo_hinojosa · Accepted solution]

Hi,

One idea. Perhaps you need create a new conditions where you can populate the value of this rounding. For this issue you can use VOFM subroutines.

These notes will give you ideas (they describe pricing procedures, VOFM and related notes)

Note 178824 - Withholding tax from SD for countries other than Argentina

Note 80183 - Rounding

I hope this helps you

Regards,

Eduardo

[Former Member · Accepted solution]

hi friends,

I ssue is still open....any solution?

ajay

[jignesh_mehta3 · Accepted solution]

Dear Ajay,

Create a new Condition Type for Rounding Value & insert it in your Procing Procedure.

Now say your Invoice Value comes to Rs. 925.25. Manually insert -0.25 in your Rounding condition type.

This will ensure that your Customer account is posted only Rs. 925.

Now in your Pricing Procedure, mention a account key (if required create a new account key) against Rounding Condition & mention a seperate GL account in VKOA against the Account Key mentioned in Pricing Procedure. This will ensure that -0.25 is posted in a seperate GL account which can later be cleared.

Hope this helps...

Give points if useful...

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Dear Ajay.,

Can u try this one. Just u change in u r pricing Procedure and put the values of the below one. And make a test run.

13 (Requiremnet) - 16 (Cal.type) - 4 (Alt.Base Value)

And check the result.

[Former Member]

no solution...closed

[Former Member]

Hi,

If your value is rounded off in sales order and it not happening in invoice then the problem is in copy control.

Go to VTFL for delivery to billing copy control or VTFA for sales to billing copy control.

Chose one procedure which you are using and select combination of documents.

Now go to item level and select your item category and go to detail

In that maintain pricing type D instead of B.

Save the setting and create your invoice again.

Regards

Raj.

[Former Member]

Hi raj,

Please undertsnd the query.Its not the issue of copycontrols.

Thanks

ajay

[Former Member]

Hi,

But I ask you one more thing dear.

Whether proper rounding is happening in sales order or not.

If its happening proper over there then there should be no problem in billing also.

And you are saying that only

So I just suggest you that thing. Just try at once for my suggestion.

Regards

Raj.

[Former Member]

Thanks raj,

I want the rounded off final net value to be flowing when we post the invoice and that value should be seen in the Finance so that the FI guys can collect payment accordingly.

hope now this is clear.

Thanks

ajay

[Former Member]

Dear Ajay,

An Example:

Step-Cdt Typ

---

Descrp

---

FromTo---Subtotal--Req-AltCalAltbase--AcctKey

XXX-----DIFF

---

Rounding Off---YYY--N/A

---

N/A

---

13

---

16

---

2--

---

ERS

Insert Above line, after the step, where onwards (say, after Net Value OR Net Value+Taxes)

Important: if you are inserting after Net Value, then Altbase will be "2"; and

If, you are inserting after Net Value+Taxes, then Altbase will be "4"

Best Regards,

Amit

Note: Also refer, my posts in to:

[Former Member]

Dear Amit,

please find the pricng procedure

step condtyp description frm to Ma RqStat P Subtotal Reqt CAl typ Bas ty Ackey

10 ZBBP Basic price 2 ERL

100 Total Basic Price 10 90

200 JIVP A/R VAT PAY 100 JN6

250 ZIVP A/R ADD VAT 100 JN8

300 JIVC A/R CST 100 JN7

350 Total Taxes 200 300

400 Total Basi+Taxes 100 300

550 Total 400 500 A 17

600 DIFF Rounding Off 550 13 16 4 ROU

650 Grand Total A 17

Now can you please tell me wwhere exactly the alternative base value shpuld differ according to your given solution.

Thanks

ajay