Analysis Code Maintenance

Use this form to set up and maintain analysis codes, and define related defaults. You must assign an analysis code to an inventory item, and codes integrate with:

Reporting
Reordering
Pricing
Applying shipment costs (if import costing function is being used)
Posting transactions to the general ledger.

Once analysis codes have been set up, you can also use the Analysis Code Tree Maintenance form to group analysis codes together for analysis and reporting. User-defined fields can also be assigned at an analysis code level.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Code

Enter or select a unique analysis code, up to 15 alphanumeric characters.

Description

Enter or select a description, up to 30 alphanumeric characters to identify the analysis code.

Active

If a code is inactive, you can't assign it to items on the Inventory Item Maintenance form. You can't make an analysis code inactive if it is assigned as the default on the Inventory Module Control form, or if it is assigned to any active item.

Default markup%

Enter a markup percentage, margin percentage, or margin value, depending on the Markup Indicator that has been selected on the Main tab of the Module Control form.

This field is not enabled if you are not using markups or margins to price items. If you enter a value here, it is the default for new items that are set up with this analysis code.

Re-order calc method

This field enabled if you are using the Advanced Reordering module. Select a reorder calculation method, to default to all new items that are set up and have this analysis code assigned. The reorder calculation method can be overridden at item level.

If you select Default, Greentree Desktop uses the method assigned on the Defaults tab of the Module Control form, if one has not been assigned specifically to the item.

Overhead %

This field is available and applicable if you are using the Import Costing module. You can enter a percentage that Greentree Desktop uses to calculate an overhead cost (for example, administrative costs) for each item included in a shipment, that has this analysis code.

Total overhead costs are added to the shipment landed cost, and individual item costs (last and average) are updated, inclusive of the overhead, when the shipment line is received.

Import Duty Code

This field is enabled if you are using the Import Costing module. You must assign a duty code here. You can select NONE if duty does not apply. The duty code is used with a supplier's duty group to calculate the duty for a shipment line.

You can assign duty codes to individual items on the Item Maintenance form, but if groups of items with the same analysis code are subject to the same duty rules, the code can be set here.

General Ledger Integration - Sales

Select the default general ledger sales account to use for all inventory items that have this analysis code. You can override a sales account at item level. If an account is not specified at an item level, Greentree Desktop sees the account specified at the analysis code level.

If you don't specify an account, Greentree Desktop posts sales values to the general ledger suspense account. You can construct the inventory sales account using wildcards.

Cost of sales

Select the default general ledger cost of sales account to use for all inventory items that have this analysis code. You can change the cost of the sales account at item level. If an account is not specified at an item level, Greentree Desktop sees the account specified at the analysis code level.

If there is no account specified, Greentree Desktop posts cost of sales values to the general ledger suspense account. You can construct the sales account using wildcards.

Inventory

Select the default general ledger inventory account to use for all inventory items that have this analysis code. You can change the inventory account at item level. If an account is not specified at an item level, Greentree Desktop sees the account specified at the analysis code level.

If there is no account specified, Greentree Desktop posts inventory values to the inventory account specified on the Integration tab of the General Ledger Module Control form. If no account is specified there, Greentree Desktop posts values to the general ledger suspense account. You can construct the inventory account using wildcards.

In transit

Select the default general ledger in-transit account to use for all inventory items that have this analysis code. If no account is specified there, Greentree Desktop posts in-transit values (if applicable) to the general ledger suspense account.

Kitset variance

This is enabled if the Inventory Kitset module is in use.

Select the default general ledger kitset variance account to use for all inventory items that have this analysis code. You can change the inventory account at item level when a kitset is defined. If an account is not specified at an item level, Greentree Desktop sees the account specified at the analysis code level.

If there is no account specified, Greentree Desktop posts kitset variance values to the inventory account specified in on the Integration tab on the General Ledger Module Control form. If no account is specified there, Greentree Desktop posts values to the general ledger suspense account.

Analysis code fields

This table displays any user fields that have set up specifically for the analysis code using the Analysis Code User Field Maintenance form. You can change the values of the fields.

Location profiles

This section enabled if the Warehouse Bin Management module is in use.

The location list is pre-populated with any stocking locations that have Use multi-binning selected.