Menu

Blog

Blog

Search

Category

AutoUpdated

VAT Sage Line 200 Nominal Sage Line 50 Static

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

Archive by category: Common FunctionsReturn

Sage 50 Transaction Product Descriptions

Sage 50 Transaction Product Descriptions
In a PostTrans transaction template, PostTrans scans down the sheet until it finds 5 consecutive blank description lines,and then posts the transaction.  Thus the tag TLDesc is used to detect the “End of File”.Service TransactionsService Invoices can be imported using the Transaction type ‘SSI, Sales Service Invoice’.   This allows allows a simpler import:is imported as:Description of a ProductTransaction type ‘SQ,Sales Quote’, ‘SO,Sales Order’, ‘SI,Sales Invoice’, ‘PO,Purchase Order’...
Read More
Categories: Sage Line 50, Fast Orders Entry, Transaction Data | Tags:

Expand Bill of Materials

Expand Bill of Materials
Depending on the options, PostTrans will expand a product with Bill of Materials, to list the sub items description in the Bill of Materials:Thus when we select a BOM item, PostTrans inserts the description of all the items:The descriptions will be imported as S3 items depending on the settings for text.  see Sage 50 Transaction Product Descriptions
Read More
Categories: Fast Orders Entry, Transaction Data | Tags:

Sage 50/200 In Cell Searching

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 con...
Read More
Categories: Sage Line 50, Sage Line 200, Static Data, Transaction Data, Common Functions, Fast Orders Entry, Nominal | Tags:

Protecting the PostTrans template

Protecting the PostTrans template
Excel Spreadsheets, and thus PostTrans templates, can be protected from users editing the spreads sheet.   Many methods can help protect the PostTrans template: Hiding Sections of the template Putting the Header fields in hidden section of template Grouping sections, to temporally hide sections Make template file read only Save the template as a Excel Template – User cannot change the template Disable the PostTrans Setup button Protect sections of the sheet, to stop users editing cer...
Read More
Categories: Sage Line 50, Sage Line 200, Transaction Data, Fast Orders Entry, Nominal | Tags:

Importing CSV/Fixed file into Sage 50, 200 and Xero

Importing CSV/Fixed file into Sage 50, 200 and Xero
This article explains how import delimited, or fixed length, text file into Sage 50, using PostTrans which has the following advantages: Interactive Data Validation Optional Confirmation before import Print or e-mail transactions after import PRO Import SINGLE file or ALL files from directory Archive file to processed directory after successful import, so use only new files which have not been imported Run batch file before selecting file Easy to use interface for end users, simply press the Fil...
Read More
Categories: Sage Line 50, Sage Line 200, Static Data, Transaction Data, Nominal | Tags:

Clear transaction and copy down formula

Clear transaction and copy down formula
Pressing the Clear button on the PostTrans toolbar, clears the sheet ready for data entry. In a transaction based template the Clear button will look at the contents for row 27 and depending on the content of each cell PostTrans will:        “X” - Delete the content of the column from row 30 onwards.        Formula -  Copied down the sheet from row 30 onwards.        Any other value - Copied down the...
Read More
Categories: Sage Line 50, Transaction Data, Fast Orders Entry, Sage Line 200, Static Data | Tags:

Sage 50 Posting Order in Currency

Sage 50 Posting Order in Currency
If multi currency is turned ON in Sage Line 50, PostTrans will switch to the currency of the currently selected account automatically.  In order for the user to know the currency, and Exchange rate we may add this information to the header of the transaction. Example: Press Help, on the PostTrans toolbar, then select example “Posting Order in Currency” which is the example discussed below.  You should also have read the "Importing Transactional Data" on the Training page for a basic understand...
Read More
Categories: Sage Line 50, Fast Orders Entry, Transaction Data | Tags:

Sage 50 order Carriage Charge

Sage 50 order Carriage Charge
Carriage Charge can be posted with an order very easily by simply specifying a few tags in the header of the Sage 50 Order Example: Press Help, on the PostTrans toolbar, then select example “Posting Payment with Order” which is the example discussed below.  You should also have read the "Importing Transactional Data" on the Training page for a basic understanding of PostTrans basics.ExampleSimply open a blank Excel spreadsheet and press Import button.  PostTrans will then offer you all of the ...
Read More
Categories: Sage Line 50, Fast Orders Entry, Transaction Data | Tags:

Viewing Sage 50/200 Ledger from template

Viewing Sage 50/200 Ledger from template
The PostTrans tags CuBalance, CuOutOver30Days, CuCreditLimit, CuAvCrdit return the currently selected account  credit and balance figures.  The user can double click on these figures to access the ledger: Having double click you will see:Thus while taking an order, the user can discuss and follow up outstanding Invoices.This requires the Pro version of PostTransTags of interestThe following PostTrans tags allow the above functionality:Tag NameData TypeDescriptionCuBalanceCurrencyCustomer Balance...
Read More
Categories: Sage Line 50, Fast Orders Entry, Transaction Data | Tags:

Creating text message top/bottom of transaction

Creating text message top/bottom of transaction
A PostTrans template can easily add a message to the top or the bottom of a Sage 50 Sales Quote, Order Invoice + Purchase Order, by simply Adding extra text at top or bottom of transaction. So we could take the default template layout:And add extra text in order linesThese will be imported as S3 text lines, so can be as long as you want. Example: Press Help, on the PostTrans toolbar, then select example “Creating text message top/bottom of transaction” which is the example discussed below.  Yo...
Read More
Categories: Fast Orders Entry, Transaction Data | Tags:
Page 1 of 2 FirstPrevious [1]

Blog Categories