Cash Discount at the time of Goods Receipt.

[Former Member]

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

[Former Member]

Please create a Price determination schema/ Modify existing schema to calculate (subtract) Cash Discount in Nett Price and not on Gross Price.

Assign the CAsh discount Z condition to the schema.

You can use this in either header or item level depending upon your requirement.

This is to be maintained in condition table MEK1

[Former Member]

Hi,

I already created a Price determination schema/ Modified existing schema to calculate (subtract) Cash Discount on total value.

Will you pls expalin how to calculate Discount on Nett Price and not on Gross Price.

Regards

Nilesh

[former_member614205]

Hi,

Please check by setting indicator "discount base is net value': T001-XSKFN in txn OBY6.

Kind Regards,

Suneet

[former_member824495]

Hi,

Maintain cash discount condition 'Statistical' in your pricing.

Hope it will work for you.

Regards,

Piyush

[Former Member]

Hi Piyush, if we make it stas, it wont get reflected in accounting as we in MIRO. I want is Dynamic.

Regards

Nilesh