Incident Description

The TSM – ABM accounting link fails to post data.

Resolution

General Post Errors

Failure of the post to successfully complete may be due to any of the following issues.

[]

Note: Before performing any Postings check the Post program is not already running by starting the Windows Task Manager on each machine which runs the Post, and on the applications tab clicking on ‘End Task’ for any instances of Accounting Post,

1. If the post is freezing without displaying specific errors in the failed queue, please change the Post Setup options ‘Records Synchronisation’ and ‘Account link process’ frequency to 10,000 minutes to ensure the post is not being interrupted by its own update.

2. Errors containing ‘.CDX is not found’ require a reindex of TSM (Utilities→ Reindex). If the error continues you will need to manually delete all files in the TSM directory with the file extension CDX (restarting the machine if any of them are locked by another process).

3. SQL or other miscellaneous errors may indicate the Post is unable to create temporary files. Ensure the disk on which hosts the TSM directory, as well as temp directory of the machine from which the Post is run both have sufficient free space (at least 1 gigabyte).

Specific Post Issues [] The failed queue of the ABM Post details the reasons individual records do not post successfully to ABM. To debug individual failed entries, do the following:

1. Start the ABM Post program (actpost.exe in the TSM directory, or “TSM.exe actpost”).

2. Select the Transaction History tab, and change the Show Status Dropdown to ‘Failed’.

3. Any entry with a Parameter of ‘ALL’ needs to be deleted before attempting to repost any failed entries. Simply select each record and click the Delete button.

4. Credits (posted as supplier and customer invoices with negative totals) can not be posted and will display a status of ‘Transaction Failed to process’. These entries will need to be entered manually entered into ABM via a journal entry.

5. If any invoice is still in the queue after a Re-process of the failed, and the status gives no indication to the cause of the error, then you may need to delete and recreate the invoice. Entries relating to invoices will have the invoice number listed in the Parameter Column, enabling you to locate the invoice in TSM. Use the Invoicing tab of the job cards to easily perform the delete and recreate. If you need to use the same invoice number, ensure the option ‘Invoice Numbering’ is set to ‘Manual’ (Utilities→ Setup→ Invoices tab)

[]

Note: If specific invoices are not appearing in the either the post or failed queues, check the related contacts card and ensure the ‘Account Status’ is set to active, and the option ‘Prevent Accounting Post’ is not checked.