Menu

Sales Receipts

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

Tags for Receipt Transactions (PRO Version)

The following tags can be used to import a Sage 50 Sales Receipt and allocate to matching Invoice .

See Online Training for Transaction based templates for a full explanation of tags, and how PostTrans reads them to define the Extract/Import template.

Tag Name

Data Type

Description

uniqueID

Integer IOP

Unique ID for each line record which does not changed
    Sage V21 2015 onwards

headerUniqueID

Integer IOP

Unique ID for each header record USE TO RELATE THE TWO FILES RECORDS
    Sage V21 2015 onwards

ADD_DISC_RATE

Double IOP

Additional Discount Percentage Rate
    Sage V21 2015 onwards

BASE_FULL_NET

Double IOP

Full Net Amount (no discount)
    Sage V21 2015 onwards

BASE_NET

Double IOP

Base Net Amount
    Sage V21 2015 onwards

BASE_NETVALUE_DISCOUNT

Double IO

Base Net Value Discount Amount
    Sage V21 2015 onwards

BASE_TAX

Double IOP

Base Tax Amount
    Sage V21 2015 onwards

COMMENT_1

Text 60 IOP

Comment 1
    Sage V21 2015 onwards

COMMENT_2

Text 60 IOP

Comment 2
    Sage V21 2015 onwards

COST_CODE_ID

Integer IOP

Project Cost Code ID
    Sage V21 2015 onwards

DELIVERY_DATE

Date IOP

Delivery Date
    Sage V21 2015 onwards

DEPT_NUMBER

Integer IOP

Department Number
    Sage V21 2015 onwards

DESCRIPTION

Text 60 IOP

Description
    Sage V21 2015 onwards

DISCOUNT_AMOUNT

Double IOP

Total Discount Percent on line item
    Sage V21 2015 onwards

DISCOUNT_RATE

Double IOP

Discount Rate set on Sales record
    Sage V21 2015 onwards

DUE_DATE

Date OP

Due Date
    Sage V21 2015 onwards

EXT_ORDER_LINE_REF

Integer IOP

Extra Order Line Reference
    Sage V21 2015 onwards

EXT_ORDER_REF

Text 30 IOP

Extra Order Reference
    Sage V21 2015 onwards

FULL_NET_AMOUNT

Text 8 IOP

Full Net Amount (Before Discount)
    Sage V21 2015 onwards

FUND_NUMBER

Integer IOP

Fund Number
    Sage V21 2015 onwards

INVOICE_NUMBER

Integer IOP

Invoice Number
    Sage V21 2015 onwards

IS_NEGATIVE_LINE

Integer I

Is item line negative (1 == negative 0 == positive)
    Sage V21 2015 onwards

ITEM_NUMBER

Integer IOP

Item Number
    Sage V21 2015 onwards

ITEMID

Integer IOP

Unique Identifier, Unaffected By File Maintenance Routines
    Sage V21 2015 onwards

JOB_REFERENCE

Text 60 IOP

Job Reference (Line Information)
    Sage V21 2015 onwards

NET_AMOUNT

Double IOP

Net Amount (After Discount)
    Sage V21 2015 onwards

NETVALUE_DISCOUNT

Double IO

Net Value Discount amount
    Sage V21 2015 onwards

NETVALUE_DISCOUNT_ALLOCATED

Double O

Negotiation Discount allocated
    Sage V21 2015 onwards

NEXT_ITEM

Integer IOP

Record Number of Next Item
    Sage V21 2015 onwards

NOMINAL_CODE

Text 8 IOP

Nominal Code
    Sage V21 2015 onwards

OFFSET

Integer IOP

Offset of Service Text
    Sage V21 2015 onwards

PREV_ITEM

Integer IOP

Record Number of Previous Item
    Sage V21 2015 onwards

PROJECT_ID

Integer IOP

Project ID
    Sage V21 2015 onwards

QTY_ALLOCATED

Double IOP

Quantity Allocated for this Order
    Sage V21 2015 onwards

QTY_DELIVERED

Double IOP

Quantity Previously Delivered for this Order
    Sage V21 2015 onwards

QTY_DESPATCH

Double IOP

Quantity left to Despatch
    Sage V21 2015 onwards

QTY_INTRASTAT_CONFIRMED

Double IOP

Quantity IntraStat Confirmed
    Sage V21 2015 onwards

QTY_ORDER

Double IOP

Quantity Ordered
    Sage V21 2015 onwards

SERVICE_FILE

Text 60 IOP

Redundant - Do Not Use
    Sage V21 2015 onwards

SERVICE_FILE_SIZE

Integer IOP

Redundant - Do Not Use
    Sage V21 2015 onwards

SERVICE_FLAG

Integer IOP

Service Item Flag
    Sage V21 2015 onwards

SERVICE_ITEM_LINES

Integer IOP

Redundant - Do Not Use
    Sage V21 2015 onwards

STOCK_CODE

Text 30 IOP

Stock Code
    Sage V21 2015 onwards

TAX_AMOUNT

Double IOP

Tax Amount
    Sage V21 2015 onwards

TAX_CODE

Integer IOP

Tax Code
    Sage V21 2015 onwards

TAX_FLAG

Integer IOP

Item VAT Ammended.
    Sage V21 2015 onwards

TAX_RATE

Double IOP

Tax Rate
    Sage V21 2015 onwards

TEXT

Text 60 IOP

Service Invoice/Credit Text
    Sage V21 2015 onwards

UNIT_OF_SALE

Text 8 IOP

Unit of Sale
    Sage V21 2015 onwards

UNIT_PRICE

Double IOP

Unit Price
    Sage V21 2015 onwards

QTY_INVOICED

Double P

Quantity Invoiced
    Sage V21 2015 onwards


Req = Field is required    EOF = End of file, Stop when no more values    

IO  This type of import shares common tags for Orders and Invoices

O  Tags for Orders only

I  Tags for Invoices only

With data type Yes/No fields, if cell starts with 'y' or 'Y' is taken as TRUE

Where ^ denotes a In Cell Code Search, delete ^ at end of tag, to turn off code search

All Text fields are trimmed (spaces before) by default. Add ' to the end of the tag name to stop this.