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

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

Multiple Transactions from CSV file

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

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 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Manufacturing

200 Manufact.

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

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

50 Projects

PostTrans Blog

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

Blog Search

Sage 200 Stock Supplier Prices (Pro Version)

Tags StSuppCode1-5 can be specified, to extract/amend or import stock supplier information. When extracted tag StSuppCode1 contains the preferred supplier, and name. To delete a supplier from the supplier list, simply delete the code in StSuppCode1-5 cell, and press Import.

image

Demonstration Video

 
 
                                                                                                                                                                                                
    Quick intro: How to Extract/Import Static Data:
   0:40 What we are editing in Sage 200 stock record
   1:30 30 Extract Search values, edit import changes
   6: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 of interest:

Tag

Description

StSuppCode1-5

Supplier code. Anything after comma is ignored.

StSuppP1-5

Y will designate this supplier as preferred

StSuppLeadTime1-5

Lead Time

StSuppLeadUnit1-5

Lead Time Unit - 0,Days,1,Weeks,2,Months,3,Years

SuppOrderQty1-5

Usual Order Qty

SuppOrderMinQty1-5

Min Order Qty

StSuppListPrice1-5

List Price

SuppListPrBs1-5

List Price Base

SuppListPriceCur1-5

List Price Currency

SuppListPriceExp1-5

List Price Expires

SuppPriceSource1-5

Price Source - 0,Last Buying Price,1,List Price

SuppCatPrice1-5

Catalogue Price

SuppCatPrDate1-5

Catalogue Price Date

SuppLastOrdDate1-5

Last Order Price

SuppCuntOrg1-5

Country of Origin

SuppStkCode1-5

Supplier Stock Code

   
   

Set StSuppP1-5 to YES to change the allocation of Preferred Supplier. When the data is extracted, StSuppP1 contains the preferred Supplier, thus the first column is the preferred Supplier.

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

Post a Comment

Blog Categories