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

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

Multiple Transactions from CSV file

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

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 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Manufacturing

200 Manufact.

Create BOM Stock Easily
Create Bill of Materials
Labour, Machine, Tools

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

50 Projects

PostTrans Blog

Why not sign up to recieve news, tips, ideas, training.  Sign up for bi-weekly newsletter.

Blog Search

Viewing Sage 50/200 Ledger from template

The PostTrans tags CuBalance, CuOutOver30Days, CuCreditLimit, CuAvCrdit return the currently selected account  credit and balance figures.  The user can double click on these figures to access the ledger:

image

 

Having double click you will see:

image

Thus while taking an order, the user can discuss and follow up outstanding Invoices.

This requires the Pro version of PostTrans

Tags of interest

The following PostTrans tags allow the above functionality:

Tag Name

Data Type

Description

CuBalance

Currency

Customer Balance

CuOutOvr30Days^

Currency

Figure Outstanding over 30 days.

CuAvCredit^

Currency

Available Credit.

CuCreditLimit^

Currency

Credit Limit.

CuOutDaysTxt^

Text

Outstanding 30,60,90,120 day break down in text form.


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

Post a Comment

Blog Categories