Setup & Administration

The Setup categories described in this section relate specifically to the CAI Software Precious Metals Solution and for the most part do not change once the system is in production.

The Refining Setup page records settings that control various features of the application. This page has three FastTabs:  General, Numbering, and Charges. On each FastTab, specific settings regarding each of those categories can be maintained. The following is a brief description of each setting.


The General FastTab contains such settings as those used to set defaults throughout the application and those used to define external file paths. While most are self-explanatory, a description is provided for all

Default Lot Path Item No.

  • The Path Item to use as the default when a Lot is created.

Default Lot Inventory Type

  • The Inventory Type to use as the default when a Lot is created.

Default Lot Receiving UOM

  • The Unit of Measure to use as the default when a Lot is created.

Default Lot Metal On Account

  • When checked, Settlement of the Lot will be On Account by default.

Default Rcpt. Prod. Location

Default Prod. Issue Locatio

Default Sample Inventory Type

  •  The Inventory Type to default to for Samples when a Production Order is created.

Default Item for Prod. Jrnl.

Prod Order for each Lot Detail

  • When checked, a Production Order will be created for each line in Lot Detail.

Auto Recalculate Assay By %

Default Assay Adj. Reason Code

Default Settlement Metal On Account

  •  When checked, new Settlements will have On Account on by default.

Default Metal Charge Inv. Acct.

Accrued Inventory Acct.

  • General Ledger liability account to use for placing processed Lots which have not yet been Settled.

Calendar Code

Image Directory

  • Directory Path which contains images to associate with Finished Goods Items.

PicXFer Directory

Kitco Market Quote


Many entities within Business Central and the CAI Software Precious Metals Solution are identified by unique identifying numbers (e.g., Document No.). This FastTab provides the means to assign a specific numbering series to each of the various objects used within the Refining application.  Decisions regarding these assignments are unique to each site, and to each Company within a site. These include, but are not limited to:

  • Production Inventory Lines
  • WCT Nos.
  • Blend Nos.
  • Production Order Nos.
  • Lot Nos.
  • Settlement Nos.
  • LIT Nos.
  • Auto Assign Contract No.


The Charges FastTab provides the means to associate specific General Ledger accounts to use to post the various charges as they are incurred through normal transaction processing.  Those charges are as follows:

  • Revenue Account Treatment
  • Revenue Account House
  • Revenue Account Freight Ocean
  • Revenue Account Assay
  • Revenue Account Freight Inland
  • Revenue Account Minimum Lot
  • Revenue Account Lot Charge
  • Revenue Account Metal Transfer
  • Revenue Account Mrkt Discount
  • Revenue Account Representation
  • Revenue Account Penalties
  • Revenue Account Conversion Fee
  • Revenue Account Refining
  • Revenue Account Incineration
  • Revenue Account Sampling
  • Revenue Account Shredding
  • Revenue Account Interest
  • Revenue Account Advance

The Miscellaneous Codes page provides access to code categories used within the Refining application.  At minimum there are three categories of codes that are required, but additional categories can be defined and maintained as system modifications are made to suit current processing requirements.  The three base categories are:

Material Type (MATTYPE)

Material Type codes are used to categorize material as it is brought in to Lots.  Examples might include an array of categories such as  Silver or Gold Scrap, Watch Batteries, or Sweeps.

Inventory Type (INVTYPE)

Inventory Type codes are used to categorize material after it has been processed and is ready to be added to Refining Inventory.  These codes could include such categories as Karat Gold or Low Grade Silver.

Segment (SEGMENT)

Segment codes are used to identify the industry or market segment from which the material was derived.  Examples of Segments codes could include Jewelry, Dental, Automotive or Coin Dealers.

The Metal Type table is one of the first tables to be specified during Refining setup and is likely one of the tables that is least likely to change over time.  In fact, once an entry is made for a Metal Type it cannot be changed – the table can only be added to with new metal types if necessary and even then those changes cannot be done from the Metal Type list page, only at the table level by authorized Software Support.

The Metal Types tell the system which metals are of most interest to the system with regard to being Assayed for and for being Payable.  The order that the Metal Types are entered is also significant as is the Sequence that is assigned to each code as that determines the order that information appears on various Refining Documents and screens.

Report Selection is used to define which Report or Report(s) are to be run for each document type that appears in the Usage list. For example, the Report to print when a Final Settlement is posted is by default Report ID 37031302, Settlement. If a custom-formatted or Company-specific Settlement Document is developed it can be identified here as the Report to use when a Final Settlement is printed

The Work Center pages allow you to define information about the staging areas where work is to be processed.  You give each Work Center a name and a Code representing the Work Center.  Once defined, each Work Center is actually set up as an Item, flagged as having a Production BOM on the Item Card Refining FastTab, and set up with Production BOM lines which specify any additional steps that are to be associated with this Work Center.  This configuration of a Work Center is then known as a Path Item.

When setting up a new Lot, you select one of these Work Centers as the ‘Path Item’ which will then be used by the Production Order that is created from the Lot.

You can set up multiple units of measure for a Refining Item so that you can use different units of measure for the same Item in different contexts:

  • Assign a base unit of measure on the Item’s Item card to define how it is stored in inventory and to serve as the conversion basis for alternate units of measure.
  • Assign alternate units of measure to purchase, production, or sales documents to specify how many units of the base unit of measure you handle at a time in those processes.

To set up a Unit of Measure, select New on the Home tab Ribbon Bar.  Enter the Unit of Measure Code and a Description of the measure.  Finally enter the Factor value which is the value in relation to the Unit of Measure with a Factor of 1.