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 (where 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 function 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 of up to 15 alphanumeric characters.

Description

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

Active

If a code is inactive, you can't assign it to items in Inventory Item Maintenance. You can't make an analysis code inactive if it is assigned as the default in IN Module Control, 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 in Module Control - Main. 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 uses the method assigned in Module Control - Defaults, 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 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 using Item Maintenance, but where 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 be used for all inventory items that have this analysis code. The sales account can be overridden at item level. If an account is not specified at an item level, Greentree will see the account specified at the analysis code level.

If you don't specify an account, Greentree 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 sees the account specified at the analysis code level.

If there is no account specified, Greentree 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 be used 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 sees the account specified at the analysis code level.

If there is no account specified, Greentree posts inventory values to the inventory account specified in GL Module Control - Integration. If no account is specified there, Greentree 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 be used for all inventory items that have this analysis code. If no account is specified there, Greentree 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 be used 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 sees the account specified at the analysis code level.

If there is no account specified, Greentree posts kitset variance values to the inventory account specified in General Ledger Module Control - Integration. If no account is specified there, Greentree 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 IN Analysis Code User Field Maintenance. 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.