Solved

How to create the line chart to show the total overdue amount of customer by month based on duedate?

  • 6 June 2023
  • 2 replies
  • 72 views
H
Rank
Userlevel 4
Badge

Hi all,

I have created a generic inquiry to show total overdue by customer.  I want to show the trend of change customer like this. I know how to draw when fin-period is one column like this. Because I want to calculate the total overdue of customer base on each invoice due date, etc. So I have no idea how to combine them to one column period. I have also attached a GI I created for this. 

Pls advice me if you have any idea

 

 Thanks in advance

icon

Best answer by aaghaei 6 June 2023, 17:32

View original
1 Attachment

2 replies

aaghaei
Rank
Userlevel 7
Badge +9

Short answer is you can not using out of the box functionality 

Value can only be in one column 

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
H
Rank
Userlevel 4
Badge

Short answer is you can not using out of the box functionality 

Value can only be in one column 

Thanks @aaghaei 

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