Summary

Follow this process to enter manual inventory transactions to issue, receipt, transfer, return to vendor, return to stock, or return inventory to stock used. If you are going to import transactions into the batch, follow the Import Inventory Transactions process before manually entering additional inventory transactions.

Step by Step

1     Open or create a new Inventory Transactions batch.

• Open the Inventory Transactions Batches window (IC> Inventory Transactions). The Batches window will display all the open Inventory Transactions batches.
• Select a batch and click DETAILS to open the selected batch.
• Select a batch and click the Delete button to delete the selected batch. Any uncommitted data in the batch will be deleted.
  • If the batch was created by another process, such as a committed PO Receiving batch, your ability to delete the batch will be limited.
• Click the Create New Batch button to create a new batch. This will open the Create Batch window.
  • If there are open batches in the Inventory Transactions process, you can create a new batch without affecting the open batches.
• The Batch Month and Batch Year fields default to the current date and are used for reference only and are not necessarily the fiscal month and year the transactions in the batch will be posted to.
• Click the Create New Batch button to create the new Inventory Transactions batch.

2     Open the Batch Overview page.

• The Batch Overview page provides a general overview of the selected batch.
• The left navigation menu displays all the steps in the Inventory Transactions process.
• In the main section you'll see information about batch steps that are currently processing, next available batch steps, and the last completed batch step.
  • Batch steps that are currently processing will display a blue indicator bar to alert you that the step has not yet completed.
  • Once the preceding batch step is complete, the next available batch steps will be enabled and you can select the next step you would like to run.
    • While some batch steps are optional, any batch step that includes the Required tag   must be completed before the batch is allowed to proceed through to the Commit step.
• The Batch Outputs section on the right will display any reports or exports that have already been generated in the Inventory Transactions process.

3     View the existing transactions.

• The Enter Inventory Transactions (IC> Inventory Transactions> Enter Transactions) window will display all inventory transactions in the batch. If this is a new batch or there are no transactions in the batch the window will be empty.
• Select a transaction and click EDIT to open the Edit Transactions window.
• Select a transaction and click DELETE to delete the selected transaction.
• Click PERSISTENT FIELDS to open the Set Persistent Fields window.
  • The Set Persistent Fields window is used to specify individual transaction fields that will populate with the same information as the previously entered transaction. For example, if you are receiving a number of items of the same category and with the same transaction description, check the Action, Category, and Transaction Description toggles on the Set Persistent Fields window. Each time you save transaction and create a new one, the action, category, and transaction description information will carry over.
• The REVERSING TRANSACTIONS and RETURN TO STOCK TRANSACTIONS buttons are covered in other topics.
• Click CREATE TRANSACTION to enter a manual inventory control transaction. This will open the Create Transaction window.

4     Enter the item number.

• Enter an item number in the Item Number field or click the field search button   to select one from a list.
  • After you enter an Inventory Item the fields in the Quantity section on the right will populate with the Inventory Item information. The fields in this section will contain future transactions in order to give the user a way to see what the final effect of a transaction will be, even if it is not the latest transaction.
  • Click on the PO Quantity or Requisition Quantity field open button to view the transaction detail that created the quantity values. This allows you to open the purchase order or requisition that contributed to the Adjusted Quantity.
  • Click the Pending PO Quantity field open button   to view the pending transactions that are also contributing to the Adjustment Quantity.
  • The WO Quantity field has not yet been implemented.
  • The On Hand Quantity field in this section does not include uncommitted transactions, but the On Hand Quantity field in the Item Maintenance window (IC> Maintenance> Item> Quantity and Value tab) includes uncommitted transactions. If there are uncommitted inventory transactions on the item, the Quantity On Hand fields of these windows will not be the same.
  • The Outstanding Quantity field will display the expected quantity changes associated with any outstanding, uncommitted inventory transactions on the selected inventory item.
  • The formula for the Adjustment Quantity field is:

• The value in the Available for Issue field is limited to the number of items currently on hand.

5     Edit the Inventory Transaction details.

• The Tab Ordering button is used to customize the order in which the inventory transaction fields are displayed.
• The Transaction Date and Transaction Time fields will update with the current date and time but the values in these fields can be edited.
  • This field is very important because it determines the order of costing when using LIFO or FIFO costing.
  • If you are posting inventory transactions to a previous fiscal period, make sure the date and time fields are correct. Otherwise current fiscal period transactions could be used in the costing of previous period transactions.
  • If you are posting the transaction to a date and time prior to other transactions on the inventory item, the existing transactions could be recosted.
  • Verify the values in these fields are correct.
  • You cannot enter a transaction time that is the same as a transaction that already exists on the inventory item.
  • If you are entering Project Management information, the Transaction Date field will be the transaction date of the Project Management information.
• Use the Action drop-down menu to select an inventory transaction type. The options are Issue, Receipt, Return to Stock Used, Return to Vendor, or Transfer.
  • Issue will deduct the inventory items from inventory. If you have set up the Work Order module to interface with the Inventory Control module you will be able to associate a work order with this transaction.
  • Receipt will place inventory items into inventory.
  • Return to Stock Used will place inventory items into inventory.
  • Return to Vendor will deduct inventory items from inventory and give you the option to create a credit memo in Accounts Payable for the vendor of the inventory item.
    • Click the Receipt Date/Time field search button to select the inventory item receipt. You will not be able to create a return to vendor inventory transaction without selecting a receipt.
  • Transfer will move inventory items from one location to another.
    • Both the From Location and To Location will need to be specified when creating a Transfer.
    • The Transfer action is not available when editing a previously saved transaction.
  • The selection in this field will determine which fields in the window will be enabled.
• Enter a Category or click the field search button to select one from a list.
  • The category type will determine which account types are credited and debited by the inventory transaction. The general ledger accounts attached to the account types will then display on the General Ledger Distribution Report. The inventory transaction type selected in the Action drop-down menu will not affect how or which general ledger accounts are affected by the transaction.
  • Categories can be associated with actions on the Category Maintenance window (IC> Maintenance> Category Maintenance). If the selected category is not associated with the action selected in the Action drop-down menu, you will receive an error message when you try to save the inventory transaction.
  • If a work order is attached to the inventory transaction below, the IC Transaction Category associated with that work order will automatically populate the Category field.
  • If a project driven general ledger account is attached to the account type that is attached to the selected category, then you will be required to enter valid project information in the Project Management fields on the window.
    • If the Project Management fields are not enabled in the window you can enable them during the IC Module setup step (IC> Utilities> Setup Inventory Control> Options section> PM Interface toggle).
    • If you do not want to interface the IC module with the Project Management module, you must then uncheck the Account is Project Driven toggle (GL> Maintenance> Chart of Accounts> Account Information section) to process the transaction.
• Enter a description of this transaction in the Transaction Description field.
  • This field will default to the description of the inventory item selected in the Item Number field above. This field can be edited and can accommodate up to 50 characters.
• Select the inventory locations that will be affected by the transactions in the From Location and To Location fields.
  • Enter a From and To Location if the inventory transaction is a Transfer.
  • Enter a To Location if the inventory transaction is a Receipt or Return to Stock Used.
    • If a default location is specified on the selected Item, the To Location field will automatically populate with that location.
  • Enter a From Location if this is an Issue transaction.
    • If a default location is specified on the selected Item, and if the quantity of items in that location is greater than zero, the From Location field will automatically populate with that location.
  • The From Location and To Location fields will be disabled for Return to Vendor transactions.
• Enter a Quantity and select the Unit field. If the Unit field has a multiplier attached to it, the unit quantity in the Actual Quantity field will be the Unit Quantity multiplied by the Unit multiplier.
• Enter a Unit Price. This field will not be enabled on issue, transfer or return to vendor inventory transaction types.
• Click the PO number displayed in the Purchase Order field to view the purchase order attached to the Inventory transaction.
  • The Purchase Order field will never be enabled and will only contain a purchase order number if the inventory transaction has been created in the Purchase Order module.
    • Purchase Orders can be received in PO> Receiving. This option will only be available on the Purchase Order drop-down menu if the Receive order through PO toggle is checked (PO> Utilities> Setup PO).
    • The window will also display if the purchase order has been invoiced in the Accounts Payable module.
• The Reference Number field is used to enter a work order reference number.
  • This field will only be enabled if the Require unique reference number toggle is checked on the WO Setup window (WO> Utilities> Setup).
    • Unique reference numbers can help Cirrus users easily attach work orders to IC Inventory Transactions without having to remember specific work order numbers or use the work order selection window.
  • If this toggle is not checked the Reference Number field will not be enabled. If a reference number is attached to the work order selected below, that reference number will automatically populate.
• The Receipt Date/Time field is used to specify the receipt that will be associated with a Return to Vendor transaction.
  • When creating a Return to Vendor transaction, you must specify a receipt. Click the field search button   to select a previously received inventory transaction.
• Enter a Task and Type Code if the Project Management module interfaces with the Inventory Control module.
  • The Project Management module is set up to interface with the Inventory Control module on the IC Setup window (IC> Utilities> Setup Inventory Control> PM Interface toggle).
  • These fields will only be available on Issue and Return to Stock Used transactions types.
• The Vendor Number field is used to specify a vendor that will be associated with a Return to Vendor transaction.
  • This field will automatically populate with the vendor number attached to the Receipt selected above.
• The AP Batch field is used to specify an uncommitted Accounts Payable Invoices batch.
  • The credit memo generated when processing a Return to Vendor transaction will be included in this AP Invoices batch.
  • If you would like to add the credit memo to a new AP Invoices batch, create a new batch and select it before saving the new transaction.
• The Equipment Code field is used to associate the transaction with an existing WO equipment record.
• The Created By field will display the Cirrus user name of the user that created the transaction.
• Check the Create Credit Memo toggle to create a credit memo from the return to vendor transaction. This will create an invoice with a negative amount in AP> Invoices.
• The Totals section to the right will display the quantity and value details associated with the transaction.
  • The Actual Quantity, Actual Units, and Actual Unit Price fields will automatically populate with the details specified to the left.
  • Enter any applicable Discount, Tax or Shipping/Handling amounts. These fields will affect the fields in the Total section below and should be verified before saving.
• Click the Save button when complete. The transaction has now been created but not committed.
  • When creating a new transaction, all fields other than default/persistent values will clear and you can proceed to the next new transaction.
  • When editing an existing transaction, this will return you to the Enter Inventory Transactions window.
• You will receive an error message if there are inventory issue transactions in uncommitted inventory transaction batches that will result in a negative on-hand quantity for an inventory item.

6     Calculate the inventory transaction values.

• Open the Calculate Values window (IC> Inventory Transactions> Calculate Values).
• The Calculate Values step will generate the new inventory values that will result from committing the batch.
• Click the Submit button to calculate the transaction values.
  • You will be notified of errors resulting from the calculation process and prompted to open detailed error messages in the jobs viewer.

7     Commit the Inventory Transactions batch.