Why is the Vendor Center not using the Regional Setting and causing overflow on the transaction overview

GHN · ‎January 17, 2019

QBE Desktop Enterprise 2018 , multi-currency

Our Windows setting is 'dot' as decimal symbol and 'comma' as digit grouping separator.

The vendor center overview is showing this correct for the USD (PO,... ).But for IDR values a comma is used as decimal symbl and a dot as digit grouping separator on the PO screen (although this was not inputted like that). This is causing wrong information and *overflow* on the vendor center transactions overview. cfr screenshots in attachment.

In Customer Center there is no problem, all values are using a 'dot' as 'decimal ' correctly.

What need to be done to have the correct values on Vendor Center?

Anonymous · ‎January 17, 2019

Hello, GHN.

Indonesia is one of the countries that uses comma as decimal separator. Most of their financial institutions record their bank statements and reports through this format. QuickBooks Desktop is also using this format for any IDR transactions.

We always got your back. Feel free to lean on us anytime you need help with QuickBooks.

GHN · ‎January 17, 2019

Changing the 'locale' to Indonesia makes IDR correct but USD is now wrong: 45,456.00 USD (45 thousand USD) becomes 45 USD only which is also wrong and will give overflow if having 45,567,875.12 USD.

It seems QBE really gives problems on the vendor overview, if using multi-currency. This is a QBE bug.

Anonymous · ‎January 17, 2019

Hello, GHN.

There might be minor data problem since your USD currency is already been affected. To fix the issue, I’d recommend running the Verify Rebuild Utility. This lets the program identify the root cause of the issue and resolved it eventually.

Please make sure to secure a backup copy of your company file prior from doing so.

We'll always be here if there's anything else we can do to help you.

Topics

Training

Community

Resources

Why is the Vendor Center not using the Regional Setting and causing overflow on the transaction overview