Skip to main content
Question

"Open Item" Customer Statement with Adjustments


Background

The Customer Statement only prints adjustments if the customer’s statement type is Balance Brought Forward. The ARStatementAdjust table is not populated if the customer’s statement type is Open Item.

Business Case

Customers with statement type of Open Item have requested their (monthly) statements to include lines that show adjusting document(s) which explain the difference between Orig. Amount and Balance statement-columns.   Note: We are aware of AR Balance by Customer that can show these details.

Questions

  1. Is there an easy customization to make to populate the ARStatementAdjust table for statement type Open Item?
  2. Has anyone modified the Customer Statement report to use other AR adjust tables? If so, how did you handle ARStatementAdjust fields that drive critical calculations in the Customer Statement report, that do not exist in the other adjust tables?
  3. Are there any other options?

Thanks,

Dan

8 replies

Forum|alt.badge.img
  • Jr Varsity I
  • 38 replies
  • June 7, 2023

Hi, please try with this one.

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • June 7, 2023

Hello,

Aradjust table contains the relationship between an invoice and the payments/credit memos that reduced the balance of the invoice.

Laura


Forum|alt.badge.img
  • Jr Varsity I
  • 38 replies
  • June 7, 2023
Laura02 wrote:

Hello,

Aradjust table contains the relationship between an invoice and the payments/credit memos that reduced the balance of the invoice.

Laura

Are you able to put some screenshot that I can see how you fixed?


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • June 7, 2023

Hello, I am providing the name of the table you can join, to see the payment or credit memo document that reduced your customer’s invoice.

I can’t show screenshot of the join now, but you will join statement table to aradjust on branch/company, statement table’s invoice document type to aradjust.adjdDoctype, and statement table’s invoice reference number to ARAdjust table’s AdjdRefNbr. The payment fields to add to report are adjgRefNbr and AdjgDocType, adjustment amount.

Laura


@Laura02, @enhee0702   Thanks for adding to the thread!

 

If so, how did you handle ARStatementAdjust fields that drive critical calculations in the Customer Statement report, that do not exist in the ARAdjust tables?

 

Personally, I think a customization to populate the ARStatementAdjust table for Statement Type = “Open Item” is the better solution.

I am guessing it must not be a common request to show adjusting documents on Customer Statements, no matter the statement type.


DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • 119 replies
  • June 9, 2023

@Laura02@enhee0702   Thanks for adding to the thread!

 

Here is the critical issue when refactoring to use the ARAdjust table:

If so, how did you handle ARStatementAdjust fields that drive critical calculations in the Customer Statement report, that do not exist in the ARAdjust table?

 

Personally, I think a customization to populate the ARStatementAdjust table for Statement Type = “Open Item” is the better solution.

I am guessing it must not be a common request to show adjusting documents on Customer Statements, no matter the statement type.

 

Best,

Dan Concannon


Forum|alt.badge.img
  • Jr Varsity II
  • 13 replies
  • October 14, 2024

Hi,

One of our customers would like to view payment details when the customer statement is set to open item. The customer statement report (AR641500) seems quite complex, making it challenging to resolve this issue. If anyone has found a solution or workaround for this, could you please share it?

Thanks.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2621 replies
  • December 24, 2024

Hi ​@dconcannon20 were you able to find a solution? Thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings