Open Invoice is not shown in Settlement page

(0) Share

Report

Posted on by Reign

200

Hi Dynamics Community:

I have an open invoice (unpaid invoice), appeared in both Open transaction and AP Aging Report. I want to settle via payment or enter a credit note and match to this open invoice.

However the open invoice will not show in Settlement screen. I checked the last settlement voucher of this invoice and its blank. I also tried entering a credit note in Invoice Journal but when I try match in All Vendor/Transactions/Settle Transaction, it wont appear as well. I also tried to Reverse this open invoice but the Reverse button is gray-off so I cant proceed. I checked the table browser 'VendTransOpen' and this invoice is also shown there. Why it does not appear int he settlement page>?

Please advise how void this invoice or knock off by entering a CN or GJ? The objective is for this invoice not to appear as open and it should not appear in the AP Aging report as well.

I have the same question (0)

All responses (16)

Answers (4)

Suggested answer

Gaurangkumar Jani 4,512 User Group Leader on at

Like (2)

Report

RE: Open Invoice is not shown in Settlement page

Hi Reign,

Can you check Approved tick on Vendor transaction? and Release date?

Please check this and if it's disable please mark to enable and if release date is there, try to remove it.

Let us know if it's work for you.

Thanks

Gaurangkumar Jani

Was this reply helpful? Yes No
Verified answer

saurabh bharti 15,039 Moderator on at

Like (2)

Report

RE: Open Invoice is not shown in Settlement page

Hi Reign,

As suggested by Gurang, please Navigate to Vendor > Transactions > Select Invoice > Edit > Invoice tab > Check if "Approved" is marked as yes, if not mark as yes it will be available for settlement

Note: To avoid this in future please map "Worker" to all users so that next time it is automatically selected. This also happens generally in "General Journal entries and mainly for uploads ", so take care of updating this field at the time of Entry posting to avoid this

Was this reply helpful? Yes No
Reign 200 on at

Like (0)

Report

RE: Open Invoice is not shown in Settlement page

Hi thanks Gaurangkumar and Saurabh. I could not change to enable the Approve field to YES. This is a posted transaction. Please advise how to proceed.

Once it becomes editable, please advise also if I have to manually populate the approve date field for this invoice. Thanks

Was this reply helpful? Yes No
Verified answer

MATTGUO 22,349 Moderator on at

Like (1)

Report

RE: Open Invoice is not shown in Settlement page

For this field, you can disable/enable it even if it has been posted.

The approve date will automatically be filled in as the session date.

Was this reply helpful? Yes No
Reign 200 on at

Like (0)

Report

RE: Open Invoice is not shown in Settlement page

Hi Mattguo,

I cannot move the slider on this field to change it to YES.

Was this reply helpful? Yes No
Verified answer

MATTGUO 22,349 Moderator on at

Like (1)

Report

RE: Open Invoice is not shown in Settlement page

Is it editable but can not be changed？

Please check if the user is associated with a worker in System administration > Users > Users.

Or select a person in the Personnel number field.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 299,386 Super User 2025 Season 2 on at

Like (0)

Report

RE: Open Invoice is not shown in Settlement page

Hi Reighn,

To be able to change the field, you have to click the Edit button on the form menu. If you are then still not allowed to change this, then check if you have the permissions to edit the details on this form. If you have view access, you are not able to change it. With edit or maintain privileges, you should be able to change it.

PS. Check the Settlement field on the Settlement tab page. This also should be enabled.

Was this reply helpful? Yes No
Reign 200 on at

Like (0)

Report

RE: Open Invoice is not shown in Settlement page

Hi Mattguo,

I tried mapping a person on my user and also map a person on the user who created the transaction. But still when I click Edit, it wont allow me to change the slider to YES. I can click Edit, the Edit button will change to Save but it does not allow any change

I also check the invoice register journal and it is not setup with simple or workflow approval hence there is no approver needed for invoice register.

Please advise how to possible change the Approve field to YES so I can proceed with matching.

Also please also advise how can an open invoice (entered via invoice register) be Reversed or Voided? Currently the Reverse button is disable.

Thanks

Reign

Was this reply helpful? Yes No
Reign 200 on at

Like (0)

Report

RE: Open Invoice is not shown in Settlement page

Hi Andre,

I have added all roles to my user id but still I cannot edit the Approve field to YES. However the Settlement field it allows me to change to YES.

Is it possible to ask a developer to do this particular change at the back end?

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

RE: Open Invoice is not shown in Settlement page

would suggest to use role Accounts payable manager and suggest

Was this reply helpful? Yes No