Menu

Blog

Search

Category

AutoUpdated

Save time updating

Sage 50

Stock/Product Creation
Customer/Supplier Prices
Bill of Material
Project Creation
Location Bins

Sage 200

Simply extract, edit and import

Xero

Import from Excel

50 Trans

Nominal Journals
Quotes/Invoices/Orders
Remote Orders
Product/Stock Adjustments
Sales Receipts
Quick OrderPad

200 Trans

Transaction from Manual Input

Image Alt TextImage Alt Text

Multiple Transactions from CSV file

Xero

Solve the Puzzle?

Sage 50

Help on every type of import
Demo Video of all functionality
Loads of Examples included
Online Training
We can help too…

Sage 200

Image Alt Text

Xero

Great Customer Satisfaction

Customer Comments

Full Trial with Demo Data
Low cost Subscription
Cancel anytime
From a £1 a day
Saving you hours

Simply extract, edit and import

Power of Excel

Sage 50

Quick Template Creation
Customise with:
    Formula
    Macros
    VBA

Sage 200

To reach your goals quickly

Sage 200

Sage 200 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Image Alt TextImage Alt Text

Manufacturing

200 Manufact.

Create BOM Stock Easily
Create Bill of Materials
Labour, Machine, Tools

Image Alt Text

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

Image Alt Text50 Projects

PostTrans Blog

Why not sign up to recieve news, tips, ideas, training.  Sign up for bi-weekly newsletter.

Blog Search

Sage 200 Stock Price Band Prices (Pro Version)

Sage line 200 stock prices can easily be edited using PostTrans within Excel. Using the example provided “Stock Prices”, you can extract up to 10 price bands at once, into columns, edit the data, and post back any changed stock price values back into Sage 200.

The video below demonstrates this, by first extracting whole series of price bands from Sage 200, editing the values, and updating the prices within Sage 200. Standard prices can be specified by entering a X in the cell.


 
 
   Sage 200 Edit Stock Prices using PostTrans:
   0:35 Open Example Template for Stock Prices Assignment
   5:00 How to find more information and Training
 
 

To use the template, with Sage 200, install PostTrans. Download
Trial with Sage demo company. Purchase a month subscription for Live Sage Company. Price
Watch the On-line Training course on how to use and customise the templates.

Tags StSellPrice1-10 can be specified, to extract/amend or import stock price band prices. When first extracted the user is asked to define the Price Bands for each of the StSellPrice1-10 tag specified in the PostTrans template.

image

See example template by pressing Help button and selecting “Stock Prices”. 

The prices for that band will be written to designated column specified. Any changes on Import will update that band price.

Putting an "X" in the price cell will designate it as a "Use Standard Price"

Tag StStdSellPrice, allows the user to extract/import the Standard Price.

Tag StCostPrice, is provided to allow formula to be added to the sheet to calculate new prices.

The band allocation can altered by changing the "Related Code", under the tag StSellPrice1-10 in row 3.

The cost price can also be pulled through, allowing the use of simple Excel functions to calculate new stock price.

Tags of interest:

Tag

Description

StCostPrice

Cost Price

StStdSellPrice

Standard Stock Price

StSellPrice1-10

Price for designated price band, See above.

Categories: Sage Line 200, Static Data | Tags: | Return

Post a Comment

Blog Categories