Menu

Sales/Purchase Transactions

Releated Topics.

Training on Transaction Data
Create a quick Sales Order Pad
Printing Quote/Order
Posting to multiple Companies
Importing from file easily
In Cell Searching

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

Sage 50:Import Quotation/Order/Invoice Import

This type of PostTrans import, imports Sales/Purchase Transactions, which can be input manually, data from an ODBC connection or imported from CSV file.

Page Contents

Automated Transaction Import via XML API for Sage 50

Related Pages

Import Types/Features in Sage 50

Sage 50 Transaction Types

  • SQ - Sales Quote
  • SO - Sale Order, including with Payment
  • SI - Sales Product/Service Invoice, including with Payment
  • SIAT - Sales Invoice Audit Trail - Invoice to Audit Trail if THAmtPaid then posts an allocated Receipt
  • SCAT - Sales Credit Audit Trail - Credit Note to Audit Trail
  • SSC - Sales Service Credit Note (SI sets this automatically so use that)
  • SSI - Sales Service Invoice
  • SC - Sales Credit Note
  • SR - Sales Reciept more about Payments
  • SA - Payment on Account
  • PO - Purchase Order with Authorisation
  • PI - Purchase Batch Invoice
  • PIA - Purchase Invoice and Adjust stock IN
  • PC - Purchase Credit
  • PR - Purchase Receipt more about Payments
  • PA - Payment on Account
  • BP - Bank Payment Cashbook Import
  • BR - Bank Receipt
  • CP - Cash Payment
  • CR - Cash Receipt
  • VP - Visa Credit Payment
  • VR - Visa Credit Receipts

Can be Printed or automatically e-mailed to customers when posted

The transaction type is set, either on the Header of the import, or on the lines of the import. See examples below.

Invoices are imported into Sage 50 as a Service Invoice, if it contains no products, or a Product Invoice of it contains Product lines.Sage 50 Transaction Product Descriptions

Import Transaction Features in Sage 50

Simply add new lines to the spreadsheet from row 30 on-wards. Then press Import button, on the PostTrans Toolbar, to import single or multiple Sage 50 Quotes, Orders, or Invoice transactions (Examples shown below).

Advantages

  • Detailed conformation before transaction importation
  • Print or e-mail Transaction after importation
  • Highlighted Validation of codes and data
  • Search for Account, Stock, Project, Nominal, using our In-Cell Searching
  • Looks up, and fills in default values, including customer price from Matrix
  • Add formula, vba or macros to manipulate the imported data
  • Cannot Post Sage transaction twice. Writes POSTED in row, with transaction Ref generated.
  • Can skip Zero Qty, and thus allows the creation of order pads Pro
  • Chain posting, allows a second template to post, for Back to Back order Pro
  • Press Extract to populate the sheet with product codes, and optionally sort by Category, to quickly create an Order Pad for fast Order entry Pro
  • Can automatically add a line to account round differances in Line Total and Patment Totals
  • Easily Add your own validation, using the THBefDisplayMessage tag
  • Easy importation from CSV file

Examples of importing Sage 50 Transactions

Posting Single Transaction

Header values can be specified in the top portion of the PostTrans template, and/or in line items in rows 30 on-wards. The template structure detail is discussed in Template Structure (below this section).

Single Transaction Layout

Single Transaction Layout

After pressing the Import Button:

Conformation and Validation before Posting

Conformation and Validation before Posting

The below is a screen shot of Sales Order template which is automatically generated after selecting this type of transaction, many of the fields are optional and are filled in automatically by PostTrans. Indeed the user need only enter Product Code and Quantity, all other fields are filled in by PostTrans, including the price to the customer.

Note: The delivery address, and credit information, is automatically populated after selecting the account code.

Thus:

Default Single Transaction Layout

Default Single Transaction Layout

Formula, VBA and macros can be added to further enhance this data entry template.

The Path the Cursor takes can also be defined

Multiple Transactions

Multiple Transactions can be imported by adding the Header fields to the Tag row 28. These are easily inserted using the Tags button, see all tags listed at the bottom of page.

Multiple Transaction Layout

Multiple Transaction Layout

Indeed we can add tag "THTransType" to allow us to post different types of transactions:

Multiple Transaction Type Layout

Multiple Transaction Type Layout

In this configuration PostTrans forces a new transaction when Account code, Transaction date or Customer reference changes. Blank values are ignored, but would probably be repeated if brought in from a CSV file.

Indeed multiple companies can be imported into:

Multiple Transaction Layout

Multiple Transaction Layout

Formula, VBA and macros can be added to further enhance this data entry template.

The Path the Cursor takes can also be defined

Template Structure for Transaction Data

The template must have tag ‘Sage50Trans’ in the comment of cell A1 to instruct PostTrans that we are interested in importing Transactions, and that the sheet is a PostTrans Template. Pressing Import or Extract on a blank sheet will either open an existing example or create basic template for you to customise.

Cell A1 (Sage 50 Sales Order shown in this example)

Cell A1 (Sage 50 Sales Order shown in this example)

The top section of this template contains Transaction header fields, in the case of a single transaction, or just transaction type of all multiples transactions list from row 30 onwards, see examples below:

Comments map to Sage fields (Sales Order in this example)

Comments map to Sage fields (Sales Order in this example)

These Transaction header fields can be deleted if not required, or added by moving the cursor, to a cell in the header area, and pressing the Tag button. This will display a list of PostTrans Tags. A tag beginning with “TH”, denoting for use in a header, can then be inserted. Table of Sales/Purchase Transactions Tags

Row 28 contains a series of tags, which denote to PostTrans the data to be read/written in each column. These tags, and data columns can be rearranged to suite your needs, and the tags are added using the Tags button. Deleting the Tag name, in the cell, from this row removes the Sage 50 mapping.

Row 27 designates what will happen when the Clear button is pressed, see Clear Transaction and copy down formula

Row 28 defines the data in row 30 onwards

Row 28 defines the data in row 30 onwards

Hovering over these tags, and header cells will show a comment which explains the tags purpose, data type and any other useful details.

For importing multiple transactions, most header tags can be copied/moved to row 28, thus designating a column to set the header value. 

Transaction Header fields added to Row 28

Transaction Header fields added to Row 28

On-line Training video of how all this works 

Common Features

In-Cell Searching

Any Tag ending with ^ will have a In-cell search facility to look up associated values.  Use SPACE + TAB to see all values, or SPACE and TEXT to perform a text search on description. These are returned to the cell as "CODE, DESCRIPTION".  PostTrans only uses the CODE and ignores the comma and anything after it, thus data from a field would only need the CODE part of the data if from an external imported file.  

In-cell Searching can be turned off by removing the ^ from the end of the tag name, or name in first line of comment (Header cells) to disable in-cell searching for a single column, or header cell.  All in-cell searching can be turned off in SetupIn-cell searching.

Cursor Path

The path the cursor takes through the sheet, when entering data manually, can also be easily defined in Setup.  See Set Cursor Path

Importing the Data

Simply press the Import button to validate and import the data into Sage 50.  PostTrans will read the Header cells and then process the rows of data until TLDesc column contains no data. The Sage Company imported into can be set in the Setup window.

PostTrans ONLY edits those fields listed on the sheet when importing, thus any existing values, on a record, are unaffected.   New records may have default values for certain fields.

Validation

Any values and associated codes will be invalid during import.   The cursor will be moved to highlight any problems in data.

POSTED Document Ref

After Posting a transaction, PostTrans will write "POSTED:" and the transaction reference number in column A (tag TLPosted).  Lines marked as "POSTED" are then ignored by PostTrans when re-posting. So, transactions cannot easily be posted twice. So the transaction can not easily be posted twice.   The user would have to remove "POSTED" from column A in order to post the transaction a second time.  The user would have to remove "POSTED" from column A, to post the transaction a second time.

Confirmation before Posting Transaction

Just before posting the validated transaction, PostTrans will optionally show a transaction summary for the user to validate.   This can be turned off in Setup window.

File Import Button

This can be enabled in Setup to easily import CSV, or fixed length files, into sheet for importation.   Formula can also be added, or macros/VBA to manipulate this data before importation.   Import from CSV file.

Clear Button

The Clear button will clear all values on the sheet, according to the row just above the tag row, and copy down any formula.  Clear Transaction and copy down formula

Evaluation and License

This functionality will work with Sage Demo data without a license. A license is required to import into any other Sage Company. 
A subscription be purchased, and cancel on-line at any time very easily.   Pricing

Address Entry


Pro Feature: UK addresses can have Postcode look enabled for faster data entry.   Postcode Address Lookup

Printing


Pro Feature: Transactions can be printed, or e-mailed, at the end of the import  Printing - e-mailing Transactions. Ideal for order entry templates.

Restrictions

  • PostTrans will lookup the customer price, but does not support the Sage 50 pricing rounding options.
  • Does not apply the Sage Line 50 Additional Discount. But this can be calculated in sheet and posted using header Tag THAddDisc.

What else can I do?

Other Sage 50 Extract/Import types

Frequently Asked Questions?

Got another question? It may well be covered on our Frequently Asked Questions page.

Demonstration Video

Since the functionality of this type of import is quite broad, the following Videos/Blog articles have videos showing it in action:

 
 
   Importing a CSV file into Sage 50/200
  0:00 Video Introduction
  1:25 Opening File Import Example
  2:00 Import Sales Orders into Sage 200
  5:00 How to setup file import
  7:15 How to find more information and Training
View the full article on this
 
 

 
 
   Quick Sales Order Pad 1/2 using PostTrans in 30 seconds
  0:00 Video Introduction
  1:10 Taking an order in 30 seconds
  2:08 Rewind for a slower explanation of process
  4:00 Adding another product to Order Pad
  6:50 Posting the Sales Order into Sage 50
  8:00 How to find more information and Training
View the full article on this
 
 

Inter-Company Transaction

It is easy to post Sage Line 50 Inter-Company Transactions, since you can either:

  • Specify the Company Code on each line, in which case PostTrans will change company every time it sees a change in company. Example 1 in the following video.
  • Specify the Company Code on the header to override the company set in system settings, then simply create the transaction on a separate sheet for each company, in THBefSWCompany, and post each individually. This can then be automated by specifying the Header tag THAftProcessSheet, to switch to named sheet and process after current. Example 2 in the following video.

 
 
   Sage 50/200 Inter-Company Transfer within Excel
  0:00 Video Introduction
  1:50 Posting SI/PI to 2 companies (Example 1)
  5:00 Prove the data has been imported into Sage 50
  6:40 Posting 2 Nominal Journals to 2 companies
  7:30 Posting SO/PO into 2 companies using 2 sheets (Ex. 2)
View the full article on this
 
 

Transactions Import Options

Transaction Import has the following options, which are accessible by pressing the Setup button on the toolbar:

Switches in Setup window

Switches in Setup window

Option Description
 Header Options  
Turn off all Cell Lookups

This option turns all in cell searching

more about Sage Line 50 Related Code Search

Don't Post if over Credit Limit Check customer credit Balance before importing Order/Invoice
Don't Post if Payment is UNDER PAID

Used in conjunction with THAmtPrePaid for Payments with transaction

More about Sage Line 50 Payment with Order/Invoice

Don't Post if Payment is OVER PAID Used in conjunction with THAmtPrePaid for Payments with transaction
Use System Exchange Rate Use System Exchange Rate, when posting to an account with currency other than base.  Else allow override using tag THExchange, and will warn if 10% variance from system.  
Update Ledger when posting to Invoices/Credits PRO If Sales Invoice then update ledger after posting Pro
 Line Options  
Read Product description from spreadsheet

Read description from spreadsheet, otherwise get from stock record so user cannot alter it.

More about How Sage line 50 Descriptions are Imported

Product Desc word wrap in Comment1/2 If read Product Description from sheet then allows for long description into Comment 1+2 for printing
If no Product code Post Description S3, else S1 If no Product code then post Description to S3 with word wrap.  Else use S1.  Tax can of course be set using TLTaxCode or S1, S2 or S3 could be entered as products.
DISCOUNT:Do NOT apply customer discount when selecting Product Just pull through standard price
DISCOUNT:Post discount as Standard price-TLUnitPrice When importing a line with value using Inclusive of Tax, using Tag TLTotIncluOfTax, calculate line discount based on the Product Standard Price
Qty : Allocate Product on Sales Order Allocate Stock on Sales Order when importing in to Sage 50 2015 V21 onwards
Qty : Ignore 0 qty/hours Transactions

This allows the template to have a predefined list of Products.  Allowing the user to simply enter Qty against the required product lines required on Quote/Invoice/Order.  This allows for the creation of Order Pads and Telesales data  entry. Pro

More about How to create a Sage Line 50 quick order Pad

Qty : Do NOT allow negative Product Check product to make sure will not go negative before import
Allow zero sales price Allow zero sales price.   If cell is Blank PostTrans will look-up price and write back to cell during import.  Thus to look-up prices simply press import and press Cancel on summary window, and customer prices will be populated.
with warning (allowed to continue) Display warning and allow to continue
Project Costing : Enforce Job codes in Cells Enforce Project Costing code entry on transaction Pro
with warning Display warning and allow to continue
 Summary  
Show Summary before posting transaction Turn ON/OFF Summary window.
Show Nominal breakdown Show a breakdown of Nominal values
Show Department breakdown Show a breakdown of Department values
Show Project Costing breakdown Show a breakdown of Project Costing values
Show Stock Code breakdown Show a breakdown of Stock values
include Margin and cost Show Margin and Costs on summary window
Post all silently as possible Turn on to suppress registration message, and status at end

The above settings are stored in each sheet, Cell A1 Comment, where as most settings are stored per workbook

Confirmation window showing summary of transaction.

Confirmation window showing summary of transaction.

This would be turn off if importing a large number of lines from an external file.

In Cell Searching Options

After the user enters an account code PostTrans can perform the following:

Confirmation window showing summary of transaction.

Confirmation window showing summary of transaction.

Option Description
 After Selecting an Account  
Offer Delivery Addresses Offer delivery address for the account
Don't write delivery Address in Normally after selecting an account, and delivery address, it is written to the delivery address.  This turns it off, but still writes to header tags CUDelAdd1-5, and contact, allowing bespoke functionality.
Show Memo Show customer/supplier memo before proceeding.  Useful for better communication Pro
Clear Transaction

Will Clear Transaction lines before proceeding

More about Clear transaction copy formula​

 After Selecting Stock on lines  
Explode Stock BOM

Will expand BOM's and formula for price calculation.   Pro

More about Expand BOM on Order​

And Indent Description Indent description when adding lines with 3 spaces
Add a blank line after Add blank line on transaction
Show free stock in search When searching for stock, show free stock level _Pro
Show In Stock Qty in search When searching for stock, show Stock Qty level _Pro
Show Qty on order in search When searching for stock, show Qty on Order _Pro
Update TLUnitPrice on Qty Change If on the TLUnitPrice will update whenever the Qty changes.  If OFF then PostTrans will write the TLUnitPrice if the cell is blank, thus user can overide th value.

The above settings are stored in each sheet, in the comment in cell A1.

PostTrans Tags which map to Sage 50

Not all of these tags/columns are needed. The table below lists the required and recommended:

Tag Name

Data Type

Description

Important Fields:

TLPosted

Text Req

Returns `POSTED` if Trans line has been posted and will be ignored if `POSTED` (required). Also reports errors/warnings in data row

Common:

TLProduct^

Text 30 XML

Product code. Not used on Service Type Transactions.
    In Cell Searching values in table ProdCodeNoDesc

TLDesc

Text 60 EOF XML

Product Description. PostTrans stops importing after finding 5 consecutive blank cells.
How Descriptions are Imported

TLQty^

Double XML

Quantity, if Service Transaction then can be omitted, and lines with TLNett will have Qty 1. PRO – For Product Transactions - If switch 'ignore ZERO qty' ignores any lines with zero qty. This allows a long product list to be listed, and user simply edit a qty to book IN/OUT
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLUnitPrice^

Currency XML

Unit Price for each item. If cell is blank then PostTrans will lookup customer price on change of Qty, or adding a product. If option is on to override the price, in System setup >> Lookups >> Switches, then the customers price will overwrite any value already in cell, on change of Qty. Price will be after customer discount. PRO - If multi-currency is ON will be in account currency.
Unit Price
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLDueDate

Date XML

Due Date for Invoice, Delivery Date on Order, Expire Date on Quote. Overides the date set on Header in THDueDate

Financial Analysis:

TLNomCode^

Text 8 XML

Nominal Code, if not specified then uses default
    In Cell Searching values in table NomCode

TLDepartment^

Integer XML

Department, if not specified then uses default. Make sure the format of the cell is “General” else search may not work properly
    In Cell Searching values in table DeptCode

Discount:

TLDiscValue^

Double XML

Sales:Additional Discount Value to be applied to TLUnitPrice, Value should be specified in TLDiscValue OR TLDiscTotValue OR TLDiscPerc but not both cells. Note TLUnitPrice has already had any system discount applied on account record.
See discount section of this page
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLDiscTotValue^

Double XML

Sales:Additional Discount Value to be applied to Line, Value should be specified in TLDiscValue OR TLDiscTotValue OR TLDiscPerc but not both cells. Note TLUnitPrice has already had any system discount applied on account record.
See discount section of this page
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLDiscPerc^

Double XML

Sales:Additional Discount Percent to be applied to TLUnitPrice, Value should be specified in TLDiscValue OR TLDiscTotValue OR TLDiscPerc but not both cells. Note TLUnitPrice has already had any system discount applied on account record.
Discount calculation
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

Line Totals:

TLTotNet

Currency Read

Total Net Price, TLQty * TLUnitPrice calculated with discount. Allows formula to total Transaction. PRO - If multi-currency is ON will be in account currency.

TLTotCost

Currency Read

Total Cost Price, TLQty * PrCostPrice calculated with discount. Allows formula to cost Transaction to get Margin. PRO - If multi-currency is ON will be in account currency.

TLTotIncluOfTax

Currency Pro XML

Line Total inclusive of Tax. PostTrans will calculate Tax and Unit Price back from Inclusive Tax Total for Line given Qty and overcome rounding problems. Use THNetDiscount to account for discount. Best choice when importing data as reduces rounding problems

Text:

TLComment1

Text 60 XML

Comment1 on line. If system settings ‘Large Product Description word wrap in Comment1/2’ is ON and ‘Read Product description from spreadsheet’ then will word wrap Description into these fields
How Descriptions are Imported

TLComment2

Text 60 XML

Comment2

TLJobRef

Text 60 XML

Project Ref

TLLineInfo

Text 60 XML

Line Information, N/A for PI/PC

TLOrdRefTxt

Text 30 XML

Line Order Ref Text (only visible on SI/SO), ExtRef on PI/PC/SIAT/SA/SR/PR

TLOrdRefNo

Integer XML

Line Order Ref Number (only visible on SI/SO)

Tax:

TLTaxManAmount

Currency XML

TTax Amount, per item, if calculated manually. Use with Caution as you are responsible for calculating Tax correctly.
more about VAT

TLTaxManTotAmount

Currency XML

Tax Amount if calculated manually. Use with Caution as you are responsible for calculating Tax correctly.
more about VAT

TLTaxCode^

Integer XML

Tax Code. Will fill in default if blank. Make sure the format of the cell is “General” else search may not work properly
more about VAT
    In Cell Searching values in table TaxCode

TLTaxAmount

Currency Read

Tax Amount. Calculated but not read as PostTrans will calculate this
more about VAT

Stock price:

TLPriceCur1^

Currency Read Pro

Price in currency 1. Allows Order pad to list prices in Major currencies
Sage 50 Quick Pad
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLPriceCur2^

Currency Read Pro

Price in currency 2. Allows Order pad to list prices in Major currencies
Sage 50 Quick Pad
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLPriceCur3^

Currency Read Pro

Price in currency 3. Allows Order pad to list prices in Major currencies
Sage 50 Quick Pad
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLPriceCur4^

Currency Read Pro

Price in currency 4. Allows Order pad to list prices in Major currencies
Sage 50 Quick Pad
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLPriceCur5^

Currency Read Pro

Price in currency 5. Allows Order pad to list prices in Major currencies
Sage 50 Quick Pad
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

Product Info (Written Back):

PrCostPrice

Double Read

Product Cost Price, if TLNet has ^, then it will contain the Cost Price. PRO - If multi-currency is ON will be in account currency.

PrQtyFree

Double Read

Product Qty free, updated when stock code entered

PrQtyInStock

Double Read

Product Qty In stock, updated when stock code entered

PrQtyAllocated

Double Read

Product Qty Allocated, updated when stock code entered

PrQtyOnOrder

Double Read

Product Qty On Order, updated when stock code entered

PrQtyReOrderLevel

Double Read

Quantity of stock at which new stock should be ordered.

PrQtyReOrder

Double Read

Product Qty ReOrder, updated when stock code entered

PrLocation

Text 16 Read

Product Location, updated when stock code entered

PrSuppPartNo

Text 16 Read

Product Supplier Part Number, updated when stock code entered

Other Product Info (Written Back):

PrCategory

Integer Read

Stock Category Number Lookup

PrType

Text 16 Read

Type of Stock

PrNominal

Text 8 Read

Nominal Code Lookup

PrPartNo

Text 16 Read

Supplier`s Part Number Lookup

PrSuppAccount

Text 8 Read

Supplier`s Account Reference Lookup

PrCust1

Text 60 Read

Custom Field 1 Lookup

PrCust2

Text 60 Read

Custom Field 2 Lookup

PrCust3

Text 60 Read

Custom Field 3 Lookup

Transaction Header:

THTransType^

Text 2 Head Chg XML

Transaction Type. Make sure the format of the cell is “General” else search may not work properly. Must be specified on each line.
        In Cell Searching values:Transaction Type
                  SQ, Sales Quote
                  SO, Sales Order
                  SI, Sales Invoice
                  SIAT, Sales Invoice Audit Trail
                  SCAT, Sales Credit Audit Trail
                  SSC, Sales Service Credit Note
                  SSI, Sales Service Invoice
                  SC, Sales Credit Note
                  SR, Sales Reciept
                  SA, Payment on Account
                  PO, Purchase Order
                  PI, Purchase Batch Inv
                  PR, Purchase Receipt
                  PA, Payment on Account
                  PIA, Purchase Inv + Adj IN
                  PC, Purchase Credit
                  BP, Bank Payment
                  BR, Bank Receipt
                  CP, Cash Payment
                  CR, Cash Receipt
                  VP, Visa Credit Payment
                  VR, Visa Credit Receipts

THAccCode^

Text 8 Head Chg XML

Transaction Account Code. Customer or Supplier depending on Transaction Type.
    In Cell Searching values in table THAccCode

THTransDate

Date Head Chg XML

Transaction Date

THDueDate

Date Head XML

Due Date for Delivery Date on Order, Expire Date on Quote. SO/PO only

THAccName

Text 60 Head XML

Customer Account Name

THAdd1

Text 60 Head XML

Customer Address 1

THAdd2

Text 60 Head XML

Customer Address 2

THAdd3

Text 60 Head XML

Customer Address 3

THAdd4

Text 60 Head XML

Customer Address 4

THAddPostcode^

Text 60 Head XML

Customer Postcode. If Postcode Search is enabled in ‘Setup >> Lookup >> Address Lookup’ then enter Space or Space + Postcode to search for an address.
More about Postcode Address Lookup
    In Cell Searching values in table SimplyPostcode

THContact

Text 30 Head XML

Customer Contact Name

THPhone

Text 30 Head XML

Customer/Supplier Telephone Number SO/PO only

Currency:

THCurrency^

Integer Head Pro XML

Currency, will be set after selecting an account, any prices then altered will be in that currency.
    In Cell Searching values in table CurrencyCode

THCurExch

Double Head Pro XML

Use System Exchange Rate, unless option changed in PostTrans system settins

THCurSymbol

Text 3 Head Read Pro

Currency Symbol

THCurCode

Text 3 Head Read Pro

Currency Code

Carriage:

THCarrCourierNo^

Integer HeadOnly XML

Carriage Courier Number. Make sure the format of the cell is “General” else search may not work properly
Sage 50 Carriage Charge
    In Cell Searching values in table CourierCode

THCarrConsNo

Text 30 HeadOnly XML

Consign Number
More information

THCarrNet^

Currency HeadOnly XML

Carriage Net Amount, else value in Sage Line 50 SOP Settings
More information
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

THCarrTaxCode^

Integer HeadOnly XML

Carriage Tax Code, else uses Account Default. Make sure the format of the cell is “General” else search may not work properly
More information
    In Cell Searching values in table TaxCode

THCarrDepartment^

Integer HeadOnly XML

Carriage Department, else value in Sage Line 50 SOP Settingst. Make sure the format of the cell is “General” else search may not work properly
More information
    In Cell Searching values in table DeptCode

THCarrNomCode^

Text 8 HeadOnly XML

Carriage Nominal Code, else value in Sage Line 50 SOP Settings
More information
    In Cell Searching values in table NomCode

Footer:

THGlobalNomCode^

Text 8 Head XML

Footer - Global Overide Nominal Code
    In Cell Searching values in table NomCode

THGlobalDep^

Integer Head XML

Footer - Overide Department
    In Cell Searching values in table DeptCode

THGlobalDetails

Text 60 Head XML

Footer - Overide Details

THGlobalTaxCode^

Integer Head XML

Footer - Overide Tax Code.
    In Cell Searching values in table TaxCode

Header Delivery:

THDelName

Text 60 Head XML

Delivery Address Name. Double click to change delivery address

THDelAdd1

Text 60 Head XML

Delivery Address Line 1. Double click to change delivery address

THDelAdd2

Text 60 Head XML

Delivery Address Line 2. Double click to change delivery address

THDelAdd3

Text 60 Head XML

Delivery Address Line 3. Double click to change delivery address

THDelAdd4

Text 60 Head XML

Delivery Address Line 4. Double click to change delivery address

THDelPostcode^

Text 60 Head XML

Delivery Postcode. PRO -If Postcode Search is enabled in ‘Setup >> Lookup >> Address Lookup’ then enter Space or Space + Postcode to search for an address.
More about Postcode Address Lookup
    In Cell Searching values in table SimplyPostcode

THDelEmail

Text 255 Head

Delivery email address. PRO - Can be mapped it e-mail Quote/Invoice or Order.
emailing Sage 50 transaction

Project (Pro):

TLProject^

Text 12 Pro XML

Project code where appropriate
    In Cell Searching values in table ProjectCode

THProject^

Text 12 Head Pro XML

Project code where appropriate
    In Cell Searching values in table ProjectCode

TLCostCode^

Text 8 Pro XML

Cost Code on Transaction line
    In Cell Searching values in table ProjectCostCode

THCostCode^

Text 8 Head Pro XML

Cost Code on Transaction line, but default can be set on header for greater flexability, where appropriate
    In Cell Searching values in table ProjectCostCode

Header Text:

THCustRef

Text 30 Head Chg XML

Customer`s Order Number

THOrderNo

Text 7 Head Chg XML

Order Number can be set on SI

THDetails

Text 60 Head XML

Details on PI

THDUNSRef

Text 9 Head XML

DUNS credit reference number

THNotes1

Text 60 Head XML

Notes 1

THNotes2

Text 60 Head XML

Notes 2

THNotes3

Text 60 Head XML

Notes 3

THPracSolRef

Text 60 Head XML

Sage Practice Solutions Reference

THTakenBy

Text 60 Head XML

Order Taken By

Header Discount:

THNetDiscount

Currency Head XML

Net Discount Value applied to whole transaction, as shown at the bottom of Sage Line 50 Order.
Apply discount to whole Order/Invoice

THNetDiscDesc

Text 60 HeadOnly XML

Net Discount Description. If used in lines then is the sum of values
Sage 50 overal disocount

Header Payment:

THPayAmt

Double Head XML

Amount Prepaid. Option in 'Setup >> Switches’, can stop posting if UNDER or OVER paid. If used in lines, then posts sum of all lines
Sage 50 Payment with Transaction

THPayRef

Text 30 Head XML

Payment Reference
more about with payment

THPayType^

Text 2 Head XML

Payment Type (PAR/SR/SA). SI or SO should be SA, Post as Type SIAT (SI to Audit Trail) fro SR allocation
more about with payment
    Sage V21 2015 onwards
        In Cell Searching values:Payment Type
                  PAR, Payment already received
                  SR, Allocate Payment To Invoice
                  SA, Post as Payment on Accounts

THPayNom^

Integer Head XML

Payment Bank Nominal
more about with payment
    In Cell Searching values in table NomCodeBank

Analysis:

THAnal1

Text Head XML

Transaction Analysis 1
    Sage V22 2016 onwards

THAnal2

Text Head XML

Transaction Analysis 2
    Sage V22 2016 onwards

THAnal3

Text Head XML

Transaction Analysis 3
    Sage V22 2016 onwards

Header:Add Message:

THMessTop

Text HeadOnly

Add message at top of transaction using S3
Creating Message Top/Bottom

THMessBot1

Text HeadOnly

Add message at bottom of transaction using S3
Message Top/Bottom

THMessBot2

Text HeadOnly

Add message at bottom of transaction using S3
Message Top/Bottom

Line Special Functions:

TLSkipLine

Yes/No

If YES then skip this line

TLForceNewTrans

Yes/NoTF

If YES then force a new transaction

Header Printing:

THPrintEmail

Text Head Pro

Email address to send to. Multiples and be expressed using “,”. If put on lines will then will email doc to address if print dialog is off
Printing after posting a Sage Line 50 Order

THPrintEmailCC

Text HeadOnly

Email address to CC to. Multiples and be expressed using “,”.
more info on printing

THPrintSubject

Text HeadOnly

Subject of email, which overrides that set in System >> Printing.
more info on printing

THPrintBody

Text HeadOnly

Body of email, which overrides that set in System >> Printing.
more info on printing

THPrintAttachment

Text HeadOnly

Add an attachment. Full Path. Multiples and be expressed using “,”.
more info on printing

THPrintLayout^

Text HeadOnly

Sage Line 50 layout file for printing. Enter SPACE to search display list of form layouts
more info on printing
    In Cell Searching values in table FormLayout

THPrintNoCopies

Integer Head Pro

Print x copies to printer. 0 for no print. If put on lines will then will print doc if print dialog is off
more info on printing

Rounding:

THRoundToGross

Currency Head

Round Transaction to this value by either adding a line to add value, or using overall discount

THRoundToNom^

Text 8 Head

Rounding Nominal, if not specified then uses Sales Discount.
    In Cell Searching values in table NomCode

THRoundToDep^

Integer Head

Rounding Depatment
    In Cell Searching values in table DeptCode

Header:Before Posting:

THBefSWCompany^

Text 6 Head Chg Pro

This will cause PostTrans to change company before posting if different from current Sage Line 50 Company. Thus can be user to post transactions into different companies, thus intercompany transactions are possible. It uses a 6 letter company code, which found by pressing the Select Company button in system setup. Must be specified in each row.
Posting to multiple companies
    In Cell Searching values in table CompanySelect

THBefDisplayMess

Text 60 HeadOnly

If contains value, then this text is displayed, and import cannot take place until this text if clear. Thus you can your own formula, macro or VBA code to stop import until a certain condition.
Validating Transaction before posting

THBefDisplayMessYN

Text 60 HeadOnly

If contains value, then this text is displayed. Asks Yes/No to continue
Validating Transaction before posting

Header - After Posting:

THAftWriteRef

Text 60 HeadOnly Read

After posting write back transaction reference to this cell

THAftWriteAlocRef

Text 60 HeadOnly Read

SOP After posting write back stock allocation status, Full, Part

THAftWritePayRef

Text 60 HeadOnly Read

Writes back the reference of payment transaction, if posting a SA on Sales Order

THAftProcessSheet

Text 60 HeadOnly Pro

After posting this sheet, switch to work book with this name, and post that. Allows back to back purchase orders, or multiple company transfers. PRO
Posting into multiple Sage Companies

THAftSwitchSheet

Text 60 HeadOnly Read Pro

After posting this sheet, switch to work book with this name PRO
Posting into multiple Sage Companies

Header - After Save:

THAftSavePATH

Text 60 HeadOnly Read Pro

If THAftSavePATH and THAftSaveFilename specified, will save as PATH + ‘\YYYMM\’ + Filename + "_0000.xls". YYYMM can be overridden with value in THSaveSubDirectory cell.
Saving template after posting

THAftSaveSubDir

Text 60 HeadOnly Read Pro

See THAftSavePATH
more about saving

THAftSaveFilename

Text 60 HeadOnly Read Pro

See THAftSavePATH. Example ‘ABAP01’ will saveas ABAP01_0001.xls.
more about saving

Import File:

THImportFullName

Text 500 HeadOnly

Full PATH and Filename of the file just imported using the Import button. This is required if you set the directory to move file after posting transaction.
File Import instructions

THImportFileName

Text 500 HeadOnly

Filename of the file just imported using the Import button
File Import instructions

After Account Selection:

CuName

Text 60 Read Rel

Account Name. PRO - Double clicking on this cell will drill down to Ledger.

CuBalance^

Currency Read Rel

Balance. PRO - Double clicking on this cell will drill down to Ledger.
Double click to view ledger
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

CuOutOvr30Days^

Currency Read Rel

Outstanding over 30 days.
PRO Double clicking on this cell will drill down to Ledger.
Double click to view ledger
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

CuAvCredit^

Currency Read Rel

Available Credit.
PRO Double clicking on this cell will drill down to Ledger.
Double click to view ledger
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

CuCreditLimit^

Currency Read Rel

Credit Limit. PRO - Double clicking on this cell will drill down to Ledger.
Double click to view ledger
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

CuOutDaysTxt^

Text Read Rel

Outstanding 30,60,90,120 day break down in text form.
PRO Double clicking on this cell will drill down to Ledger.
Double click to view ledger
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

Registered Address:

CuAdd1

Text 60 Read Rel

Account Address Line 1

CuAdd2

Text 60 Read Rel

Account Address Line 2

CuAdd3

Text 60 Read Rel

Account Address Line 3

CuAdd4

Text 60 Read Rel

Account Address Line 4

CuAddPostcode^

Text 60 Read Rel

Account Postcode.
More about Postcode Address Lookup
    In Cell Searching values in table SimplyPostcode

CuCountryCode^

Text 2 Read Rel

Country Code
    Sage V22 2016 onwards
    In Cell Searching values in table CountryCode

CuVATRegNo

Text 20 Read Rel

VAT Registration Number

Contact Information:

CuContactName

Text 30 Read Rel

Contact Name

CuTradeContact

Text 30 Read Rel

Name of Trade Contact

CuPhone

Text 30 Read Rel

Telephone Number

CuPhone2

Text 30 Read Rel

Second Telephone Number

CuFax

Text 30 Read Rel

Fax Number

CuWWW

Text 255 Read Rel

WWW Address

e-mail Settings:

Cue-mail1

Text 255 Read Rel

E-mail Address

Cue-mail2

Text 255 Read Rel

E-mail Address 2

Cue-mail3

Text 255 Read Rel

E-mail Address 3

CuAnal1

Text 30 Read Rel

Analysis 1
    Sage V22 2016 onwards

CuAnal2

Text 30 Read Rel

Analysis 2
    Sage V22 2016 onwards

CuAnal3

Text 30 Read Rel

Analysis 3
    Sage V22 2016 onwards

CuDiscRate

Double Read Rel

Discount Rate %

CuPriceList^

Text 8 Read Rel

Price List Reference
    In Cell Searching values in table PriceList

CuNomCode^

Text 8 Read Rel

Default Nominal Code
    In Cell Searching values in table NomCode

CuTaxCode^

Integer Read Rel

Default Tax Code
    In Cell Searching values in table TaxCode

CuCurrency^

Integer Read Rel

Currency
    In Cell Searching values in table CurrencyCode

CuDepartment^

Text 2 Read Rel

Department Number
    In Cell Searching values in table DeptCode

CuPaymentDueDays

Integer Read Rel

Payment Due Days

CuTermsTxt

Text 30 Read Rel

Terms

CuStatus^

Integer Read Rel

Account Status
    In Cell Searching values in table StatusCode

CuTermsAgreed

Yes/No- Read Rel

Terms Agreed Flag

CuOnHold

Yes/No- Read Rel

Account On Hold

CuMemo

Memo Read Rel

Customer Notes

CuManager

Text 60 Read Rel

Name of Account Manager

Delivery Address:

CuDelAdd1

Text 60 Read Rel

Delivery Address Line 1

CuDelAdd2

Text 60 Read Rel

Delivery Address Line 2

CuDelAdd3

Text 60 Read Rel

Delivery Address Line 3

CuDelAdd4

Text 60 Read Rel

Delivery Address Line 4

CuDelPostcode

Text 60 Read Rel

Delivery Postcode
Postcode Address Lookup

CuDelContactName

Text 30 Read Rel

Delivery Contact Name

CuDelFax

Text 30 Read Rel

Delivery Fax Number

CuDelName

Text 60 Read Rel

Delivery Name

CuDelPhone

Text 30 Read Rel

Delivery Telephone Number

Post Extra Line 1:

THExLineProduct1^

Text 30 Head

Product code. Not used on Service Type Transactions. For Extra Line
    In Cell Searching values in table ProdCodeNoDesc

TLExLineDesc1

Text 60

Product Description. PostTrans stops importing after finding 5 consecutive blank cells.
How Descriptions are Imported

TLExLineQty1^

Double

Quantity For Extra Line (If obmitted set to 1)
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLExLineNet1^

Currency

Unit Price for each item For Extra Line
Unit Price
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLExLineNomCode1^

Text 8

Nominal Code, if not specified then uses default from stock/account. For Extra Line
    In Cell Searching values in table NomCode

TLExLineDepart1^

Integer

Department, if not specified then uses default. Make sure the format of the cell is “General” else search may not work properly. For Extra Line
    In Cell Searching values in table DeptCode

TLExLineTaxCode1^

Integer

Tax Code. Will fill in default if blank. Make sure the format of the cell is “General” else search may not work properly
more about VAT
    In Cell Searching values in table TaxCode

TLExLineTaxManTot1

Currency

Tax Amount if calculated manually. Use with Caution as you are responsible for calculating Tax correctly. For Extra Line
more about VAT

TLExTotIncluOfTax1

Currency Pro

Line Total inclusive of Tax. Best choice when importing data as reduces rounding problems If main Product has Tax then uses the Tax Rate of Product record
more about VAT

Post Extra Line 2:

THExLineProduct2^

Text 30 Head

Product code. Not used on Service Type Transactions. For Extra Line
    In Cell Searching values in table ProdCodeNoDesc

TLExLineDesc2

Text 60

Product Description. PostTrans stops importing after finding 5 consecutive blank cells.
How Descriptions are Imported

TLExLineQty2^

Double

Quantity For Extra Line (If obmitted set to 1)
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLExLineNet2^

Currency

Unit Price for each item For Extra Line
Unit Price
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLExLineNomCode2^

Text 8

Nominal Code, if not specified then uses default from stock. For Extra Line
    In Cell Searching values in table NomCode

TLExLineDepart2^

Integer

Department, if not specified then uses default. Make sure the format of the cell is “General” else search may not work properly. For Extra Line
    In Cell Searching values in table DeptCode

TLExLineTaxCode2^

Integer

Tax Code. Will fill in default if blank. Make sure the format of the cell is “General” else search may not work properly
more about VAT
    In Cell Searching values in table TaxCode

TLExLineTaxManTot2

Currency Pro

Tax Amount if calculated manually. Use with Caution as you are responsible for calculating Tax correctly. For Extra Line
more about VAT

TLExTotIncluOfTax2

Currency

Line Total inclusive of Tax. Best choice when importing data as reduces rounding problems If main Product has Tax then uses the Tax Rate of Product record
more about VAT

Post Extra Line 3:

THExLineProduct3^

Text 30 Head

Product code. Not used on Service Type Transactions. For Extra Line
    In Cell Searching values in table ProdCodeNoDesc

TLExLineDesc3

Text 60

Product Description. PostTrans stops importing after finding 5 consecutive blank cells.
How Descriptions are Imported

TLExLineQty3^

Double

Quantity For Extra Line (If obmitted set to 1)
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLExLineNet3^

Currency

Unit Price for each item For Extra Line
Unit Price
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLExLineNomCode3^

Text 8

Nominal Code, if not specified then uses default from stock. For Extra Line
    In Cell Searching values in table NomCode

TLExLineDepart3^

Integer

Department, if not specified then uses default. Make sure the format of the cell is “General” else search may not work properly. For Extra Line
    In Cell Searching values in table DeptCode

TLExLineTaxCode3^

Integer

Tax Code. Will fill in default if blank. Make sure the format of the cell is “General” else search may not work properly
more about VAT
    In Cell Searching values in table TaxCode

TLExLineTaxManTot3

Currency

Tax Amount if calculated manually. Use with Caution as you are responsible for calculating Tax correctly. For Extra Line
more about VAT

TLExTotIncluOfTax3

Currency Pro

Line Total inclusive of Tax. Best choice when importing data as reduces rounding problems If main Product has Tax then uses the Tax Rate of Product record
more about VAT

Post Extra Line 4:

THExLineProduct4^

Text 30 Head

Product code. Not used on Service Type Transactions. For Extra Line
    In Cell Searching values in table ProdCodeNoDesc

TLExLineDesc4

Text 60

Product Description. PostTrans stops importing after finding 5 consecutive blank cells.
How Descriptions are Imported

TLExLineQty4^

Double

Quantity For Extra Line (If obmitted set to 1)
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLExLineNet4^

Currency

Unit Price for each item For Extra Line
Unit Price
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

TLExLineNomCode4^

Text 8

Nominal Code, if not specified then uses default from stock. For Extra Line
    In Cell Searching values in table NomCode

TLExLineDepart4^

Integer

Department, if not specified then uses default. Make sure the format of the cell is “General” else search may not work properly. For Extra Line
    In Cell Searching values in table DeptCode

TLExLineTaxCode4^

Integer

Tax Code. Will fill in default if blank. Make sure the format of the cell is “General” else search may not work properly
more about VAT
    In Cell Searching values in table TaxCode

TLExLineTaxManTot4

Currency

Tax Amount if calculated manually. Use with Caution as you are responsible for calculating Tax correctly. For Extra Line
more about VAT

TLExTotIncluOfTax4

Currency Pro

Line Total inclusive of Tax. Best choice when importing data as reduces rounding problems If main Product has Tax then uses the Tax Rate of Product record
more about VAT

TLDonFund^

Integer XML

Charity Fund Number
    In Cell Searching values in table CharityCode


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

XML = Un-attended PostTrans XML API for Sage 200

Head  A header tag can be used in header section, before row 30, of the transaction template.  Or in the rows data of data, below row 30, of the template like a traditional CSV importer.

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.

.

Related Example Sheets

You can easily access the example sheets by pressing Help button, on the PostTrans Toolbar to access these related examples, or downloading them from the links below.

To use the template, with Sage 50, install PostTrans. Download
Trial with Sage demo company. Purchase a month subscription for Live Sage Company. Price
Watch the On-line Training course on how to use and customise the templates.

Transaction - Sales:

 

Sales Order PAD Pro

Sheet:'Order PAD'
Order Pad demonstation
   Main page for Posting to multiple Companies

 

Sales Order

Sheet:'SO'
Sales Order demonstation
   Main page for Posting to multiple Companies
   Help article for Posting to multiple Companies

 

Auto saving template after posting Pro

Sheet:'Saving'
Save transaction to directory with account code
   Main page for Saving template after posting

 

Sales Order with Payment

Sheet:'Payment'
Posting a payment with an order
   Main page for Payment with Order/Invoice

 

Printing/e-mail Quote/Order after posting Pro

Sheet:'Printing'
How to e-mail to specified user
   Main page for Printing Quote/Order

 

Sales Service Invoice

Sheet:'Service SSI'
Sales Service Invoice demonstation
   Help article for Sales Service Invoice

 

Sales Service Credit Note

Sheet:'Service SSC'
Sales Service Credit Note demonstation
   Help article for Sales Service Credit Note

 

Sales Receipts - Import Allocation by Referance (Extras Module)

Sheet:'Import Receipts'
Import Sales Receipt and allocated to existing invoices

 

Sales Receipts - Manual Allocation (Extras Module)

Sheet:'Manual Receipts'
Extracts Ourstanding Invoices, enter payment figures and referance, Import to create Sr and allocate

Transaction - Purchase:

 

Expenses + Mileage

Sheet:'Expense demo'
Posting a Expenses + Mileage in as a Purchase invoice
   Main page for Help on this Sheet
   Help article for Help on this Sheet

 

Expenses iPhone/Android or Web via ExpenseIn

Sheet:'Import Expenses'
Import expenses into Sage 50 via IPhone, Android etc. with authorisation
   Help article for Expenses iPhone/Android or Web via ExpenseIn

 

Remote Purchase Order

Sheet:'Orders'
Purchase Order PAD for remote loactions to fill in, e-mail and import.
   Help article for Remote Purchase Order

 

Purchase Order

Sheet:'PO'
Posting a Purchase Order
   Help article for Purchase Order

 

Purchase Order with Authorisation

Sheet:'PO Auth'
Posting a Purchase Order with authorisation

 

Purchase Invoice with Project

Sheet:'PI'
Posting a Purchase Invoice (Project in header)
   Help article for Purchase Invoice with Project

 

Purchase Invoice Multiples + Job Costing

Sheet:'PI Multi'
Posting a Purchase Invoice
   Help article for Purchase Invoice Multiples + Job Costing

 

Purchase Invoice AND adjust stock IN

Sheet:'PIA'
Posting a Purchase Invoice, and then Adjust stock in all in one operation

 

File Import CSV:Multiple Transactions

Sheet:'Multiple Trans'
Shows how you can import Multiple Transactions in one sheet like a convesional CSV importer
   Main page for Importing from file easily
   Help article for Importing from file easily

 

Multiple Transactions Called from VBA Button

Sheet:'Multiple Trans'
Shows how you can import Multiple Transactions in one sheet like a convesional CSV importer
   Main page for Importing from file easily

 

File Import CSV:Multiple Transactions from multiple files

Sheet:'Multiple Trans multi file'
Shows how you can import Multiple Transactions in one sheet like a convesional CSV importer
   Main page for Importing from multiple files easily

 

Import File:Simple Multiple Orders from CSV

Sheet:'Simple Orders from CSV'
Contains two sheets. The first imports three customers, and then an order for each customer in currencies. Demonstrates how to import files easily and importing multiple transactions in one sheet

 

Import File:Customer and Multiple Orders from CSV

Sheet:'Order CSV'
Contains two sheets. The first imports three customers, and then an order for each customer. Demonstrates how to import files easily and importing multiple transactions in one sheet

 

Import File:Multiple Orders from CSV with Currency Pro

Sheet:'Order CSV with Currency Pro'
Contains two sheets. The first imports three customers, and then an order for each customer in currencies. Demonstrates how to import files easily and importing multiple transactions in one sheet

 

BP Cashbook Bank Payment with or without currency

Sheet:'BP Bank Payment'
This imports Invoices BP transactions, optionally with currency, to Audit Trial

 

SC Sales Credit with or without currency

Sheet:'SCAT'
This imports Invoices SC transactions, optionally with currency, to Audit Trial

 

VR Cashbook Visa Credit Receipts with or without currency

Sheet:'VR Visa Credit'
This imports Invoices VR transactions, optionally with currency, to Audit Trial

 

VP Cashbook Visa Credit Payment with or without currency

Sheet:'VP Visa Payment'
This imports Invoices VP transactions, optionally with currency, to Audit Trial

 

CR Cashbook Cash Receipt with or without currency

Sheet:'CR Cash Receipt'
This imports Invoices CR transactions, optionally with currency, to Audit Trial

 

CP Cashbook Cash Payment with or without currency

Sheet:'CP Cash Payment'
This imports Invoices CP transactions, optionally with currency, to Audit Trial

 

BR Cashbook Bank Receipt with or without currency

Sheet:'BR Bank Receipt'
This imports Invoices BR transactions, optionally with currency, to Audit Trial

 

Import File:Direct Debit payments SI+SR with Currency

Sheet:'Direct Debit SI Paymen Currency'
This imports Invoices SI with matching Recipts to Audit Trial with Currency

 

Import File:Orders from CSV with Payment, Rounding and Extra Lines

Sheet:'Order and payment CSV'
This imports orders, and overcomes rounding issues with external system. It also shows how to add addition lines in each row.

 

SR with or without currency

Sheet:'SR'
This imports Invoices SR transactions, optionally with currency, to Audit Trial

 

Cashbook Multi Company and Type

Sheet:'Cashbook Multi Company and Type'
This imports Invoices Cashbook Multi Company and Type

 

PR with or without currency

Sheet:'PR'
This imports Invoices PR transactions, optionally with currency, to Audit Trial

 

Import File:Direct Debit payments SI+SR

Sheet:'Direct Debit SI with Payment'
This imports Invoices SI with matching Recipts to Audit Trial

 

SA with or without currency

Sheet:'SA'
This imports Invoices SA transactions, optionally with currency, to Audit Trial

 

Import Multiple Invoices\Orders NO Print or Price Lookup

Sheet:'Simple Orders No lookups'
Demos importing SI, Credits, Discount and Sales Orders. But after import e-mails the transaction or prints it

 

Posting to Multiple Companies Multi Types Pro

Sheet:'Multi in one sheet'
Inter-company transactions by posting to multiple companies
   Main page for Posting to multiple Companies

 

PA with or without currency

Sheet:'PA'
This imports Invoices PA transactions, optionally with currency, to Audit Trial

 

Import Multiple Invoices\Orders and e-mail/Print

Sheet:'Simple Orders email and Print'
Demos importing SI, Credits, Discount and Sales Orders. But after import e-mails the transaction or prints it

Transaction - Sales/Purchase Design:

 

Shows Customer Price List on header

Sheet:'PriceList'
Adding a tag to header to show the name of the customer price list after selecting the account

 

Message at Top and Bottom of transaction

Sheet:'Message'
Adding a message at top and Bottom of transaction by specifying the header of Sage Line 50 Transaction
   Main page for Creating text message top/bottom of transacton

 

Carriage Charge on Order

Sheet:'Carriage'
How to specify Carriage Charge on an Order
   Main page for Specifying Carriage on an Order

 

Posting Order in Currency Pro

Sheet:'Currency'
How to post to different Currencies
   Main page for Posting Order in Currency

 

Copy formula down sheet

Sheet:'Margin'
Copy formula down sheet, after pressing Clear button, and when populating transaction using the Extract button
   Main page for Clear transaction copy formula

 

Apply discount to whole transaction

Sheet:'Discount'
How to apply discount to the whole Sagel Line 50 transaction
   Main page for Apply discount to whole transaction

 

Validating Transaction before posting

Sheet:'Validation'
Stop PostTrans importing a transaction by using a formula to show message
   Main page for Validating before posting

 

Transaction - Inter Company in 2 sheets using SO/PO Pro

Sheet:'Sales'
Post a Sales Order into one company and a matching Purchase Order in a second company

 

Transaction - Inter Company Nominal in 1 sheet Pro

 

Transaction - Inter Company in 1 sheet Pro

 

Transaction - Inter Company in 2 sheets using SI/PIA Pro

Sheet:'Sales'
Post a Sales Invoice into one company and a matching PIA (Purchase Invoice and Stock Adjust IN) in a second company

Transaction - Chaity:

 

Shows Customer Price List on header

Sheet:'Invoice'
Importing an SI to Charitable Fund

Transaction - Product Adjustment:

 

Product Adjustment

Sheet:'Product ADJ'
Product Adjustment sheet
   Main page for Product Adjustment
   Help article for Product Adjustment

 

Product Adjustment Simple (Code + Qty)

Sheet:'Product ADJ Simple'
Product Adjustment sheet
   Main page for Product Adjustment