New Feature - to Display buttons to allow user to adjust VAT by +/- 0.01 pence on confirmation window. This allows slight adjustment when importing from external systems which use different rounding rules.

V5.6.186 27/2/2006 XLA 5.6.120 Lookup XLA 5.6.115

Did not process the Employee rates correctly, option "Global, Own, Job" was getting "Global" rates first, which is logical. In enterprise "Own" takes precedence over "Global".

Also "Global, Job, Own"

Slight change for customer

Added Do NOT set costs automatically on SOR

New Feature - Added a filter for currency on the Account and Stock discount matrix window

V5.6.179 6/2/2006 XLA 5.6.120 Lookup XLA 5.6.115

Price Matrix import causing duplicates, or appeared to (0 and 1 look same in Enterprise)

V5.6.175 20/1/2006 XLA 5.6.120 Lookup XLA 5.6.115

New Feature - holding down SHIFT while posting transaction puts it on "Query"

When loaded locally, used to come up with warning message about not being in PATH statement. Fixed

New Feature - When option "Import blank notes"=ON, then suppress word wrap.

V5.6.167 4/1/2006 XLA 5.6.120 Lookup XLA 5.6.115

Updating Discount matrix, for same account/stock items with different currency, overrode previous entries. Fixed

V5.6.162 10/12/2005 XLA 5.6.120 Lookup XLA 5.6.115

If over 150 lines in summer then came up with warning, FIXED

Other minor changes for customer for printing Trans + Fax

V5.6.155 6/12/2005 XLA 5.6.120 Lookup XLA 5.6.115

Made changes to Order from Cheapest Supplier, to order with cost price to 4 dp.

V5.6.134 17/11/2005 XLA 5.6.120 Lookup XLA 5.6.115

Added posting SAGE opening balances to Post History example

If update transactions was on, and tried to post multiple trans, then tried to update what had be been posted. Fixed by automatically turning flag off in settings

Credit check only worked if conformation window was enabled. FIXED

if "EXCHPATH" in path, then suppress Path message

When Lookup button looks up data, only clear columns it needs too

New Feature - Added ability to import up to 25 lines of general Notes against a transaction for customer.

V5.6.125 14/10/2005 XLA 5.6.120 Lookup XLA 5.6.115

New Feature - Support for multiple lines on stock records

New Feature - Added Account code and Stock code to lookup criteria where applicable

Fixed slight bug in Stock record selection

V5.6.122 30/9/2005 XLA 5.6.120 Lookup XLA 5.6.115

Fix Cost price was not being updated on multi-Bin when moved to location

Removed restriction IN/OUT locations must be different

V5.6.120 22/9/2005 XLA 5.6.120 Lookup XLA 5.6.115

New Feature - Added a "Find" button for customer to allow search for transactions and open linked document

V5.6.117 21/9/2005 XLA 5.6.115 Lookup XLA 5.6.115

New Feature - Added support to have User name specified in header of spreadsheet

New Feature - Stock ADJ, with Serial/Batch codes, contra's Serial/Batch to location

V5.6.115 15/9/2005 XLA 5.6.115 Lookup XLA 5.6.115

Add support for returns fields on Stock Records

V5.6.105 14/9/2005 XLA 5.6.111 Lookup XLA 5.6.110

New Feature - Stock ADJ with Bin codes allows user to specify the Bin Code to contra too

Slight Display enhancements

Changed System set-up validation

Changed Stock Take tag STKTakeQtyFree to STKTakeSystemQty, more logical

Amended the above tag to post the "In stock" figure for "Normal" stock

V5.6.101 7/9/2005 XLA 5.6.100 Lookup XLA 5.6.102

First release

V5.6.15 19/8/2005 XLA 5.0.11

Interim release for testing

V5.6.12 12/8/2005 XLA 5.0.8

Interim release, new functionality for Exchequer customer

New Features -

Lookup popup for easy code entry (Professional Version)
New option to stop negative stock
Credit check account option
Up to 12 General Notes lines on Transaction, all of which word wrap
Dated notes on Transaction with alarm
Printing/Faxing/e-mail transactions (Professional Version)
Looks up Job costing Time rates rules
Supports Stock adjustments
Can now update Transactions, except TSH/ADJ/SRI/PPY
Warns if GL is inactive
Supports Serial and Batch Transactions (Professional Version)
Supports Multi BIN Transactions (Professional Version)
Stock Take, including Serial/Batch/Multi-Bins (Professional Version)
Discount Matrix support Effective dates (Professional Version)
Can now delete stock alternate database entries
Attach up to three linked document to a transaction
Can now specify Payment details in header for SRI's for Credit Card details
If when populating a large sheet >65000 lines then creates new copy sheet and populates it
[Update Lookup] button populates data for
1. Customer
2. Supplier
3. Stock
4. Discount Matrix
5. Alternate code DB
6. GL
7. BOM
8. Job
9. Job Analysis
10. Employee's
11. TIme Rates

New Fields - Customer/Supplier

Field Name	Type	Description
OrderConsMode	Long	Order Consolidation mode 0-8
SOPConsolidatedToHO	Yes/No	SOP Consolidated To Head Office

New Fields - Stock

Field Name	Type	Description
ShowAsSalesPacks	Yes/No	Order Consolidation mode 0-8
UsesBins	Yes/No	Use multi bins
WOPProdTimeDays	Long
WOPProdTimeHours	Long
WOPProdTimeMins	Long
WOPCalcProdTime	Yes/No	Auto Calc Prod Time
WOPMinEcQty	Long	Min Economic build qty
WOPIssuedWIPGL	Long	WIP GL
WOPLeadTime	Integer	Lead time in days
PriceByStockUnit	Integer	Price by Stock Unit 0, Sales Unit 1, Split pack 2
LineType	Integer	Default Line type 0-5
ShowBOMKitOnSales	Yes/No
ShowBOMKitOnPurchases	Yes/No

New Fields - Transaction

Field Name	Type	Description
TransLookup		Must be in cell A1, enables lookups on transactions (Professional version)
ADJQtyIn	Double	Qty in
ADJQtyOut	Double	Qty Out
ADJBuild	Boolean	Build BOM * not implemented
BinCode	Text List	Bin Code
BinQty	Double List	Bin Qty, to specify the qty for each bin optional
BinSellByDate	Date List	Date
BinPickPriority	Text List	Picking Priority
BinTagNo	Text List	Tag no of item
BinUOM	Text	Unit of measure text
BinAutoPickMode	Integer	Default 0,Lock Bin 1, Quarantine Bin 2, Tag no 3
BinCapacity	Double List	Capacity of Bin
SBSerialNo	List	Serials number of Product comma delimited list
SBBatchNo	Text	Batch number
SBSellByDate	Date	Sell by date
SBBinNo	Text	Bin number
StkTakeFree	Double	Will write the Stock Take Free Qty to this cell
StkActual	Double	User enters Actual stock Qty here, system then posts difference

New Fields - Discount Matrix

Field Name	Type	Description
EffectiveDateStart	Date	Start date of price (waiting for COM toolkit to allow changes to these)
EffectiveDateEnd	Date	End date of price
DeleteRecord	Flag	Delete record if =X
StockDescription	Text	Stock description from Stock record (Read Only)
AccountName	Text	Account Name

New Fields - Alternative Code Database

Field Name	Type	Description
DisplayOrder	Yes/No	Display Order
ReplacementQty	Yes/No	Replacement Qty
UseReplacementQty	Long	Use Replacement Qty
ESOType	Long	E= Equivalent, S= Superseded or O=Opportunity
StockDescription	Text	Stock description from Stock record (Read Only)
AccountName	Text	Account Name
DeleteRecord	Flag	Delete record if =X

New Fields - BOM

Field Name	Type	Description
UnitCost	Double	Unit cost (Read only)
BOMStockDescription	Text	Stock description of Child Item (Read Only)
ComponentStockDescription	Text	Stock description of Parent Item (Read Only)

V5.6.11 7/6/2005 XLA 5.0.7

Added user count to system

V5.6.9 6/6/2005 XLA 5.0.7

Time sheets were being posted to wrong GL when job invoiced. This bug was due to the COMToolkit rewrite, earlier this year, changing the behavior FIXED

SOR/POR had wrong overall delivery date if not specified on sheet. FIXED

New Feature - Added TLExchangeRate to allow NOM with different currencies and added an example

V5.6.7 4/5/2005

Fixed slight problem calculating VAT on POR

V5.6.5 9/3/2005

Found Due date was set wrong due to the COM rewrite

V5.6.4 21/2/2005

"Stop" encountered when posting NOM, Fixed

V5.6.3 7/2/2005 XLA 5.0.6

Customer Specific Change (Tenda)

V5.6.2 22/1/2005 XLA 5.0.6

New Feature - Holding down ALT, after Transaction is posted or after error, now forces the transaction browse window to be displayed for debug purposes.

More bespoke alterations for selecting cheapest supplier for POR

Vat calculated by COM Toolkit, to Exchequer rules. No more VAT rounding errors.

Now switches back to Excel at end of import operations. Used to some time leave focus on wrong application.

Automatically sets the number of decimal places to Exchequer settings

Used to come up with "Microsoft Excel is waiting for another application to complete an OLE action." When PostTrans was working. FIXED

15/1/2005 DLL 5.5.16 XLA 5.0.5

New Feature - Import Alternate Stock code DB

New Feature - Add function to Delete Customer/Stock Discount matrix entries. Note : cannot delete Supplier entries due to no Exchequer DLL functionality

New Feature - Add function to lookup cheapest prices, when importing POR, from Supplier Alternate Stock DB and apply discount if specified in matrix

Add new Tags for Alternate Stock DB import to XLA

21/10/2004 DLL 5.5.14 XLA 5.0.4

New Feature - Import discount Matrix for Suppliers as well as customers

Restricted Discount and BOM to full payment of software

8/9/2004 DLL 5.5.12 XLA 5.0.4

Fixed a bug in Discount/VAT calculation

Now allows you to override the GL when Job analysis code is specified

1/7/2004 DLL 5.5.10 XLA 5.0.4

When Office has been installed without a registration name being entered could not unlock software. FIXED

Found new feature had effected the "POSTED" flag causing lines to be re imported FIXED

25/6/2004 DLL 5.5.9 XLA 5.0.4

Could not previously import qty breaks for stock record FIXED

21/6/2004 DLL 5.5.8 XLA 5.0.4

Found the Due data of the Transactions could not be

24/2/2004 DLL 5.5.7 XLA 5.0.4

Post Back the Transaction number after the POSTED flag

If "*" is entered as a description then looks up stock description

Changed the setup to install common dialogue OCX on each computer. Before caused problem on XP machines

24/2/2004 DLL 5.5.6 XLA 5.0.4

Added functionality to alter lines on Transactions which have not been posted.

20/2/2004 DLL 5.5.5 XLA 5.0.2

Found that if account code is less 6 chars long then did not update accounts properly

4/1/2004 DLL 5.5.4 XLA 5.0.2

Found that importing NOM, had N/A in the VAT line, but also had a VAT code. When the user edited the NOM in Exchequer then each line had to be edited to put correct VAT settings in. Fixed

1/8/2003 DLL 5.5.2 XLA 5.0.2

On very old systems, single currency, gave an error. Fixed
Found it was possible to import stock heading with wrong parent Fixed

28/5/2003 DLL 5.5.0 XLA 5.0.2

New Feature - BOM Import added

Version for V5.5
Stock record descriptions can now be 10 chars, previous 7

Changed the way it sets stock levels (Customer specific)

BOM import added

28/1/2003 DLL 5.00.3 XLA 5.0.2
BOM Import added

10/12/2002 DLL V5 XLA V5.0.2

Better error reporting if type mismatch
CSFormNo can now be updated.

1/11/2002 DLL V5 XLA V5.0.1

Small fix for a customer specific problem (Stock take with multi locations)
If 'AccountCode' tag was moved in Customer/Supplier moved then caused a problem

4/4/2002 DLL V5 XLA V5.0.0

Version for Exchequer V5

Tag Numbers added to Accounts records and Transaction Headers

20/3/2002 DLL V4.32 XLA V4.0.0

If importing Transactions, then does no longer requires Job code if specified as column, but warns that blank Job codes exist.
If Description = "." then skip the line.
BUG FIX: If the Customer/Supplier record specifies a different Control GL account then only read the first account, if multiple accounts imported.
Network installation
No longer need Exchequer in the PATH statement

28/2/2002 DLL V1.1.18 XLA V1.0.8
Can now import discount matrix for Customers
If importing Transactions, then does no longer requires Job code if specified as column, but warns that blank Job codes exist.
If Description = "." then skip the line.
BUG FIX: If the Customer/Supplier record specifies a different Control GL account then only read the first account, if multiple accounts imported.

16/11/2001 DLL V1.1.16 XLA V1.0.8

Can now post General notes on Transactions, Stock and Accounts
The new SSD fields added to Customer and Stock records
NOM can have Contra account specified, if so the auto creates an extra line to contra out the main line.
Switch added to stop it enforcing Job codes when Job Columns are specified

31/8/2001 DLL V1.1.14 XLA V1.0.7
All imported transactions had Discount Taken ticked which shouldn't be. FIXED
If the Ctrl GL code is overridden checks it is a control account and displays in conformation that it has been overridden
If payment does not balance on a SRI, PRI then optionally auto create payment side for easier importing of History.

28/7/2001 DLL V1.1.13 XLA V1.0.7
Warns when importing Stock records that the Cost price cannot be update if LIFO or FIFO, OLE allows this as work around.

1/7/2001 DLL V1.1.12 XLA V1.0.7
If the Ctrl GL code is overridden checks it is a control account and displays in conformation that it has been overridden
If payment does not balance on a SRI, PRI then optionally auto create payment side for easier importing of History.

16/6/2001 DLL V1.1.11 XLA V1.0.7
Previous versions did not allow VAT when posting Payment lines in SRI's. FIXED

2/6/2001 DLL V1.1.10 XLA V1.0.7

New switch added to System Setup. "Use Account Alt Search Ref" on the "Trans Switches" Tab. PostTrans will use the "Alt Search Ref" for account code instead of the A6 normal one
Cleans imported codes with "," in them. This allows "AAA, General Cost Centre" to be treated as AAA, therefore can add combo boxes to enter data.
Better error message for those people who have not read the manual
Does not require GL codes when importing Customers/Suppliers
Can now be installed in any directory (Could not on older versions)
Auto calc VAT (but not for payment lines)

21/1/2001 DLL V1.1.9 XLA V1.0.5

Imported transactions appearing as tagged in daybook fixed.

21/8/2000 DLL V1.1.8 XLA V1.0.6

Very minor bugs corrected when clearing the import template via [Clear Transaction] button.

New feature to update TLUser 1-4 fields between two periods for a Stock item. Written for a customer who wants to post back a revised cost for stock items months after the transactions has been posted.

21/8/2000 DLL V1.1.7 XLA V1.0.5

Extra tag added "SkipLine" to make PostTrans skip lines. Added to allow new timesheet import format.

3/8/2000 DLL V1.1.6 XLA V1.0.3

Customer specific additions, plus small bugs removed.

23/5/2000 DLL V1.1.3 XLA V1.0.3

New version for Exchequer V4.31.

20/2/2000 DLL V1.1.2 XLA V1.0.3

New Feature - 2000 or more Transaction Lines per Transaction

New Feature - Importation of GL Records

Press the [Design] button to view tags in the Design Window.

Field Name	Type	Description
GLPosted	Yes/No	Returns 'POSTED' if Trans line has been posted and will be ignored if 'POSTED' (required)
ErrorDesc	Text	Description of error posted back if record unsuccessfully posted
GLCode	Long	GL code (Required)
Description	Text 40	Description (Required)
ParentGLCode	Date	Parent GL code (Required)
Type	Text 1	H - Heading, A - P/L, B - Balancesheet, F - Carry Forward and F - Carry Forward (Required)
Page Break	Yes/No	If Yes then page break else No
CarryForwardTo	Yes/No	Carry forward
Revalue	Yes/No	If Yes then revalue else No
SubTotalAtEnd	Yes/No	If Yes then sub total at end else No

New Feature - Importation of Bank Reconciliation Records

Press the [Design] button to view tags in the Design Window.

Field Name	Type	Description
ABPosted	Yes/No	Returns 'POSTED' if Trans line has been posted and will be ignored if 'POSTED' (required)
ErrorDesc	Text	Description of error posted back if record unsuccessfully posted
BankRef	Text 40	Reference which should match the payment ref entered (required)
BankValue	Double	Positive value for Receipts, negative for payment (required)
TransDate	Date	Transaction date (required)
BankGLCode	Long	Overrides the default set-up in system settings
Currency	Integer	0-29,1=Sterling, Optional (default=1)

1/2/2000 DLL V1.1 XLA V1.0.2 released contained on February 2000 CD-ROM

Because of the new functionality included in Version 1.1 no upgrade from V 1.0.x to V 1.1 is available.

Please Install V 1.1 over the top of previous versions..

5/1/2000 DLL V1.0.10 XLA V1.0.2

New Feature - Automatically sets CC/Dep On/Off

New Feature - Scrolls through data while importing

While importing the cursor moves through data on sheet. Very Sexy!

New Tags

The following Tags were added to override Transactions Header values

THYear

THPeriod

THDelAdd1

THDelAdd2

THDelAdd3

THDelAdd4

New Feature - Code conversion

The following Tags have been added which allow external Ref. numbers, used by older external systems, to be imported into Exchequer Account fields. PostTrans will then convert external reference number, as long as they are unique, into Exchequer account codes based on the reference (held in User 1 etc) numbers held in Exchequer. Therefore an external system does not need to know the Exchequer account code. After conversion PostTrans can be set-up to write back the account code to the spreadsheet for extra conformation.

ACName

ACConvertUser1

ACConvertUser2

ACConvertUser3

ACConvertUser4

ACConvertVATReg

ACConvertSortAndBankCode

ACConvertPhone

ACConvertPhone2

ACConvertFax

ACConvertAccForUS

ACConvertTerms1

ACConvertTerms2

The above functionality was added to allow the easy importation of opening balances from an older system when changing the original account codes.

New Feature - Force separate lines

Two new tags added:

THForceSeparateTrans Forces a new Transaction
PostBlankDescription PostTrans stops importing when it finds a blank Description line. The tag overrides this system allowing the importation of blank Description lines.

New Feature - Lookup Stock Price

If a Stock code is specified then PostTrans will lookup Description line 1, Cost Price, Sales Price (Band A), Weight from Stock Module. This values can then be overridden by specifying within the spreadsheet. Therefore only need to specify stock code and Qty to input a line.

Note : This does not apply price matrix and customer discount. This may be completed in future versions.

09/12/1999 DLL V1.0.7

By default when creating a new account Enterprise ticks "Print Statement". This has been added to PostTrans.

December 1999 Showcase CD-ROM contains V1.0.6

21/11/1999 DLL V1.0.6

PostTrans now shows the default values before importing Stock and Account records. Default values, for transaction, can also be view from the conformation window menu. These new features make it easier to use.

Stock import PORPrice and LastPrice were being imported into LastPrice

1/11/1999 DLL V1.0.1

Fixes problem with dates being treated as American date format.

November 1999 Showcase CD-ROM contains V1.0.1

[ Home ] [ Up ] [ More about Exchequer Software ] [ IRIS Enterprise Software ] [ WebRangle Linking ]

Last modified: February 15, 2008