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

Validating Transaction before posting

Before you allow PostTrans to Post a transaction into Sage 50 you may want to do your own validation.

 Example: Press Help, on the PostTrans toolbar, then select example “Validating Transaction before posting” which is the example discussed below.   You should also have read the "Importing Transactional Data" on the Training page for a basic understanding of PostTrans basics.

Example – Stop Transaction Posting

If we take the standard post a transaction template:

image

We can select cell C7, and add tag c, under the ‘Header’ tab of the PostTrans tags side bar.  Thus we have:

image

We can now add a formula in cell C7

=IF(K9<30,"Margin below 30%","")

which says if the margin is below 30% then the cell contains a message “Margin below 30%".

If the cell is not blank then PostTrans will display the message held in the cell, with tag THBefDisplayMess.   PostTrans will not allow the user to post the transaction into Sage Line 50/200 until the value has been cleared from cell C7,

The result would be:

image

Example – Stop Transaction Posting with Question

Tag THBefDisplayMessYN offers similar functionality, but the user is asked if the want to continue:

image

 

Tags of interest

The following PostTrans tags allow the above functionality:

Tag Name

Data Type

Description

THBefDisplayMess

Text

If contains value, then this 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.

THBefDisplayMessYN

Text

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


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: Transaction Data, Fast Orders Entry | Tags: | Return

Post a Comment

Blog Categories