Show/Hide Toolbars

Jim2® Business Engine Help File

Navigation: Jim2 Functions > Jobs

Job Stock Grid

Scroll Prev Top Next More

This section of the job form contains a grid that is used to record and automatically price any stock (parts, tests or labour) used in a job that will be invoiced to a customer. Price calculations are in direct relation to the price levels and price breaks (and tax requirements) as set in the customer's card file, and the stock pricing calculation as set in each stock record. The stock grid calculates the sub-total selling price, tax amount and total to be invoiced as stock is added to the grid.

 

If pre-configured in the stock tab of the Item, stock will be added automatically when an Item is selected in the Job header.

 

item stock1

 

This is commonly used when adding stock where certain conditions are imposed on the job, such as running product tests prior to selling. You can also add additional lines of stock after the Item has populated the stock grid.

 

auto add item stock

 

The fields within the stock grid are described below:

 

Field

Explanation/Usage

Date

The date the stock line was added to the job.

Initials

Initials of the user that added the stock to the job.

Status

Status allows you to record a unique status for each stock line. The type of status available will change depending on the type of stock, and uses statuses already set up in Jim2. In this example labour stock has different statuses to depleting stock.

 

job stock status

 

Note: You will be asked if you wish to update the status of the job itself – you can update, or leave it as is.

PO#

The purchase order number related to this line of stock. This will show when you have auto-created a PO from the job.

 

Note: You cannot add a purchase order number to a job – it will automatically populate on auto create.

 

warning1

Once a PO is linked to a job stock line, the unit measure cannot be changed on the job as the entire line of stock is tied to that job. To change the unit measure on the job, unallocate the stock first.

PO Due

This displays the due date of the linked purchase order at line level or purchase order header due date, if not set at line level.

 

job po due date

Location

The location of the stock you are selling – this will default to the location set in the user card file. You can change the location using the drop-down list.

Stock Code

The user adding stock must select a stock code to identify the product or service being tracked by this job. Selections can be made from the stock records via the ellipsis [...] at the end of this field, which will bring up the Stock Select screen. If the stock code is coloured red, this means that the stock is either special stock or a customer-specific order.

Description

The description of the stock code from the stock records is automatically placed in this field. You can add or change information in this field. If you have set up multiple measures for this stock, it will use the description appropriate for that measure.

 

Tip

If the stock you are selling requires a serial number either on purchase or sale, the Description field in the stock grid will include an ellipsis [...]. If the stock requires a serial number on sale, you will be able to add the stock to the job, but you will be unable to invoice the job until you have added or selected a serial number. To complete the details, select the ellipsis [...] and record the appropriate serial numbers. If you try to finish a job with missing serial numbers you will receive an option to back order. If you say no, your invoice will only be for the stock that has serial numbers against them, and the others will not be back ordered.

 

Stockdesc.browse

Unit

The unit measure for that stock code is entered here. You are able to change the unit measure type by selecting the down arrow beside the Unit field.

Order

Number of units ordered by the customer.

Supply

Number of units actually supplied to the customer.

 

Info

If the supply quantity is coloured red, this indicates that there is an action to be taken.

B. Ord

Displays the quantity on back order.

Qty Pick

Displays quantity picked – only with Advanced Warehouse Management.

Price Ex.

Actual selling price excluding tax.

Price Inc.

Actual selling price including tax.

Disc %

Allows you to enter a discount percentage.

Tax

Tax code applicable to that stock.

Hide

Ticking this box will hide that particular stock code information.

Total

Line total (Supply Qty x price including GST).

 

You can change the order of the stock lines within the stock grid via drag and drop. Click and hold the mouse in the area left of the stock line number, then drag to where you require the line to sit.

 

rearrange stock lines

 

Sell Details

sell details

 

Sell details are automatically added or updated when adding stock to a job, or when recalculating the selling price. The sell details show the source of the selling price (Price Level, Promotion, etc.) and the source reference. The selling price is colour coded to indicate the source, and hovering your cursor over a sell price cell will display the details.

 

Sell Source

Colour

Description

Price Level

White

Sell price is as per price level set on the Job header.

Different Price Level

Pink

Sell price is based on a price level different to the price level set on Job header.

Customer Specific

Green

Sell price is as per the customer-specific price on the related stock.

Manually Entered

Yellow

Sell price has been manually entered.

Promotion

Orange

Sell price based on a promotion.

Project

Purple

Sell price is based on the price level of the related project (only if you are licensed for Managed Services or Managed Print Services editions.

Min Sale

Red

Sell price is set to the stock’s min sell price level.

 

Other Price Background Colours

Blue

This is a kit.

Pale Blue

Linked to a PO.

Red

The background colour of the B.Ord column will be coloured red if any stock is back ordered. If the Supply plus B.Ord figures do not equal the ordered quantity, both the Supply and B.Ord figures will be displayed in red.

 

Info

If the stock you are selling has been purchased specifically for the job (the purchase order stock line has a job number link), the line will show in a light blue colour in the PO and the job. If the stock you are selling is special stock, it will show with the stock code in red and also the line in light blue.

 

Right clicking in the stock grid enables several additional features, including:

 

stock grid options

 

Drop-down Selection

Explanation/Purpose

Add New

Adds a new stock line.

Delete

Deletes the line including the stock that has been added to the job.

View Purchase#

Is a hyperlink and will take you to the purchase order that was used to order the specific stock for this job.

View Stock

Is a hyperlink and will take you to that stock form. Available in Edit and View mode.

Stock Availability

This setting gives you the ability to override committed stock (ie. stock allocated to other jobs).

Auto Create Purchase Orders

This setting allows you to automatically create a purchase order. Note that linked stock is excluded from this list.

Reserve Stock

Reserving stock means that stock is exclusively held for that job and can't be sold, picked or reserved on other jobs.

Recalculate:

Recalculate current Stock price

Recalculate the line of stock. For instance, you have changed the original amount, or expenses may have been applied.

 

Note: If you have manually entered a price, select Recalculate and it will be replaced by the original price from the stock record. We recommend that you change the quantity first, then enter prices.

Recalculate current Stock price to

This will recalculate the pricing for the stock line you have selected to another price level you have set up.

Recalculate all Stock prices

Allows you to automatically recalculate stock prices to match a certain figure. For example, you have several lines of stock on a job with the total price being $2019.25. Recalculating all stock prices to match job total allows you to enter a price of, say, $1999. Jim2 will automatically adjust all prices based on their selling price so that the job total equals $1999.

Recalculate all Stock Prices to match Job total

This will recalculate all stock prices in the grid – useful if you have applied an expense to a line of stock on a particular job.

Show Serial#

In the Description field you can choose to show the serial number of the stock item.

Show Attributes

Displays stock attributes within the stock line, if applicable.

Grid Columns...

 

job grid columns

This sets up the grid columns that will be displayed in the stock grid. In expanded view, all grid columns are displayed by default.

 

expand stock grid

 

In collapsed view, the following columns are not shown:

Date

Initials

PO#

Location

Qty Pick

Disc %.

 

You can add or remove grid columns by ticking the box, then clicking Apply. Once you click OK you will be asked if you wish to update all users to the new layout as well.

 

update layout

 

 

Within the stock grid, you can search all columns and rows by selecting Ctrl+S. This will bring up the Locate value screen, where you can select which field to search and enter the text to search for in the Value field:

 

locate value job

 

Stock search facility is available from within the stock grid by selecting the ellipsis [...] in the Stock Code field (or by using the F5 function key on your keyboard). This will assist you in refining what stock will be included in the stock grid. It will show the available quantity of stock at each stock location – this may affect which stock you choose to supply. In this screen you are also able to select multiple lines of stock by specifying the quantity required of each stock record in the Select Qty column.

 

select quantity

 

You can review your selection in the Selected Stock tab.

 

select stock

 

You can also see the history relating to stock, showing what stock has been sold in the last 365 days.

 

Stock Select History

 

Further information: