|
|
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.
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
Receiving Purchase Order Items