Transactions Tab

Back Top Previous Next

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.

 

stock transactions tab

 

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.
 

transactions relationships

 
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.

 

transfer link

 
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:

 

transfer po

 
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):

 

return link

 

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.

 

Stock transaction

 

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.

 

serial in stock grid

 

Tip

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 filter icon icon, then choose the required values. Multiple columns can be filtered at the same time. For example, set the filter for required stock location, then show only sale records. Sort and group to further refine the results.

filter transactions

 

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.

 

View Transfer

 

Info

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.

 

job reserve1

 

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.

 

line reserve

 

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.

 

show attributes1

 

Info

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

Buying Tab

Committed Tab

Document tab

Manufacture Tab

Notes Tab

Pricing Tab

Pricing Tab Stock Costs

Promotional Pricing Tab

Sales Tab

Stats Tab

Stock on Hand Tab

Transactions Tab

Vendors Tab

Watchouts Tab