We are not sure how it is happening yet, but we have some Bill Payments that do not appear to have any Bill. What we think is happening is that someone creates the Bill, then the Bill Payment, then the Bill is accidentally deleted, leaving the Bill Payment marooned.
Does anyone know of a way to discover all such Bill Payments which have no corresponding Bill?
Didn't find your answer? Ask the community — no account required.
!
!-!
There are several methods. This one, for example:
Edit, Advanced Find. Select the following filters: Transaction Type = Bill Payment Paid Status = Open Find
Payments that
accidentally
L
L
How did you find the suspect bill payments in the first place?
Seriously, when you mention that the bill payments'do not appear to have any bill' what do you mean?
When a check is created as a bill payment check, and you try to delete the corresponding bill, an error flag appears, warning that deleting the bill will cause the payment to be 'unapplied'. If you IGNORE THE WARNING, and delete the bill, the corresponding check will have an 'empty' space underneath -- without corresponding bill (and therefore, expense) information. To find them, run a 'Check Detail' report from the banking menu, filtering for check type Bill Payment. All bill payment checks in the report will have bills listed underneath, and the expense account information. 'Orphaned' bill payment checks will appear with a single line of information, and the corresponding account will be "accounts payable".
And, before Allan chimes in on your use of the newsgroup for basic QB help....
Let me give you a few things I've learned about researching methods in QB. First, create a test record. Second, try using the reports QB provides. (The reports under banking on the report menu are an especially excellent place to try and research what happens during a specific transaction.)
To get your answer, I created a fake "bill", paid it using the bill payment window, and deleted the bill. I then tried the transaction detail report. That report didn't give me what I wanted, so I tried the 'check detail', filtering for type bill payment. I selected a date range during which I KNEW I had printed bill payment checks. The 'bill' information was listed for EVERY check, with the exception of the test case I created. To try and weed out extraneous records, I tried varying the account selection. I was unable to create a report that ONLY listed the transactions you needed, but WAS able to create a report that can be used to find them.
W
Will
Open Bill Payment. Select "History" button. Response is "No transaction history exists" or words to that effect.
That result is then confirmed by doing a search on the vendor, and sure enough no BIll corresponding to the payment is found.
I made a point of answering another user's questions, in the hope of balancing cosmic karma, or whatever needs balancing. :)
Thanks for other suggestions.
A
Allan Martin
Billy,
Its been almost a week since your last question. Good to see you again.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required
Report Content
You are reporting this content to the moderators. They will look at it
ASAP.