Use analysis codes with SOP

About analysis codes

Analysis codes are custom fields that you can associate with SOP (sales orders, returns, quotes and pro formas). You can use them to filter or group your documents on reports and workspaces.

For example, you could use analysis codes to specify which sales person has sold the goods, or to specify which branch or region placed the sales.

You use the same analysis codes for both Invoicing and SOP. You can have up to 20 different codes.

Each analysis code has two parts: a Code for the type of information and a set of Values that can choose for each invoice. For example, a Sales person analysis code could have a set of values; John, Tim and Ben. You choose a Value for each relevant analysis code. If an analysis code is not to be used on an invoice, leave the value blank.

Analysis codes can be added to:

  • A whole order (header), on the Delivery / Invoicing tab.

  • Individual lines, by selecting the Analysis Codes button on the line.

Things to consider

Note: Analysis codes can be set up in either Invoicing or SOP and are used for both.

  1. Do you want to allow users to change values when entering orders?

    If so, select Allow amendment of - Analysis codes in the Invoice and Order Entry tab of SOP Settings. This is not selected by default. You can choose to do this for the header and/or individual lines.

    You may not want to allow this if the same analysis code value must always be used. For example, if you're just using analysis codes to identify the region a customer is from, you may not want users to change this.

  2. Do you want users to be able to add a one-off value for an analysis code when they're entering sales orders?

    If so, then choose Enter Free Text when setting up the analysis code.

    These are not saved and can't be reused. This is useful if you're going to use analysis codes to record information that'll be unique to each record. This saves you having to create a long list of values.

    Don't choose this if you have specific list of values that you want to report on. Allowing free text may result in similar values being used, which may be difficult to report on.

  3. Do you want users to be able to create a new value for an analysis code when entering orders? If so, then choose Add New on Entry when setting up the analysis code.

    These values are saved and can be reused.

    Whether you allow this or not depends on how you're going to use the analysis codes. You can make it easier for people by letting them have the flexibility to create new values when required. However, allowing this also means that there's more chance of codes being duplicated, and you have less control over how data is reported. You may end up with several values for the same thing that are spelt slightly differently, for example.

  4. Do you only want users to change the values for specific analysis codes only?

    This is useful if you have some analysis codes that must always use the default value and others which can be changed.

    If so:

    1. Choose to Allow amendment of - Analysis codes in the Invoice and Order Entry tab of SOP Settings.
    2. Edit the analysis code on the Maintain Analysis Codes screen, and choose Allow analysis codes to be amended for each order/return.
  5. Do you want to use the analysis code values set on your customer's account rather than the values set for sales orders?

    This is useful if you've already set an analysis code on a customer account that you want to use for all sales relating to that customer.

    To do this:

    1. Set the analysis codes on the customer account.
    2. Choose the same analysis code on the Maintain analysis codes screen (Sales Order Processing > SOP Maintenance).
    3. Edit the analysis code, and choose to Get default from customer account.
  6. Do you want to use the values set for SOP analysis codes for your stock history, rather than the analysis codes set in Stock Control?

    If so, edit the analysis code using SOP Maintenance > Maintain analysis codes, and choose Use as stock item history value for.

  7. Do you want always want a specific analysis code value to be applied to all orders? You won't be able to save the order until a value is entered.,

    If so, choose to make the analysis code Mandatory on the Maintain analysis codes screen. To do this the analysis code must also have a default value set in Accounting System Manager.

  8. Don't want to set values on some orders?

    Don't set the code to be Mandatory and leave the value blank when entering orders.


Set up analysis codes

Create analysis codes

Create your analysis codes and values in Accounting System Manager.

Open: Accounting System Manager > Settings > Maintain Analysis Codes.

Here you choose whether to allow free text, allow user to add new values when entering orders and set the default value.

Allow users to change analysis codes when entering invoices or orders

Open: Sales Order Processing > Utilities > System Set UP > SOP Settings | Order Entry

Here you choose whether analysis code values can be changed on orders. You can set this for the whole order (header) and for individual lines.

Choose which analysis codes to use with sales orders:

Open: Sales Order Processing > SOP Maintenance > Maintain Analysis Codes.

  • Choose whether the value can be changed when the orders are created. This is useful if you have some analysis codes that must always be set and others which can be changed.

    To do this:

    1. Select the analysis code and click Edit.
    2. Edit the analysis code and select Allow analysis codes to be amended for each order/return.

    Note: You must also set Allow amendment of analysis codes in the settings. See Invoice and order entry (SOP settings / Invoice and order settings).

  • Choose whether to use the values set on the customer account for an analysis code.

    This is useful when you're applying the same analysis code to customer accounts and orders. Once set up the value specified on the customer account is applied to orders.

    1. Select the analysis code and click Edit.
    2. Select Get default from customer account.
    3. Use the drop-down list to select the analysis code.
  • Choose whether to use an analysis code set for related stock transactions rather than code set in Stock Control.
    1. Select the analysis code and click Edit.
    2. Select Use as stock item history value for.
    3. Select the stock analysis code to apply the values to.

Apply codes to orders

Analysis codes can be applied to the whole order, or to individual lines. For example, you could use analysis codes to group your documents by sales staff for calculating commission, and your item lines by the type of item sold.

  • Choose the value for analysis codes to apply to whole order on the Delivery and Invoicing tab.

  • To choose the analysis codes for individual lines, you'll need to Edit the line.

Reporting on your analysis codes

So you've set your analysis codes and added them to your orders. Next you'll need to use them for reporting. You can use analysis codes to filter information in reports, lists and enquiries.

Reports

You can use the analysis codes as criteria to filter your reports. Analysis codes are included on the criteria of the following reports by default.

Sales order allocations required
Sales order allocations not despatched
Sales order despatches not invoiced
Sales return receipts pending
Sales receipts returns not credited
Sales orders - summary and detailed
Sales orders book report - summary and detailed
Stock item allocations required

You can also use Report Designer to add analysis codes as criteria to other reports.

List and enquiries

Analysis codes can be added as additional columns to the Sales Order List, and any enquiry workspaces .

Add analysis codes to lists
  1. Right-click on any column heading.
  2. Choose Columns > Info and select the analysis code required.
Add analysis codes to enquiry workspaces
  1. Right-click on any column heading.
  2. Choose Add column to or Column Selector.
  3. Choose the required analysis code(s).

Troubleshooting

Setting up

Applying to analysis codes to Invoicing and SOP documents