Menu

Blog

Blog

Search

Category

AutoUpdated

Static Sage Line 50 Sage Line 200 VAT Nominal

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: Sage Line 200Return

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 VAT

Sage 50 VAT
PostTrans uses the Tax code assigned on the Sage 50 Product code, or if overridden on Customer/Supplier account record, uses the one specified in the account record. Example:  You should also have read the "Importing Transactional Data" on the Training page for a basic understanding of PostTrans basics.The default PostTrans Order record contains tag TLTaxAmount.  This is populated with the VAT content of the line.If tag TLTaxCode is added.  Then tag TLTaxCode is populated with the default TAX co...
Read More
Categories: Sage Line 50, Transaction 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:

Sage 50 Payment with Order/Invoice

Sage 50 Payment with Order/Invoice
Payments can be posted with Single/Multiple orders or invoices, see example in next section. Sales Invoice + Payment for Direct Debits paymentsPayments can be imported as SIAT (SI with matching SR for Direct Debit payments), SA (On Account), SR (Sales Receipt) or PR transaction types, shown in the screenshot below.  With optional currency using the PRO version of PostTrans.  Simply press the Help button on the toolbar and search for 'payment" to list examples. PostTrans can even post ...
Read More
Categories: Sage Line 50, Fast Orders Entry, Transaction Data | Tags:

Sage 50 Apply discount to whole transaction (Single Transaction Import)

Sage 50 Apply discount to whole transaction (Single Transaction Import)
PostTrans can handle Sage 50 overall transaction value discount, or Qty based discount, by simply adding you own formula to calculate the overall discount on the header of the transaction. Example: Press Help, on the PostTrans toolbar, then select example “Apply discount to whole transaction” 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. Thus if we take our standard S...
Read More
Categories: Fast Orders Entry, Transaction Data | Tags:

Sage 50 VAT Nominal Journal

Sage 50 VAT Nominal Journal
Use PostTrans to post VAT Nominal Journal from MS Excel. Great for repetitive journals + add your own calculations.
Read More
Categories: Sage Line 50, Nominal, Transaction Data | Tags: Nominal, Sage Line 50, VAT

Saving template after posting

Saving template after posting
After posting a transaction, or series of transactions using PostTrans, you may want the template to be saved with the posted data in it. Example: Press Help, on the PostTrans toolbar, then select example “Auto saving template after posting” 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. PostTrans has a very flexible method of doing this, which also handles revis...
Read More
Categories: Sage Line 50, Sage Line 200, Transaction Data, Fast Orders Entry | Tags:
Page 3 of 4 [3]

Blog Categories