Dynamics GP 9.0

25 pts.
Tags:
Microsoft Dynamics
Microsoft Dynamics GP
I have an invoice dated 1899. the system does not recognize a date of 1899 and therefore will not pay the invoice.
ASKED: May 16, 2008  5:02 PM
UPDATED: October 22, 2008  3:10 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You’ll probably need to go into the database directly and correct the date on the invoice.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • alessandro.panzetta
    I'm sorry, is that real that you have a 1899 bill??? Anyway did you try and change this bill date to Jan 1st 1900?
    9,725 pointsBadges:
    report
  • Squashjunkie
    Making any direct changes to the database, such as the invoice date is a great risk. For ERP apps such as Dynamics, the info is stored in several tables. Changing the date in one location will pull your data out of sync and give you more problems than you are trying to fix. If you can, cancel the invoice somehow, either through a credit/debit procedure or if the date is causing the problem of not being able to process in any way, then look to the tables for all places that the invoice info is stored, and make sure they are all updated.
    325 pointsBadges:
    report
  • DBGuy75
    Without affecting any other data you can simply change the due date of the invoice. Depending on what version of Dynamics you're running, you might be able to change it through the application (Transactions > Purchasing > Edit Transaction Information). If not, you can simply edit the DUEDATE and DISCDATE field in the PM20000 table. I wouldn't change the DOCDATE because that has larger ramifications for reporting, etc., but you should be ok to just change those two fields.
    40 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following