This option determines whether newly created stock items are enabled as “Default Publish on Web” (toggle enabled) or not (toggle disabled). The default publish to web option on stock items themselves will create stock items on websites via the 3rd Party API, BigCommerce, Reverb and Shopify channel integrations.
- If enabled, the system will not allow more than one stock item to be saved with the same Stock Code.
- If disabled, the system will allow multiple stock items to be created with the same Stock Code.
- If enabled, the system will not allow more than one stock item to be saved with the same Other Ref.
- If disabled, the system will allow multiple stock items to be created with the same Other Ref.
This function determines how stock descriptions are displayed within the system, and on subsequent printed documents such as purchase and sales orders.
- Default – Legacy setting, do not use.
- Upper Case – Will force stock descriptions to upper case when saved, irrespective of how they are entered.
- Lower Case - Will force stock descriptions to lower case when saved, irrespective of how they are entered.
- Normal - Will force stock descriptions to have the initial letters of each word capitalised, followed by lowercase thereafter when saved, irrespective of how they are entered.
- User Raw – Will not change the format of the stock description and will save exactly as the user has entered it.
This function determines how stock codes are displayed within the system, and on subsequent printed documents such as purchase and sales orders.
- Upper Case – Will force stock codes to upper case when saved, irrespective of how they are entered.
- Lower Case - Will force stock codes to lower case when saved, irrespective of how they are entered.
- User Raw – Will not change the format of the stock codes and will save exactly as the user has entered it.
STOCK VALUE
Stock Value Calculation Method
It is very important that you decide how you wish your stock value to be calculated and set this here.
- Last price paid – will update the stock value based on the latest posted purchase invoice for the stock item.
For example, if there are 20 items in stock, 10 were purchased last week at £10 and 10 were purchased this week at £20, the stock value would be £20.
- Average price – will update the stock value based on an average of the posted purchase invoices for the current stock being held.
For example, if there are 20 items in stock, 10 were purchased at £10 and 10 were purchased at £20, the stock value would be £15.
- Standard price – the system will not update the stock value, it must be manually entered and maintained by the user(s).
- Average inc Build - When a stock item is built, the stock value is updated to take into account the stock value of the child items.
Include Overheads - This option is now deprecated and does not affect how stock value is calculated, irrespective of whether it is enabled or disabled.
Include Adjustments in Average Price Calculations - If enabled, the system will include any manually entered stock value figures added from the stock adjustment screen. This option will also be used if using the ‘Build’ items functionality. If disabled, stock adjustments will not impact the stock value calculation.
3.3 Sales Tab
NEW ORDERS
Invoice address as default
Enabled – the first address on the company record marked as address type of “Invoice” will be used as both the standard invoice address and the standard delivery address. Other
preferential options will be ignored.
Disabled – the first address on the company record marked as address type of delivery will be used by default.
Proforma Order Type
This option determines what type of sales orders are created by default for customers who are marked as Proforma Customers:
- Sales Order – orders will be created as sales orders, stock will be assigned and the order will appear in the relevant stage in Sales Invoice Manager (e.g. Staging, Awaiting Stock).
- Pro-Forma – orders will be created as Pro-forma orders, stock will be assigned and the order will be placed in the Manual Hold stage of Sales Invoice Manager.
Quotation – orders will be created as quotes, stock will not be assigned and the orders will be visible under the [CRM | Opportunities (Quotes)] screen as well as in the relevant Quotations stage in Sales Invoice Manager.
GENERAL
Take full payment
Enabled – irrespective of whether the order is 100% fulfilled or not, prepayment orders will have the full sales order total payment taken, while account orders will be invoiced in full for the sales order total.
Disabled – if the order is not 100% fulfilled, prepayment orders will only have payment taken for the total of the assigned stock, while account orders will only be invoiced for the items sent on a part shipment.
Include Backorder in Run To Zero calculation
This option determines whether existing, unallocated items are taken into consideration when trying to produce a new sales order for a Run To Zero stock item (as the system won’t allow Run To Zero items to be added to a sales order if no stock is available).
Enabled – If the option is enabled, the system will factor in any outstanding, unassigned stock on existing sales orders. For example, if the Run To Zero item had 5 available but also
had 5 unassigned to sales orders (5 on backorder) then the sales operative would be prevented from adding the stock item to a new sales order because there is only enough stock to fulfil the backorders.
Disabled – if the option is disabled, the system will ignore any outstanding, unassigned stock on existing sales orders. For example, if the Run To Zero item had 5 available but also had 5 unassigned to sales orders (5 on backorder) then the sales operative would not be prevented from adding the stock item to a new sales order.
REQUIRED FIELDS
Keycode required
If enabled, the user must assign a keycode to the sales order before they are able to save it.
Sales source required
If enabled, a sales source will be required before the user is able to save a sales order.
Branding required
- Do not require – does not require a brand to be specified before saving sales orders.
- Sales Orders only – requires a brand to be specified on Sales Orders only before users can save them.
- All (Sales, Proforma, Credit Notes) - requires a brand to be specified on sales orders, proforma orders and credit notes before users can save them.
PRICING
Action if price is zero
Determines how the system will behave if a user tries to save a sales order which has a stock item where the sell price is set to 0
- None – the system will allow users to save sales order.
- Warning – the system will display a popup to warn the user, but the user can accept the warning and save the sales order nonetheless.
- Error – the system will not allow the user to save the sales order.
Warn if price is changed
If enabled, the user will receive a popup warning when trying to save a sales order where the prices the customer is entitled to have been manually changed on the sales order. The user can accept the popup and save the sales order nonetheless.
Lock Sales Order Prices
If enabled, the prices on sales orders will be locked once the sales order is saved. If the sales order is edited in the future, users will not be able to change the prices of the items listed.
Minimum Order Value
If an amount is specified here, then users will be warned if trying to save a sales order where the net sales order total falls below this figure.
Sell Prices are Net
Controls whether sell prices in the system are represented in Net (option enabled) or gross (option disabled).
Force sales order lowest price
Enabled - the system will use the lowest price from all applicable prices for an item that the customer is entitled to.
Disabled - the system will follow a pricing hierarchy when working out what price the customer will pay.
Note: Do not tick if using multi-currency. With this option enabled, the system will attempt to sell stock at the lowest value without taking currency into consideration.
Compound Discounts
Enabled – customers will receive all discounts available to them.
Disabled – customers will not receive the total sum of all discounts given, and instead will receive only one discount.
Note: Which one discount the customer receives when Compound Discounts is disabled depends upon the use of the Force Sales Order Lowest Price setting as to whether the customer receives the best price with the most discount or the price determined by the discount hierarchy.
Minimum Sales Order Margin
If a percentage is specified here, then users will be warned if trying to save a sales order where the order line margins and/or total sales order margin fall below this figure.
DELIVERY
Delivery Date (Release Early)
The number specified here depicts how many days prior to the sales order’s delivery date the order will be released from the Awaiting Date Stage in Sales Invoice Manager.
Part Ship Period
The number of days a part fulfilled invoice will stay in Awaiting Stock until the fulfilled stock items are automatically released for processing as a part-shipment.
Delivery date (put in awaiting date)
Orders will be automatically put in Awaiting Date in Sales Invoice Manager if the delivery date is more than the number of days specified here in the future.
Delivery date (add to default)
Adds the number of days specified here to the system default delivery date (system default delivery date is order date plus 1 day, i.e. next day).
Delivery Date (cheque clearance)
If the payment added to a sales order is cheque, the system will increase the delivery date by the number of days specified here.
MANUAL BO/PO
Allow auto book-in of BO/POs
Controls whether stock can automatically be booked into the system for back order purchase orders without the need for users to manually create and complete a delivery note. The option can be configured to:
- None – Never allow stock to be automatically booked in.
- Allow for all – allow stock to be automatically booked in for all BO/POs.
- Direct to customer POs only – will only allow stock to be automatically booked in for BO/POs being sent directly from the supplier to the customer.
Assign stock to Dropship if available
Enabled – If a stock item is marked as a Dropship item, but you have enough available stock to fulfil the order(s), the system will assign the available stock to the sales order.
Disabled – the system will ignore your available stock when a customer orders a Dropship item. Available stock will not be automatically assigned to the order and a BO/PO should be raised.
Deliver to Site
If enabled, this option will set the delivery address for non-direct to customer purchase orders as the address specified against the Site the goods are being ordered to, as per the Site details in [System Data | Sites]. If disabled, the delivery address for non-direct to customer purchase orders will be set to the company address as specified under Company Details in [System Values | General].
3.4 Purchasing Tab
PRICES
The first four options update the buy price on the stock item, or for the supplier associated with the stock item, either when you save a purchase order or purchase invoice. This means that the latest buy price is held against the stock item.
Purchase Prices are Net
Control whether purchase prices are Net (default) or Gross.
Purchase Discount Net
Control whether purchase discounts are Net (default) or Gross.
Lock Purchase Order Prices
This is used when you don’t want the prices on a purchase order to be changed once saved, for example if you negotiate special prices with your supplier.
REORDERING
Stock Reordering Base Value
Determines what the Reorder Report bases the suggested reorder quantities on, either Reorder Qty or Safe Level recorded against stock items, or based on nothing (i.e. no suggested reorder quantities will show).
Round to Reorder Multiple
Controls whether the reorder multiples recorded against stock items are used to calculate the suggested reorder quantity on the reorder report (enabled) or not (disabled).
Use Backorders in Calculations
Controls whether back order quantities are taken into consideration when suggesting reorder quantities on the reorder report or not.
SAFE LEVELS
Max number of months sales to assess
The number of months sales to be taken in consideration when performing a re-assessment of safe levels from the Reorder Report screen.
Note: We usually recommend to set the system to assess quite a few months’ worth of sales data (e.g. 12 months) so that any fluctuation in seasonal demand is evened out. This is so that if you perform a safe level reassessment during or immediately after a seasonal busy period for example, the system won’t be setting your safe levels to an unrealistic high level based on the last month or so only, which would be unsuitable during quieter periods.
Options
Using the options following on from the above, you can dictate what the system takes into account when reassessing safe levels, for example if it should look to factor in back order figures and credit notes. In addition, it allows you to choose whether to assess safe levels for items currently with a 0 safe level.
3.5 Accounts Tab
MISCELLANEOUS
Monthly Debt Periods
Enabled – Debt periods are represented by calendar month.
Disabled – Debt periods are represented by 30-day blocks.
Future Payment Days
The value input here limits the number of days in the future any payment transaction can be posted into the Nominal Accounts. The recommended default is 14 days.
Xero/Quickbooks Integration
Although the Xero/Quickbooks integration and configuration are configured in the Accounts section, this toggle will enable the integration to be used and configured when switched on. If the toggle is disabled, you will not be able to use or configure Xero/Quickbooks integration on your Khaos Control Cloud account.
SALES
VAT based on delivery address
Enabled – VAT inclusion or exclusion on sales orders will be calculated based on the delivery address.
Disabled – VAT inclusion or exclusion on sales orders will be calculated based on the country specified against the company record.
PURCHASES
Purchase invoice created from Purchase Order (or Delivery Note)
Controls whether purchase invoices are created when saving the delivery note (disabled) or when saving the created Purchase Order (enabled). If the purchase invoice is raised from the delivery note, any discrepancies or differences in the items delivered compared to the items ordered will be taken into consideration when the purchase invoice is created. If the purchase invoice is raised solely based on the purchase order, any discrepancies in the quantities or items delivered will not be taken into consideration.
Create purchase invoices
When this option is enabled, it will create purchase invoices based on the previous option (either from delivery notes or from purchase orders). If the option is disabled, purchase invoices will not be automatically created by the system, and posting purchase invoices must be done via the SP Ledger.
3.6 Companies Tab
GDPR – ANONYMISATION OPTIONS
Anonymisation Data
The text input here is used to overwrite any identifying details on company records when anonymised.
Minimum Days Since Last Order
If a user attempts to anonymise a customer who has a sales order dated within the past number of days specified here, they will be unable to do so. Only customers who have had sales orders prior to the specified time period can be anonymised.
Anonymise Company Code
Enabled – The company code will be anonymised in addition to any identifying data when a company is anonymised.
Disabled - The company code will not be anonymised at the time of anonymisation.
Anonymise Other Ref
Enabled – The company code will be anonymised in addition to any identifying data when a company is anonymised.
Disabled - The company code will not be anonymised at the time of anonymisation.
Company Debt Handling
This dropdown function determines what happens when a user is trying to anonymise a customer who has outstanding debt. The system can be set to prevent or warn users anonymising customers with a debt amount higher than specified in the following option, or alternatively it can allow anonymisation regardless of any outstanding debt and the value of it.
Anonymise Debt Value
The value specified here works in conjunction with either the prevent or warn functions from the previous option.
GDPR – DATA HOLDING OPTIONS
Holding Data
The text input here is used to overwrite any identifying details on company records when the Hold Data flag is set against the company, contact or address.
Held data is removed from hold by new Sales Orders
Enabled - Khaos Control Cloud will allow new sales orders to be created for companies on data hold and upon creation, will automatically remove a company level Hold against the
company.
Disabled – Users will be prevented from creating new sales orders for companies on Data
Hold.
Held data is removed from hold by new Purchase Orders
Enabled - Khaos Control Cloud will allow new Purchase orders to be created for companies on data hold and upon creation, will automatically remove a company level Hold against the company.
Disabled – Users will be prevented from creating new purchase orders for companies on Data Hold.
Data Import
Once you have gone through the System Values configuration and set up any required System Data options, you may want to import your existing stock or customers and suppliers into Khaos Control Cloud. The Data Import facility enables you to do this by creating a template table for you to populate with your existing Stock, customers and suppliers or sales orders, and once filled in allows you to import this information back into Khaos Control Cloud.
Template Generator
The template generator is found under [System Setup | Data Import]. Click on Generate Template and choose which template you would like to generate. Once you have done this, you will have the template generator screen with a four-step process. Each step contains field names to be added to your generated template, which will become column headings on the table upon download ready for you to populate with information.
- Step 1 – The fields in this step are compulsory and will be automatically added to your generated template. This information is also required upon import, so those columns must be present and filled in on the file imported into Khaos Control Cloud.
- Step 2 – The fields on this screen are optional but recommended for a more comprehensive data import. To add any of these fields/columns to your template download, enable the
toggle on the righthand side of the row you want to add. If you wish to add all the recommended rows, you can simply use the “Select all recommended?” toggle to the top right of the grid.
- Step 3 – The fields on this screen are also option. Again, you can either enable the toggle on the row of the field/column heading you would like to add to your template or use the
“Select all optional?” toggle on the top right of the grid.
- Step 4 – This step gives you a final overview of all the fields from the previous three steps which will make up your template. If you are happy with the overview, you can click
Generate Template to download the CVS copy of your file.
There are PDFs available for each template which include the title, field name and description for the importable fields to assist in compiling the information and outlines what type of information is required in each field, for example VAT on Stock Item Import is depicted by a number between 1 and 6, and the PDF specifies what these are.
Compiling your data import file
The generated template will usually download as a .txt file. One way to fill in the data import file is to copy and paste the downloaded column headings into a spreadsheet as column headers. Once the column headings are in place, you can populate the rows on the spreadsheet with the relevant information.
Importing your Data
Once you have compiled your data ready for import, you will need to ensure it is saved as a “Text (Tab Delimited)” file in order to import the information back into KCC. Once saved in this format, log in to KCC, go back to [System Setup | Data Import] and select “Import your data”.
- Step 1 - You can drag and drop your import file or browse your local resources to find and select the file to upload. You will also need to specify which type of data you are importing (Stock, Customer or Sales Order) on the right-hand side of the screen, and we recommend previewing the data prior to import. Finally, there is a “Calculate” button which will total the number of rows KCC can read on the import file, which is a useful indicator to know that the system can see as many lines as you had on your import file.
- Step 2 – KCC will verify the import file to let you know if the file is suitable for importing, along with listing the column headers seen within the file and highlighting in green the valid column headers.
- Step 3 – This step is for the recommended data preview. The system will run a dummy import to check the data and will feedback to tell you how many rows the import preview
was successfully able to import.
Note: At this stage the data is not yet imported into your KCC system, you will need to continue to Step 4 in order to fully import your data.
- Step 4 – The final step will be to fully import the data. Once you have done this, there will be no more click through options and the system will simply confirm how many items have been successfully imported. The data import screen can then be closed using the red cross button on the top right of the screen. Once your data has imported, you will be able to view or find the imported information on the relevant screens within the system, for example from the Stock Item screen.
Notes:
Any price fields on the stock import should be entered as a numerical figure, and not in a currency format.
It’s important to consider which order you would like to import information in, because some of the data import facilities will need to link to information already in Khaos Control Cloud, for example if you want to link your suppliers to stock items you would need to have imported your supplier data prior to importing your stock items.