We had our consultant create us a Progress program that kicks off every night. Contact RAM Systems in Dallas.
My controller asked me if there was any way in Vantage to automatically place a Customer on credit hold if an invoice reached 90 days old. I told her I did not think so but I thought I would ask here just incase there was a way that I was not aware of. Does anyone know how I could accommodate her?
Thanks in advance,
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
[Non-text portions of this message have been removed]
Thanks in advance,
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
[Non-text portions of this message have been removed]
Nothing built in that I can think of. If you have service connect, you could
always schedule a BAQ export process to run once a day which would export all
invoices over 90 days old. Then have Service Connect process the file and place
those customers on credit hold. Just a thought.
________________________________
From: Charles Carden <shadowcar1449@...>
To: vantage@yahoogroups.com
Sent: Wed, January 19, 2011 12:46:06 PM
Subject: [Vantage] Credit hold based on invoice age
Â
My controller asked me if there was any way in Vantage to automatically place a
Customer on credit hold if an invoice reached 90 days old. I told her I did not
think so but I thought I would ask here just incase there was a way that I was
not aware of. Does anyone know how I could accommodate her?
Thanks in advance,
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
always schedule a BAQ export process to run once a day which would export all
invoices over 90 days old. Then have Service Connect process the file and place
those customers on credit hold. Just a thought.
________________________________
From: Charles Carden <shadowcar1449@...>
To: vantage@yahoogroups.com
Sent: Wed, January 19, 2011 12:46:06 PM
Subject: [Vantage] Credit hold based on invoice age
Â
My controller asked me if there was any way in Vantage to automatically place a
Customer on credit hold if an invoice reached 90 days old. I told her I did not
think so but I thought I would ask here just incase there was a way that I was
not aware of. Does anyone know how I could accommodate her?
Thanks in advance,
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
YOu can write a BPM to do an aging and put the customer on credit hold of over 90 days during processing a sales order
--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...> wrote:
>
> My controller asked me if there was any way in Vantage to automatically place a Customer on credit hold if an invoice reached 90 days old. I told her I did not think so but I thought I would ask here just incase there was a way that I was not aware of. Does anyone know how I could accommodate her?
>
> Thanks in advance,
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> Georgetown, Texas
>
> [Non-text portions of this message have been removed]
>
I haven't done this before but I'd imagine that you can do it.
Someone had posted how to schedule a progress file (.p) to run using
Scheduled Tasks in Windows.
You could create a .p file that calls the business objects for Customer
and ARInvoice and if a customer has an over 90 invoice, put the customer
on credit hold.
I was told you can schedule a BPM but I have yet to find out how.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charles Carden
Sent: Wednesday, January 19, 2011 12:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Credit hold based on invoice age
My controller asked me if there was any way in Vantage to automatically
place a Customer on credit hold if an invoice reached 90 days old. I
told her I did not think so but I thought I would ask here just incase
there was a way that I was not aware of. Does anyone know how I could
accommodate her?
Thanks in advance,
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Someone had posted how to schedule a progress file (.p) to run using
Scheduled Tasks in Windows.
You could create a .p file that calls the business objects for Customer
and ARInvoice and if a customer has an over 90 invoice, put the customer
on credit hold.
I was told you can schedule a BPM but I have yet to find out how.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charles Carden
Sent: Wednesday, January 19, 2011 12:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Credit hold based on invoice age
My controller asked me if there was any way in Vantage to automatically
place a Customer on credit hold if an invoice reached 90 days old. I
told her I did not think so but I thought I would ask here just incase
there was a way that I was not aware of. Does anyone know how I could
accommodate her?
Thanks in advance,
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Charles,
Do you have Service Connect? I wrote a service connect workflow which does
a similar thing, it searches through the open invoices and places customers
on hold if their invoice is past due. If you don't have SC, you would
likely have to do it with a customization attached to some program that gets
run daily.
Kevin Simon
SimsTrak Consulting
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charles Carden
Sent: Wednesday, January 19, 2011 12:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Credit hold based on invoice age
My controller asked me if there was any way in Vantage to automatically
place a Customer on credit hold if an invoice reached 90 days old. I told
her I did not think so but I thought I would ask here just incase there was
a way that I was not aware of. Does anyone know how I could accommodate her?
Thanks in advance,
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Do you have Service Connect? I wrote a service connect workflow which does
a similar thing, it searches through the open invoices and places customers
on hold if their invoice is past due. If you don't have SC, you would
likely have to do it with a customization attached to some program that gets
run daily.
Kevin Simon
SimsTrak Consulting
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charles Carden
Sent: Wednesday, January 19, 2011 12:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Credit hold based on invoice age
My controller asked me if there was any way in Vantage to automatically
place a Customer on credit hold if an invoice reached 90 days old. I told
her I did not think so but I thought I would ask here just incase there was
a way that I was not aware of. Does anyone know how I could accommodate her?
Thanks in advance,
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
I don't think there's any automatic way of doing it. We got around this by creating a BPM against the SalesOrder.ChangeCustomer BO. Now, whenever a new sales order is created, the BPM checks if any of that customer's invoices are beyond terms and places the account on credit hold. The new SO is therefore placed on credit hold.
Not perfect but at least it stops new SOs going to overdue customers.
HTH,
Nigel.
Not perfect but at least it stops new SOs going to overdue customers.
HTH,
Nigel.
--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...> wrote:
>
> My controller asked me if there was any way in Vantage to automatically place a Customer on credit hold if an invoice reached 90 days old. I told her I did not think so but I thought I would ask here just incase there was a way that I was not aware of. Does anyone know how I could accommodate her?
>
> Thanks in advance,
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> Georgetown, Texas
>
> [Non-text portions of this message have been removed]
>
If you have Service Connect then that can be another option. I would just do a daily export of a BAQ that has invoices 90 days out that do not have a credit hold. Drop the export into the designated Service Connect folder. That way, it is automatic and not waiting for the next invoice to be created. This way reports and other fun stuff can be made from it.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
I added two BPM directive groups to Files>BPM's>CustCreditHold (new folder).
These BPM's were developed based on the following business requirement:
"The basic Vantage Customer Credit Hold evaluation relies exclusively on Customer Credit Limit measured against Open Customer Invoice Balance and may include Open Sales Orders. Assessment of a Customer's Credit and subsequent On Hold status is made at the time of Sales Order Entry and displayed for reference or transactional enforcement at various other points within the Vantage modules.
TPI requires that a Customer's Aged Invoices also be taken into consideration as part of that Customer's on-going credit worthiness calculation. Additional alerts and controls are also required to notify our Sales Team and limit certain transactional activity with Customers who are on or being placed on Credit Hold. This will help to raise awareness earlier in the Sales process and minimize TPI's financial exposure to Customers posing a potential Credit risk.
Additionally, as customers' accounts become current (payment of old invoices, etc.) customers should be taken off credit hold without manual intervention."
If you think you'd like to use this but need help adjusting to your specific requirement, please let me know - always happy to help.
Hope this helps,
NB
bonner.n@
totalplastics.com
269.553.5838
bonner.nathan@
gmail.com
616.717.1613
These BPM's were developed based on the following business requirement:
"The basic Vantage Customer Credit Hold evaluation relies exclusively on Customer Credit Limit measured against Open Customer Invoice Balance and may include Open Sales Orders. Assessment of a Customer's Credit and subsequent On Hold status is made at the time of Sales Order Entry and displayed for reference or transactional enforcement at various other points within the Vantage modules.
TPI requires that a Customer's Aged Invoices also be taken into consideration as part of that Customer's on-going credit worthiness calculation. Additional alerts and controls are also required to notify our Sales Team and limit certain transactional activity with Customers who are on or being placed on Credit Hold. This will help to raise awareness earlier in the Sales process and minimize TPI's financial exposure to Customers posing a potential Credit risk.
Additionally, as customers' accounts become current (payment of old invoices, etc.) customers should be taken off credit hold without manual intervention."
If you think you'd like to use this but need help adjusting to your specific requirement, please let me know - always happy to help.
Hope this helps,
NB
bonner.n@
totalplastics.com
269.553.5838
bonner.nathan@
gmail.com
616.717.1613
--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...> wrote:
>
> My controller asked me if there was any way in Vantage to automatically place a Customer on credit hold if an invoice reached 90 days old. I told her I did not think so but I thought I would ask here just incase there was a way that I was not aware of. Does anyone know how I could accommodate her?
>
> Thanks in advance,
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> Georgetown, Texas
>
> [Non-text portions of this message have been removed]
>