019821 Create stock records on order import

Create stock records on order import is not enabled by default.

Please email Development for more information.
Note: there will be additional costs involved if this option is enabled.

Overview

KCSL have modified the Order Import functionality of Khaos Control to allow for the creation of stock records on order import.

Specification

This new functionality will create any items from an order that do not exist in the Khaos Control database allowing for new items to be created on Order Import.

The Stock record when created, takes the following information:

  • Stock Code - XML Stock Code
  • Short Description - XML Short description
  • Sell Price - XML Gross Unit
  • Stock Type - [TBC] – When a stock item is imported and a Stock Type of “[TBC]” exists in the [ System Data | Level 2: Type] screen this will be set as the Stock Type so users know to modify it. If the Stock Type “[TBC]” is not found then it will be imported with a stock type of “System & Miscellaneous”.

The stock record will be marked as stock controlled and will not import with a level against it, allowing it to appear on the [ Sales Invoice Manager | Back Orders ] reports.

Note: If an order contains an item that has no stock code, this will be imported with an SKU of “unknown” if this item already exists then the details against the item will be updated, if any Sales Orders that have this item have the “Refetch Price” used against it then the Order information will be updated to have this new price.


Configuration

An update and a changelog will be applied as a part of this development. Other steps for configuration are as follows:

Create the TBC Stock Type

  1. Open a System Data screen (show me how).
  2. Double-Click on Level 2: Types to open.
  3. Press Alt+E or click the green triangle icon is the buttonbar's EDIT button to enter edit mode.
  4. Press F3 or click the NEW ITEM button has an icon that shows two sheets of paper (identified by having the top right corner folded down), arranged diagonally on the icon from top left to bottom right   to add a new item.
  5. Enter the description [TBC]
  6. Press Ctrl+S or click the disk icon is the button bar's SAVE button    to save.

Usage

Once configured, steps for usage are as follows:

  1. When an order is imported via Channels 2.0 or XML Import any stock items that do not exist on the Khaos Control Database will automatically be created.

Contact the Khaos Team