Customer credit totals

Ya, we are on 9.04.507a and we have to run this every weekend.



This is also why I'm thinking that this value must be stored some where.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Thursday, November 03, 2011 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customer credit totals





> Does anyone know where these values are stored in the database?
I've never found where the values come from.

Occasionally they seem to get out of sync on 8.03.409C. I'm not sure
about E9.

I run a conversion whenever it is noticed.... 9527 I think. It has been
a while.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Joe
Rojas <jrojas@...> wrote:
>
> Hi All,
>
>
>
> When you go to Customer Maintenance or Customer Credit Manager, you
can
> see the open orders credit total and the open invoices credit total.
>
> Does anyone know where these values are stored in the database?
>
>
>
> My guess is that they are not calculated each time you pull a customer
> record up.
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.
>
>
> [Non-text portions of this message have been removed]
>












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
Hi All,



When you go to Customer Maintenance or Customer Credit Manager, you can
see the open orders credit total and the open invoices credit total.

Does anyone know where these values are stored in the database?



My guess is that they are not calculated each time you pull a customer
record up.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
> Does anyone know where these values are stored in the database?
I've never found where the values come from.

Occasionally they seem to get out of sync on 8.03.409C. I'm not sure about E9.

I run a conversion whenever it is noticed.... 9527 I think. It has been a while.


--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> Hi All,
>
>
>
> When you go to Customer Maintenance or Customer Credit Manager, you can
> see the open orders credit total and the open invoices credit total.
>
> Does anyone know where these values are stored in the database?
>
>
>
> My guess is that they are not calculated each time you pull a customer
> record up.
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
>
> [Non-text portions of this message have been removed]
>