INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY ACCOMPANY THIS DOCUMENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE.
The user assumes the entire risk as to the accuracy and the use of the information supplied. This information may be copied and distributed subject to the following conditions: 1)All text must be copied without modification and all pages must be included; 2)If software is included, all files on the disk(s) must be copied without modification; 3)All software included and documentation must be distributed together; and 4)This information may not be distributed for profit.
Copyright © 1996 Platinum Software Corporation. All Rights Reserved.
Platinum ia a registered trademark of Platinum Software Corporation.
All other trademarks contained herein are acknowledged.
HOW TO SET UP AND USE KITS
HOW TO SET UP AND USE KITS
The first issue to be addressed is where to initialize the Kit file? The Kit file is not initialized from Accounts Receivable, although the Kit file maintenance is in Accounts Receivable. The user needs to initialize the file through SYSTEM MANAGER/ COMPANY SETUP/INITIALIZE DATA FILES , initialize Inventory Kit file.
The second issue is how to setup the sub components (Sub-Item) of the kit. If the kit is not set up correctly, the Inventory files will not be updated correctly.
When creating a kit, you will have a unique item key used to identify the kit and several inventory items within that kit. For example, I am selling a COMPUTER KIT (Master Item Key) that consists of a COMPUTER, a PRINTER and a CABLE. When you create the kit in Accounts Receivable KIT File Maintenance, you should set it up as follows:
MASTER ITEM KEY COMPUTER KIT
SUB-ITEM SEQUENCE NO. 1
SUB-ITEM COMPUTER CABINET
MASTER ITEM KEY COMPUTER KIT
SUB-ITEM SEQUENCE NO. 2
SUB-ITEM COMPUTER
MASTER ITEM KEY COMPUTER KIT
SUB-ITEM SEQUENCE NO. 3
SUB-ITEM PRINTER
MASTER ITEM KEY COMPUTER KIT
SUB-ITEM SEQUENCE NO. 4
SUB-ITEM CABLE
Note that the first sub-item in the example above is the Item Key of the Master Item. This is because, when a kit is sold, the system uses the IVLOC record for the Master Item to retrieve the kit price and the sub-items that are not the Master Item to retrieve the cost. Then the IVLOC and IVPDHST record for each sub-item is updated.
When the transaction is posted, a single record is posted to ARTRAN for the Invoice or Credit Memo. This record will contain both the sale price and cost for the transaction. A single record will be posted to ARLINH with the Unit Price for the Kit Master Item.
One record will be written to IVTRANH for each item within the kit (Master Item and sub-items). The sale price detail will be posted to the IVTRANH record for the Master Item; this record will contain no cost information. The cost detail will be posted to the IVTRANH record for each sub-item; these records will contain sale price information.
If the Master Item is not included as a sub-item, the Inventory records for that item will not be updated, thus there is no way to report the number of items that were sold within kits, versus those that were sold individually.
Also, if the Master Item is not included as a sub-item, the system will not post a record to the IVTRANH with a "Unit Sale" amount for this transaction, as the sale price is associated with the Master Item. Thus, any report that uses IVTRANH will be inaccurate. For example, the Inventory Gross Profit report uses this file to calculate the difference between sale price and cost. The Gross Profit report will use the sale amount from the Master Item and the sum of the cost for all sub-items to determine the gross profit for the transaction. If there is no sale price associated with this transaction, the gross profit will be a negative number.
