Inventory

Overview

Managers can record inventory in Unanet to track items. Project Managers and Accountants can easily access the quantities of stock in inventory using the Project Inventory report. The items tracked in Unanet can be used with an integrated inventory system, which is the system of record.

If the Use Inventory (unanet.inventory.enabled) property is enabled, the following functionality will be available:

• The master item inventory list can be exported from Unanet to an integrated inventory system.
• The Inventory record can be accessed by an associated Project.
• The Inventory record can be included in reports.
• The Inventory records will be included in general ledger transactions.

This functionality is available with the Project Financials family of Unanet licenses.

Setup Inventory Items

Administrators set up the inventory items on the Setup Items page to capture the manufacturer's part number and SKU. This information can help in tracking the items on the general ledger.

Setup Posting Groups

In order for the journal entries resulting from inventory transactions to be recorded to the correct accounts, Administrators set up the account posting groups on the Setup Posting Groups page. There are three account categories related to inventory:

• Inventory Asset Account
• Inventory Payable Account
• Inventory Shrinkage Account

Setup User Defined Fields

Inventory records can display user defined fields to include data from inventory systems that is not currently stored in Unanet. See Setup User Defined Fields for more information. These are displayed on the Project Items >> Inventory page when you view the item details.

Project Inventory Items

Managers can view the list of inventory items related to a project (see Project Items >> Inventory). From that page they can also view the purchase order transaction details related to those items.

Project Inventory Report

Managers can report on inventory related to their projects using the Project Inventory report.

Item Import / Export (Master and Project)

The item import and export includes the new inventory fields:

• SKU
• Manufacturer's Part Number
• Inventory Flag

Financials

Project Managers can pay for inventory on the Vendor Invoice (VI) before it is used on the project.

Note when the Use Inventory (unanet.inventory.enabled) property is enabled: If the account is already populated for the VI line item, and the account has Transactions Require Project checked, then only non-inventory items are available (those not marked as Inventory Item on Setup Items page). Conversely, if the account does not require a project, then only inventory items are available.

Project Managers can also add Item details to the Journal Entries.