on 09-08-2011 10:14 AM
Dear All,
In the Sales order Pricing the diff amont is adding to net value and updating in the vbrp table.we are using z-report for the sales
register.In the report the net value is taking from the table vbrp field NETWR. After Saving the sales order the diff amonth is calculating and adding to the net value so it is mismathing the values in between the invoice and the sales register.Please suggest me how to get the net value without adding the Diff amout to it.
Regards
Khajahussain
Dear All,
>
> In the Sales order Pricing the diff amont is adding to net value and updating in the vbrp table.we are using z-report for the sales
> register.In the report the net value is taking from the table vbrp field NETWR. After Saving the sales order the diff amonth is calculating and adding to the net value so it is mismathing the values in between the invoice and the sales register.Please suggest me how to get the net value without adding the Diff amout to it.
>
> Regards
> Khajahussain
Diff amount is nothing but your rounding value right. inv value you will get with that diff condition amount .
what amount u r getting in the sales register. Usually sales register also will use the same kind of rounding rule.
if u dont want to add that diff amount we can restrict in the condition level or pricing procudure level. logically
diff should include in the net value same we will receive from the customer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Chandu and all,
I dont have any problem with invoice value , Problem is with taxable value. For Better understanding i have
given below one scenario
Below is the Problem i am faceing
1----
First Line Item Second Line Item Total
2 Taxable Value--
20,062.40
3 Tax Vat 5%--
1,003.12
4 Invoice Value -
10,532.76----10,532.76--
21,065.52
5 Diff----
0.48
6 Diff to each item--
0.24
7 Final Invoice Value--
21,066.00
8 Taxable Value in--
21066.88
VBRP-NETWR
Taxable Value fraction portion is 0.40(1) and 5% tax Fraction Portion is 0.12(2) , adding these fracions 0.40+0.12=0.52.
Diff(5) is coming as diff=1-0.52=0.48. Rounding is set as100 to the currency INR.This diff value 0.48 is Dividing to both the items
Diff to each item(6) = 0.48/2.Final invoice value coming correct, But when the System saves the document ( Billing Document)
The taxable value(2) 10,031.20 is changing to 10,031.44 By adding the this diff amont 0.24 and updating in the VBRP-NETWR field. Please let me know how to update this field with actual taxable value 10,031.20 without adding the diff amont.
Regards
Khajahussain
Edited by: khajahussain on Sep 9, 2011 10:29 AM
In your pricing procedure pls assign subtotal to your taxeble amount (any thing from 1 - 6). Then pls change logic in your report fetch valure from VBRP-KZWI*(any thing which you have assigned as subtotal in pricing procedure). Because of this your taxable value is showing without rounding diff.
Dhiraj
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.