Editing "Store Budgets" on each account

SOLVED

I'm preparing to import a budget. I have a budget number for nearly every GL account for multiple company divisions. However, the "store budgets" box is not currently marked on these accounts.

Is there a quicker way to mark "store budget" on a mass number of accounts instead of having to go into the setup of every account and mark the box?

Thank you,


Katie Chadwick

Parents Reply Children
  • 0 in reply to Kaohu Ah Yo

    I had previously reviewed the available field data in Report Designer and saw that it did not list the Store Budget field as ODBC replaceable. However, after your comment, I went ahead and attempted it anyway, via the data tables.

    It let me update it in Access, however, when I go back into the account in the GL>Setup, the "Store Budgets" box is still not checked.

  • 0 in reply to Katie Chadwick

    Let me redact that.

    I was not updating the live table, so that is why it wasn't showing up in the GL>Setup.

    When I do access the live table though, I am not able to update the records. In Access it gives me a read-only error for that field.

  • 0 in reply to Katie Chadwick
    verified answer

    Yes, unfortunately this check box is ODBC readable, but not replaceable (writeable). It cannot be updated using tools like Access or Excel. It could probably be accomplished through a chargeable file fix using developer tools. You could contact support to initiate this. I don't know if there is another way to update quickly.