Excise duty should affect item cost--SAP B1 2007 B ,PL-08

Dear All,

One of my client pays excise duty while purchasing goods but while selling he uses simple Vat code. As he can not take the benefit of Cenvat Credit, he wants cenvat should be added to actual purchase cost. Please advice how this functionality can be mapped.

Note: To sell the item with simple Vat code, we are doing inventory transfer from Excisable warehouse to non-excisable warehouse

Pririty-High

Regards,

Mukesh