Share
Report
2Good morning,
Bottom Line Up Front:
Using API connector in one company out of multi company tenant space, balanceSheets query returns data as of dateFilter -1 and other companies return correct data, making consolidation reporting problematic. Web generated report for same company with same dates using the same account schedule does not perform the same way and all is returned correctly. Looking for assistance to understand how to correct this as we're not yet set up with consolidation companies and cannot reasonably manually consolidate 35 companies within time requirements on regular recurrence.
Context:
I have a substantial amount of companies in a tenant space and all behave as expected except for one.
When I use the balance sheet function in the GUI, and put 1/1 to 3/31, my net income-Current Year in retained earnings section which is just the totaling of my income statement accounts matches my net income on my income statement, which is the same totaling of my income statement accounts, as one would expect.
I am using a custom account schedule based off an extensive chart of accounts but there are no additional formulas, math, etc, I am just returning the chart of account number in both row number and totalling number for the row definitions for both IS and BS report and have set up the GL setup to use this custom schedule for our income statement and balance sheet.
We consolidate financials and are using a python script to interact with the posted v2 API balanceSheets function and incomeStatements functions then consolidate into formatted excel sheets. We have not yet moved to consolidation companies in BC.
When I use 1/1-3/31 in the web interface, the company behaviors are correct, when I use the dateFilter of 3/31 on the BS API query and the ge 1/1 and le 3/31 query in the IS API query, all companies except this one company operate correctly.
For this one particular company, it stops calculating the BS data as of in this instance, 3/30. The exact imbalance is the activity posted on 3/31 in the sum total of the IS accounts when I filter via the web by dateFilter for 3/31 across the totaling group.
So bottom line, 30+ companies return 1/1-3/31 for IS and 3/31 BS when I use standard variables, but one company returns 1/1-3/31 for IS but 3/30 BS.
I have confirmed the behavior occurs for this company in PowerBI as well as Postman using the standard API connector, it has to be something with the company setup somewhere, but I cannot find it.
All responses (
Answers (
