BAQs to check the exceeded credit limit amount

Yahoo Archive
1
Thank alot everyone, i will try the solution out.

Thank again

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> Its still a problem in 8.03.408A. We run conversion Program 9527 once a day.
>
>
>
>
> ________________________________
> From: NigelK <nigel.kerley@...>
> To: vantage@yahoogroups.com
> Sent: Thu, March 18, 2010 6:25:20 AM
> Subject: [Vantage] Re: BAQs to check the exceeded credit limit amount
>
> ÂÂ
> Hi Adrian,
>
> I think the fields you're looking for are actually stored in GlbCustCred. This table is updated every time an SO/Shipment/ Invoice is created/amended.
>
> We've had problems with the values in this table before (v8.03.4##) so we run Conversion Program #9527 every so often.
>
> HTH,
>
> Nigel.
>
> --- In vantage@yahoogroups .com, "adriancctfssb" <xenite_v@ .> wrote:
> >
> > Hi everyone,
> >
> > Currently i need to create a dashboard that show the credit limit exceeded amount. I can't seem to find those field in the BAQs on the Customer table (Order Credit, Invoice Credit, Credit Total and Payment Credit). How to i get those field out. I have been trying for days and still havent found out any solution. Any help will be greatly appreciated.
> >
> > Thank you
> >
> > Adrian
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Hi everyone,

Currently i need to create a dashboard that show the credit limit exceeded amount. I can't seem to find those field in the BAQs on the Customer table (Order Credit, Invoice Credit, Credit Total and Payment Credit). How to i get those field out. I have been trying for days and still havent found out any solution. Any help will be greatly appreciated.

Thank you

Adrian
3
Hi Adrian,

I think the fields you're looking for are actually stored in GlbCustCred. This table is updated every time an SO/Shipment/Invoice is created/amended.

We've had problems with the values in this table before (v8.03.4##) so we run Conversion Program #9527 every so often.

HTH,

Nigel.


--- In vantage@yahoogroups.com, "adriancctfssb" <xenite_v@...> wrote:
>
> Hi everyone,
>
> Currently i need to create a dashboard that show the credit limit exceeded amount. I can't seem to find those field in the BAQs on the Customer table (Order Credit, Invoice Credit, Credit Total and Payment Credit). How to i get those field out. I have been trying for days and still havent found out any solution. Any help will be greatly appreciated.
>
> Thank you
>
> Adrian
>
4
Its still a problem in 8.03.408A. We run conversion Program 9527 once a day.




________________________________
From: NigelK <nigel.kerley@...>
To: vantage@yahoogroups.com
Sent: Thu, March 18, 2010 6:25:20 AM
Subject: [Vantage] Re: BAQs to check the exceeded credit limit amount

Â
Hi Adrian,

I think the fields you're looking for are actually stored in GlbCustCred. This table is updated every time an SO/Shipment/ Invoice is created/amended.

We've had problems with the values in this table before (v8.03.4##) so we run Conversion Program #9527 every so often.

HTH,

Nigel.

--- In vantage@yahoogroups .com, "adriancctfssb" <xenite_v@.. .> wrote:
>
> Hi everyone,
>
> Currently i need to create a dashboard that show the credit limit exceeded amount. I can't seem to find those field in the BAQs on the Customer table (Order Credit, Invoice Credit, Credit Total and Payment Credit). How to i get those field out. I have been trying for days and still havent found out any solution. Any help will be greatly appreciated.
>
> Thank you
>
> Adrian
>







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