Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

invoice date 7004 instead of 2004-just noticed!

Status
Not open for further replies.

barbola

Technical User
Feb 27, 2003
1,132
CA
Can I simply do a return? Is there anything I need to do as far as the re-invoice being a historical transaction?

thanks.
 
Ha...I snuck in the back door and changed all the occurrances of 7004 back to 2004 and re-aged and it seems to be ok. It's a smaller database so no major damage was expected anyway.

But now the customer isn't too happy that he owes another $2000 that hadn't been showing up on his statement.
 
plus customer has to pay NOW rather than a year from now. bummer for the customer. :)
 
yeah, try 5000 years from now!!!

I had missed one table, as the statement was still incorrect. It was the apply table, so I fixed that too.
 
Probably wouldn't hurt to run a check links real quick if you haven't already.
 
Yes I ran checklinks without error.

thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top