Hello,
I don't know if this is the place to report this, but we've encountered a serious issue in the latest release of QuickBooks Enterprise v20.0. Previously, we heavily relied on the 'Advanced Excel Import' feature found under 'File - Utilities - Import - Excel Files - Advanced Import' but this feature seems to be broken in the latest release. When trying to import an Excel file in the same format that worked in v18.0 & v19.0 with the same field mapping, we receive the errors seem in 'Excel Import Error #1.png' & 'Excel Import Error #2.png'. Essentially, the error is telling us that the unit of measure for the field mapping is invalid. Upon taking the advice of the error message, we've tried creating a new field mapping, but it still refuses to accept the file. We have even tied to set the entire company to allow multiple units of measures under the preferences, but we are then told that the mappings were made in a single unit of measure mode (even new ones we make), so we need to switch back to a single unit of measure. No matter what we do or however many new mappings we create, we are unable to get the Advanced import feature to work.
Ideally, we'd be able to restore from a backup that was made on v19.0, but we can't do this since we've already been using v20.0 for a while now and this issue has just come to my attention. Any help on how to solve this issue or a method to downgrade our file to v19.0 would be greatly appreciated. Also, if any additional information is needed/wanted, just let me know and I'd be more than willing to provide it.
Thanks in advance,
Jared
PS. Apparently I can only attach one image, so both of them can be found at the link below:
https://drive.google.com/drive/folders/1CpQVYqEilWv2YV3gdDFD-u-zmxLBpnv-?usp=sharing