IRIS Exchequer Enterprise Plug-ins

MS SQL Version Notes:

---

Issues have been found when running PostTrans with the MS SQL version of Exchequer. The following functionality, which is used by very few users, may not work if using PostTrans with Excel 2000/2003:

• Import/Update Discount Matrix works, but cannot delete matrix entries. This can be done in Exchequer by copying empty matrix to same account types anyway. Simply remove DeleteRecordFlg Tag to stop 1114 error.
• Import Batch Payments for auto bank rec
• Update user defined fields after posting

As these functions use the DLL toolkit, and it is suspected that Excel 2000/2003 stops the .NET Pervasive emulator (a .NET component) from communicating with the Exchequer DLL toolkit.

Vista Issues:

---

I get repeated errors under Vista. Error "Problem getting values from registry key:..."

Reason

User Access Control is stopping PostTrans installing

Answer (6.7.2 Aug 2011 onwards)

PostTrans from Aug 2011 includes a "PostTransInstall.exe", in the Exchequer directory, which will attempt to fix this issue.  It must be run with admin rights otherwise it will not fix problems.

Answer (pre Aug 2011)

Close Excel

Often the tighter security controls in Vista stops PostTrans installing the necessary component automatically.

You need to open regedit and give FULL rights to the Everyone for following keys

• HKEY_CLASSES_ROOT\CLSID\PostTrans.Exch\ClsID\InprocServer32     (may not exist)
• HKEY_CLASSES_ROOT\CLSID\{D7AF2B20-8D38-11CF-BD36-444553540000}\LocalServer32  

To do this find the key, right click and select permissions.  Press [Add] button and type "Everyone" in box.  Press [OK] then tick Full control which is the top option in list of permissions.

Now retry Excel with PostTrans.xla enabled.

Error "error 76" or "error 5"

The Vista User Access Control (UAC) is stopping the automatic installation.   Disable the UAC, which requires a reboot, run the Excel and no errors should appear.  Next re-enable the UAC and every thing should be OK.

How to disable the User Access Control

Installation Issues

---

I get error 5 or 8 when I open the spreadsheet?

Reason  

The software has been installed when logged in as a different user, and the software cannot access the registry keys for the current user.

Answer (6.7.2 Aug 2011 onwards)

PostTrans from Aug 2011 includes a "PostTransInstall.exe", in the Exchequer directory, which will attempt to fix this issue.  It must be run with admin rights otherwise it will not fix problems.

Answer (pre Aug 2011)

Start "regedit"

Give Full permission to "Everyone" for the following keys:

• My Computer/HKEY_CLASSES_ROOT/CLSID\PostTrans.Exch\ClsID\InprocServer32 
• My Computer/HKEY_CLASSES_ROOT/CLSID\{D7AF2B20-8D38-11CF-BD36-444553540000}\LocalServer32

Exchequer is not in your PATH Statement

Reason  

Your installation of Exchequer must be in the PATH statement

Answer (6.7.2 Aug 2011 onwards)

PostTrans from Aug 2011 includes a "PostTransInstall.exe", in the Exchequer directory, which will attempt to fix this issue.  It must be run with admin rights otherwise it will not fix problems.

Answer (pre Aug 2011)

• Right click on "My Computer" then select properties
• Select "Advanced Tab"
• Press [Environment variables] button
• Select "path" in the bottom list 
• Press [Edit] button
• Add Exchequer directory to list.  Note you should already have a reference to the BIN sub directory.  Remove unwanted references to Exchequer

Or

Remove any unwanted references to Exchequer in PATH using above method and then run SETPATH.EXE from the "wstation" sub directory of Exchequer

and tick all tick boxes

I have upgraded PostTrans but it is the same version as before?

Nothing makes sense, how can I un-install and reinstall PostTrans

Reason  

If you have more than one installation of Exchequer, you may have installed PostTrans in a different place

Answer

• Open DOS prompt
• Navigate to the Exchequer directory
• When in Exchequer directory type "RegSvr32 PostTran.dll" this should then say

 

• Now open excel, go to "Tools >> Add ins" untick all references to PostTrans

 

• Press [OK]
• Next go to "Tools >> Customize" menu:
  

 

• Select "Post Transaction" entry then press [Delete] button to delete toolbar
• Close Excel
• Open Excel
• Now open excel, go to "Tools >> Add ins", now press [Browse] button
• Find Exchequer directory and select "PostTrans.xla"
• Answer NO to next question
• Add PostTransLookup.xla if you use it, in a similar fashion
• Close Excel
• PostTrans has now been re-installed to new directory
  

When I start Excel I get an Automation error with a large negative error number.

Reason

The PostTrans COM object cannot be found.  Each COM object is registered in the registry, but your settings in the registry are wrong.

Answer (6.7.2 Aug 2011 onwards)

PostTrans from Aug 2011 includes a "PostTransInstall.exe", in the Exchequer directory, which will attempt to fix this issue.  It must be run with admin rights otherwise it will not fix problems.

Answer (pre Aug 2011)

• Firstly be very careful!
• Run “regedit”.
• Make sure the cursor is at the top of the tree on the left hand pane of the window
• Click on “Edit” menu and select “Find”
• Enter “PostTran” in the find window.
• Press [OK]
• RegEdit will then move to the first entry for this key.  Select the large key on left hand side:

 

• This should end in “0559C83}”
• Right click and select “Delete”.
• Now press [F3], to search again.
• RegEdit should now find another entry:

 

• This should read in “PostTrans.Exch
• Right click and select “Delete”.
• Now run Excel and use PostTrans, problem should now be fixed.

Reconfigure Installation due to server move

This may be needed if PostTrans has been moved between two servers.

Answer (6.7.2 Aug 2011 onwards)

PostTrans from Aug 2011 includes a "PostTransInstall.exe", in the Exchequer directory, which will attempt to fix this issue.  It must be run with admin rights otherwise it will not fix problems.

Answer (pre Aug 2011)

Make a batch file to run:

x:
cd entrprse
pause
regsvr32 posttran.dll /u
pause
regsvr32 posttran.dll
pause
posttran.exe
pause
AddExchPath.EXE
pause

 

Newer version of Excel gives an error about Forms not being licensed

Reason

Your Excel Spread sheet contains a form. These can cause problems with newer versions of Excel.

Answer

Remove them as they are not used

• From within Excel press [Alt] + F11. This will open VBA code editor
• You should see a project tree on the left-hand side. If not click “View >> Project Explorer”
• Under the name of the sheet you have open, in the project tree highlight each form and right click:
  

• Now right click and select "Remove ...".  this will delete the form
• Answer NO to question about exporting the form.
• Repeat to delete all forms
• Now save your spreadsheet
• Fixed
  

Useful Code:

---

To activate [Post Transaction] from VBA use the following before:

Function PostCustomerOrder()
    'Select correct sheet before posting
    'As usually one sheet can be a user interface, then PostData in PostTrans format
    Sheets("PostData").Select

    'Call PostTrans
    Application.Run macro:="PostTransaction"

    'If posted do something else ???
    If Left$(ActiveSheet.Range("A62").Value, 6) = "POSTED" Then
       ' MsgBox "Sales have been posted!"
       ActiveSheet.Range("H33").Value = "Sheet has posted"
      
       PostCustomerOrder = True
    Else
        MsgBox "Sales side has not posted due to an error.   Please resolve and try again!"
    End If
End Function

Using the above all sorts of things are possible!

Other usefull code is:

'Used to remeber original sheet, and then select after posting
Dim t$
t = ActiveSheet.Name
Sheets(t).Select

'Select a cell.  Usefull for allying validation in VBA
ActiveSheet.Range("a21").Select

'Save workbook
ActiveWorkbook.Save

'Delete contents of block of cells
ActiveWorkbook.ActiveSheet.Range("A60:A999").Select
Selection.ClearContents

Excel 2010 Security Issues:

---

Note: Office 2010 64bit is NOT supported and does not run.  32 bit Office is OK.

We have two choices here

1)      Trust the Enterprise folder in the Trust Centre

       a.       In Excel “File >> Options”

       b.      Select “Trust Center” on left-hand list

       c.       Press [Trust Center Settings] button

       d.      Select “Trusted Locations” on left-hand list

       e.      Press [Add new location]. Add the Enterprise directory to list.  Also tick sub-directories.   Use UNC PATH ONLY

       f.        Now add the add-ins. 

       g.       Close Excel and Test

2)      Trust all files on your network.

       a.       In Excel “File >> Options”

       b.      Select “Trust Center” on left-hand list

       c.       Press [Trust Center Settings] button

       d.      Select “Trusted Documents” on left-hand list

       e.      Tick “Allow documents on a network to be Trusted”

       f.        Now add the add-ins. 

       g.       Close Excel and Test

       h.      Now reverse the trust

After “Trust all files on our network” and installing the add-ins, we found that reversing the trust still seems to allow the addins to run.  Thus security is back to original settings.

Authorise module:

---

Does PostTrans work with the Authorise module?

Yes, it detects the Enterprise directory for “ExpaInt.dll”, which allows access to user authorisation settings.

This DLL may be an additional download from IRIS. See download.

This functionality then checks the Authorisation limit, and if the POR is above this limit it puts the transaction on “Authorise” status. The Authorise-e™ uses an Email Authorisation Request (EAR) application, to inform whoever should authorise the POR. This is then either authorised or declined by the Authorise-e module. If Floor limit is reached, then the POR is not posted.

The cell ref, under tab “Tran Defaults”, “Or in cell ref” cell ref is used to supply the Operator/Username name for requesting the Authorisation/Floor limit.

Holding down ALT, at the start of a posting will show the Authorisation/Floor limit, retrieved from IRIS Enterprise. If not then the DLL is not in correct place.

Click here for more information