Skip to main content
Solved

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

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

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