Use the programs on this menu to transfer items from one warehouse to another.
Use Suggested Transfer Entry (ICE310) program to enter suggested transfers for inventory items from one warehouse to another. The items may then be printed and checked for accuracy on the Suggested Transfer Report before the actual transfer is entered on a transfer ticket. Suggested transfers are automatically updated to this file by the IC Replenishment Report’s optional update. Throughout the sales order entry programs, if items are on back-order, the user may automatically update items to the suggested transfer file. If a line of an order is deleted and a suggested transfer exists, the suggested transfer is automatically removed from the suggested transfer file. When a special order suggested transfer is created, the system checks to make sure that a suggested PO does not already exist for that order and line and that the order and line do not already exist on another suggested transfer.
Then, use the Suggested Transfer Report (ICR310) program to obtain a report of all suggested transfers entered in the Suggested Transfer Entry program, any suggested transfers updated by the Replenishment Report and any suggested transfers from the sales order system. Report information includes: from and to warehouse, item number and description, units, stocking unit of measure, cost, costing unit of measure, extension, sales order number, line number and customer.
Use the Transfer Entry program to enter and correct transfer tickets and/or import suggested transfer, which contain items to be transferred from one warehouse to another. The Transfer Entry screen consists of two sections. The upper portion of the screen is called the header portion where the FROM and TO warehouses, request date, etc. are entered. The lower portion of the screen is called the line-item portion where items, quantity information, etc. are entered. You have the option of changing, adding or removing line-items, or deleting the transfer ticket at any time. You also have the ability to back order warehouse transfer line items. This program provides a complete audit trail of all transfer ticket numbers used. When you add a new transfer, the program checks to ensure that the transfer ticket number being assigned does not already exist in the transfer history header file. A deleted ticket’s line-item records are removed and the header record status is changed to deleted. The transfer ticket appears on the next Receiving Register as a deleted transfer ticket and is removed in the register update. For EMS processing the Transfer Entry program checks to determine if the transfer you are going to change has been flagged by Radio Beacon. If it is has you will not be able to modify it, if it has not, the system sends a ‘nuke’ record to Radio Beacon causing this transfer to be removed. The transfers then need to be reprinted in order to get it sent back down to Radio Beacon.
Transfer tickets are available for printing using the Transfer Ticket Print program. You can print transfer tickets through this program or through the Transfer Entry program. The printed transfer tickets include all header and line-item information. The form depth (number of lines), whether printing on a preprinted form, item description(s) to print and whether to sort by location is determined in the IC static control record. You can select to print open transfers only, backorders only or all transfers or rush tickets only, normal priority tickets only or both. Transfer Tickets on service hold will not print. Only document type "S" can be printed. Lines print in sequence number order.
The program calculates and prints the next ticket shipment number in the header portion of the transfer ticket. This will not update until the shipment register is run. The header and line notes also print on the transfer. Templates that store "system date" resolve to the "current system date at the time the report is run" rather than what the "current system date" was at the time the template was created. For example: If you save a template for the Transfer Ticket Print and select "Current Date" for the Cutoff Date field, when that template is selected to run again (either manually or via Job Stream) the cutoff date is determined using the current date in the Company Periods & Ending Dates F/M (GLF970) when the report is run not the current date when the template was created. Multiple Bin Locations on Transfer Tickets: If the Print Alternate Locations on Transfer Ticket setting in the IC Static Control F/M program is set to yes, the Transfer Ticket Print program prints a new line after the main item line that shows all alternate locations set up for the "from" warehouse/item. If the Print Alternate Locations on Transfer Ticket setting in the IC Static Control F/M program is set to no or there are no alternate locations set up, no additional line prints. NOTE: If a bill of lading is to be printed for a warehouse transfer ticket, it needs to be done from the SO Bill of Lading Print Program. For WMS processing, the Transfer Ticket (ICP310) program creates 2 flat files that will be sent to Radio Beacon. Select the check box to control whether or not a flat file needs to be created.
Shipments from the FROM warehouse are confirmed through the Shipment Confirmation (ICE330). The confirmation process involves confirming that a transfer ticket (or a portion of it) was shipped. Once a transfer ticket is confirmed, it is ready to print on the next Shipment Register. For WMS processing, the Shipment Confirmation (ICE330) program does not allow confirmation of shipped orders that belong to a Radio Beacon controlled warehouse. That process is done by the upload stock picks program.
Shipments are then updated by the Shipment Register (ICR320) and then appear on the Transfer Status Report until receipts are confirmed by the TO warehouse in the Receipt Confirmation.
During processing, the system automatically displays urgent notes for transfer ticket headers, lines and items based on your settings on the Notes tab of Transfer Entry Options F/M. Refer to the Viewing/Entering Notes from IC Transfer Entry Programs topic for additional details.
As the Shipment Register prints, deleted and voided documents are printed, including the date the document was deleted and the user who deleted it print. These are not counted in the number of tickets processed, and the lines will not print for a deleted document. Any lines that were deleted from a ticket that is running through the register also print after all the open lines for the ticket have printed. This information comes from the deleted lines file (ICTRND) and includes the item, description, quantity requested or shipped, cost, date the line was deleted and the user who deleted it. The deleted lines do not include the cost extension and do not add into the ticket total. This program will: print a listing of transfer tickets confirmed as shipped, items transferred and costing information, build and print a general ledger distribution, if needed, post to general ledger, if general ledger is built, update inventory and general ledger files. Register information includes: ticket number, request date, shipped date, from and to warehouse, ship via and reference number. For each item transferred, the item number and description, serial/lot numbers (if applicable), units, stocking unit of measure, cost per unit, costing unit of measure, extension and sales order tickets. Ticket and register totals are printed. The total number of tickets listed is also included. Usage: If the "To" warehouse’s restocking warehouse is the "From" warehouse, then the "From" warehouse gets the usage updated if the "From" warehouse also has the Replenish flag set to Y on the Main screen of Warehouse/Item F/M (ICF920). Transfer History Processing: When the Shipment Register update is run, the system writes the processed transfer tickets to the Transfer History files. For each ticket, the program writes a record to the ICPTRH Transfer History Header file. For each line on the ticket, the program creates a record in the Transfer History Line file, ICPTRL. For is for a serial or lot line-items, records are written to the Transfer History Serial/Lot file, ICPTRS. For duplicate ticket numbers, the program uses a sequence number field. Before writing a new header record, the program determines if the ticket number already exists and increments the sequence number for the new header being added and writes all line and serial/lot records with the new sequence number.
When the receiving warehouse receives the items, the receiving warehouse confirms their arrival through the Receipt Confirmation program. Use this program to enter confirmation of transfers out of the FROM warehouse. The confirmation process involves confirming that a transfer ticket (or a portion of it) was shipped. Once a transfer ticket is confirmed, it is ready to print on the next Shipment Register.
During processing in the Suggested Transfer Entry (ICE310), Transfer Entry, Shipment Confirmation (ICE330), and Receipt Confirmation programs, the system automatically displays urgent notes for transfer ticket headers, lines and items based on your settings on the Notes tab of Transfer Entry Options F/M. Refer to the Viewing/Entering Notes from IC Transfer Entry Programs topic for additional details. EWMS Processing Note The Shipment Confirmation (ICE330) program does not allow confirmation of shipped orders that belong to a Radio Beacon controlled warehouse. That process is done by the upload stock picks program.
You can use the Document Fill Report (ICR350) to advise warehouse personnel of what backorders can be filled with the incoming merchandise (received purchase orders and transfers) before the Transfer Receiving Register is run. The report can be run for special order lines (those tied to an SO) and/or restocking (those not specifically tied to an SO). Received Purchase Orders print first and then the received Transfers. The program prints a page break between the two types of documents. In addition, since Transfer Entry has the capability to back order quantity, the document lines that could be filled by incoming stock, the report output also includes backordered transfers. The backordered sales order lines will print first and then the backordered transfer lines. The alternate bin locations are print on the report based on the IC Static Control F/M setting, Print Alt Locations on Transfer Fill. If you select to print POs only or both document types, this program prints the received purchase order that match the selection criteria and the backordered document lines that could be filled by these receipts. If you did not include POs in the document type selection, then this program does not print and runs for transfers. After the sales order line are printed that could be filled by a PO line, then any transfer lines for the item that have a back-ordered quantity also print. The "to" warehouse description prints in the column where the customer name printed for the sales orders. If you select to print transfers only or both document types, this program prints the received transfers that match the selection criteria and the backordered document lines that could be filled by these receipts. If you did not include transfers in the document type selection, then this program does not print and instead returns to the menu. The program reads the transfer line file for all open receipt lines that have a received quantity. Since there can be multiple open receipts for one ticket, the report prints the transfer ticket number and total received once and then each receipt for that ticket prints on a separate line. If you included updated receipts, those also print. Then, the report prints the lines that could be filled by that received quantity. After the sales order line are printed that could be filled by a transfer line, then any transfer lines for the item that have a back-ordered quantity will also print. The "to" warehouse description will print in the column where the customer name printed for the sales orders.
After receipt confirmation, the receiving warehouse runs the Receiving Register. This program: prints a listing of transfer tickets confirmed as received, items transferred and costing information; builds and prints a general ledger distribution, if needed; post to general ledger, if general ledger is built, and updates inventory and general ledger files. Register information includes: ticket number, shipped date, receipt date, from and to warehouse and either the ship via and reference number of the status of deleted (prior to printing ticket) or voided (after printing ticket) ticket. For each item received, the item number and description, serial/lot numbers if applicable, units, stocking unit of measure, cost per unit, costing unit of measure, extension and order number. Ticket and register totals are printed and the total number of tickets listed is also included. When a line on a transfer is tied to a sales order, the Receiving Register prints the sales order line number next to the sales order number.
Lead Time: If the "To" warehouse’s restocking warehouse is the "From" warehouse, the Receiving Register may flag abnormal (A) lead time in the "To" warehouse if the "To" warehouse item is stocked and the Replenish flag on the Main screen of Warehouse/Item F/M (ICF920) set to Y, before checking all other conditions that would flag the item with an abnormal lead time.
Transfer History Processing: The Receiving Register Update updates the records previously added in the transfer history files. The Receiving Register updates the receiving-side information in the records. The program updates the records for the last sequence number in the file. For each ticket, the program updates the ICPTRH Transfer History Header file, the Transfer History Line file, ICPTRL and the Transfer History Serial/Lot file, ICPTRS for a serial or lot line-items.
The Transfer Status Report may be printed at any time to obtain a list of all items in the warehouse transfer system. This list prints the status of the item (in-transit, etc.). Report information includes the following: ticket number, item number and description, status (E-entered, P-printed, S-shipped, T-in transit, R-received, D-deleted and V-voided), request date, from and to warehouse, number of units requested, backordered (if the document status is Entered, Printed, or Shipped), shipped and received quantities (if the document status is In-transit, Received, Updated) , stocking unit of measure, cost per unit and costing unit of measure. The total number of tickets listed is also included. The report prints a separate line for an open transfer shipment and all open transfer receipts within the ranges selected. Each will be evaluated based on its own status and priority.
The Quick Transfer Adjustment program allows an immediate transfer of on hand quantities from one warehouse to another. The audit trail of the warehouse transfer is printed on the next Adjustment Register located on the Adjustments menu. Use this program to transfer a quantity of an item from one warehouse to another. Updating the on hand quantities of the items according to the transfer amounts occurs immediately as the transfer is updated. Two records of the transfer (one for each warehouse) are created in the adjustments file and are available for printing on the next Adjustment Register. The Quick Transfer Adjustment (ICE350) program uses the Costing Method designated the Static Control F/M (ICF980) program instead of Standard Cost. A scrolling feature displays the most recent transactions recorded at the bottom portion of the screen. This provides additional safeguards against user error due to oversight or transaction duplication. Usage: If the "To" warehouse’s restocking warehouse is the "From" warehouse, then the "From" warehouse gets the usage updated if the "From" warehouse has the Replenish flag on the Main screen of Warehouse/Item F/M (ICF920) set to Y. Lead Time: If the "To" warehouse’s restocking warehouse is the "From" warehouse, then the "To" warehouse lead time type is set to "A" for abnormal only if the item is stocked and the Replenish flag on the Main screen of Warehouse/Item F/M (ICF920) set to Y. Otherwise, the lead time flag will be blank. The Quick Transfer Adjustment (ICE350) program is disabled for any Radio Beacon controlled warehouses.
Run Commit Backordered Quantities (SOR210) to update the back-ordered quantities on sales orders, warehouse transfers and backorders to committed quantities and to provide a report of what is updated. The report prints as the update occurs. You can select whether to include sales orders only, transfers only or both when the report is run. You also have the option to print the transfer tickets for the transfers that had back-ordered quantities committed. As orders and invoices are entered, some line-items have backordered amounts, usually because a customer order an amount greater than the quantity available. In time, another shipment of the backordered item arrives at the user’s company. Some of this new stock may be partially committed from special orders that were imported to create purchase orders; however, the rest of the quantity is available. Since the quantity is available, it can once again be committed by new orders and invoices, leaving none left over to fill backorders. To avoid leaving back-ordered quantities on permanent backorder, the system allows the user to run this program. This program checks orders and backorders for backordered amounts. The program does not check invoices, printed or confirmed orders, quotes, counter sales, etc. Sales orders and backorders for customers on hold are not checked for backordered amounts. If the program finds backordered amounts, it then looks to see if the item has any quantity that is available. If there is enough of the item available to fill the entire backorder quantity and leave at least one in stock, the system automatically commits the quantity and sets the backordered amount to zero. For serial or lot number items, the system does not commit the backordered amounts if the OE Serial/Lot Number Entry flag in the Sales Orders Static Control Record is set to Y. Infor™ recommends that you run this program after running the purchase order Receipt Register, after entering adjustments in inventory control, or after a large amount of line-items have been deleted or voided. If there are a large number of orders and invoices in the system, this program may take some time to run. Report information includes order number, order type and status, requested date, warehouse code, customer number and name, item number and description, and the amount committed and its corresponding unit of measure.
The Transfer Document Inquiry allows you to view the various record types that make up a transfer document
.
Updating the On-Hand Quantity: Updating the on-hand quantity based upon the adjustment amount occurs immediately as the transaction is recorded. If the adjustment type is an R-receipt, the unit cost is also entered and the current cost updated according to the costing flag is the IC static control record. If the adjustment type is an S-sale, the sales dollars (dollar amount of sales) are also entered. If the adjustment type is an A-adjustment, the cost is also entered. The Adjustment Register should be run periodically to give a hard copy of all adjustment and repackaging transactions and update general ledger.
You have the ability to cost serial and lot items by the system cost (costing method for the module). The feature provides for GAAP compliance. For the FACTS SO, IC and MC modules, you can decide if the cost for serial and lot items will be averaged actual (as it has always operated in the past) or system cost (costing method for the module). The default setting for each Static Control F/M is A-Averaged Actual (same behavior as they have before the monthly is applied). Users who want to take advantage of this change will need to change the option to S-System Cost for each of the applicable modules. The net result of selecting S-System Cost is that serial/lot items will be costed like non-serial/lot items. The results of this program are affected by this selection.
Lead Time: If the adjustment type is "R" for receipt and the restocking warehouse is direct from the vendor, the lead-time is set to abnormal only if the item is stocked and the replenishment flag (located on the Main view of Warehouse/Item F/M) is Y. Otherwise, the lead-time flag is blank.
EWMS Processing Note: The Adjustment Entry (ICE210) program does not allow exiting an item that is in a Radio Beacon controlled warehouse if the adjusted quantity does not sum to zero. All quantity adjustments should be done in Radio Beacon. The only reason this program should be used is to adjust costs. So you can adjust one out at one cost and back in another. The net effect on inventory quantity is zero.