Report for improperly entered business transactions
Derek Atkins
warlord at MIT.EDU
Fri Jul 26 12:54:16 EDT 2013
Bob,
Bob Brush 3 <bobbrush3 at gmail.com> writes:
> No, it was done manually in the check book register, not by me, but not
> caught by me (in time) either.. Yes, those I and P are tricky too, if
> you change them to "I" they won't go back, so yes I am just deleting and
> reentering them.
Yeah, "thou shalt not enter Business Transactions by Hand". The
corellary is that "thou shalt not enter transactions for A/R or A/P by
hand". If you ever find yourself doing that, you're doing it wrong.
> I wish I could hack reports or the search, would it be possible to
> expand the file (I don't remember if it is zipped or what) and grep some
> kind of word, I guess questionmark wouldn't be the best choice?
Nope, because that's not in the datafile. The question mark exists
because xaccTransGetType() is returning "unknown" instead of "invoice"
or "payment".
Your best bet is to just open your A/R account, scroll to the top, and
then page down to scroll... And every time you find a manually-entered
transaction delete it and then Process Payment to replace it.
> Thanks, Bob
-derek
> On Mon, 2013-07-22 at 16:55 -0400, Derek Atkins wrote:
>> Hi,
>>
>> Robert L Brush III <bobbrush3 at gmail.com> writes:
>>
>> > I have discovered quite a few transactions entered in the check register
>> > instead of using the pay vendor dialog, I also notice they don't show up
>> > on the AP report for the Vendor, and in the register view they have a
>> > "?" instead of I or P in the type field. I would like to fix all of the
>> > mistakes in a thorough way and not miss any. What would the best way be
>> > to do this, I was thinking a report or view, but I can't sort or filter
>> > by "type". Any suggestion is greatly appreciated, what a mess!
>>
>> Let me guess: you used an importer?
>>
>> Business transactions can only be entered through the Business
>> Interfaces (Invoices and Process Payments). Anything is wont work.
>>
>> You will need to delete all those existing transactions and re-enter
>> them via Process Payment.
>>
>> I'm afraid there's no way to search; you'll just need to page through
>> your A/R account and delete/re-enter them one by one.
>>
>> > Thanks, Bob
>>
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>>
>
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
More information about the gnucash-user
mailing list