Depot Excise Invoice in case of Invoice Split

Hello Experts,

This is the case of Depot Sales and system is splitting Retail Invoice ( VF01 - Invoice) because of different Header Data in Sales Order. Now when creating Depot Excise Invoice with refrence to Delivery, system is creating single Excise Invoice for both the Invoices . Now as per business there has to be one Excise Invoice for one commercial invoice ( VF01 Invoice) .

Sales Order has 2 line Items with different Price List Type . Because of this system is splitting Invoice( VF01 - Invoice). Now while creating depot excise invoice with refrence to Delivery , system captures both line items in one excise invoice . Find the e.g.

Excise Inv no Retail Inv no date

8611212141 7486286119 28/11/12

8611212141 7486286120 28/11/12

As per business 2 Retail Invoices can't have one Excise Invoice .

Kindly advice.

Regds

Vikas