Solved

What is the link field between ARInvoice and ARDunningLetter?

  • 24 May 2023
  • 5 replies
  • 52 views
N
Rank
Userlevel 3
Badge

I have queried both tables separately but can’t find anything that matches between the two.

Thanks for your help

 

icon

Best answer by iqraharrison48 24 May 2023, 20:19

View original

5 replies

iqraharrison48
Rank
Userlevel 7
Badge +6

@nperez94naw i believe the link between the two would be the customer

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
N
Rank
Userlevel 3
Badge

Hi @iqraharrison48 

Thank you so much for your suggestion, but that, does not seem to do the trick. 

You could have more than one dunning letter for a customer, therefore, that link will throw as many dunning letters there are in the system that customer, instead for that specific AR Invoice. 

 

iqraharrison48
Rank
Userlevel 7
Badge +6

@nperez94naw sorry that didn’t help! what is the desired outcome you are looking for? i know there are a few reports that are in part of native acumatica that can give you details of the dunning letters by customer and invoice numbers. if you could provide more details, that would be great!

 

these are the two reports that i saw in my demo environment:

 

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
E
Rank
Userlevel 5
Badge +1

Good afternoon,

     I did some digging and found that the AR Preference screen defines the dunning level for the customer class.  I also found that on the Dunning Tab of the AR Preferences Screen, you can select by Document and uncheck automatically release dunning letters.  When you do this an create the dunning letter, you will have the ability to delete specific AR invoices from the letter by clicking the “X” in the details portion of the Dunning Letter window.

This customer originally had 4 invoices and I deleted 2 of them.  Hope this helps.  Let me know if you need more assistance.

Eric

Eric Wolfe
N
Rank
Userlevel 3
Badge

Hi @ericwolfe74 thanks you so much for your feedback.  That should work here too.

as per my requirement to add it to the AR3010PL, I took @iqraharrison48 suggestion and it worked. Thank you.

 

 

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved