Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Voided Invoices not cl...
Finance | Project Operations, Human Resources, ...
Unanswered

Voided Invoices not clearing IVC10100

(0) ShareShare
ReportReport
Posted on by Taylor_Greenwood 370
After we void Invoices through invoice entry, they are not clearing the IVC10100 table. We then get a duplicate script error. Also, older unused invoice numbers stay in the table with no batch number, source post date etc. I have been manually deleting them from the table for the time being. Is that a bad practice?
 
We have also had one or two invoices that after being printed/saved, the subtotal, total etc remains but none of the line items are on the invoice. We generally void and re-enter these as they occur. 
 
Our server is up 24/7 and there is very little down time to initiate reboots. Typically only happens when a windows update automatically does so outside of regular hours. Also, users tend to forget to close down Dynamics on there clients at the end of the day, and sometime remain logged in for days on end. Is a normal reboot of the server something that could help this, or do we need to run Check Links or something?
Categories:
Microsoft Dynamics GP
  • Taylor_Greenwood Profile Picture
    Taylor_Greenwood 370 on at
    Voided Invoices not clearing IVC10100
    I created a test company, and recreated the RM Keys Table using the following instructions:
     
    TRUNCATE TABLE RM00401

    3) Log back into GP then go to MSDGP > Maintenance > Check Links. Select
    Sales from the Series drop down.

    4) Add the following logical tables:

    Receivables Transaction History Files
    Receivables Batch History
    Receivables Open Transaction Files
     
    GP generated a 109,312 page report!
     
    I reopened Invoice Entry and "Voided" one (deleted an unposted invoice). Immediately after, I went to "Invoicing Transactions" on the main window and the duplicate script error remained. I decided to exit and relaunch GP. Once GP was relaunched, the script error disappeared. I decided to create and "Void" another Invoice and close the invoice entry window instead of completely exiting the program, this too worked. So I thought maybe it would work to enter a new invoice without closing the window after voiding one, but unfortunately it did not. This is obviously an improvement, but I cant help but think something is still not quite right. There are a limited number of users with the password to void, so they could be instructed to close the invoice entry screen after each void, or at least shortly thereafter, but I am not sure how this would play out with multiple users logged in all with the invoice entry screen open while the voids are taking place.
     
    Did I recreate the RM Keys Table correctly? Are there additional Check Links that may be helpful to run?
     
    I will play around with it a little bit, and report back if I find any solution.
     
    Thanks again for the help!
  • Taylor_Greenwood Profile Picture
    Taylor_Greenwood 370 on at
    Voided Invoices not clearing IVC10100
    I know, we have been using the invoicing module for about 20 years!
     
    Do you have any specifics on the tools that log users out due to inactivity? We've instructed users to all close dynamics at least at the end of the day, but it falls on deaf ears. 
     
    Our partner typically tells us to use a different method. e.g. use Inquiry>Sales>Transaction by Document as opposed to "Invoicing Transactions" on the main window where the script errors show. Or to turn off "Track Voided Transactions in History" in invoicing setup, as that is what is causing the script errors. Solutions I have never been quite happy with.
     
    We have not run check links, and we have a large, high volume database so I am sure there will be a ton of messages. I will try the suggestions listed below and report back. 
     
    Thank you for your help!
  • StefanieC Profile Picture
    StefanieC 432 on at
    Voided Invoices not clearing IVC10100
    Hi Taylor,

    You probably haven't gotten a response because not a lot of people use that Invoicing module.  Most people use the Sales Order Processing module instead.  Sorry!

    I recommend making a backup and restoring it to a test company if you know how to do that.  Do that before doing any of the suggestions because you can then try these things in that test company first. 
     
    If you are getting errors referencing duplicate records, then you should check for those.  You can use the script below to check the invoicing tables.  
    select DOCTYPE, INVCNMBR, COUNT(*) as [COUNT] from
    (
    select DOCTYPE, INVCNMBR from IVC10100 W
    UNION ALL
    select DOCTYPE, INVCNMBR from IVC30101 H
    ) C
    group by DOCTYPE, INVCNMBR
    having COUNT(*) > 1

    You might also want to recreate the RM Keys table.  Do a search on how to do that.  You might also run Checklinks.   I'm not sure why you have records without complete information.  This can happen if users are not logging out.  I typically tell users they should log out any time they walk away for a meeting, lunch, to go home, or any extended period.  At the very least they should close all their windows, especially transaction windows.  If users get deleted out through User Activity, SQL, or just timed-out sessions; it can leave partial "orphaned" records.  There are tools that can log a user out properly if they haven't been active after a certain amount of time.  I just usually tell them "log out or else!".  Haha

    As for the line items being missing on the invoice, that sounds like part of the data issue.  If you've never done Checklinks, I am guessing that you will have a ton of messages come up on the report.  Again, make sure you do this in a test company.

     
  • Taylor_Greenwood Profile Picture
    Taylor_Greenwood 370 on at
    Voided Invoices not clearing IVC10100
    Curious if anyone has any insight into this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans