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

image

If tag TLTaxCode is added.  Then tag TLTaxCode is populated with the default TAX code as discussed earlier.

image

The Tag TLTaxAmount contains the TAX, or VAT value, when the TLTaxCode, TLUnitPrice, TLQty, TLDiscValue or TLDiscPerc column values are changed by the user.  Thus the Tag TLTaxAmount  can be used to calculate the VAT content of the transaction.

Both tags TLTaxCode and TLTaxAmount, can be deleted if not required as PostTrans will do the calculations in the background.

If the user alters the TLTaxCode , then the VAT will be calculated at the new rate.

Sage 50 VAT calculation

Its worth noting that Sage 50 calculates VAT having deducted any settlement discount defined on the account record.  This is taken in account on the TLTaxCode figure.

Sage 50 Manual VAT

You can override the VAT value by simply adding the tag TLTaxManAmount

Example: Press Help, on the PostTrans toolbar, then select example “Manual VAT” which is the example discussed below.

image

Pressing import button results in:

image

Note: This must be used with extreme caution, but if importing transactions from external source then it may be needed to overcome rounding issues.

Tags of interest

The following PostTrans tags allow the above functionality:

Tag Name

Data Type

Description

TLQty

Text

Quantity. PRO - If switch 'Iignore 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

TLUnitPrice

Text

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.

TLTaxAmount

Text

Tax Amount

TLTaxCode^

Text

Tax Code

TLDiscPerc

Text

Additional Discount Percent to be applied to TLUnitPrice, Value should be specified in TLDiscValue OR TLDiscPerc but not both cells. Note TLUnitPrice has already had any system discount applied on account record.

TLDiscValue

Text

Additional Discount Value to be applied to TLUnitPrice, Value should be specified in TLDiscValue OR TLDiscPerc but not both cells. Note TLUnitPrice has already had any system discount applied on account record.


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

Where ^ denotes a Code Search field (Popup search window), delete ^ at end of tag, to turn off code search

Categories: Sage Line 50, Transaction Data | Tags: | Return

Post a Comment

Blog Categories