Question Re: Net amount does not tally in Enterprise Resource Planning Q&A

Net amount does not tally

Former Member — Wed, 04 Feb 2015 05:05:32 GMT

Hi experts,

My net amount maintained in PO is 233.64.which is exclusive of GST. When i maintain a tax code this amount gets calculated to 249.99 and the total net amount for this is calculated.But my requirement is that this should be 250.Please advise

Re: Net amount does not tally

JL23 — Wed, 04 Feb 2015 12:18:07 GMT

It is basically the same question as in your discussion

you get a gross price including 7% GST which is 250

so the formula to get the net price is

250 * 100 /107 = 233.6448598130841

and this was rounded by you to 233.64

If you now use this rounded net price to calculate GST and a total, then of course you will not get an exact match.

233.64 *107/100 = 249.9948

and with just 2 decimals it is rounded down to 249.99 which makes a difference of 0.01 to your original. this is just mathematics.

Again, you would not have less problems if you would use a price per 100 instead of per 1.

Re: Net amount does not tally

Former Member — Thu, 05 Feb 2015 02:16:19 GMT

Hi Jurgen,

Thanks a lot for you response.Here i have a total quantity of 21.Which means 233.64*21= 4906.44.

When this is inclusive of GST it calculates for The total amount rounds up to 5249.89.But the requirement is 5250.Thus there is a difference of .11.If i need to calculate for 21 quantities should i maintain 21 instead of per 1.Or the full amount 4906.44 per 21.please advise how to proceed further.

Re: Net amount does not tally

JL23 — Thu, 05 Feb 2015 05:55:37 GMT

see the problem is basically because your vendor is giving you prices including the GST, while in normal commercial business we get prices without tax.

Once you get the invoice from your vendor you will have those smaller differences which can be accepted if the tolerances are setup to allow this.

If you maintain the price as 4906.44 per 21 then you are certainly at best what you can do.

I am not the guru on pricing, maybe there a way to enter gross prices instead of net prices, may know it better

Re: Net amount does not tally

former_member183424 — Thu, 05 Feb 2015 06:35:37 GMT

Thank you for calling me.

I was following this discussion. System is behaving correctly. His requirement doesn't seems logical to me.

As you can see, system is calculating like that 233.64 X 21 = 4906.44 (no need to rounding)

Then 7% GST charges 4906.44 X 7 % = 343.4508

Then add this to gross price 4906.44 + 343.4508 = 5249.8908, here system is rounding as 5249.89.

So why you want 5250 as you are allowing two decimal points for the currency.

If you want to round it up, then you can use an extra condition type.

Re: Net amount does not tally

Former Member — Thu, 05 Feb 2015 06:39:53 GMT

Thanks Jurgen,

I maintained with the same value as mentioned.But still the difference is the same.Thanks a lot for your assistance.

Re: Net amount does not tally

Former Member — Thu, 05 Feb 2015 06:45:23 GMT

Hi Dibyendu,

Thanks a lot for the response.Here we do not have an RFQ. But we have a quotation which is maintained manually.This value is 250.We attach this with the PO.Now this should match up the PO value which in inclusive of gst.So we convert it to exclusive of gst which is 233.64 and then raise a PO.But in PO the total value is 5249.89. instead of 5250.IF we a re maintaining a manual condition type then it is tedious and difficult if i have 10 line items.

Re: Net amount does not tally

former_member183424 — Thu, 05 Feb 2015 06:48:58 GMT

Okay I have found an workaround..

You can use the Calculation formula as 17 for your subtotal in M/08.

Then you can able to see the condition tab like this :

Re: Net amount does not tally

former_member183424 — Thu, 05 Feb 2015 06:51:26 GMT

Look the below reply. Hope it can fulfill your requirement.

Re: Net amount does not tally

Former Member — Thu, 05 Feb 2015 06:56:48 GMT

H Dibyendu,

Correct me if am wrong.For which condition should i maintain this?

Re: Net amount does not tally

former_member183424 — Thu, 05 Feb 2015 07:00:33 GMT

You do not need to maintain this for any condition type.

You need to maintain this for your total net amount's line item (which is calculating sum of gross amount+GST) in M/08.

Re: Net amount does not tally

Former Member — Thu, 05 Feb 2015 07:26:30 GMT

Hi Dibyendu,

I do not have a subtotal value maintained in the pricing.All i have is an effective price which is maintained from 21 to 39.There is nothing maitained for 1 to 21.I am unable to identify.The field subtotal has any effect in the pricing configuration??please assist.

Re: Net amount does not tally

former_member183424 — Thu, 05 Feb 2015 07:33:17 GMT

Check your PO condition tab, for which line item you can able to see the value 5249.89.

Note that line item and maintain the calculation formula for same line item in M/08.

If you still can't able to find, then please share the screen shot of your calculation schema (M/08) and PO condition tab.

Re: Net amount does not tally

Former Member — Thu, 05 Feb 2015 08:42:11 GMT

Hi Dibyendu ,

Thanks a lot for your quick response. Appreciate for the fast turn around.Thank You Jurgen.But still not able i tried each of the condition type for which value is coming.Am attaching the screenshot the pricing maintained