QuickBooks: add the Preferences table (closing date)
Connector name: QuickBooks
Table name: PREFERENCES
API documentation link: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/preferences
Additional details:
Please add the QuickBooks Online Preferences entity as a new table. We need each company's "Close the books" date, AccountingInfoPrefs.BookCloseDate (read-only, ISO date, API minor version 21+), to automate month-end close in our reporting.
Read endpoint: GET /v3/company/{realmId}/preferences (or query "select * from Preferences"). It returns one record per company, so a daily sync is enough.
At minimum we need the AccountingInfoPrefs fields (BookCloseDate, FiscalYearStartMonth, etc.). The rest of the Preferences object (SalesFormsPrefs, VendorAndPurchasesPrefs, CurrencyPrefs) would also be useful as columns or a JSON column.
Connection: quickbooks_powdersize (same need for all our QuickBooks connections).
Table name: PREFERENCES
API documentation link: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/preferences
Additional details:
Please add the QuickBooks Online Preferences entity as a new table. We need each company's "Close the books" date, AccountingInfoPrefs.BookCloseDate (read-only, ISO date, API minor version 21+), to automate month-end close in our reporting.
Read endpoint: GET /v3/company/{realmId}/preferences (or query "select * from Preferences"). It returns one record per company, so a daily sync is enough.
At minimum we need the AccountingInfoPrefs fields (BookCloseDate, FiscalYearStartMonth, etc.). The rest of the Preferences object (SalesFormsPrefs, VendorAndPurchasesPrefs, CurrencyPrefs) would also be useful as columns or a JSON column.
Connection: quickbooks_powdersize (same need for all our QuickBooks connections).
Please sign in to leave a comment.
Comments
0 comments