Skip to Content
0
Former Member
Aug 06, 2010 at 08:50 AM

Cash Discount at the time of Goods Receipt.

182 Views

Dear Gurus,

Our requirement is to post goods receipt at cash discounted value but at the same time I wants to calculate taxes on Gross. Consider following case.

Base value 100, Quantity 1.Total value =100 RS. 8.24% Excise on 100= 8.24 . Add to Gross=100+8.24=108.24. Now 4% VAT on 108.24=4.33. Total PO Value =100 8.244.33=112.57 RS.

100 ( Base material prise)

+8.24 ( Excise)

+4.33 ( 4%Vat on 108.24)

-


112.57 (Tot PO value)

-2.57

-


112 ( PO)

Now since 2.57 RS cash discount known at the time of PO, so I have created a Z condition ( cash discount Value type) and assigned it in prising at proper place ( below total PO value) so that when I assign value 2.57 to this Zcondition, my PO gross is getting changed from 100 to 100 minus 2.57=97.43. Now system is calculating 8.24 % excise on 97.43 but I want it on 100 . How to do this.

Thanx in advance.

Regards

Nilesh