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.