• QBO Preference data missing AccountingInfoPrefs BookCloseDate field

QBO Preference data missing AccountingInfoPrefs BookCloseDate field

  • 37Views
  • Last Post 20 April 2023
  • Topic Is Solved
0
votes
Dominic Santini posted this 09 April 2023

The field BookCloseDate does not seem to appear in QBO source data replicated through Skyvia. None of our operations will work if this field is not available. 

 

QB docs show this as a child field under AccountingInfoPrefs:

 

    "AccountingInfoPrefs": {

      "FirstMonthOfFiscalYear": "January", 

      "UseAccountNumbers": true, 

      "TaxYearMonth": "January", 

      "ClassTrackingPerTxn": false, 

      "TrackDepartments": true, 

      "TaxForm": "6", 

      "CustomerTerminology": "Customers", 

      "BookCloseDate": "2018-12-31", 

      "DepartmentTerminology": "Location", 

      "ClassTrackingPerTxnLine": true

    }          

 

But the only fields in this child set that appear in Skyvia’s QB Preferences data are these:

      ,[AccountingInfoPrefs_TrackDepartments]

      ,[AccountingInfoPrefs_ClassTrackingPerTxnLine]

      ,[AccountingInfoPrefs_ClassTrackingPerTxn]

      ,[AccountingInfoPrefs_CustomerTerminology]

 

Is there a solution? 

 

Thanks.

quickbooks missing-field
Order By: Standard | Newest | Votes
0
votes
Yevheniia Bilotserkovska posted this 10 April 2023

Hello Dominic.

Thank you for contacting us.

Our developers will consider the possibility to add this field and we'll get back to you as soon as it's ready.

Best regards,

Yevheniia Bilotserkovska.

0
votes
Dominic Santini posted this 10 April 2023

Hi Yevheniia -

Sounds good. I'll wait to hear from you. This particular field happens to be critical for us; Skyvia would not be a possible solution for our use case without it.

Thanks!

- Dominic

0
votes
Yevheniia Bilotserkovska posted this 11 April 2023

Hello Dominic.

 

We appreciate you taking the time to contact us.

Regarding the feedback from developers, this field will be supported in the upcoming release. We will let you know as soon as it happens.

Thank you for your waiting.

Best regards,

Yevheniia Bilotserkovska.

 

0
votes
Dominic Santini posted this 11 April 2023

Hi Yevheniia -

Thanks for the information. Is there a rough timeline for the next release? 

Looking in the documentation, it looks like there are sort of updates every month. 

Thanks.

- Dominic

0
votes
Yevheniia Bilotserkovska posted this 12 April 2023

Hello Dominic, 

Thank you for your reply. 

Unfortunately we do not have a precise date for the next release at this moment. However, we will keep you informed as soon as we have more information.

We appreciate your patience and understanding.

Best regards,

Yevheniia Bilotserkovska.

0
votes
Dominic Santini posted this 14 April 2023

Hi -

I was wondering, once this field is added, would it appear automatically when existing Replication packages are run? Or would those packages have to be recreated/refreshed to see the new field? 

Note we are not using custom mapping for now, just selecting some QBO tables to replicate.

Thanks.

- Dominic

0
votes
Yevheniia Bilotserkovska posted this 18 April 2023

Hello Dominic.

Thank you for your reply.

Skyvia does not support automatic detection of metadata changes. If metadata are changed in your cloud data source, a replication package will continue to run knowing nothing about these changes. If a new field is added to a replicated object, the replication will continue working, but the new field will not be replicated. If a replicated field or a replicated object is deleted or renamed in the data source, the replication package will start failing until you perform the necessary changes to it.

Please check the Metadata Changes and Editing Replication Package topic via this link 

Should you have any questions, do not hesitate to contact us back.

 

Best regards,

Yevheniia Bilotserkovska.

 

0
votes
Dominic Santini posted this 18 April 2023

Hi Yevheniia -

Thanks for the information. The link was helpful. 

Unfortunately I cannot go much further with our evaluation of migrating to Skyvia until this release comes out (I don't want to refresh 100+ packages) so I am somewhat on hold. Please let me know when you learn more about the timing of the release.

Thanks.

- Dominic

0
votes
Yevheniia Bilotserkovska posted this 19 April 2023

Hello Dominic.

Thank you for your reply.

We are pleased to inform you that the AccountingInfoPrefs_BookCloseDate field of the Preferences object has been supported.

Please check on your side and let us know the result.

Should you have any questions, do not hesitate to contact us back. 

Best regards,

Yevheniia Bilotserkovska.

0
votes
Dominic Santini posted this 20 April 2023

Hi Yevheniia -

That is great news!

I confirm I was able to access the new field by clearing the metadata cache for my QBO connections.

Thank you!

- Dominic

New Ticket
Categories
Popular Tags
Close