The Transactions tab can be a very useful tool when tracing the history of stock. It not only shows records of every single action against stock (eg. purchase, sale, transfer, etc.), but also the inter-relationships between the records themselves. It is a very powerful audit trail of what has transpired on that stock record.
Relationship between records
Everything in stock transactions is linked back to purchase orders (PO# and POLine# columns), except when sold in advance. In this case PO# and POLine# will show -1 in both columns.
When selling, transferring, adjusting down or returning stock to vendor, all of these transactions will link back to the original purchase order via the Link Tran column. For example, in the image below see that the highlighted sale was sold from purchase order #5 – sales Link Tran has value 2880 which is the same as the Tran# of the purchase order.
When transferring stock to another location, Jim2 will split the original purchase transaction and will also link the transfer back to the purchase order. In the example below there were 3 units purchased originally and 1 transferred to another location:
A return from customer will link back to the sales record (Link Tran 2268 on return from customer line links to Tran# on sale record):
Link General Ledger column
Use the Link GL column to find the linked general ledger transaction in the Transaction Journal.
The Transactions tab grid will show information relating to purchases, sales and transfers of that stock, including a quantity balance of that transaction.
This grid applies the stock sold or transferred to the purchase order they relate to. This is useful when stock is being purchased at different cost prices. Using this grid, locate the correct cost prices of the stock by viewing the purchase order.
Where serial numbers are not required on either purchase or sale, only one line will be shown per transaction. As a result, the Serial Number column is usually hidden. In this image, the Serial Number column shows.
Where a particular stock has been set up with serial numbers, either on purchase (and therefore sale) or on sale only, a separate line will be shown for each relevant transaction. For the stock shown below, serial numbers are only required on sale, so the two pieces purchased on on Tran# 122 are recorded together on one line, whereas the sale of two pieces on is shown on two separate lines, each showing one serial number.
|
•Right click in the grid and select Show All which will load all transactions to the screen (Jim2 loads the last 1,000 records by default). •Use filters to narrow down the results – hover over the column header and click the filter  |
Right click on any transaction line to view the related transaction. eg. purchase, transfer, sale, job.
Right click Transfer in the Type column to view any related stock transfer.
|
Up to 50 characters can be entered as a Serial Number. In the Stats and Transactions tabs, re-size the Serial field to display the entire serial number. |
The Transactions tab displays stock on hand and stock required quantities by purchase order, job, adjustment and return from customer. It can also show a history of transactions relating to this stock code by right clicking on the list and choosing Show All.
To understand this tab, users need to understand the terms Reserved and Line Reserved.
Reserved refers to job reserve, a feature which allows users to select Reserve Stock and lock up all the stock in a job so other users cannot steal the stock for another job.
In the process, Jim2 selects which purchase order the stock will be coming from (according to FIFO or serial number rules) and therefore knows the actual cost of that stock. Once job reserve is set, the purchase order balance in this screen will now be reduced.
Line Reserved refers to a feature which allows users to set a priority for this stock for this job but at this point, Jim2 doesn’t select which purchase order the stock will be coming from, and therefore doesn’t know the actual cost of that stock. This is performed by right clicking on the stock line and choosing Reserve Stock.
Field |
Explanation |
|---|---|
Tran# |
This is an internal Jim2 transaction number. |
Date |
This is the invoice or modified date of the job, or the invoice date of the purchase order, or the last time the purchase order was saved. The date variation depends on whether the transaction has been received, finished, invoiced, etc. |
Type |
This refers to what type of transaction is involved. The type also includes a notation indicating what level of commitment, reserving or line reserving is involved, where Sale (job) is the type. Note that purchase includes consign buy purchase orders. Stock within packages will not show as committed because it already cannot be used. |
Ref# |
This indicates the document number involved. For instance, if the type is a Purchase and the Ref# is 7, the purchase order number for that transaction is 7. |
Serial |
Where serial numbers are not required on either purchase or sale, only one line will be shown per transaction. As a result, the Serial Number column is usually hidden. |
Loc. |
This refers to which location the stock has been received into, or sold from. |
Qty |
This is the quantity used in that transaction. |
Qty Bal |
This refers to: a.the quantity of stock still available for sale (where purchase, transfer po, or ret. customer is the Type), or b.the quantity invoiced (where Sale is the Type), or c.the quantity on back order (where the Sale is the Type and the notation is Committed), or d.the quantity selected from a purchase order (where Sale is the Type and the notation is Reserved or Line Reserved), or e.the quantity adjusted down (where Adjustment is the Type). |
PO# |
This refers to the adjustment, purchase order, or return from customer number |
PO Line# |
This indicates which line of the document the stock is listed on. |
Job# |
This indicates the active job that stock is linked to from a purchase order. |
Link Tran |
This indicates which Tran# the line is linked to. Right click and choose to view the relevant object. |
Link GL |
Provides a transaction number, which can be used when searching the Transaction Journal list (Accounts > Transaction Journal). |
Pack# |
Refers only to packaged stock codes, and displays the package configuration number for that stock. |
If stock attributes is enabled in the Jim2 licence key, tick Show Attributes to show them on the Stock On Hand tab.
|
Right clicking in this grid allows access to the sales, purchase, return or transfer documents. There are options to view the relative document, show the top 100 transactions, or show all transactions. |
View any of the listed purchase orders by right clicking on that purchase order line, and choosing View Purchase # xx.
Further information