Version 5.9
In this Topic: Show
The Transfer Inventory screen is accessed via the Inventory & Suppliers tab of the Maintenance Menu.
In some instances, a merchant may sell a product as an individual item and they may also sell that same item in a larger quantity, packaged as a single unit. Both the individual product and the multi-pack of the same product can have different, but related, SKUs in the Order Manager, allowing the program to track the quantity on hand for each of them separately.
In order to accomplish this, the user designates a Single Unit SKU (product inventory record) as the sole component of the Lot SKU (product inventory record), as well as the number of Single Units that make up the lot. Refer to the Knowledge Base topic for the Inventory screen for more information about creating or updating product inventory records.
The purpose of the Transfer Inventory screen is to logically "move", or transfer, some or all of the Quantity on Hand count (of physical merchandise) between the single unit SKU and the lot SKU as needed. In this topic, the use of the words "build" and "break down" refer to the movement of QOH between the Single Unit and Lot SKU inventory records.
The benefit of this feature is that when the QOH of the individual item is low, the user can "break" a lot into the individual components, increasing the number of single units available to fill orders. Conversely, the user can "build" lots from the single unit SKU's QOH, if they have an abundance of that single item SKU. For example, if you sell batteries by the piece, you can "transfer" inventory (QOH) from the single unit SKU to the lot SKU and sell packages of ten batteries, in addition to selling single batteries.
The Transfer Inventory screen displays the accurate inventory count at-a-glance; you can easily see how many single units you have in stock versus the number of ten-packs you have in stock. If you see that you are almost sold out of single pieces but still have many ten-packs in stock, you can break down some or all of the ten-packs to replenish your inventory of single units.
Click the Show
link next to "In This Topic"
at the top of this page to see a series of links in outline form,
which can be used to quickly jump to that section of the topic.
In addition, major topics may provide a brief synopsis of a field's purpose or direct the reader to the appropriate section of the topic by scrolling over the image. To return to the previous location within the same page, right-click the mouse and select [Back].
If clicking a field directs the reader to a different Knowledge Base topic, it will open in a new tab or window, leaving the currently viewed topic open. The browser's settings determine whether a new tab or window is opened.
Figure 1: Transfer Inventory screen
Note: If you have not built any lots yet, you will see a QOH of 0 (zero) when you open this screen.
This section is not labeled as such, but it provides details about the Single Unit SKU which is the sole component of the Lot SKU that is selected in the SKUs that are multiple unit "Lots" of other SKUs section of the screen.
enter any value, up to the value in the Max. Build field, to indicate the desired number of lots to "build"
click the [Build Lots] button
the QOH of the Single Unit SKU will be decreased by this value; the QOH of the Lot SKU will be increased by this value
enter any value, up to the value in the QOH field of the selected LotSKU seen in the SKUs that are multiple unit "Lots" of other SKUs section, to indicate the desired number of lots to "break down"
click the [Break Down Lots] button
the QOH of the Single Unit SKU will be increased by this value; the QOH of the Lot SKU will be decreased by this value
Use this section of the screen to manipulate a range of Lot SKUs at one time.
enter the specific number of lots to be built or broken when the [Build Specified Lots] button is clicked
mutually exclusive with the All Possible check box
enter a string of text with which the Lot SKUs begin
Qty on Hand is less than or equals
enter a threshold value, at which the program should limit the "building" or "breaking" of lots
Before you can begin "building" Lot SKUs, you must first create a Lot SKU inventory record in the Order Manager.
Go to Main Menu>Maintenance Menu>Inventory & Suppliers>Inventory.
Click the [Add] button to create a new record, or use the [Duplicate] button to create the lot SKU from the corresponding Single-Unit SKU record. If the latter method is chosen, navigate to the individual SKU record before clicking the Duplicate button.
Refer to the Knowledge Base topic, Inventory Screen, for more information about completing the other fields on that screen, which are not mentioned in this set of instructions.
In the bottom left corner of the Product Info tab, there is a section called "Selling by Lots: If this item consists of multiple units of a different SKU:". Enter the individual product SKU in the Single Unit SKU field or use the [Browse] button to search for the appropriate product record (opens the Find a Product/Search Inventory screen).
Enter the number of units of the Single Unit SKU that make up the "lot" into the Qty. in this SKU field.
Click the appropriate For Purchase Orders, order radio button to select which SKU, individual or lot, appears on Purchase Orders generated by the Order Manager. This usually depends on the supplier's requirements (vendor). If the Order Manager's Purchase Order system is not being used, leave this button at its default setting of Single Unit SKU.
Figure 2: Portion of the Inventory screen pertaining to Lot SKUs
When all of the necessary information has been filled in, click the [Save] button to create the new Lot SKU.
Figure 3: Example of a Lot SKU displayed at the Transfer Inventory screen
From the Main Menu, click the Maintenance Menu icon, select the Inventory & Suppliers tab and double-click the [Transfer Inventory] activity at the bottom of the list of activities. Use the vertical scroll bars to locate it.
A list of all of the Lot SKUs that are currently defined in the program will be displayed in the SKUs that are multiple units"Lots" of other SKUs. Refer to Figure 3.
In this example, the Lot SKU, pepsi6pk, is made up of the Single Unit SKU, pepsi12oz, and there are currently 12 multi-packs in stock (QOH column).
Looking in the lower left-hand corner, we see that the Single Unit SKU, Pepsi12oz, has a current QOH of 10. The Lot SKU requires 6 units (Qty per Lot) of the Single Unit SKU, so therefore the program can only "build" a maximum of 1 lot (Max. Build).
Enter "1" in the Number of Lots to Make field in the Selected (Lot) SKU section of the screen and click the [Build Lots] button.
The program pops up a message box that says "OK!". Click the [OK] button to acknowledge the completion of the action.
The Transfer Inventory screen now reflects the changes in QOH for the Lot SKU, 13, and the Single Unit SKU, 4.
Figure 4: The result of building a lot
Referring to Figure 4, we see that there are currently 13 multi-pack units of Lot SKU pepsi6pk in stock. Each lot is comprised of 6 units of the Single Unit SKU, pepsi12oz.
An order has been received for 5 units of Single Unit SKU pepsi12oz, but the program shows there are only 4 on hand. To fill the order, we can "break down" one or more of the multi-unit Lot SKUs into its components (six 12 oz bottles of Pepsi).
Enter "2" in the Number of Lots to Break Down field and click the [Break Down Lots] button.
Figure 5 shows the changes in QOH for the Single Unit SKU, 16 (4+ 6 + 6 = 16), and the Lot SKU, 11 (13 - 2 = 11).
Figure 5: The result of breaking a lot
This section of the screen provides the flexibility to identify and build or break lots in groups of inventory records simultaneously. Use various combinations of the fields in this area to achieve the desired results. Please review the explanations provided earlier in this topic, to make the appropriate selections.
Let's assume that there are so many Lot SKUs defined in the program that they cannot all be seen in the SKUs that are multiple units"Lots" of other SKUs list box.
Let's also assume that we want to build all possible lots for all Lot SKUs that start with the letters "pep".
Referring to Figure 1, go to the Build/Break a Range of Lots SKUs section of the screen and complete the steps below. The actual screen in the program does not contain a label for this section, it was added to Figure 1 for the sake of explaining its purpose.
Click the [Build] radio button.
Leave the Quantity field blank, since we are going to build All Possible lots, not a fixed number of lots.
In the Lot SKU STARTS with field, enter the characters "pep".
Click the [Build Specified Lots] button.
The program will prompt the user for confirmation prior to completing the action requested.
Figure 6: Confirmation prompt from program
Click [OK] to proceed, or [Cancel] to abort the change.
When the OK button is clicked, the program will build as many lots as it mathematically can for the Lot SKU records that begin with the letters "pep".
Figure 7: Acknowledge the completion of the request
Click the [OK] button to acknowledge the completion of the request, and return to the Transfer Inventory screen.
Created: 8/11/11
Modified: 1/13/12
Go to Top