search

ajency / cashflow-issue-tracker

Issue Tracker for issues
0 stars 1 forks source link

N-24: Avg. days to collect customers/vendors & Quick ration/wc ratio blank for the current month even though have data #818

Closed HazelColaco19 closed 4 years ago

HazelColaco19 commented 4 years ago

Problem Statement By Aditya with regards to WCR and QR:

  1. We should never see a blank even if end date is a future date
  2. The WCR/ QR values are improper
  3. Avg days values is improper
HazelColaco19 commented 4 years ago

For point number 1, need to confirm on requirement and check how it is built. According to what is known, we do not consider future dates for this calculation or pulling data from future dates is not done. We only pull data as on " End date ". Now since we run the cron at the end of the day at 11:30 PM, the data of the reports will be synced only at that time and not on the fly. Will confirm with @georgioajency and update this ticket.

Suggestion to client:

Change the default filter for Key Metrics date range to " Start of the month to( Current date - 1 ) ). Also block the user from selecting a future date as the outcome will always be " - " for future dates.

image

  1. This is proper. No issue
  2. Will be handled in issue #819
legred21 commented 4 years ago

Tested