Page 1 of 1

A/R situation Posted record stuck in Maintain Open Invoices

Posted: Sun Jan 11, 2015 3:06 pm
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

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

Posted: Mon Jan 12, 2015 3:52 pm
by NeilZ
[email protected] 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.