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 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 Transactions

Service Invoices can be imported using the Transaction type ‘SSI, Sales Service Invoice’.   This allows allows a simpler import:

image

is imported as:

image

Description of a Product

Transaction type ‘SQ,Sales Quote’, ‘SO,Sales Order’, ‘SI,Sales Invoice’, ‘PO,Purchase Order’

Depending on the system switch “Read Product Description from spreadsheet”,   PostTrans will either use the text defined in the Sage line 50 Product record, or the description entered on the sheet.  By default this is OFF,  thus by default the user cannot override the Sage 50 Product description.

Press Setup on the PostTrans toolbar gives access to this switch:

image

Non – Product: Entering a Text Line

If the user enters a simple text line in the column below the TLDesc  tag, then the text will be imported as a Sage Line 50 S3 item, thus allowing a large amount of text to be entered.   And of course Qty and Unit price values can be assigned to such lines.

image

An option “If no Product code Post Description S3, else S1” will make PostTrans use S1 instead of S3 item.  And if option “Product Desc word wrap in Comment1/2” is ON then PostTrans will word wrap the text to fit into the 3 lines in the S1 item.

image

Word wrapping a cell in Excel

For long text descriptions, you may want to make PostTrans Word Wrap the Text cell:

image

to fix this we simply right click on the cell, and select

image

Now we select “Word wrap”

image

 

Other reading

Creating text message top/bottom of transaction discuses how to add text to the top and the bottom of a transaction using a special header tag

Categories: Sage Line 50, Fast Orders Entry, Transaction Data | Tags: | Return

Post a Comment

Blog Categories