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 50/200 In Cell Searching

Often the user is required to enter a code while entering Sage 50/200 data in to a PostTrans template. PostTrans code search allows the user to easily search for that code, by simply entering the start of the code, and moving to the next cell using tab or enter key. If only one match exists then that value is used, otherwise all matches are shown for selection.

After selection the code is written back to the cell with it description.

CODE, Description

PostTrans strips the description off the contents of the cell as it imports the data.

Example:

On the header of the transaction, in Account if we type “A” and tab we see:

image

You can search in the description or name by simply prefixing you search with space.   The space “Ltd” gives:

image


To see all codes available, simply press space and tab

image

Having performed a search in a name of description, the cached data will be stored, so on second, third search will be really fast.

This is great when looking for Products.

Example:

In the product cell we can type “48mb” tab to find a memory pack which has the word “48mb” in it.

Turn off all searching by Cell/Column

The Tag button, “Current Tag Properties” tab, gives access to window which helps turn ON/OFF In-Cell Searching:

image

Turn off all searching Globally

All tags ending in ^ have code search.  To disable this function, simply delete the ^ from the end of the tag.

The searching within a transaction template, can be turned off in setup:

image

Other Reading

Postcode address lookup can also be provided, inn the delivery address, and all other address in a similar fashion.

Categories: Sage Line 50, Sage Line 200, Static Data, Transaction Data, Common Functions, Fast Orders Entry, Nominal | Tags: | Return

Post a Comment

Blog Categories