Processing Inventory Transactions

TabWare provides several windows for recording storehouse activity and keeping accurate balances on inventory records. As an activity occurs, the system creates a transaction record as an audit trail for tracking what has occurred. Some of the more popular transactions include material issues and returns to stock, purchase order receipts, and cycle count adjustments.

Transaction Types Created by TabWare

Depending on the specific modules your site uses, you can view transactions that TabWare creates for tracking activity. The following modules trigger transactions: Inventory, Purchasing, Purchasing Interface, and Invoice Matching.

The following table contains a list of transactions available for viewing from the Stores Activity Search window.

Module

Transaction Description

Tran ID

Note

Comments

Inventory

Receipt

Xrecp

 

Purchase order item received. Negative quantity entered for items returned to vendor.

Inventory

Issue

Issue

 

An item has been withdrawn from inventory and issued to a requester. Also includes transactions created from receipts window for auto issue on receipt.

Inventory

Return

Rturn

 

A stores item, previously issued, has been returned to inventory.

Inventory

Restock repairable part

Restk

 

An item has been repaired and returned to inventory.

Inventory

Adjustment

Adjst

 

Cycle count activity has occurred. The adjustment reflects the difference between the actual bin count and the balance on-hand shown by TabWare.

Inventory

Manual change to item unit cost

Price

 

The unit cost for an item has been changed using the Item Notebook. A pair of transactions created for old and new prices.

Inventory

Transfer request issue

Triss

 

Used only if Multiple Warehousing is on, an item is issued against a transfer request.

Inventory

Transfer request receipt

Trrec

 

Used only if Multiple Warehousing is on, an item is received against a transfer request.

Inventory

Move material from "in receiving" to a bin

Binng

 

Material is moved from status in receiving to a bin and the quantity on hand is incremented.

Inventory

Move from one bin to another

Bibo

 

Item is moved from one bin into another. Quantity in the source bin is reduced and quantity in the target bin is increased by the same amount.

Inventory

Return for Repair

RFRpr

 

Repairables Tracking Only – A  repairable item is returned to the repair shop to begin the repair process.

Inventory

Issue for Repair

IssRp

 

Repairables Tracking Only – Repairable item is issued for either inside or outside repair.

Inventory

Restock Credit

Rstkc

 

Repairables Tracking Only – Restock of the repairable item.

Inventory

Restock

Rstk

 

Repairables Tracking Only – Restock of the repairable item, debit the issuing work order, credit the repair work order (if used).

Inventory

Repair Credit

Rcrdt

 

Repairables Tracking Only – done at time of original Issue for clients using the accounting option of Create credit memo at time of Issue found in the Repairables Setup window.

Inventory

Scrap

Scrap

 

Repairables Tracking Only – Repairable item has been scrapped rather than repaired.

Purchasing Interface

Order request received by purchasing system

Xorr

 

The client’s purchasing system acknowledges receipt of an order request.

Purchasing Interface

Order request canceled or unapproved by purchasing system

Xorc

 

The client’s purchasing system has canceled or canceled approval for an order request.

Purchasing Interface

Purchase order issued (released) by client’s purchasing system

Xpoi

 

The client’s purchasing system has issued a purchase order.

Purchasing Interface

Purchase order item has been canceled by client’s purchasing system

Xpoc

 

The client’s purchasing system has canceled an item from a purchase order.

Purchasing Interface

Purchase order item received by client’s system

Xrecp

 

A client system has reported receipt of a purchase order item.

Purchasing Interface

Invoice posted to TabWare

Xinv

 

Client’s accounts payable system has notified TabWare of a new invoice.

PurchasingInterface

Invoice price variance

Xvar

2

Client’s account payable system has notified TabWare of unit price variance.

Purchasing

Change Order for unit cost change

Cord

 

Change order processed for unit cost change.

Purchasing

Cost variance when change order changes unit cost

Cvar

 

Created in conjunction with Cord transaction to show variance on unit cost change.

Invoice Matching

Invoice entered to TabWare

Xinv

1

Invoice entered to Invoice Notebook and selected for payment.

Invoice Matching

Invoice price variance

Xvar

1

Unit price variance between purchase order and invoice.

Invoice Matching

Discount on supplier invoice

Xdsc

1

Discount taken on supplier invoice.

Invoice Matching

Taxes on supplier invoice

Taxes

1

Taxes entered to supplier invoice.

Invoice Matching

Freight on supplier invoice

Frght

1

Freight entered to supplier invoice.

Invoice Matching

Accrued tax on supplier invoice

Accr

1

Accrued tax entered to supplier invoice.

Invoice Matching

Accrued tax on freight from supplier invoice

Faccr

1

Accrued tax on freight.

Invoice Matching

Taxes on freight from supplier invoices

Ftax

1

Taxes on freight on supplier invoice.

 

 

 

 

 

Note: 1 indicates that the invoice status is Selected for Payment when the transaction is being created. 2 indicates that a transaction is not created for service contract purchase orders.

The following topics provide information about processing inventory transactions.

Using the Stores Activity Search Window

Defining the General Ledger Setup for the Microsoft Dynamics GP Interface

Generating External Reports

Issuing Inventory Items

Returning Inventory Items

Restocking Repaired Items

Receiving Purchase Order Items