Job Stock Grid

Back Top Previous Next

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, price breaks and tax requirements as set in the customer's cardfile, and the stock pricing calculation as set in each stock record. The stock grid calculates the sub-total of the 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 can be added automatically when an Item is selected in the Job header.

 

itemstock1

 

This is commonly used when adding stock where certain conditions are imposed on the job, such as running product tests prior to selling (Applies stock). More lines of stock can also be added after the Item has populated the stock grid.

 

autoadditemstock2

 

Click the arrow symbol angled in the top left corner of the grid to display all fields.

 

The stock grid area can be expanded by clicking and dragging the horizontal dots up and down. Double clicking the dots will hide the stock grid completely. Double click again to show.

 

Hidegrid

Whilst this shows an expense order, the process is the same for all objects

 

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 recording of a unique status for each stock line. The type of status available (statuses already set up in Jim2) will change depending on the type of stock. In this example labour stock has different statuses to depleting stock.

 

jobstockstatus

 

Note: A message will appear asking whether to update the status of the job itself – this can be updated or left as is.

PO#

The purchase order number related to this line of stock. This will show when a purchase order has been auto created from the job.

 

Note: A purchase order number cannot be added here – it will automatically populate on auto create.

 

warning1

Once a PO is linked to a job stock line, the unit measure cannot be changed, 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).

 

jobpoduedate

Location

The location of the stock being sold – this will default to the location set in the user cardfile. The location can be changed 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 the stock is either special stock or a customer-specific order.

Description

The description of the stock code from the stock record is automatically placed in this field. Information in this field can be changed or added to. If multiple measures have been set up for this stock, it will use the description appropriate for each measure.

 

Tip

If the stock being sold 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, the stock can be added to the job, however the job cannot be invoiced until a serial number has been entered. To complete the details, select the ellipsis [...] and record the appropriate serial numbers. When trying to finish a job with missing serial numbers, an option to back order will appear. If No is selected, the invoice will only be for the stock that has serial numbers against them, and the others will not be back ordered.

 

Stockdescbrowse

Unit

The unit measure for that stock code is entered here. If more than one unit measure type, this can be changed 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 entry of a discount percentage.

Tax

Tax code applicable to that stock.

Hide

Ticking this box will hide that particular stock line on an invoice.

Total

Line total (supply quantity x price including GST).

Vendor

The vendor the cost price was sourced from, and who a purchase will be created for when using auto create purchase order.

Manual Cost

The cost price that will be used in job profit calculations. This will be used when using auto create purchase order.

 

This is an amount that will be entered by a user, ensuring the costs carry through and ignoring what is on the stock code.

Est. Cost

The estimated cost price of each line of stock or service, excluding tax.

Cost Total

The total cost price of each line of stock or service, excluding tax.

Markup %

Percentage markup.

Total Ex. $

Total cost ex GST.

Comm Floor

Used when calculating commission based on profit. If a commission floor cost is entered, profit calculations will use this value rather than the actual cost. For example: cost $1,000, actual cost $945, profit is based on $1,000 floor cost.

Comm%

Percentage of commission to be paid, depending on commission method: price inc, price ex, or profit.

Comm Extra$

A flat dollar amount paid per stock sold. For example, $100 for every XYZ sold.

Note: Commission components can be combined. For example, 10% commission of profit based on floor cost plus extra $10.

 

The order of the stock lines can be changed 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 the new position.

 

rearrangestocklines

 

When you have stock that is available but your are supplying 0 and is on back order, the following screen will pop up for you to decide what you would like to do:

 

stockpopup

 

Stock grid price background colours

stockgridcolours

 

Info

Note: The yellow background in Status indicates there are choices to be made there.

 

Tip

Hover over the coloured fields and Jim2 will pop up an explanation of the colour meaning:

 

hoverpopup

 

Within the header field of a job, if the Cust# field is pale red, this means that the customer is on credit hold.

 

When adding a job, a warning will pop up and the Cust# field will turn pale red. If the customer is placed on credit hold after jobs have been created, the field will change colour, however no warning will pop up.

 

Price columns

Colour

Explanation

White

Price level is being used (ie. Price Level 1).

Lilac

Contract price level.

Green

Customer-specific price level.

Yellow

Manual/overridden price level.

Mustard

Promotional pricing level.

Orange

Minimum sale price level.

Blue

This is a kit.

Pale Blue

Linked to a purchase order. See Stock Code below – can also be background for special stock.

Red

Stock is back ordered.

Pink

Different price level to that selected in the header.

Light Grey

If stock is reserved at a line level, the line will turn light grey. If the whole job is reserved, the entire stock grid will turn light grey.

 

Sell Details

selldetails

 

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 background is colour coded to indicate the source, and hovering over a sell price cell will display the details.

 

Info

Note: The yellow background in Status indicates there are choices to be made there.

 

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 the 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

Mustard

Sell price is based on a promotion.

Project

Purple

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

Min Sale

Orange

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

 

Other Price Background Colours

Blue

This is a kit.

Pale Blue

If the stock being sold 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 purchase order and the job.

 

If the stock being sold is special stock, it will show with the stock code in red and also the line in light blue.

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.

 

Tip

Hover over the coloured fields and Jim2 will pop up an explanation of the colour meaning:

 

hoverpopup

 

Within the header field of a job, if the Cust# field is pale red, this means that the customer is on credit hold.

 

When adding a job, a warning will pop up and the Cust# field will turn pale red. If the customer is placed on credit hold after jobs have been created, the field will change colour, however no warning will pop up.

 

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

 

stockgridoptions

 

Dropdown 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 open the purchase order that was used to order the specific stock for this job.

View Stock

Is a hyperlink and will open that stock form. Available in both Edit and View mode.

Stock Availability

When selected, the line number in the grid will change to green, signifying that stock is available. This setting allows to override committed stock (ie. stock allocated to other jobs).

Auto Create Purchase Orders

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

Reserve Stock

This means that stock is exclusively held for that job and cannot be sold, picked or reserved on other jobs.

Recalculate

Recalculate current Stock price

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

 

Note: If a price is manually entered and Recalculate is selected, it will be replaced by the original price from the stock record. It is recommended to change the quantity first, then enter prices.

Recalculate current Stock price to

This will recalculate the price for the selected stock line to another price level.

Recalculate all Stock prices

This will recalculate all stock prices in the grid – useful when an expense has been applied to a line of stock on a particular job.

Recalculate all Stock Prices to match Job total

Allows automatic recalculation of stock prices to match a certain figure. For example, there are several lines of stock on a job, with the total price being $2019.25. Recalculating all stock prices to match the job total allows entering a price of, say, $1999. Jim2 will automatically adjust all line prices based on their selling price so that the job total equals $1999.

Show Serial#

Choose to show the serial number of the stock object in the Description field.

Show Attributes

Displays any stock attributes within the stock line.

Grid Columns...

 

jobgridcolumns

This sets up the grid columns that will be displayed in the stock grid. In expanded view (click the arrow symbol angled beside the Price Level field). All grid columns are displayed by default.

 

expandstockgrid

 

In collapsed view, the following columns are not shown:

Date

Initials

PO#

Location

Qty Pick

Disc %.

 

Add or remove grid columns by ticking the box, then selecting Apply. Click OK to update all users to the new layout as well.

 

updatelayout

 

Upon saving, all columns will be shown. Click on the arrow at top left of the grid in either Edit or View mode to view only the columns required.

 

gridcols

 

If the Hide box is ticked, this will selected hide stock lines in the job and on the invoice.

 

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

 

locatevaluejob

 

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 whilst in the field). This will assist 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 to choose to supply. In this screen, it is also possible to select multiple lines of stock by specifying the quantity required of each stock record in the Select Qty column.

 

selectquantity

 

The selection can be reviewed in the Selected Stock tab.

 

selectstock

 

History relating to stock will appear on the History tab, showing what stock has been sold in the last 365 days.

 

StockSelectHistory

 

Further information

Job Options

Job Setups

Jobs Security

Jobs at a Glance

Job Comment Grid

Job Footer

Job Header

Job List

Job Reports

Job Preview Pane

Dispatch

Invoicing

Manufacturing Jobs

Progressive Payments and Claims

Return from Customer

Retail Jobs

Sales Register

Accounting Entries for Jobs