You’re offline. This is a read only version of the page.
Hi,
On my GP Payables Transactions I have two blank invoice transactions with amounts and no Vendor ID, Vendor Name or Document Number and the Document status is "Posted". See attached screenshot.
*This post is locked for comments
No worries, thanks again! :)
Hi Ahmed,
Thank you for pointing me in the right direction! I found the blank entries in the below database.
PM20000
From there I confirmed they existed and deleted the entries after backing up.
*Confirming they exist*
select * from PM20000 where VCHRNMBR = '00000000000000617'
select * from PM20000 where VCHRNMBR = '00000000000000616'
*Deleting the entries*
delete from PM20000 where VCHRNMBR in ('00000000000000617','00000000000000616')
Thanks again!
Hi peter
To be honest its going to be tricky deleting those invoices without any information either than the amount and we don't know if the transactions are recorded in all the related tables, with that being said you should start looking on the following tables and try searching for those amounts in them
PM10000 – Work/Unposted Transactions
PM10100 – GL Distributions for Work and Open Transactions
the transactions should be in either one table or the two tables and also try to catch a primary key (like a document number) so you can search in all database with it, if not then delete these records and then run checklinks.
run the report and see if the invoices are gone.
Hope that gets it done.
Regards,
Hi Ahmed,
Thanks for the response. I just did that and they are still there..any other ideas I could try?
Wanted to delete the two transactions as they are altering the total amount.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (