I am having dealer scenerio.
While PO the user does not know what will the Excise amount
I have tried following attempt
For DEALER INVOICE, For Example:
Material Price = 1000/-
Excise Duty = 103/- (BEDECessSECess)
Margin of Dealer = 300/-
VAT @4% = 56/-
Grand Total =1459/-
PO created for Dealer Vendor with Base Price as 1403/- by selecting tax code which is having VAT as 4% (Total PO value will be 1459/-)
& then done MIGO, selected MRP indicator in miscellaneous tab, Entered Assessable value 1300/- as in Excise tab Item level and entered the excise values BED, ECess , SECess manually, & saved the document.
And finally while MIRO , i have edited base value as 1300/-enter the amount, but the system is calculating VAT on 1300 not on 1403. if i keep 1403 as base amount system is crediting the vendor by 140310356=1562.
Please guide me to correct scenerio.