InterDyn Artis
  • Home
  • Solutions
    • Dynamics 365
    • Dynamics NAV
    • Dynamics GP
    • Dynamics CRM
    • View All
  • Industries
    • Distribution
    • Financial Services
    • Healthcare
    • Manufacturing
    • Nonprofit
    • Professional Services
  • Events
    • Conferences
    • Training / CPE
    • Vision
    • Webinars and Workshops
  • About Us
    • Blog
    • Careers
    • Choose InterDyn Artis
    • Contact InterDyn Artis
    • Press Releases
    • Referral Program
    • Services We Offer

Unhandled Script Error in Dynamics GP Payables Document Lookup Window

10/6/2016

0 Comments

 
Posted by Shannon Mullins

Picture
On a recent screen share with a client, we discovered script errors when the client was trying to open the payables document inquiry window. The message the client was receiving was below:

Unhandled script exception:
Index 0 of array 'PM Transaction Abbreviation' is out of range in
script 'PM_Transaction_Inquiry_Scroll_FILL'. Script Terminated.

The message appeared twice before disappearing and the records appeared in the window. When they did, I noticed two blank historical records showing up in the first two lines. There were two broken records in the PM00400 table of GP.
 
Here are the steps I took to fix this. Before you start, make sure you take a backup of your company database in question.

  1. Run check links on the payables transaction logical files
  2. Check to see if this has resolved your issue
  3. If not, sort the PM00400 by CNTRLNUM  and check if any blank records exist in PM00400.
    Select * from PM00400  Order by CNTRLNUM= ‘ ‘  
  4. If blank records exist- delete them.  
    Delete from PM00400 where CNTRLNUM= ‘ ‘  
  5. Close the inquiry window that was in question. Open the window and you should be good to go!

If you have any questions feel free to contact us and we'll be happy to assist!

Picture
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    InterDyn Artis

    Your one stop shop for Microsoft Dynamics.

    Categories

    All
    Dynamics 365
    Dynamics CRM
    Dynamics GP
    Dynamics NAV
    Events
    Microsoft Dynamics Add-ons
    Software Decisions
    Tutorial

    RSS Feed

Software Solutions
  Microsoft Dynamics 365
  Microsoft Dynamics NAV
  Microsoft Dynamics GP
  Microsoft Dynamics CRM

  Find Your Fit
Microsoft Dynamics Training
  GP Boot Camp
  GP Database Administration
  ​Intro to Dynamics 365 for Sales

  Management Reporter
​  Reporting in Excel with Jet Express

  SmartList Builder
  SQL Server Reporting (SSRS)
About Us
  Microsoft Dynamics Gold Certified Partner
  Services We Offer
  Contact Us
(704) 846-6750
info@interdynartis.com
Proudly powered by Weebly

Sitemap | Home | Careers | Contact Us

share

Copyright © 2018

InterDyn Artis
✕