Page 1 of 2 1 2 >
Topic Options
#5858 - 04/24/06 03:32 PM Corrupt Data?
bal Offline
Adagio Ace

Registered: 03/29/99
Posts: 216
Loc: Ottawa
I have a vendor in A/P that I can't delete because a transaction in 2001 always remains current no matter what I do.

Data integrity checks show no errors.

Any ideas?


Top
#5859 - 04/24/06 04:06 PM Re: Corrupt Data?
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4505
Loc: Wynnewood, PA
Does the transaction have a current balance, or is it zero?

Check carefully that the date is really 2001, not 3001 or 2081, or something way in the future.


Top
#5860 - 04/25/06 10:57 AM Re: Corrupt Data?
bal Offline
Adagio Ace

Registered: 03/29/99
Posts: 216
Loc: Ottawa
The original transaction was in 2003. It was a posting, then a cheque issued.

If I look at the vendor, there is no oustanding balance. The transaction shows as a current transaction - an invoice dated 03/08/01 and a cheque dated 03/08/26. If I check the payment control, there is an outstanding balance of $3,500 which I can not get rid of. Adjusting entries don't work. Cheques don't work....probably because there is this inconsistency in the data which seems to get by the data integrity check.

I want to take this vendor off the system but I can't.


Top
#5861 - 04/25/06 08:36 PM Re: Corrupt Data?
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4505
Loc: Wynnewood, PA
I didn't ask whether the vendor has a balance, I asked whether the TRANSACTION has a balance. From the Vendor List, double-click on the vendor, then click on the Transactions tab and look at the "Current Amt" column.

If the transaction has a balance, and the vendor balance is zero, there ought to be another transaction with an offsetting balance, and these can be applied against each other, as long as they are not checks. Let us know.


Top
#5862 - 04/25/06 08:37 PM Re: Corrupt Data?
Douglas Dickie Online   content
Adagio God

Registered: 06/02/99
Posts: 4408
Loc: Vancouver, BC
You cannot delete a vendor with current or historical transactions.

Issue a manual cheque selecting payment type and then the two transactions. The cheque amount will equal $0.00. After running a subsequent period end all of the transactions will go to history. They will stay there for however long you have set company profile to keep history. Once they are gone from history you will be able to delete the vendor.


Top
#5863 - 04/26/06 08:18 AM Re: Corrupt Data?
bal Offline
Adagio Ace

Registered: 03/29/99
Posts: 216
Loc: Ottawa
I can't issue a $0 cheque. Since it shows a $3,500 credit, it won't let me. Adjusting entries don't work either.

Top
#5864 - 04/26/06 12:36 PM Re: Corrupt Data?
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4505
Loc: Wynnewood, PA
There is an inconsistency in either the data or your explanation (and you mention that the data is clean).

Would you mind sending a backup of your data (under File|Backup|Payables data) to me at steve@sschwartzcpa.com, including a mention of the problem vendor, and I can diagnose the situation better.

Thanks

Steve


Top
#5865 - 04/26/06 01:55 PM Re: Corrupt Data?
bal Offline
Adagio Ace

Registered: 03/29/99
Posts: 216
Loc: Ottawa
Sure will.

The data shows clean when I do a data integrity check but I think there is a problem.


Top
#5866 - 04/27/06 02:16 AM Re: Corrupt Data?
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 694
Loc: Prince George BC
Bal,

To issue a zerio dollar check you must:

1. Use manual check processing.

2. Uncheck the "print check" box.

3. Enter a number in the "Check number" field.


Top
#5867 - 04/26/06 03:58 PM Re: Corrupt Data?
bal Offline
Adagio Ace

Registered: 03/29/99
Posts: 216
Loc: Ottawa
I know HOW to do a zero cheque. Payables won't let me.

Top
Page 1 of 2 1 2 >


Moderator:  Christa_Meissner 
Who's Online
1 registered (Lauren Stief), 146 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14449 Topics
70594 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30