Visual Catpro
  

Jewelers Invoice  (Gold/Diamond System)

Three new columns are provided namely
1.       GOLD_PURITY
2.       GOLD_QUANTITY
3.       GOLD_RATE

In GOLD_PURITY column you should enter purity factor. e.g. 22 for 22ct gold.  You must open a relevant gold account having alias name as 'G.22'. Similarly you may open separate gold accounts for different purity e.g. G.18, G.14 etc. For Diamond Account alias should be 'G.Diamond'. These account must exist to post diamond & gold quantity.

For posting Sale amount in Gold Sale account in financial accounts a new DocProperty GOLD_SALE_CODE is available. Amount of gold as calculated with gold rate shall be posted in this gold Sale account. Balance amount shall be posted in normal sale account attach with this document type.

Treatment of Polish
Some polish is generally charged by jewelers while selling ornaments. e.g. A Jeweler may charge 4 gms. polish while selling 100 gms of ornaments. In this case he will charge the customer the price of 104 gms. But stock of gold will be reduced only by 100gms. To handle this situation two Columns namely GOLD_POLISH and GOLD_POLISH_PER are available. When we fill GOLD_POLISH_PER column polish will be calculated as a percentage of gold weight and auto filled in GOLD_POLISH column. However if you do not fill anything in GOLD_POLISH_PER column, you may enter gold polish in gms. If GOLD_POLISH column exist then amount will be calculated by applying rate on QUANTITY+GOLD_POLISH. Full amount shall be credited to Gold sale account.  Gold polish does not effect stock of gold.

Treatment of Labour
Labour is generally charged by jewelers on weight of gold + GOLD_POLISH. We need to use TOTAL_WT column which shall also include gold polish if this column is open. We may now charge polish per gm. To do so follow the following steps:

Set the following properties of LABOUR total field:
1.       Write "Per Gm. (Rs)" in "TOTPERCENTTEXT"  property.
2.       Specify "TOTAL_WT" against "TOTAPPLYONCOLUMN" property of           "LABOUR" field
3.       Specify "LabourRate" against "TotPercentField" property.

This will make a string like Labour@Rs. 25 Per Gm.