Open Order / Invoice History Inquiries GUI Windows Show No Column or Data

Open Order / Invoice History Inquiries GUI Windows Show No Column or Data

Q - In the following areas I can access two special functions "Open Order Inquiry" (Alt-O) or "Invoice History Inquiry" (Alt-V):
  • COP Sales Desk
  • A/R Customer File Maintenance or Inquiry
  • COP Order Entry
However, when some of my users try to access these two functions, the screen appears with no columns and no data displayed. See sample screen below:



What can cause this to happen?

A - In Elliott V8, the user can customize the Open Order/Invoice History Inquiry screen. The customization is saved in the registry.  It seems some registry values are corrupted for some reason. You may try to resolve this problem by going to the particular user's workstation and using the REGEDIT utility to edit the registry.

Browse to the following path:
\\My Computer\HKEY_CURRENT_USER\Software\Netcellent\/Elliott\8.0\Preferences

If you have an issue with Open Order Inquiry (Alt-O), look for any values (name column) that start with Geo-SYTABORD-LV… Delete these entries.  If you have an issue with Invoice History Inquiry (Alt-V), look for any values (name column) that start with Geo-SYATBINV-LV... Delete these entries.  See sample screen below.



The system will use its default values when these registry values are not found.  So next time when you run these applications, the window should show up normally.  
WARNING: Editing registry is a dangerous act.  If you accidentally change or delete another registry value, you could potentially corrupt your computer. You are warned to use REGEDIT utility at your own risk!




    • Related Articles

    • Feature - Invoice History Archive

      Release Date: 8/23/21 Version: 8.6 and Above The current invoice history data tables CPINVHDR, CPINVLIN, CPINVOPT, CPINVMTL, CPINVRTG, CPBOXFHS (history version of CPBOXFIL), CPBOXHSR (history version of CPBOXSER), CPBOXHST (history version of ...

    • CP1700 Customer Order Processing Invoice History Inquiry

      Invoice History Inquiry Application Overview This function gives you fast and easy access to all the necessary information to provide customer service for posted invoices on file for a customer. It allows you to quickly access and display a customer ...

    • I Am Running Out of Invoice Numbers -- I Need Direction to Archive Invoices

      Q: Within the next 6 months we will run out of invoice numbers. I don't want to purge my invoice history because it contains valuable data that I would like to go back to in the future. So I would prefer a method to archive my invoice history instead ...

    • How to Retrieve Open Orders That Are Not Invoiced Through Query

      Release Date: 05/04/2022 Version: 7.5 & Higher Q - I used the following SQL statement to get invoice history: SELECT INV_ITM_INV_DATE, INV_ITM_ITM_NO, INV_ITM_DESC_1, INV_ITM_DESC_2, INV_ITM_QTY_ORDER, INV_ITM_TOT_QTY_SHP, INV_ITM_UNIT_PRICE, ...

    • How to Optimize SQL SELECT Statement When Retrieving Data from Invoice History

      'Release Date:11/29/2017 Q - I used the following SQL statement to retrieve invoice history data for a certain item within a certain date range. It took forever to run. Please help. SELECT CPINVLIN.INV_ITM_ITM_NO, CPINVLIN.INV_ITM_INV_DATE, ...