New features added, version 7.5.2, 7.5.3, 8.1
Program RTVM, Return to Vendor Maintenance, is used to enter and maintain transactions governing the return of quarantined inventory to vendors. . These transactions are then picked and shipped to the vendor using this program.
* The inventory that you are returning to the vendor must be moved to a quarantine location before you can enter a return to vendor transaction for the inventory in this program.
Return to vendor transactions are created automatically when inventory is moved to quarantine locations with program REIE, Inspection Entry, program REOM, One Step Receiver Entry/Maintenance, or program SVMM, Service Master Maintenance. They can also be created manually in this program.
* One return to vendor transaction is entered per receiver number. As long as the return to vendor transaction remains open, the transaction lines will be added to that return to vendor transaction. If the return to vendor transaction status changes to any status other than open, additional return to vendor transaction lines for the same receiver will be added to a new return to vendor transaction.
* When quantities are moved to quarantine locations in program SVMM, Service Master Maintenance, the SVMM_RTV parameter in program MURM, Initialization Parameter Maintenance, determines whether a return to vendor transaction is created for the returned quantity.
* Non-Maintain On Hand items will now get item trans log entries written into IPPI and ICPQ with adjustment type ‘W’ so that general ledger postings can be done. The standard material and unit cost will come from the RTV line’s return price. Actual material and unit cost will come from the RTV line’s original purchase price. In the rare case that there is no RTV line, the standard method of getting inventory costs will be used.
If you are printing license plates for return to vendor transactions, you must first complete the Label Printing for Receipts section in program MURM, Initialization Parameter Maintenance, for license plates.
Some functionality of this program is controlled by parameters in program MURM, Initialization Parameter Maintenance. See the Return to Vendor Parameters section for more information.
Third Party Shipping Accounts for Shipping Interfaces
Entering and Maintaining Return to Vendor Headers - RTV Maintenance Tab
Adding and Changing Return to Vendor Lines - Open Quarantine Items Tab
Entering Return to Vendor Lines for Non-Stocked Items - Open Quarantine Non Stock Tab
Maintaining Return to Vendor Lines
Entering and Maintaining Return to Vendor Containers
Entering or Changing the Return To Vendor Address - Return To Address Tab
Picking Inventory to Return to Vendor
Shipping Inventory to the Vendor without Clippership
Shipping Inventory to the Vendor with Clippership
Creating Credit Vouchers for Returned to Vendor Inventory
Setting Print Flags on the Print Select Tab
1. The RTV No will be generated by the system when you commit the header.
* For transactions created from program REIE, Inspection Entry, and program SVMM, Service Master Maintenance, this number was generated when the transaction was generated.
2. Set the RTV Status pop-list to Open.
3. The Dt Created field will default to the system date. It can be changed.
* For transactions created from program REIE, Inspection Entry, and program SVMM, Service Master Maintenance, this is the date on which the transaction was created, but it can be changed manually.
4. In the Return Dt field, enter the date on which the inventory was returned to the vendor. You can leave this field blank and update it with the correct date later.
5. In the Vendor No field, enter the vendor to which you are returning the inventory.
* For transactions created from program REIE, Inspection Entry, this is the vendor from the purchase order for which the inspection was entered.
* Transactions created from program SVMM, Service Master Maintenance, are not assigned a vendor upon creation, and one must be entered when the transaction is updated.
* Type RTV comments entered for the vendor will be copied to the return to vendor transaction.
6. In the Vendor RA field, enter the vendor return authorization code.
* This number is used as the invoice number when credit vouchers are created for the return to vendor transaction.
7. The Voucher No field displays the credit voucher number for the inventory being returned.
* For more information on creating credit vouchers from this program, see the Creating Credit Vouchers for Returned to Vendor Inventory section.
8. In the Contact field, enter the contact for this vendor and return to vendor transaction.
* The primary contact for the vendor is entered automatically when the transaction is created, but can be changed.
* The list of values on this field displays all contacts entered for the vendor in program SPWM, System Contacts Maintenance, or program VEMM, Vendor Master Maintenance.
9. In the Phone field, enter the telephone number for this contact.
* The entry in this field will default to the Business telephone number entered for the contact in program SPWM, System Contacts Maintenance, or program VEMM, Vendor Master Maintenance.
10. In the Freight Cost field, the freight cost for the return to vendor transaction is displayed.
* This information will be calculated automatically when cost is entered in the transaction line container information.
11. In the THP Acct field, if the vendor is going to pay the freight cost for the transaction, enter the third party account in this field. You can double click in this field to view a list of values of the third party accounts for the vendor and ship via code in program VESM, Third Party Vendor Maintenance.
* If the third party account entered does not exist in program VESM, Third Party Vendor Maintenance, the user will be prompted to add it to the program automatically.
* The third party address sent to the shipping interface will be the return to vendor address.
12. If the vendor is going to pay the freight cost for the transaction, set the Vendor Pays Frt flag to on.
* When this flag is set to on, and the vendor for the transaction is assigned a third party account in program VESM, Third Party Vendor Maintenance, for the ship via code, the freight charges will be charged to the third party account. In addition, freight charges will not be included the credit voucher.
* For more information, see the Third Party Shipping Accounts for Shipping Interfaces section.
13. If you are using the Clippership interface to ship the inventory to the vendor, set the Clipper Return Loc pop-list to the desired sales location.
* The setting of this pop-list defaults to the sales location for the plant that the user is logged into.
* The sales location information will be used as the return address information when writing to the Clipper table.
* Sales locations are entered in program ARLM, Location Maintenance.
14. In the Ship Via field, enter the ship via code for the return. The default is the vendor's ship via code from program VEMM, Vendor Master Maintenance.
15. If the vendor charges for the inventory returned, enter the charge in the Vendor Chg field. This amount is subtracted from the Gross Return Value when calculating the Net Value for the transaction.
16. When the Vendor Pays Frt flag is set to on, the freight cost is entered in the Freight field automatically. This amount is added to the Gross Return Value when calculating the Net Value.
17. In the Return To field, enter the return to code for the vendor return address to which the inventory will be shipped.
* Return to addresses are entered in program VEMM, Vendor Master Maintenance. The list of values displays all return to addresses entered for the vendor.
* You can maintain the Return to Address on the Return To Address Tab.
18. Set the Print flag to the desired setting. When this flag is set to on, the return to vendor transaction will be included when program RTVR, Return to Vendor Report, is printed.
19. Set the Print Pick flag to the desired setting. When this flag is set to on, a pick list can be printed for the return to vendor transaction with program RTVPI, Return to Vendor Pick List.
20. Set the Print Pack flag to the desired setting. When this flag is set to on, a pack list can be printed for the return to vendor transaction with program RTVPA, Return to Vendor Pack List.
* When the RTV_AUTO_PACK_PRINT parameter is set to Y in program MURM, Initialization Parameter Maintenance, the packing list will be printed for the return to vendor transaction, provided that the drill down record for program RTVPA, Return to Vendor Pack List, has been set up.
21. Set the Print License Plates flag to the desired setting. When this flag is set to on, license plates will be printed for this return to vendor transaction.
* If you are printing license plates for return to vendor transactions, you must first complete the Label Printing for Receipts section in program MURM, Initialization Parameter Maintenance, for license plates.
22. In the No of Plates field, enter the number of license plate labels for the shipment.
* License plate labels will be written to the output file in the format lpxxxxx.xml, where xxxxx is the order number. The output file location is determined by the setting in program MURM, Initialization Parameter Maintenance.
23. In the Label Printer field, select the printer to which the license plates will be printed from the list of values.
24. Set the Request Auth Sent flag to the desired setting. This is a user-defined and user updated field that indicates that the authorization was sent to the vendor.
25. Set the Inspect Only flag to the desired setting, indicating whether the items on this return to vendor transaction are being returned to the vendor for inspection only.
* When set to on, and the RTV_HOLD_INSPECT parameter in program MURM, Initialization Parameter Maintenance, is set to Y, credit journals will not be written for the return to vendor transaction.
* When set to off or when the RTV_HOLD_INSPECT parameter is set to N, credit journals will be written for the return to vendor transaction when the status is changed to Picked.
* For return to vendor transactions that had this flag set to on¸ and the RTV_HOLD_INSPECT parameter is set to Y, when the user sets this flag to off, the credit journals will be written.
26. Press [Commit].
When return to vendor transactions are created automatically with program REIE, Inspection Entry, and program SVMM, Service Master Maintenance, the item line is added to the transaction automatically when it is created. Items can also be moved to quarantine locations manually using inventory adjustment, picking, and receiving programs. These items need to be assigned to return to vendor transactions manually.
You cannot add lines in the middle block of the RTV Maintenance Tab for stocked items. You must use the Open Quarantine Items Tab. This allows better control of the inventory moved in and out of the quarantine locations.
For transaction lines created automatically, you may wish to group lines going to the same vendor or from the same purchase order on the same return to vendor transaction. This is also accomplished with the Open Quarantine Items Tab.
1. When this tab is selected, all moves to the quarantine location are displayed, including those assigned to an existing return to vendor transaction, and those not yet assigned.
2. Those assigned to an existing return to vendor transaction have the return to vendor transaction number entered in the Current field.
3. Those not assigned are displayed with the Current field blank.
4. To move an existing line to a different return to vendor transaction, in the New RTV Number field, enter the RTV number to which you are moving the transaction line.
5. To add an item line to an existing return to vendor transaction, in the New RTV Number field, enter the RTV number to which you are adding the transaction line.
6. If the item is a serial controlled item in a serial control number range, you can enter the range that you are moving to the new RTV number. Enter the control number range being moved in the Control No and Control No - End fields.
* You can only move a range beginning with the starting serial number in the original range or ending with the ending serial number in the original range. You cannot move a range from the middle of the original range.
* For example, if the range were 0001 to 0009, you could move 0001 to 0004, or 0008 to 0009, but you could not move 0004 to 0007.
* You cannot change lot control numbers.
* You cannot enter control numbers for controlled items in non-controlled quarantine locations.
8. In the Return Qty field, enter the quantity that you are adding to the new RTV number. This can be a partial amount up to the original adjustment quantity in the Orig Adj Qty field.
9. The vendor number displayed on this tab is the preferred vendor for the item from program ICPM, Inventory Planning Data Maintenance.
10. When you have completed entering all of your changes, press the [Change RTV No] button to complete the changes.
You cannot add lines in the middle block of the RTV Maintenance Tab for non-stocked items. You must use the Open Quarantine Non-Stock Tab. This allows better control of the inventory moved in and out of the quarantine locations.
For transaction lines created automatically, you may wish to group lines going to the same vendor or from the same purchase order on the same return to vendor transaction. This is also accomplished with the Open Quarantine Non Stock Tab.
1. When this tab is selected, all non-stocked items that have been entered here are displayed, including those assigned to an existing return to vendor transaction, and those not yet assigned.
* Those assigned to an existing return to vendor transaction have the return to vendor transaction number entered in the Current field.
* Those not assigned are displayed with the Current field blank.
2. To create a new transaction or to modify an existing transaction, complete the following steps.
3. In the New RTV Number, if you are moving the transaction to a new return to vendor transaction, or if you are entering a non-stocked item for an existing return to vendor transaction, enter the RTV number to which you are adding the transaction line.
* You can leave this field blank if you are not yet ready to assign the non-stocked item to a return to vendor transaction.
4. In the Item No field, enter the non-stocked item number that will be returned to the vendor.
5. In the description field, enter a description for the item.
6. In the Return Qty field, for new records, enter the quantity to be returned to the vendor.
* If you are modifying an existing record, enter the quantity that you are adding to the new RTV number. This can be a partial amount up to the original adjustment quantity in the Orig Adj Qty field.
7. In the Orig Adj Qty field, enter the original quantity to be returned to the vendor.
8. In the Vendor ID field, enter the vendor ID for the return to vendor transaction.
9. In the Area field, enter the stock area in which the quantity is stored.
10. In the Bin field, enter the bin location in which the quantity is stored.
11. In the Reason field, enter the reason code indicating why this item is being returned to the vendor.
12. Press [Commit].
13. For existing records that you are moving to a return to vendor transaction, when you have completed entering all of your changes, press the [Change RTV No] button to complete the changes.
1. Transaction lines are added to return to vendor lines on the Open Quarantine Items Tab and on the Open Quarantine Non Stock Tab. Once the lines have been added, some of the information can be maintained.
* When the ALLOW_RTV_INSERT parameter is set to Y in program MURM, Initialization Parameter Maintenance, discontinued items can be entered on the RTV Maintenance tab by scrolling to the last item record and using the arrow keys to arrow down to a new record. The transaction has to be open.
The reason code assigned to these transactions is defined by the RTVM_DEFAULT_REASON_CODE parameter.
In the Orig Item field, in the Orig Item No field, enter the item number for the discontinued item and then continue with the maintenance information below.
2. In the Orig Vendor Item field, you can enter the vendor's item number for the original item.
3. In the Return Item field, you can enter the item number that is actually being returned to the vendor. For example, if the original item was a kit or model item, and one of the is being returned, this would be the component item number.
4. In the Return Vendor Item field, you can enter the vendor's item number for the return item, if it differs from the original item.
5. The Control No field and the Control No End field contain the control numbers that are being returned to the vendor.
* This information cannot be changed for lot control numbers.
* If the item is a serial controlled item in a serial control number range, and you are modifying the quantity for this transaction line, you can modify the range that is being returned, within the original range entered.
* You can only modify a range beginning with the starting serial number in the original range or ending with the ending serial number in the original range. You cannot move a range from the middle of the original range.
* For example, if the range were 0001 to 0009, you could move 0001 to 0004, or 0008 to 0009, but you could not move 0004 to 0007.
* You cannot enter control numbers for controlled items in non-controlled quarantine locations.
6. In the Return Qty field, you can modify the quantity being returned to the vendor on this transaction line. The quantity entered here must be less than the original quantity.
* If you reduce the quantity entered here, the remaining quantity will be entered on the Open Quarantine Items Tab to be included on another transaction line.
7. In the Return Price field, you can change the price at which the quantity is being returned to the vendor. It can be changed.
* The return price defaults to the original price for the item. The original price is taken from the last price recorded on a purchase order for the item and vendor. This information can be viewed in program VEIQ, Vendor/Item History Inquiry.
* For lines created from purchase orders, the original price is taken from the purchase order line.
8. In the Ctr No field, you can enter the container number in which the transaction line will be entered. Containers are created in the lower block of this tab.
* When a transaction line is created, it is added to a container automatically. The container information can be changed in the lower block.
* To add a new container to the lower block, enter a new container number in this field and commit. When you click in the lower block, the new container will be displayed for maintenance.
* Only one container can be entered per transaction line. If you wish to split an item among multiple containers, you have to split the transaction line and enter the appropriate amount per each container.
9. In the Reason Cd field, you can change the reason code to indicate the reason the material is being returned to the vendor. The default is the original reason code entered when the material was moved to the quarantine location.
10. In the PO No and Line fields, if the item was originally entered on a purchase order for this vendor, you can enter the purchase order number and line on which the item was originally entered.
* For return to vendor transactions created from program REIE, Inspection Entry, this information is entered automatically.
11. If a voucher was created for the entered purchase order and line, you can enter the vendor's invoice number and line for the voucher in the Vendor Inv No and Line fields.
12. If a voucher was created for the entered purchase order and line, you can enter the voucher number in the Voucher No field.
13. In the Recv No and Line fields, if the item was originally received on a receiver for this vendor, you can enter the receiver number and line on which the item was originally received.
* For return to vendor transactions created from program REIE, Inspection Entry, this information is entered automatically.
14. In the SV Master ID and Line field, if the item was originally returned to inventory on a service warranty transaction, you can enter the service warranty transaction number and line on which the item was returned.
* For return to vendor transactions created from program SVMM, Service Master Maintenance, this information is entered automatically.
15. If a customer returned the material, you can enter the customer's sales order number and line in the Order No and Line fields.
16. In the Cust No field, enter the customer number to which the material was sold and from which it was returned.
17. In the Return UM field, enter the unit of measure by which you are returning the item to the vendor.
18. In the Conv field, enter the unit of measure conversion factor for the return unit of measure.
19. In the Purch UM field and the Sales UM field, if the purchase order number or sales order number was entered, these fields display the units of measure from the purchase order and sales order.
20. You can press the [Split Line] button to create another transaction line for the same quarantined item. You must manually maintain the return quantities.
* You would want to do this if you were entering multiple shipping containers for the same return item.
21. To remove a transaction line, select the desired transaction line and press [Delete Record]. The transaction line will be removed from the transaction and added to the Open Quarantine Items Tab to be assigned to a different transaction.
1. The container information for the return to vendor transaction is displayed in the lower block. Multiple transaction lines can be assigned to the same container, but multiple containers cannot exist for the same transaction line.
2. To assign a transaction line to a container, enter the desired container number in the Ctr No field for the transaction line.
* If the container does not yet exist for the transaction, it will be created in the lower block, and the container ID will be automatically generated. You can maintain the information for existing containers.
3. To create a new container in the lower block, click in one of the empty container records, or move to the lower block and press [New Record].
4. In the Container No field, enter the container number for the new container in which items will be shipped. You can enter numbers from 1 to 99 in this field.
5. In the Container ID field, enter the container ID. This number will be generated by the system if you do not enter a container ID.
* If you have a tracking number for the container from a vendor carrier company such as UPS or Federal Express, this is where you would enter the tracking number.
6. In the Container Type field, enter the container type for this container. Container types are entered in program ICCT, Container Type Maintenance.
7. If you enter a container type, the length, width, and height for the container will be entered from the container type record in program ICCT, Container Type Maintenance, but can be changed.
8. In the Empty Wt field, enter the empty weight of the container. If you entered a container type, this will default from the container type record in program ICCT, Container Type Maintenance, but can be changed.
9. In the Gross Wt field, enter the gross weight of the container. This is the weight of the container when it has been filled.
10. In the Net Wt field, enter the net weight of the container. The net weight of the container is calculated as the gross weight - empty weight.
11. In the Pack Dt field, enter the date on which the container was packed. This date defaults to the date on which the container was created, but it can be changed.
12. In the Freight Inv field, enter the freight charge for this container. These amounts will be summed and entered in the Freight Cost field in the header.
1. When you click on this tab, the currently selected return to address will be displayed from program VEMM, Vendor Master Maintenance.
2. Make any desired changes. When you are making changes here, you are also changing the main record in program VEMM, Vendor Master Maintenance and any other return to vendor transactions using the same return to address.
3. To enter a new record, press the [Clear and Enter New] button. This will clear the current record and allow the entry of a new return to address for this vendor to be used on this transaction.
4. To copy the existing record to a new return to address code for use on this transaction, press the [Copy and Add as New] button.
5. To save your changes, press the [Save] button.
6. Any new addresses entered here are added to the list of return to addresses maintainable in program VEMM, Vendor Master Maintenance.
1. Enter all transaction lines for the return to vendor transaction.
2. When all transaction lines have been entered and the return quantities are correct, press the [Confirm Pick] button.
3. The RTV Status will change to Picked, and the quantities will be removed from the quarantine location.
4. Once a return to vendor transaction has been picked, transaction lines can no longer be added to the transaction.
1. Pick the inventory.
2. In the Return Dt field, enter the date on which the inventory is shipped to the vendor.
3. In the Clipper Return Loc pop-list, select the sales location from program ARLM, Location Maintenance, that will be used as the return location for the Clippership interface.
4. Set the RTV Status flag to Shipped.
5. Press [Commit].
1. Pick the inventory.
2. In the Return Dt field, enter the date on which the inventory is shipped to the vendor.
3. In the Clipper Return Loc pop-list, select the sales location from program ARLM, Location Maintenance, that will be used as the return location for the Clippership interface.
4. Press [Clipper]. The information will be written to the Clipper table, and the status will be set to Shipped.
1. When the inventory has been shipped, press the [Voucher] button.
2. An accounts payable batch will be created in program APVM, Voucher Entry/Maintenance, using the letters RTV and the RTV number as the batch ID.
The voucher number is created using the voucher auto-number feature set up in program APEM, AP Enterprise Maintenance.
For example, suppose a return to vendor transaction is entered for an item. The RTV number is 140. When the [Voucher] button is pressed, the batch is created in program APVM, Voucher Entry/Maintenance, with the following information:
* The batch number is RTV-140.
* The voucher number calculated by program APEM, AP Enterprise Maintenance, is 4879.
The system will assign an invoice number to the vouchers. The invoice number is created as the Vendor RA number.
The vouchers can be maintained in program APVM, Voucher Entry/Maintenance.
3. The vendor's account distribution code is used for the voucher general ledger distribution.
* If the vendor does not have an account distribution code, the voucher is entered with a value of 0 and is out of balance until the user updates it manually.
4. When the RTV_AUTO_CLOSE parameter is set to Y in program MURM, Initialization Parameter Maintenance, the status will change to Closed automatically after the voucher is created.
1. On the Print Select Tab, all existing return to vendor transactions are displayed to allow you to maintain the print flags.
2. The Print Flag determines whether the return to vendor transaction will print when program RTVR, Return to Vendor Report, is run.
* To set the flag to on for all displayed return to vendor transactions, press the [Select All] 
button.
* To set the flag to off for all displayed return to vendor transactions, press the [Deselect All] 
button.
3. The Print Pick flag determines whether a pick list will be printed for the return to vendor transaction with program RTVPI, Return to Vendor Pick List.
* To set the flag to on for all displayed return to vendor transactions, press the [Select All] button.
* To set the flag to off for all displayed return to vendor transactions, press the [Deselect All] button.
4. The Print Pack flag determines whether a pack list will be printed for the return to vendor transaction with program RTVPA, Return to Vendor Pack List.
* To set the flag to on for all displayed return to vendor transactions, press the [Select All] button.
* To set the flag to off for all displayed return to vendor transactions, press the [Deselect All] button.
On the OOB Items tab, items where the item location quantity does not match the quantity listed in this program for the item, bin location, and control number.
* Double click on the item number field to display the item on the Open Quarantine Items tab.
* Double click on the bin location to display all items in that bin location on the Open Quarantine Items tab.
Click on the [ICPI] button to view the inventory transactions for the item, including the historical sequence, transaction type, transaction quantity, transaction date, and reference order.
* To create a record on the Open Quarantine Items tab for the item and quantity, set the Create QIT flag to on. This allows you to correct the balance when someone else has accidentally deleted the record on the Open Quarantine Items tab.
Press this button to change the status of the return to vendor transaction to Shipped, and to write the return to vendor transaction information to the Clipper table.
Press this button to move the return to vendor transaction lines to the new return to vendor transaction.
Press this button to clear the current record and allow the entry of a new return to address for this vendor to be used on this transaction.
Press this button to clear all lines where both the original quantity and the return quantity are zero.
Press this button to change the status of the return to vendor transaction to Picked and to remove the return quantities from inventory.
Press this button to copy the existing record to a new return to address code for use on this transaction.
Press this button to set the flags below it to off for all displayed return to vendor transactions.
Press this button to view the inventory transaction log for the item.
Press this button to save your changes to the return address.
Press this button to set the flags below it to on for all displayed return to vendor transactions.
Press this button to split this transaction line into two transaction lines. The new transaction line will have a return quantity of 0, so the return quantities on both transaction lines have to be maintained.
Press this button to create a credit AP voucher for the return to vendor transaction.