ReadTranValue() generate/enh73.jpg


 

Use the ReadTranValue() function to retrieve information about an open transaction.

Syntax

ReadTranValue(cCode) --> xValue

Arguments

<cCode> --> The value to retrieve. Refer to the table below for avaliable codes and their meanings.

Code

Meaning

Account

The transaction account code.

Address

The first transaction address line.

Address2

The second transaction address line.

Alert

A return value of Y indicates that the transaction has been marked as "on alert."

Bank

The bank account reference. (Generally if this is a cash sale.)

Branch

The branch reference. (Generally if this is a cash sale.)

Coinround

The coin rounding amount if applicable.

Cost

The transaction cost amount.

Change

Indicates the amount of change the customer received in return. (Generally if this is a cash sale.)

Charge0

First freight or handling charge.

Charge1

Second freight or handling charge.

Charge2

Third freight or handling charge.

Charge3

Fourth freight or handling charge.

DAddress

Delivery address transaction line.

DAddress2

Second delivery address transaction line.

Date

Transaction date.

Datedue

Transaction date due.

DName

Delivery name transaction line.

Drawer

The drawer's name on the payment. (Generally if this is a cash sale.)

DState

Delivery state transaction line.

DSuburb

Delivery suburb transaction address line.

Exrate

Exchange rate if applicable.

Excise

The excise value assigned to the transaction.

Freight

Total freight value charged.

Jobno

Job number reference. This is the default for the entire transaction.

Istaxed

Returns TRUE if the transaction is not GST free or tax exempt.

Orderedby

The operator code. The person who has entered the order or transaction.

Ourref

Reference #1

Ourref2

Reference #2

Ourref3

Reference #3

Payment0 -

Payment9

The payment method amount. For example, Payment0 is the first payment method amount. Payment1 is the second payment method amount, and so on. (Generally applies to cash sales only.)

Postcode

Transaction postcode.

Reference

Transaction reference line.

Required

The sales order required date.

Salesperson

Salesperson code.

Stampduty

The amount of hire stamp duty applied to the transaction.

State

The transaction state.

Suburb

The Suburb transaction address line.

Shipped

Shipping instructions.

Tax

The tax/GST amount if applicable.

Taxno

The tax number or tax reference code.

Total

The transaction total value.

Tran

The transaction type. This is a number between 1 and 8 returned as a character string.

Tranno

The transaction number.

Weight

Transaction total weight.

Returns

The current contents of a specified field in the transaction is returned.

Description

Use this function to query information about a transaction.

Example

If IsEmpty(ReadTranValue("Account"))

   Echo("Account code missing.")

Endif

____________________________

Related Topics:

Invoice Columns Hook

Invoice Pre-Saving Hook

Other Transaction Pre-Saving Hooks

ReadItemValue()

Transaction User Columns Hook



Help Topic Map