Show/Hide Toolbars

Jim2® Business Engine Help File

Navigation: Jim2 Functions > Stock

Update Stock List Price Ex

Scroll Prev Top Next More

In this example, we will update List Price ex GST.

 

To begin, go to Stock > Create Stock List on the ribbon and run a filtered list of the stock requiring updating. Choose the Stock List - Export report, then save the file.

 

stock list export2

 

In all cases, keep the Stock Code column and remove all other columns except the List Price Ex GST column (this may be named differently depending on your setups. Make your changes to the pricing, then save the file.

 

On the ribbon go to Tools > Import Data and select Import destination: Stock.

 

stockimp1

 

Click Next. Select the Source File name and open the saved spreadsheet. Map the Source Field Name to the Destination Field Name. In the below example it is RRP Price.

 

rrp price

 

Click Next, then Load data to grid from source. Click Synchronise, Test Data, then Next

 

synch price

 

Select Import data and you're done.

 

import1a

 

How to

Add a Document to Stock

Add Groups to Stock

Add Images to Stock

Add Multiple Stock Records

Add Service Stock

Add Vendor Codes

Apply a Credit Card Charge Using Stock

Backfill Stock Sold in Advance

Bulk Update Stock

Buy and Sell in Different Measures

Buying your own stock

Change a Serial Number on a Stock Record

Change Stock GL Group

Create Similar

Generate a Backdated Detailed Stock on Hand Report

Make Stock Inactive

Handle Warranty Stock

Import Vendor Pricing

 

 

Merge Stock Codes

Move Stock from Depleting to Asset

Print Shelf Talkers

Print Stock Reports

Rental Stock

Sell Stock in Advance

Set up Pricing

Stock

Stock Adjustments

Stop Users from Giving Discounts

Synchronise Stock

Track Serial Numbers

Unallocate Stock

Update Stock Prices

Use Stock Select

Use Your Own Inventory

View or Edit Stock

Write off Stock