Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ReportStream DATE_WINDOW_SIZE not large enough to capture operational changes in ProfitAndLossReport during regular Accounting Department closing processes. #69

Open
zbrak opened this issue Mar 22, 2023 · 1 comment

Comments

@zbrak
Copy link

zbrak commented Mar 22, 2023

Description of Issue:

  • Sync runs ProfitAndLossReport on March 8th
    • ProfitAndLossReport pulled for 30 days, (2023-02-06 - 2023-03-08)
    • However, on March 8th an adjustment to posting for 2023-02-01 was made, as month closing will often modify account balances at beginning of prior period month.
    • ProfitAndLossReport totals are recognized as the sum of daily balances between 2023-02-01 - 2023-02-28, with a row output for each day.
    • This leads to continuous misalignment between what the sync reports as ProfitAndLossReport and actuals, as the stream is not picking up updates to the prior period ProfitAndLossReport during the monthly closing process.
    • As a result, stream history needs to be reset and run manually each month to capture changes against the prior month.

Proposed Solution:

  • Extend reporting window to capture 2 months (60 days) worth of report history, giving accounting teams the full month to close books on the prior period.
@zbrak
Copy link
Author

zbrak commented Mar 22, 2023

Related PR #68

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant