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 Transaction Description

When posting a Transaction, PostTrans scans down the description column, posting the lines it reads until it finds 5 consecutive blank description lines.

The description is handles in different way according to the data specified.

image

Any text in TLDescription will be word wrapped.  By default PostTrans will use the stock description from the Sage 200 stock items database, and ignore any texted entered in the sheet, unless the “Read Stock Description from spreadsheet” is ticked in Setup.

Which in Sage 200 gives:

image

The above default behaviour can be overridden to some extent.  The tag TLLineType can be added to allow each line type to be specified if need be.

image

Additional description for Picking and Dispatch note can be specified using tags TLPickListComment and TLDispatchListComment.

 

image

Categories: Transaction Data | Tags: | Return

Post a Comment

Blog Categories