search-icon

Report Logic Improvement

started a topic about 1 month ago

Please look at the words and pictures below, and we'd better improve the logic of our system.

 

1.  When there are multiple payments for an invoice, we cannot view the details of payment date and multiple payment amounts in the report.

 

2.  If the invoice of a business occurs in June but the payment is in July, so when we use the Customer Payment Detail to filter the data in June, the payment amount we see in June should be 0, and the payment amount should be found when filtering the data in July, and the payment date and payment details should be displayed in July.

 

image

image

(This amount should be filtered out in July)

 

 WE NEED THIS ANALYSIS REPORT FROM FINANCIAL POINT OF VIEW.

 

From a financial point of view, the logic of reports should be as follows

 


image


THIS LOGIC ALSO IS REQUIRED FOR CUSTOMER PAYMENT SUMMARY, PURCHASER PAYMENT SUMMARY, PURCHASER PAYMENT DETAIL.

 

Thanks

docx
(138 KB)

2 people like this idea
Login or Signup to post a comment

2 people like this idea
Log in or Sign up to post a comment