10
HI All,
Context - Last time when I ran Payable transaction with below specified Search filter it gave around 800 records, today when I Ran the same smart list with the same exact same criteria, I only got 600 records as results.
Around 200 records missing from last run.
Criteria Used
Posted Date between 9/1/22 and 9/30/22
Purchase order Number is equal to blank
Document Type is equal to "Invoice"
HI Richard,
Thank you for the input. I was able to find root cause with this direction. This view shows record from PM20000 (OPEN) this table has posted date which shows the posted date from work to open table.
Again, when the record gets applied it moves to PM30200. Now the posted date is updated in view since now it will show the applied date as posted date.
Thanks for the direction.
I would run a query against the PM30200 table. This is payables history. Something like:
SELECT * FROM [dbo].[PM30200] WHERE DOCDATE >= '2022-09-01' AND DOCDATE <= '2022-09-30'
SELECT * FROM [dbo].[PM30200] WHERE POSTEDDT >= '2022-09-01' AND POSTEDDT <= '2022-09-30'
SELECT * FROM [dbo].[PM30200] WHERE PSTGDATE >= '2022-09-01' AND PSTGDATE<= '2022-09-30'
See if these missing transactions appear in any of the results.
Do you have access to SSMS and can run queries directly on the payables history tables?
Are we talking the posting date or the posted date? The posting date is the date it will hit your ledger. The posted date is simply the date the transaction was posted.
Hi Richard,
Those missing transaction are still in payables history. But the catch here is those documents has posted date beyond the 9th month range date.
How is it possible for the posted date to change? Please shed some light on this.
Can you identify a transaction that is missing from this list and then go into Payables Inquiry to check if if exists? You are in the same company, correct? It is possible someone deleted historical payables transactions.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (