Difference between revisions of "Shadow supplier default settings - group"

From Catalyst
Jump to: navigation, search
m
Line 1: Line 1:
 +
{{Review}}
 
== Summary ==
 
== Summary ==
−
This article explains how to set a shadow suppliers default group.
+
A large proportion of suppliers will include a discount group code for their products. This article explains how to apply default settings to a discount group.  
  
 
== More Information ==
 
== More Information ==
−
Shadow supplier groups are used to provide stock items with extra information associated with the group to which they belong.
+
When an item is copied across to the main Stock File the default settings, applicable to the discount group on the item, will be applied as the part is added to the main stock file e.g. Suppliers, Stock Group, Sales Centre and V.A.T. rate.
−
For instance, stock item {{DataValue|A}} has a shadow supplier of  {{DataValue|X}} and a group of {{DataValue|01}}. Group {{DataValue|01}} for  shadow supplier {{DataValue|X}} is set up with an alternative supplier of Company {{DataValue|K}}. From this, stock item {{DataValue|A}} will have a main supplier of {{DataValue|X}}, an alternative supplier of company {{DataValue|K}} and a group of {{DataValue|01}} when the item is copied to the main stock file. This can be useful for items that you can get from more than one source.
 
  
−
To set up the shadow supplier group default settings, go to {{Menu|{{ST}}|Maintenance Options|Shadow File Maintenance|Shadow Group Information}}
+
=== Shadow Supplier Defaults ===
−
*Press the {{Button|Add}} button.
+
Initially please make sure each of your Shadow Suppliers are correctly set up:
−
*Use the search keys to find the {{DataValue|<Supplier>}} or type in the code.
+
 
−
*Move to the next field {{DataPrompt|Group:}} and press {{KeyPress|F1}} until you find the group you want and then press {{KeyPress|Enter}}.
+
Go to {Menu|{{ST}}|Maintenance Options|Shadow File Maintenance|Shadow Suppliers}}
−
*Fill in the default group information, press the {{Button|Done}} button and accept the changes.
+
* Click {{Button|List}}
 +
* All your suppliers should be listed. If any are missing click {{Button|Add}}.
 +
** Enter the 2 character code for the supplier e.g. {{DataValue|YA}}.
 +
** Enter the Supplier name in the {{DataPrompt|Description}} field e.g. {{DataValue|Yamaha}}.
 +
** Click on the {{Tab|Settings}} tab and fill in the defaults for this supplier.
 +
*** If there is one default supplier you may enter their code. Use {{KeyPress|C-F1}} to search through your supplier codes.
 +
*** Specify the priority to give to this supplier code when ordering.
 +
*** Specify where the supplier stores their {{DataPrompt|Discount}} group on Shadow items i.e. it is usually on the Stock Group field but may be stored on Notes Line 1 or 2.
 +
 
 +
* Click {{Button|Done}} and {{Button|Accept}}. 
 +
 
 +
=== Shadow Group Defaults ===
 +
Go to {{Menu|{{ST}}|Maintenance Options|Shadow File Maintenance|Shadow Group Information}}.
 +
 
 +
* Click {{Button|List}}.
 +
* If the Supplier and Group to amend is in the list, highlight it and click {{Button|Edit}} else click {{Button|Add}}.
 +
** Enter the {{DataPrompt|Supplier}} 2 character code.
 +
** Enter the {{DataPrompt|Group}} Code (this will be a maximum of 3 characters).
 +
 
 +
==== Details ====
 +
* Enter the Discount percentage to apply to items within this Discount Group. This will set the Cost price based on the Supplier's Selling Price.
 +
 
 +
{{Information|icon=1|If [[How do I Set up a Shadow File Price Escalation?|Price Escalation]] has been set up to calculate cost prices, that will take precedent over a percentage specified here.}}
 +
 
 +
* If this item can be purchased from additional suppliers you may enter up to 5 difference Shadow Supplier Codes here.
 +
 
 +
==== Groups/Analysis ====
 +
* Enter the Stock Group to apply to items within this Discount Group. This should be the Stock Group you wish to use when an item is copied to the main Stock File.
 +
** Use {{KeyPress|Ctrl-F1}} to search through your existing Stock Groups.
 +
* If you wish to apply analysis codes to items e.g. if you use [[Manufacturer Composite Information|Composite Reporting]], you may enter the default codes here.
 +
** Use {{KeyPress|Ctrl-F1}} to search through your existing Analysis Codes.
 +
 
 +
==== Invoicing ====
 +
* The {{DataPrompt|V.A.T. rate}} should be set to {{DataValue|No Default}} unless items in this Discount Group should always be classed as Zero rated or Exempt e.g. Helmets, Manuals, Children's Clothing etc. If you are unsure please consult HMRC for further advice regarding VAT.
 +
* The Sales Centre 
 +
Move to the next field {{DataPrompt|Group:}} and press {{KeyPress|F1}} until you find the group you want and then press {{KeyPress|Enter}}.
 +
* The {{DataPrompt|Sales Centre}} is used to allocate the value of sales in the accounts system. If unsure what code to enter here please contact your accounts department for advice. This may be left blank and the default for the main Stock File or main Stock group will be applied.
 +
 
 +
==== Attributes ====
 +
* If you wish to apply Attributes to items e.g. if you use [[Manufacturer Composite Information|Composite Reporting]], you may enter the default attributes here. Simply double click an item in the {{DataPrompt|Unallocated}} column to allocate it.
 +
 
 +
Once you are happy you have filled in as many defaults as you wish, press the {{Button|Done}} button and accept the changes.  
  
 
=== Default Supplier Settings ===
 
=== Default Supplier Settings ===
−
To apply settings to all items for a particular supplier you can use the special group {{DataValue|###}}. The way this works is that first any settings for group {{DataValue|###}} will be applied, then any settings for the item's specific group. So you could apply a global discount for a particular supplier, but a specific group discount could override this.
+
If you prefer to apply default settings to all Discount Group codes for a specific supplier follow these steps:
 +
* Click {{Button|List}}.
 +
* If the Supplier and Group to amend is in the list, highlight it and click {{Button|Edit}} else click {{Button|Add}}.
 +
** Enter the {{DataPrompt|Supplier}} 2 character code.
 +
* At the point of entering a Group Code enter {{DataValue|###}}.  
 +
 
 +
The way this works is that first any settings for group {{DataValue|###}} will be applied, then any settings for the item's specific group. So you could apply a global discount for a particular supplier, but a specific group discount could override this.
  
−
=== Shadow Group Properties ===
+
=== Updating Items in the Main Stock File ===
−
You can set any of the below items when copying a [[What is a Shadow Stock code?|shadow stock code]].
+
The option to {{Menu|{{ST}}|Maintenance Options|Shadow File Maintenance|Re-Sync Stock & Shadow}} will allow you to update items already copied to the main stock file. This will impose any new group defaults onto existing Stock Codes.
−
* Discount
+
* Press {{KeyPress|F1}} to scroll through your Shadow Suppliers.
−
* Alternative Suppliers
+
* Click OK to proceed with the re-sync. This may take a few minutes.
−
* Stock Group
 
−
* Stock Analysis Codes
 
−
* V.A.T. rate
 
−
* Sales Centre
 
−
* Attributes
 
  
−
=== Re-Sync ===
+
{{Note|text=This is not reversible so please use with caution.}}
−
Use the {{Menu|{{ST}}|Maintenance Options|Shadow File Maintenance|Re-Sync Stock & Shadow}} to impose any new group defaults onto existing Stock Codes.
 
  
 
== See also ==  
 
== See also ==  
Line 33: Line 74:
 
* [[Creating a Stock Item]]
 
* [[Creating a Stock Item]]
 
* [[How do I Set up a Shadow File Price Escalation?]]
 
* [[How do I Set up a Shadow File Price Escalation?]]
 +
* [[Manufacturer Composite Information]]
  
−
{{KB_Tags|shadow, supplier, group, default}}
+
{{KB_Tags|shadow, supplier, group, default, discount codes, discount groups, shadow suppliers, shadow groups, resync, re-sync, group defaults}}
 
{{KB_ST}}{{ZN_Admin}}
 
{{KB_ST}}{{ZN_Admin}}

Revision as of 12:55, 30 June 2017

 This article or section is under review.
Be aware: Content may change as the document is reviewed.

Summary

A large proportion of suppliers will include a discount group code for their products. This article explains how to apply default settings to a discount group.

More Information

When an item is copied across to the main Stock File the default settings, applicable to the discount group on the item, will be applied as the part is added to the main stock file e.g. Suppliers, Stock Group, Sales Centre and V.A.T. rate.

Shadow Supplier Defaults

Initially please make sure each of your Shadow Suppliers are correctly set up:

Go to {Menu|Stock Control|Maintenance Options|Shadow File Maintenance|Shadow Suppliers}}

  • Click [List]
  • All your suppliers should be listed. If any are missing click [Add].
    • Enter the 2 character code for the supplier e.g. 'YA'.
    • Enter the Supplier name in the "Description" field e.g. 'Yamaha'.
    • Click on the [Settings] tab and fill in the defaults for this supplier.
      • If there is one default supplier you may enter their code. Use <Ctrl+F1> to search through your supplier codes.
      • Specify the priority to give to this supplier code when ordering.
      • Specify where the supplier stores their "Discount" group on Shadow items i.e. it is usually on the Stock Group field but may be stored on Notes Line 1 or 2.
  • Click [Done] and [Accept].

Shadow Group Defaults

Go to " Stock Control Maintenance Options Shadow File Maintenance Shadow Group Information".

  • Click [List].
  • If the Supplier and Group to amend is in the list, highlight it and click [Edit] else click [Add].
    • Enter the "Supplier" 2 character code.
    • Enter the "Group" Code (this will be a maximum of 3 characters).

Details

  • Enter the Discount percentage to apply to items within this Discount Group. This will set the Cost price based on the Supplier's Selling Price.
If Price Escalation has been set up to calculate cost prices, that will take precedent over a percentage specified here.
  • If this item can be purchased from additional suppliers you may enter up to 5 difference Shadow Supplier Codes here.

Groups/Analysis

  • Enter the Stock Group to apply to items within this Discount Group. This should be the Stock Group you wish to use when an item is copied to the main Stock File.
    • Use <Ctrl-F1> to search through your existing Stock Groups.
  • If you wish to apply analysis codes to items e.g. if you use Composite Reporting, you may enter the default codes here.
    • Use <Ctrl-F1> to search through your existing Analysis Codes.

Invoicing

  • The "V.A.T. rate" should be set to 'No Default' unless items in this Discount Group should always be classed as Zero rated or Exempt e.g. Helmets, Manuals, Children's Clothing etc. If you are unsure please consult HMRC for further advice regarding VAT.
  • The Sales Centre

Move to the next field "Group:" and press <F1> until you find the group you want and then press <Enter>.

  • The "Sales Centre" is used to allocate the value of sales in the accounts system. If unsure what code to enter here please contact your accounts department for advice. This may be left blank and the default for the main Stock File or main Stock group will be applied.

Attributes

  • If you wish to apply Attributes to items e.g. if you use Composite Reporting, you may enter the default attributes here. Simply double click an item in the "Unallocated" column to allocate it.

Once you are happy you have filled in as many defaults as you wish, press the [Done] button and accept the changes.

Default Supplier Settings

If you prefer to apply default settings to all Discount Group codes for a specific supplier follow these steps:

  • Click [List].
  • If the Supplier and Group to amend is in the list, highlight it and click [Edit] else click [Add].
    • Enter the "Supplier" 2 character code.
  • At the point of entering a Group Code enter '###'.

The way this works is that first any settings for group '###' will be applied, then any settings for the item's specific group. So you could apply a global discount for a particular supplier, but a specific group discount could override this.

Updating Items in the Main Stock File

The option to " Stock Control Maintenance Options Shadow File Maintenance Re-Sync Stock & Shadow" will allow you to update items already copied to the main stock file. This will impose any new group defaults onto existing Stock Codes.

  • Press <F1> to scroll through your Shadow Suppliers.
  • Click OK to proceed with the re-sync. This may take a few minutes.
This is not reversible so please use with caution.

See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
shadow, supplier, group, default, discount codes, discount groups, shadow suppliers, shadow groups, resync, re-sync, group defaults
Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=Shadow_supplier_default_settings_-_group&oldid=27531"