How do I return inventory?

Record inventory items that have been issued to a job or maintenance but were not used.

This routine will record a credit for the returned inventory.

Contents

Returning inventory
Changing a return inventory transaction
Deleting a return inventory transaction
Options

Returning inventory

1. Open Connect Materials Management > Inventory > Return Inventory.

2. Enter the Comments.

This field is information only. You can use the Comments field to briefly explain why the inventory is being returned.

Do you want to add a comment?

Yes, I want to add a comment. Click on the Comments field, then enter a comment (up to 50 characters).
No, I do not want to add a comment. Leave the Comments field blank.

3. Select the Return From.

The default value is set in the Organization table.

Where is the inventory being returned from?

I am returning inventory assigned to an account. Select Account from the Return From drop-down list. Then, enter the GL Activity (optional).
I am returning inventory assigned to a job. Select Job from the Return From drop-down list. Then, enter the Job Number, Project, and GL Activity (optional).

4. Enter the Inventory Number.

This is the number assigned to the item that you want to return to inventory.

5. Select the Location.

This is the physical address where the returned inventory will be sent.

Where do you want to return the inventory?

I want to return the inventory to the default location. The default location is set in the inventory record. Continue to the next step.
I want to return the inventory to a different location. Select a different option from the Location drop-down list.

6. Enter the GL Account.

A GL account is an account in the General Ledger that records credits and debits.

Do you know the GL account to return the inventory to?

Yes, I know the GL account. Enter a GL account in the GL Account field.
No, I do not know the GL account. You can use the GL account drop-down list to view the GL accounts related to the selected inventory items, or click Search.

7. Enter the Quantity.

The quantity is the number of items returned.

8. Enter the Unit Cost.

The default unit cost displays in the Unit Cost field.

Is the correct unit cost for the returned inventory displayed in the Unit Cost field?

Yes, the correct unit cost is displayed. Continue to the next step.
No, the unit cost is not correct. Click on the Unit Cost field and type in an amount.

9. Enter the Total Cost.

Total Cost = Quantity x Unit Cost

Is the total cost correct? Total Cost = Quantity x Unit Cost

Yes, the total cost is correct. Press Enter again to save the transaction. The saved transactions display in the grid that is located at the bottom of the form.
No, the total cost is not correct. Click on the Total Cost field and type in an amount. Press Tab to update the Unit Cost field. Unit Cost = Total Cost / Quantity

10. Press Enter to save the transaction.

The item is returned to inventory.

Changing a return inventory transaction

Update the properties on transaction that records returned inventory.

Has the transaction been updated to the General Ledger or Project Accounting?

Yes, the transaction has been updated to the General Ledger or Project Accounting. Use Connect Materials Management > Inventory > Adjust Inventory to edit the transaction.
No, the transaction has not been updated to the General Ledger or Project Accounting. Use Connect Materials Management > Inventory > Return Inventory in Edit mode to update the transaction. Make sure to enter the input date that was used to record the transaction BEFORE you switch to Edit mode (CTRL+E). Then, select the transaction from the grid, located at the bottom of the form.

What if I need to edit a transaction that was entered in Split mode?

When you make changes to the job number or project, the same change will be applied to all of the sequences that belong to the same reference number.

Deleting a return inventory transaction

Remove a transaction for returned inventory from the database.

What do you want to do?

I want to abort the current transaction. Click Delete (CTRL+D).
I want to delete a saved transaction that has not been updated to the General Ledger. Click Delete (CTRL+D). When the Delete Returned Transactions form displays, set up the form options and enter the reference number or reference numbers. What if I don't know the reference number? Use Redisplay (CTRL+Shift+F3) to search for reference numbers.
I want to delete a saved transaction that HAS been updated to the General Ledger. Use Connect Materials Management > Inventory > Adjust Inventory to reverse the saved transaction.

Options

Comments

This field is information only. A comment is a note explaining or illustrating the meaning or purpose of a transaction. The note is saved with the transaction and you can view it using Inquiry and it can be included on some reports.

Do you want to add a comment?

Yes, I want to add a comment. Click on the Comments field, then enter a comment (up to 50 characters).
No, I do not want to add a comment. Leave the Comments field blank.

GL account

A GL account is an account in the General Ledger that records credits and debits

Do you know the GL account to return the salvaged inventory to?

Yes, I know the GL account. Enter a GL account in the GL Account field.
No, I do not know the GL account. You can use the GL account drop-down list to view the GL accounts related to the selected inventory item, or click Search.

GL activity

A GL Activity refers to a user-defined code that is created in Connect General Ledger for reporting resources and transactions. The GL activity code can report on subsystems that are interfaced to the Connect General Ledger. This interface provides an efficient means of tracking and reporting on a GL activity code.

If you want to use GL activity codes, do this first.

Turn on the interface to Connect General Ledger. This option is located in Organization > Organization > Interfaces tab. If more than one application interface is available, you may need to navigate to the General Ledger subtab. This makes the field for GL Activity available for you to fill in.
Set up the GL activity in the Connect General Ledger. Open Connect General Ledger > Setup New Activities. This is the code that you'll use to fill in the GL Activity field.

Input date

The input date is the date the system will use to record the salvage inventory transaction.

Do you want to use the current date as the input date?

Yes, I want to use the current date as the input date. The default date is the current date. Continue to the next step.
No, I want to use a different date as the input date. Click on the Input Date field, and then enter a MM/DD/YYYY.

Inventory number

An invoice number is a number that is assigned to an itemized list of goods shipped that usually specifies the items, quantity, price, and terms of sale.

What is the invoice number?

I have the invoice number. Use the Invoice Number field to type in the invoice number that is assigned to the invoice.
Help me find the invoice number. You can Search (F9) this field to show a list of previously entered invoice numbers.

Job number

A job number refers to a user-defined code that is created in Connect Project Accounting for reporting resources and transactions associated with a specific job.

What is the job number?

I know the job number. Use the Job Number field to enter it.
Help me find the job number. Click Search, it's located at the end of the Job Number field.

Location

This is the location where the inventory is returned.

Where do you want to return the inventory?

I want to return the inventory to the default location. The default location is set in the inventory record. Continue to the next step.
I want to return the inventory to a different location. Select a different option from the Location drop-down list.

Options

Use Options (F12) to modify the routine's properties.

Do you want to print the materials returned ticket after each entry? All of the options, listed below, will create a returned record transaction.

I want to print the materials returned ticket after each entry. Click Options (F12). Select Print from the Print Materials Returned Ticket When Created drop-down list. Then, select a form title from the Materials Returned Ticket Report Title field.
I want to preview the materials returned ticket after each entry. Click Options (F12). Select Print Preview from the Print Materials Returned Ticket When Created drop-down list. Then, select a form title from the Materials Returned Ticket Report Title field.
I want decide when to print the materials returned ticket. Click Options (F12). Select Prompt Each Time from the Print Materials Returned Ticket When Created drop-down list. Then, select a form title from the Materials Returned Ticket Report Title field.
I do not want to print the materials returned ticket. Click Options (F12). Then, select No from the Print Materials Returned Ticket When Created drop-down list.

Print form

Use Print Form (CTRL+P) to reprint the materials returned ticket for a specific reference number.

Project

A project is a large undertaking that involves more than one property

Is the salvaged inventory tied to a property?

Yes. Select the property number from the Property drop-down list.
No. Skip this field.

Quantity

The quantity is the number of items being salvaged.

What is the quantity?

Use the default quantity for the salvage transaction. This information is displayed.
Change the quantity. Use the Quantity field to edit the quantity.

Redisplay transactions

Use Redisplay (CTRL+Shift+F3) to show transactions by input date.

Return date

This is the date when the inventory is returned.

Do you want to use the current date as the return date?

Yes, I want to use the current date as the return date. The default date is the current date. Continue to the next step.
No, I want to use a different date as the return date. Click on the Return Date field, and then enter a MM/DD/YYYY.

Return from

The return from assigns the transaction to a GL account or job. The default value is set in the Organization table.

Where is the inventory being returned from?

I am returning inventory from an account. Select Account from the Return From drop-down list.
I am returning inventory from a job. Select Job from the Return From drop-down list. Then, enter the Job Number and Project.

Split mode

Use Split Mode (F11) to enter multiple entries for the same reference number, job number, and project. When Split Mode is turned on, the routine will assign the same job number and project values. When Split Mode is turned off, you will need to enter the job number and project values.

What if I need to edit a transaction that was entered in Split mode? When you make changes to the job number or project, the same change will be applied to all of the sequences that belong to the same reference number.

Total cost

Total Cost = Quantity x Unit Cost

Is the total cost correct?

Yes, the total cost is correct. Press Enter again to save the transaction. The saved transactions display in the grid that is located at the bottom of the form.
No, the total cost is not correct. Click on the Total Cost field and type in an amount. Press Tab to update the Unit Cost field. Unit Cost = Total Cost / Quantity

Unit cost

The unit cost is the price for a single item or unit.

What is the unit cost?

Use the default unit cost for the selected inventory. This information is displayed.
Change the unit cost. Click on the Unit Cost field to enter a new unit cost.