Visual Catpro
  

VARIABLES FOR DUTY ELEMENTS OF THE INVOICE
Variable
Description
EAssAmt
Assessable Amount
EAssAmtN
Assessable Amount Numeric Format(Sum in case of multiples)
EAssAmtW
Assessable Amount in Words
eExciseAmt
Amount of Duty
eExciseAmtN
Duty Amount Numeric Format(Sum in case of multiples)
eExciseAmtW
Amount of Duty in Words
eEduCessAmt
Amount of Education Cess
eEduCessAmtN
Education Cess Numeric Format(Sum in case of multiples)
eEduCessAmtW
Amount of Education Cess in Words
eSecEduCessAmt
Amount of S & H Education Cess
eSecEduCessAmtN
S & H Edu. Cess Numeric Format(Sum in case of multiples)
eSecEduCessAmtW
Amount of S & H Education Cess in Words
RgNoSale
RG23D Number Sale
eAcdAmt
Additional Duty Amount Passed
eACDAmtW
Additional Duty Amount Passed in Words
ePerExcise
Excise Per Unit (Manaual Detail only)
ePerECess
Edu Cess Per Unit (Manaual Detail only)
ePerSheCess
S & H Edu Cess Per Unit (Manaual Detail only)


VARIABLES FOR MANUFACTURERS DETAILS
Variable
Description
mAssAmt
Mfg. Assessable Amount
mAssAmtN
Mfg. Ass. Amount Numeric Format(Sum in case of multiples)
mAssAmtW
Mfg. Assessable Amount in Words
mExciseAmt
Mfg. Amount of Duty
mExciseAmtN
Mfg. Duty Amount Numeric Format(Sum in case of multiples)
mExciseAmtW
Mfg. Amount of Duty in Words
mEduCessAmt
Mfg. Amount of Education Cess
mEduCessAmtN
Mfg. Edu. Cess Numeric Format(Sum in case of multiples)
mEduCessAmtW
Mfg. Amount of Education Cess in Words
mSecEduCessAmt
Mfg. Amount of S & H Education Cess
mSecEduCessAmtN
Mfg. S & H Edu. Cess Numeric Format(Sum in case of multiples)
mSecEduCessAmtW
Mfg. Amount of S & H Education Cess in Words
mTotQty
Mfg. Total Quantity
MTotQtyN
Mfg. Total Quantity Numeric Format(Sum in case of multiples)
mInvNo
Mfg. Invoice Number
mDesc
Mfg. Description of Goods
MIDMark
Mfg. Identification Mark
MExcisePerUnit
Mfg. Excise Duty Per Unit
MEduCessPerUnit
Mfg. Education Cess Per Unit
MSecEduCessPerUnit
Mfg. S & H Education Cess Per Unit
MTariff
Tariff No. of Item
MDutyPerUnit
Mfg. Rate of Duty Per Unit
macdamt
Mfg. Additional amount
r99("CvtRate")
Mfg. Additional Duty Rate.
MacdPerUnit
Mfg. Additional Duty Per Unit
 
 
 
 
 
 
Manufacturer name, address, range, divison etc. field names is similar to the party name but instead of recordset1(r1) manufacturer details are stored in recordset3(r3)


VARIABLES FOR SUPPLIER DETAILS
Variable
Description
SupAssAmt
Supplier Assessable Amount
SupAssAmtN
Supplier Ass. Amount Numeric Format(Sum in case of multiples)
SupAssAmtW
Supplier Assessable Amount in Words
SupExciseAmt
Supplier Amount of Duty
SupExciseAmtN
Supplier Duty Amount Numeric Format(Sum in case of multiples)
SupExciseAmtW
Supplier Amount of Duty in Words
SupEduCessAmt
Supplier Amount of Education Cess
SupEduCessAmtN
Supplier Edu. Cess Numeric Format(Sum in case of multiples)
SupEduCessAmtW
Supplier Amount of Education Cess in Words
SupSecEduCessAmt
Supplier Amount of S & H Education Cess
SupSecEduCessAmtN
Supplier S & H Edu. Cess Numeric Format(Sum in case of multiples)
SupSecEduCessAmtW
Supplier Amount of S & H Education Cess in Words
sTotQty
Supplier Total Quantity
sTotQtyN
Supplier Total Quantity Numeric Format(Sum in case of multiples)
sInvNo
Supplier Invoice Number
sRGNo
Supplier's RG23D No.
r99("SupCvtAmt")
Supplier's Additional Duty Amount
mSupPerExcise
Supplier's Excise Per Unit (Manaual Detail only)
mSupPerEcess
Supplier's Edu Cess Per Unit (Manaual Detail only)
mSupPerSheEcess
Supplier's S & H Edu Cess Per Unit (Manaual Detail only)
Supplier name, address, range, divison etc. field names is similar to the party name but instead of recordset1(r1) supplier details are stored in recordset4(r4)


DB FIELDS FOR CVT
DB FIELD
Description
CvtRate
Rate of CVT
CvtAmtPassed
CVT Amount Passed
CvtAssessableAmt
CVT Assessable Amount
CvtAmt
CVT Amount of Manufacturer
SupCvtAmt
CVT Amount of Supplier
All the CVT Fields are present in r99 recordset.

Sometimes it is required to print the total of ExciseDuty + EduCess + S&HEducess in words.

First we have to get the total of the three things. The syntax should be:
  
c1.ToCur(rv("eExciseAmtN")) + c1.ToCur(rv("eEduCessAmtN")) + c1.ToCur(rv("eSecEduCessAmtN"))
 

The above code prints the sum of ExciseAmount, Edu. cess and SecEduCess.

To print the total in words add following syntax:
  
c1.catwords(c1.ToCur(rv("eExciseAmtN")) + c1.ToCur(rv("eEduCessAmtN")) + c1.ToCur(rv("eSecEduCessAmtN")))