Contents 

Fast Start
Weight Scale Interfacing (Digi D770)
What Is Visual Builder?
What's New In Visual Builder?
Creating A CAPITAL Form
Creating a Form - Conceptual Overview
Creating a Form - Quick Guide For Advanced Users
The Forms Wizard
Creating A CAPITAL Report
The Label Wizard
Report Wizard Tutorial
New & Revised Topics in CAPITAL 7.5
AllocatePayment()
CrossTab()
CreateTable()
EventAdd()
FilterTable()
Find()
PayMethodName()
ReadINI()
SendHTMLMail()
TranInfo()
WriteNote()
New & Revised Topics in CAPITAL 7.41
AddPayment()
Business Functions Listing
BufferCommit()
BufferRollBack()
BufferUpdates()
ExportASCII()
GetFolder()
KitList()
LockRecord()
ReadNote()
ReadTextFile()
StockQuantity()
StrWrap()
WriteTextFile()
New & Revised Topics in CAPITAL 7.4
Business Functions Listing
CompanyName()
Department()
Field Objects
JobInfo()
Linking
Moving & Resizing Body Objects
Operators & Expressions
OrderTable()
PathData()
Picture Object Properties
ReadINI()
ReadNote()
RunApplication()
Sample Scripts
Send Product Info Email With Pictures
Start-up Switches
StockAnalysis()
TagInfo()
TranWrite()
WriteINI()
New & Revised Topics in CAPITAL 7.3
AddStock()
AddTraceProperty()
BackAllocate()
Business Functions Listing
CardFileBill()
ComError()
ComClose()
ComOpen()
ComRead()
ComSetup()
ComWrite()
ComputerName()
EchoBox()
EchoBoxOn()
EchoBoxOff()
LockSemaphore()
PasswordInfo()
ScriptRun()
TodoAdd()
Trouble-Shooting Guide
UnlockSemaphore()
New & Revised Topics in CAPITAL 7.2
Business Functions Listing
ImportASCII()
Journal()
ReadNote()
StockGetQuantity()
StockQuantity()
TimeFormat()
Version()
Basic Editing
Moving & Resizing Objects
Moving & Resizing Body Objects
Creating Forms & Reports
Form Bodies
Form Design Hints & Tips
Body Properties
Body Contents
Rule Wizard
Rule Wizard Guidelines
Body Rules
Group Wizard
Body Groups & Totals
Form Output Properties
Form Notes
Question Wizard
Form Question Prompt
Form Questions
Preface and Postscript Scripts
Form Dictionaries
Page Setup
Form Editor Preferences
Field Objects
Field Formulas
Bar Code Field Objects
Text Object Properties
Picture Object Properties
Linking
Why are Table Joins Necessary?
Linking Forms - Concepts
Linking Forms - Tutorial
Linking Forms - Hints & Problem Solver
Special Topics
CAPITAL Data Browser
Bar Codes - An Overview
Cross-Tab Concepts
Cross-Tabs
Cross Tab Fields
Cross-Tab Hints & Tips
Exporting Data
Printing
Transaction (Form) Printing
The Print Job Manager
Windows Printing Concepts
Script Programming
Business Functions Listing
Capital Business Script
Variables & Data Types
Scope
Operators & Expressions
Type Conversion
Business Functions Overview
Commands
CALL
DEBUG
GOTO (label)
IF (expression) GOTO
IF (expression) ... ELSE ... ENDIF
PAUSE
REM (*)
RETURN
Visual Forms Builder Special Variables
Sample Scripts
Sending Email Using CBS
Programmer's Frequently Asked Questions
Business Functions
AAdd()
Abs()
AddCustomer()
AddJobCard()
AddMail()
AddPayment()
AddRecord()
AddStock()
AddTraceProperty()
AllocatePayment()
Alltrim()
AnswerYes()
ArraySort()
Asc()
AsChar()
ASIZE()
AsTran()
AsVal()
AT()
BackAllocate()
BPayCRN()
BPayError()
BufferCommit()
BufferRollBack()
BufferUpdates()
CDOW()
Ceil()
CHR()
CloseFile()
CloseIndex()
CloseTable()
CMONTH()
CompanyName()
CompressTable()
ComError()
ComClose()
ComOpen()
ComRead()
ComSetup()
ComWrite()
ComputerName()
CopyFile()
CopyRecord()
CopyToClipBoard()
CreateFile()
CreateEmailJob()
CreatePrintJob()
CreateTable()
CrossTab()
CTOD()
DateFormat()
DateFromMonth()
DAY()
Dictionary()
DOW()
DTOC()
DTOS()
Echo()
EchoBox()
EchoBoxOff()
EchoBoxOn()
EchoStatus()
Eof()
EraseFile()
EventAdd()
ExpenseAnalysis()
ExportASCII()
FilterTable()
Find()
FindWindow()
ForDate()
FormAdd()
FormResult()
FreeCPU()
FormCreate()
FormShow()
GetField()
GetFolder()
Goto()
GotoBottom()
GotoTop()
HoldRecord()
GroupChange()
Idle()
IF()
ImportASCII()
IndexTable()
Input()
InputFile()
INT()
IsEmpty()
IsFile()
IsFileEnd()
IsLayBy()
IsPaid()
IsPayment()
JobInfo()
JobPriority()
JobStatus()
KitList()
LEFT()
LEN()
LockRecord()
LOWER()
LTRIM()
Max()
Min()
ModemDial()
Month()
MonthEnd()
MonthStart()
NTrim()
NumToWord()
OpenFile()
OpenTable()
OrderTable()
OpenVisualBuilder()
Pad()
PathCompany()
PathProgram()
PayMethodName()
PostMessage()
PriceUpdate
RAT()
ReadFile()
ReadNote()
ReadFileLine()
ReadTextFile()
RecNo()
RenameFile()
Replicate()
Right()
Round()
Rtrim()
RunApplication()
Seconds()
Security()
SendDirect()
SendMail()
SendEscapeCodes()
SendMail()
Shell()
Skip()
Space()
SpecialName()
SpecialPrice()
SQRT()
StockAnalysis()
StockDescription()
StockMovement()
StockPrice()
StockId()
StockQuantity()
Str()
StrLine()
StrLineCount()
Strtran()
StrWrap()
Substr()
StrZero()
Time()
Today()
TodoAdd()
TranAdd()
TranCreate()
TranWrite()
TranInc()
Transform()
TranStr()
Type()
UnlockRecord()
Unpaid()
Upper()
UserName()
UserNumber()
Version()
WaitCursor()
WaitFile()
Week()
Write()
WriteFile()
WriteFileLine()
WriteNote()
WriteTextFile()
Year()
ZipFile()
Tutorials
Report Wizard Tutorial (Basic)
Label Wizard Tutorial (Advanced)
Forms Library
The Visual Builder Report & Forms Library
Forms Stationary
Report Library - Customer Transactions
Report Library - Cash Management
Report Library - Sales Analysis
Report Library - Sales Orders & Back Orders
Report Library - Stock Control
Report Library - Service Management & Periodic Billing
Report Library - Special
Appendix
Moving Forms
Logging On
Overriding Print Warning Messages
Questions & Answers
Start-up Switches
Trouble-Shooting Guide
Weight Scale Interfacing (Digi D770)
Working With Text Printers

CAPITAL Series 7 Visual Builder Reference Guide

Prev Page Next Page

TranWrite() generate/en74.gif

Enterprise Edition Only


Defines the contents of a transaction to be created.

Syntax

TranWrite(cField, [<xValue]) --> lResult

Arguments

<cField> --> The field to store a value in. There are various fields that may be assigned to transactions. These are listed in the table below:

*

Field

Comment

 

NAME

Customer name.

Assign the value "#*#" to retrieve the customer account's default name. However, if you do this be sure to assign the account code first.

 

ADDRESS

First address line.

Assign the value "#*#" to retrieve the customer account's default address. However, if you do this be sure to assign the account code first.

 

ADDRESS2

Second address line.

Assign the value "#*#" to retrieve the customer account's default second address line. However, if you do this be sure to assign the account code first.

 

SUBURB

Suburb.

Assign the value "#*#" to retrieve the customer account's default suburb. However, if you do this be sure to assign the account code first.

 

STATE

State.

Assign the value "#*#" to retrieve the customer account's default state. However, if you do this be sure to assign the account code first.

 

POSTCODE

Postcode.

Assign the value "#*#" to retrieve the customer account's default postcode. However, if you do this be sure to assign the account code first.

 

DNAME

Delivery name.

 

DADDRESS

First delivery address line.

 

DADDRESS2

Second delivery address line.

 

DSUBURB

Delivery suburb.

 

DPOSTCODE

Delivery postcode.

 

DSTATE

Delivery state.

 

TAXNO

Tax number or exemption status if applicable.

 

OURREF

"Our Reference" field.

 

OURREF2

Second reference field.

 

OURREF3

Third reference field.

 

SHIPPED

Shipped/carrier code.

 

REFERENCE

Order number/reference field.

*

ACCOUNT

The customer account code. The maximum length is 8 characters.

 

BILLCODE

The customer account billing code. If the account you are creating the transaction for does not have a head office billing account you do not need to specify the BILLCODE.

Otherwise include this statement:

TranWrite("BILLCODE", Custrec->Cusacc)

to bill the transaction to its head office account. If this is not done the billing code will equal the transaction's account code and the transaction will be visible to this account only.

 

SALESPERSON

Salesperson code.

*

DATE

Date of transaction.

 

DATEDUE

Due date of transaction.

 

TRAN

Transaction type. Must be a character code between "1" and "8". Type 6 (payment) is not allowed. Any other transaction types also defined as payments are not allowed either.

 

EXRATE

The exchange rate.

 

JOBNO

The transaction job number.

 

CHARGE1

User defined charge #1.

 

CHARGE2

User defined charge #2.

 

CHARGE3

User defined charge #3.

 

DepSALES

Department code.

*

LOCATION

You must specify a location if CAPITAL is operating in multi-location stock mode. Otherwise, this field does not need to be specified.

 

Freight

Freight.

* Denotes Required.

<xValue> --> the value to write (store in) the transaction. If this parameter is not supplied, TranWrite() can be used to inquire on the contents of an existing transaction value.

Returns

TRUE if the transaction was successfully updated with a value, otherwise FALSE.

Description

This function is used in conjunction with the Invoice Creation Hook to create transactions based on other transactions existing in the CAPITAL system. Refer to the topic: Issue Invoices found in the main CAPITAL help for more information on this subject.

This function should be called first. It is used to define the contents of an invoice transaction.

____________________________

Related Topics

Business Function List

TranAdd()

TranCreate()