A/R situation Posted record stuck in Maintain Open Invoices

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
knox16church
Posts: 1
Joined: Wed May 30, 2012 5:51 pm

A/R situation Posted record stuck in Maintain Open Invoices

Post by knox16church »

I am using Windows 7 and PC version 11.55

Accounts Receivable / Maintain open invoices.

I have a paid and posted invoice that shows ok in the journal that is still sitting in Maintain open invoices. The payment is no longer in open payments. Posting will not remove it an it cant be deleted because it has a payment associated to it.

I am not sure if it is or will be causing a problem or not, but I would like it to normalize.

I am an experienced database programmer so if this is just a flag that did not get set/unset if some one can tell me the table and field and what is required, I could repair it. Of course I will backup first.

Ken

NeilZ
Posts: 10575
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: A/R situation Posted record stuck in Maintain Open Invoi

Post by NeilZ »

kenharrower@cogeco.ca wrote:I am using Windows 7 and PC version 11.55

Accounts Receivable / Maintain open invoices.

I have a paid and posted invoice that shows ok in the journal that is still sitting in Maintain open invoices. The payment is no longer in open payments. Posting will not remove it an it cant be deleted because it has a payment associated to it.

I am not sure if it is or will be causing a problem or not, but I would like it to normalize.

I am an experienced database programmer so if this is just a flag that did not get set/unset if some one can tell me the table and field and what is required, I could repair it. Of course I will backup first.

Ken
My suggestion is call Powerchurch directly on this ... there are dependencies that may not be easily evident.
Neil Zampella

Using PC+ since 1999.

Post Reply