Home Forums Support NULL value in DB clients.currency_id

This topic contains 1 reply, has 2 voices, and was last updated by  Hillel Coren 1 week, 1 day ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #22142

    zjenko
    Participant

    As the title states – we have several clients that have properly selected currency via web UI in Clients – Additional Info – Settings – Currency and yet the vast majority of these clients (we are talking 85%+ of all clients) have a NULL value in the database in clients.currency_id .

    Is this a known thing? Are we doing something wrong?

    The thing I am trying to achieve is to export certain data out of the DB in order to make a proper report but since these fields are NULL I cant get everything out. I also planned to hard code into the report so that it would display the standard international currency code (https://en.wikipedia.org/wiki/ISO_4217) based on currencies.code in the DB.

    #22145

    Hillel Coren
    Keymaster

    Clients with a null currency use the company currency by default.

    We advise accessing data through the API rather than reading directly from the database.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Posted in: