Excise Invoice

Visual Catpro

Designing an Excise Trading invoice. :

This article shows how to design a trading excise invoice. Here we are make excise invoice of sale vat 4%. Set the following properties with their recommended value in excise invoice DocType:

Property	Value
DocBillNoPrefix	Ex
DocBookForCash	C
DocBookForCredit	S
DocCalculateVAT	True
DocCashName	VAT INVOICE
DocColumnStyle	invoice1
DocExciseTrading	True
DocInputStyle	invoice1
DocName	VAT INVOICE
DocProperties	NoRG23DStock
DocTaxRate	4
DocTaxTitle	VAT
DocTerms	BILL,CASH
DocTotalStyle	invoice1
DocType	Invoice
DocVATBill	True
SeriesCode	E
SeriesName	Excise Invoice
Sub Series Name	Sale VAT 4%

Insert the following fields in input style.

· txpPrepTime

· txpRmvTime

· Add any remarks field and set the "ExStage" against InputFieldName property.

Above mention fields are Necessary you may add the other input fields as per requirement.

Insert the following columns in column style.

· S_NO

· PRODUCT_ID

· RG23D_NO

· RG23D_NO_SALE

· QUANTITY

· RATE

· DUTY_PER_UNIT

· AMOUNT

Insert the following total fields in total style.

· GROSS_AMOUNT

· SALE_TAX

· GRAND_TOTAL

You may insert another fields in total style as per requirement.

Now by doing above tasks our inputs are ready for an excise trading invoice. For printing Visual Catpro auto generates the Excise Variables for Invoice, Manufacturer and supplier detail. You insert the the variables in Doc Report Forms forms for printing.