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.

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 sort of things ar 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

1.    Get COM Toolkit unlocked
2.    Download Installation program
3.    Make sure everyone is out of Exchequer
4.    Run setup program, and point it to MAIN Exchequer directory.  Ignore message about directory already exists
5.    If our download page includes an update of COM Toolkit then extract this to Exchequer directory
6.    Open Excel and add PostTrans.xla add-in, add PostTransLookup.xla if needed.  Answer "NO" to copy message.
7.    Examples are added to "Start >> All Programs >> PostTrans"
8.    Please browse the web site for demonstration videos, etc.

Close Excel

Often the tighter security controls in Vista stop 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.

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

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
1. Start "regedit"

2. 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

Reason  

Your installation of Exchequer must be in the PATH statement

Answer

1.  Right click on "My Computer" then select properties

2.  Select "Advanced Tab"

3.  Press [Environment variables] button

4.  Select "path" in the bottom list

5.  Press [Edit] button

6.  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, then tick all tick boxes

 

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

Download the "Un-Install Instructions" or

1.    Open DOS prompt

2.    Navigate to the Exchequer directory

3.    When in Exchequer directory type "RegSvr32 PostTran.dll" this should then say “DllRegisterServer in PostTrans.dll succeeded”

4.    Now open excel, go to "Tools >> Add ins" untick reference to “PostTrans” and “PostTranslookup” (if exists)

5.    Press [OK]

6.    Next go to "Tools >> Customize" menu, select “Post Transaction”

7.    Select "Post Transaction" entry then press [Delete] button to delete toolbar

8.    Close Excel

9.    Open Excel

10.  Now open excel, go to "Tools >> Add ins", now press [Browse] button

11.  Find Exchequer directory and select "PostTrans.xla"

12.  Answer NO to next question

13.  Add PostTransLookup.xla if you use it, in a similar fashion

14.  Close Excel

PostTrans has now been re-installed to new directory

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

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.

When installing, PostTrans should upgrade your DLL Toolkit automatically (EntDLL32.dll).  But PostTrans could be seeing the wrong version because:

Reason  

Other software has down graded it

Answer  

Reinstall PostTrans

    OR

Reason  

The file was locked when you installed PostTrans

Answer  

Reinstall PostTrans

    OR

Reason  

You have more than one installation of Exchequer, and your PATH statement points to more than one installation of Exchequer. 

Answer  

Edit PATH statement to point to your current copy of Exchequer

Right click on "My Computer" then select properties

Select "Advanced Tab"

Press [Environment variables] button

Select "path" in the bottom list 

Press [Edit] button

Remove unwanted references to Exchequer

You should leave a reference to the main Exchequer directory and the BIN sub directory

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 above.

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 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