Microsoft Dynamics AX (Archived)

AX 2009 - AP Error invoice settlement

(0) Share

Report

Posted on by Apix

305

Hello all,

I met the same problem related in these topics :

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/150731/this-transaction-has-been-marked-for-settlement-by-another-user

https://dynamicscognizance.wordpress.com/2016/02/07/dynamics-ax-invoice-settlement-error-this-transaction-has-been-marked-for-settlement-by-another-user/

Thanks to these post I have been able to find the daily journal with which my transaction is settled. But as this journal is posted I no longer have the possibility to access the settlement function to undo the settlement.

Does anyone have an idea of how I can resolve this issue?

Kind regards,

*This post is locked for comments

All responses (6)

Answers (1)

Apix 305 on at

Like (0)

Report

RE: AX 2009 - AP Error invoice settlement

Thanks Magic1949 it's perfect.
Verified answer

guk1964 10,877 on at

Like (0)

Report

RE: AX 2009 - AP Error invoice settlement

If you have Ax 2009, then there is an AP module. (Otherwise no vendors) However, you may not use it and perhaps just do general journals.

The process I have described does not need any coding - (but if you understand the tables then you can do more analysis and queries.)
Apix 305 on at

Like (0)

Report

RE: AX 2009 - AP Error invoice settlement

Morning,

Thanks a lot for your prompt response.

I am currently working within AX 2009 so I don't have the AP module neither the invoice fastab on the vendor account.

Below you can see the first step, I navigate to my vendor account then function > Settlement

I take a look to my transaction

And then I follow the steps to unsettled my transactions as explained at the head of the subject :

I think I might follow the path described by magic1949 but I really want to check if a way out exist without code.

Regards,
Suggested answer

guk1964 10,877 on at

Like (0)

Report

RE: AX 2009 - AP Error invoice settlement

Un-marking transactions is only possible when you identify the offset transaction and delete the link. When someone else has marked it for settlement you can remove thay marking by deleting the unwanted record in in the Spec trans table.

The SpecTrans table stores all the Customer and Vendor open transactions that are currently marked. Deleting a record, does not delete a transaction, it just clears the marking on the open transaction.

Go to ‘Settle open transactions’ form for Customer/Vendor. Select thetransaction, right click -> Record Info -> Show all fields and copy the Record-ID. Navigate to the AOT and use the table browser to directly access the data of SpecTrans table. In the RefRecID column find the record-id Delete the found SpecTrans record to remove the marking.

To accessing the AOT this way is not generally the way to solve a problem but sometimes there no other solution . You may need a someone with System Administrator privileges to do this.. If this seems scary then take a back up, and also test it in a test system.)

Sometimes the SpecTrans records point to LedgerJournalTrans records which no longer exists.

To learn more query the relevant tables. To find orphaned records take a look at SysDictTable’s makeRecord functionality and read up on RefRecId, RefTable and RefCompany data patterns.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: AX 2009 - AP Error invoice settlement

Hi Piccin Aymeric,

You should be able to see and revise the settlement in AP or AR depending on what kind of transaction you posted and settled. Simply select the customer/vendor and then check the closed transaction settlement form. There you should find your transaction.

Best regards,

Ludwig
Suggested answer

Galyna Fedorova 3,566 on at

Like (0)

Report

RE: AX 2009 - AP Error invoice settlement

Hi PICCIN AYMERIC,

You should be able to see settled transactions here: Accounts payable > Vendors > All vendors > On the Invoice Tab/ click Closed transactions editing button. There is a Reverse button used for the settlement reversal.