Write-off account missing when unapply invoice

(0) Share

Report

Posted on by NHI

1,600

Hi folks,

I unapplied 2 payments today and using ‘Receivables Transactions Unapply’. Seems there is a setup error when running this module as it moves the writeoff amount to an account not found, which causes a delta between our aging report & GL.

Could you plase tell me where to I need to go to set up the write-off acount?

Thanks a lot.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Write-off account missing when unapply invoice

Either in Accounts in the Customer Card or Posting Accounts>>Sales under Administration>>Setup>>Posting>>Posting Accounts.

Was this reply helpful? Yes No
NHI 1,600 on at

Like (0)

Report

RE: Write-off account missing when unapply invoice

Hi Frank,

I do have the write-off account set up in Posting account. What step did I miss?

To reconcile RM and GL, do I need to go to the JE# in Financial, enter in manually the missing account in distribution window and post it?

Thanks,

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Write-off account missing when unapply invoice

Not sure NHI. It works in my test system. Double check your posting accounts and make sure you have an account entered for Write-offs.

To correct this, it looks like in your first screenshot that you have an unposted financial batch. Enter the correct account number in that batch and post it. That should resolve the issue in Reconcile to GL.

Let us know how it works out.

Was this reply helpful? Yes No
NHI 1,600 on at

Like (0)

Report

RE: Write-off account missing when unapply invoice

So this issue is a little different since the original payment receipt was posted, but then voided. I believe since the write off account wasn’t setup it creates the error when voiding a transaction.

So these values are sitting without distribution accounts. There are several transaction like this. Not sure how we can fix this.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Write-off account missing when unapply invoice

NHI, I'm puzzled as to how the transaction posted with missing distribution accounts. The only way to fix this is thru SQL. You will need to enter the proper account indexes for the write off amount directly in the receivables table(s). Do you have someone in-house that can assist you with this? If not, I would suggest you get your MSFT partner involved.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: Write-off account missing when unapply invoice

Have you checked the Account Level Security(Tools-->Setup-->Company) is enabled for this company and this user?

Or run the below queries against your company database to verify whether all the distribution lines are available in backend.

SELECT *FROM RM10101 WHERE DOCNUMBR='PYMNT1489' AND RMDTYPAL = 9

SELECT *FROM RM30301 WHERE DOCNUMBR='PYMNT1489' AND RMDTYPAL = 9

Hope this helps!!!

Was this reply helpful? Yes No
NHI 1,600 on at

Like (0)

Report

RE: Write-off account missing when unapply invoice

Thank you for all of your help. I have opened a ticket with MSTF and let another one fixed it.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

RE: Write-off account missing when unapply invoice

NHI,

I have interest to know the resolution for this issue. Can you provide us?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Write-off account missing when unapply invoice

Hello - I have a similar issue with a client. What did MSTF say?

Was this reply helpful? Yes No