FAQs about updating Sigma Reorder Numbers

Applying AppCAT Changes

Either the AppCAT download has not completed or your supplier is not matched to a valid AppCAT Supplier.

  1. Select Assistants > AppCAT.

  2. If the date is not current, click Download Now.

Your Sigma Supplier may not be linked to an active AppCAT Supplier, you will need to review the Supplier link by:

  1. In Fred Office Plus, select Contacts > Suppliers > Search.

  2. Search for your Sigma Supplier and double click to open.

  3. In the AppCAT tab:

    1. Review AppCAT Match Details.

    2. Make sure that your relevant state is selected.

  4. If Unmatched, then click Automatic.

  5. If Automatic matching fails:

    1. Click OK.

    2. Select Manual.

    3. Search for Sigma in Search Criteria.

    4. Select the correct supplier in the list, and click Match.

  6. Click Save and Close to finalise supplier review.

  7. Select Assistance > AppCAT, and then click Download Now.

AppCAT Database Differences are downloaded automatically every night.

Yes, you can manually request an AppCAT download. In Fred Office Plus, select Assistants > AppCAT > Download Now.

Wait at least 15mins and then click Download Now again.

If issues persist, please refer to the Fred Service Performance Status Page .

The performance of Fred Office Plus may be affected temporarily while the changes are processed.

It is recommended to update smaller batches at a time or perform changes or outside of normal business hours to prevent delays.

If performance issues persist please contact the Fred Help Support Desk on 1300 731 888 or email helpdesk@fred.com.au.

When AppCAT Differences are applied, Fred Office Plus performs a check to ensure duplicate information is not produced. If Fred Office Plus detects that the information to be applied would cause a duplicate, the difference will not be applied, and you will receive this prompt.

Navigate to Management > Events. From here you can double-click to open the event to view further information.

See Manage AppCAT Differences or AppCAT Differences Duplicate check for more details.

Ordering

No, as you are updating the reorder number for your Sigma Supplier, there should be no changes required to your template.

However, you can review your saved template/s details by:

  1. Select Ordering > Drafts > New.

  2. Select Use Wizard to Add Items, then click OK.

  3. Select Load Saved Template, then use the drop down to select the template to edit.

  4. Select Allow me to edit this template, then click Next.

  5. Navigate through each step of the wizard selecting the options required, with attention to the Supplier Details section.

  6. Click Finish to save your changes.

See Managing ordering templates for more details.

No. We do not recommend sending an order with mixed reorder number lengths.

Before sending your order fix any items with the old SIX digit reorder numbers.

See What if some Sigma Reorder Numbers are still Six digits in Fred Office Plus?

For items that require urgent ordering, either order via the Sigma Portal or call Sigma to place an order.

Sigma Reorder Number details may be missing on this item, check that this item is linked to AppCAT and available from Sigma.

  1. Open the Item Card, ensure Sigma is listed under Inventory & Ordering > Supplier.

  2. Check Links > Appcat and ensure item is matched.

Sigma have standardised their items to be each for pricing and ordering. Therefore, you will no longer see pack sizes. You can use the Minimum Order Quantities if required to set an order quantity.

See Multiple and Minimum Order Quantities for more details.

A Temporary Item is an item which is returned on an electronic invoice which is unknown in your database, either because the Reorder Number has change or it is a new item in Fred Office Plus.

Right click the item to Match, Create or Delete as required.

See Temporary items for more details.

Supplier Setup

If you are an Amcal, Discount Drug or Guardian Sigma Store you may have more than one Sigma Supplier setup in Fred Office Plus. You should update all your Sigma Suppliers.

Confirm they are linked to an AppCAT supplier and apply the Item Reorder Number and Item Packsize changes.

No, you have not added a new supplier, therefore the primary supplier will remain unchanged in Fred Office Plus.

Follow the steps outlined in How to update your Sigma reorder numbers before sending your order to Sigma.

Item Management

Make sure that items are linked to AppCAT. If unmatched, match to AppCAT.

If the item is Matched, make sure the item is still supplied by Sigma and/or manually update the Reorder Number.

Open the Item Card, then select Links > Appcat, and click either Automatic or Manual.

Use manual matching, searching by description, Reorder Number or Barcode.

See Match item to AppCAT for details.

Yes, from the Item card go to Inventory & Ordering > Supplier, highlight your Sigma Supplier and press Edit.

Update, the Reorder number, Pack Sizes, Min Order and/or Cost price as required.

See Update pack quantity or Multiple and Minimum Order Quantities for details.

Yes, select Tools menu > Item > Bulk AppCAT Matching to access the Bulk AppCAT Matching Wizard.

See Bulk AppCAT Matching Wizard for more details.

You will need to identify if the items is inactive, duplicated or matched to AppCAT incorrectly.

See How to find the item card an AppCAT item is Linked to for details.

Yes, from the item card select Tools, then Merge.

Follow the wizard prompts to merge two products together.

Once a merge is confirmed and completed it cannot be undone.

See Merge products for more details.

You do not need to update your Item Lookup Codes.

This is optional and can be completed if required.

If you do update your Item Lookup Codes, you may need to reprint your shelf ticket / labels as details of the items have now updated.

See Print a label queue for more details.

Sigma have removed their pricing Tiers 2 and 3 from their National file.

If you were using Tiers 2 or 3 for your pricing plan , you will need to change your Pricing Plan to use Tier 1.

Please contact Fred Help Support Desk on 1300 731 888 or email helpdesk@fred.com.au If you need assistance updating your pricing plan.

See Pricing plan for more details.

Sigma have changed their packsizes to each for pricing and ordering, therefore it is recommended to update the details to ensure quantities and prices are correct when ordering and/or receiving invoices.

See Update pack quantity.

It is not recommended to use pack quantities different to that which is recommended by Sigma. If you choose to use a custom pack number, you may experience quantity or pricing errors when receiving invoices.

Labels

If you print the Primary Supplier Reorder Number on the shelf ticket / labels then, yes, you may want to re-print labels as this information has now updated. You may also want to re-print if you have changed your Item Lookup Code for your products.

If you have do not print the Primary Supplier Reorder Number or have not changed your Item Lookup Codes, you do not need to re-print.

You can confirm what prints on your labels by reviewing the labels setup from Tools > Item > Labels.

Highlight your label template(s), press Edit and review the Label Elements Line by Line to see what information is printed on your label(s).

The Item Lookup Code of the items has changed, and a new ticket / label has not been printed.

Add the item to a Label Queue to generate a ticket / label and print.

See Print a label queue for more details.