We have historical vouchers/invoices setup with 0 value that we can't void. These vouchers work as a memo for our AMEX expenses. Unfortunately one of the vouchers is incorrect and need to be voided. Is there any way to do this.
*This post is locked for comments
From a user level this works. I still have to create a reversing GL entry though, but its better than nothing. Thanks for the help.
Another option would be to use the remove history tool on the transaction. You would need to manually reverse the Journal entry in GL.
when using the remove history tool it is highly important to try it in a test company first and to make sure you have a full backup before using the tool in live (I have seen several times where all PM data was lost when using this tool because a range was not set correctly).
***NOTE*** Please try the following steps in a test company first
Set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, or SQL Server 2012
support.microsoft.com/.../871973
1) BACKUP your company DB.
2) To get to the remove history tool (after a backup, I recommend not even opening this window unless everyone is out of the system and you have a backup of the company DB) go to Tools>Utilities>Purchasing>Remove Transaction History.
3) First time through unmark the Two remove options.
4) Enter whatever ranges will be needed (vendor and voucher number for example).
5) Click process.
6) With the output report verify only the needed voucher number is removed.
7) Repeat step 2-5 again but this time leave the remove options marked.
8) Reverse the original journal entry with a GL general entry.
This method does not need SQL at all except for the backup. Also note What Mahmoud said is correct, and to elaborate PM was not designed to function with 0 dollar invoices and by default there is no way to void these documents. For this reason we do not recommend using PM to enter these types of transactions, GL would be a much better fit in most cases when you are just moving funds around however I can see why you are using it this way since it makes it very easy to reference on the vendor.
Joshua
the zero amount is the net value of the voucher. The distributions itself can be debit mulitple expenses and have an offset to say a prepaid account, as long as u change the gl distri type to all purch instead of purch and pay it will work. We treat a voucher such as this as a memo to reconcile against credit card statements.
I have just read an important point, how would an invoice with zero amount have GL Distribution !
If you post an invoice with zero amount, no distribution will be created, and no GL journal will be generated.
Yes, sure it is a simple void, but not in your case. Allow me to clarify the case
If a specific invoice got fully applied to a specific payment, then both of them will be automatically moved to history. At this time, you wanted to void the invoice ... right ?
You will need to do the following:
In your case, the invoice is zero (not applied to any payment though) and is in history. The usual scenario to get it voided is to void the payment, while there is no payment in your case.
My simple recommendation is to update the "void" flag which is only (1,0) on the database level, to get this invoice voided. To do so, you will need to run the below query
UPDATE dbo.PM30200 SET VOIDED = 1 WHERE VCHRNMBR = '#VoucherNumber'
Although, remember not to run the query above if you don't have at least proper knowledge in SQL. A back up is a must as well
Please let me know if you need any further inquiries,
I don't understand how Dynamics does not allow for something like this. Its a simple void.
But then how am I able to void this transaction on the GL level? We are talking about a voucher that has give or take 100 lines of GL distributions.
No matter how simple such update would be, I would not recommend to have you running such scripts. Missing a very simply character in the where condition of your script could update several other transactions.
Please feel free to close the case if it fulfills your requirement,
Your feedback is highly appreciated,
well that blows. I'm not an expert working with the databases associated with this. Is there a specific database I should be looking to change?
Posted invoices with zero document amount will be considered as fully applied automatically since the current transaction amount is zero. As a matter of fact, it will be migrated to history automatically.
The bottom line is, you can not void such transaction from the application level. Applicable methods include voiding the transaction on the database level by changing the void flag into 1 just to get this transaction out of any reporting range.
Your feedback is highly appreciated,
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
