Vantage: BAM for Vantage 6.1

I am looking for a BAM to send an email alert when an over shipment is
made on a Sales Order release line. Does anyone have this already
written and would like to share it?



Thanks in advance,

Kathy Hambleton

Electron Energy Corporation

717-459-1056

kbh@...



[Non-text portions of this message have been removed]
It was inevitable I suppose. After a few months on Vista/Vantage, a deadbeat customer finally bounced a check to us. I searched the help files and got a list of about 500 topics, none of which seem to address a procedure for dealing with these. How do you handle these?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
AÂ 11831 Beverly Park Rd, Bldg D, Everett, WA 98204Â USA
www.electricmirror.com
We set up a product group (NSF Check) which hits cash. When a check is returned, we invoice the customer using this product group. This creates the entry to cash and keeps the amount owed visible, because the invoice shows up on the aging, until paid.

Christy

Christy J. Morris
Controller
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA

+1 513-716-6370
+1 513-576-8986 (fax)
www.coldjet.com<http://www.coldjet.com>

[cid:image001.jpg@01C987DE.1A380C20]
Setting industry standards in dry ice technology and solutions for over 20 years.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Thomas Rose
Sent: Thursday, February 05, 2009 2:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Returned checks from customers


It was inevitable I suppose. After a few months on Vista/Vantage, a deadbeat customer finally bounced a check to us. I searched the help files and got a list of about 500 topics, none of which seem to address a procedure for dealing with these. How do you handle these?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com



[Non-text portions of this message have been removed]
We re-open any invoices closed by the original cash receipt - we have
to use SQL commands to do this, there's no way of doing it within
Vantage.

Then we use the "Adjustment" (Financial Management | Accounts
Receivable | General Operations) program to adjust the balances on
these invoices back up to their original value before the original
cash receipt was applied. The GL account is set to Contra.

Last, we enter a miscellaneous cash receipt into the Bank Account in
the value of the bounced cheque and set it's GL code to Contra.

Result: the contra account balances out and all the *original*
invoices reappear on the statement and AR Aging Report. There's no
change in invoice numbers to "confuse" the customer! and there's no
change in the aging of the debt.

Our credit controller seems very happy with the procedure.

HTH,

Nigel.


--- In vantage@yahoogroups.com, Thomas Rose <t.rose@...> wrote:
>
> It was inevitable I suppose. After a few months on Vista/Vantage,
a deadbeat customer finally bounced a check to us. I searched the
help files and got a list of about 500 topics, none of which seem to
address a procedure for dealing with these. How do you handle these?
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> F 425 491-8200
> AÂ 11831 Beverly Park Rd, Bldg D, Everett, WA 98204Â USA
> www.electricmirror.com
>
But the gotcha is that you have to fiddle with the data. Not everyone
has that capability.



The only clean way I can see it being done is to write a credit memo
with a misc charge pointing to the bank account for the returned check.

There might be a second misc charge for the processing fee associated
with the previous charge to misc income.



In order to do that you have to use the (or one of) original sales order
(or reference an original invoice) with a 0$ line. The accounting gets
done properly, you don't have to create extra product groups and the
credit memo prints cleanly. The customer has a reference they can hang
their hat on as well.





Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com









From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Nigel Kerley
Sent: Friday, February 06, 2009 7:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Returned checks from customers



We re-open any invoices closed by the original cash receipt - we have
to use SQL commands to do this, there's no way of doing it within
Vantage.

Then we use the "Adjustment" (Financial Management | Accounts
Receivable | General Operations) program to adjust the balances on
these invoices back up to their original value before the original
cash receipt was applied. The GL account is set to Contra.

Last, we enter a miscellaneous cash receipt into the Bank Account in
the value of the bounced cheque and set it's GL code to Contra.

Result: the contra account balances out and all the *original*
invoices reappear on the statement and AR Aging Report. There's no
change in invoice numbers to "confuse" the customer! and there's no
change in the aging of the debt.

Our credit controller seems very happy with the procedure.

HTH,

Nigel.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Thomas Rose <t.rose@...> wrote:
>
> It was inevitable I suppose. After a few months on Vista/Vantage,
a deadbeat customer finally bounced a check to us. I searched the
help files and got a list of about 500 topics, none of which seem to
address a procedure for dealing with these. How do you handle these?
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> F 425 491-8200
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com
>





[Non-text portions of this message have been removed]
"the gotcha is that you have to fiddle with the data"
Agreed. Thanks, I should have mentioned that.

"misc charge pointing to the bank account"
Not if you're using the Bank Reconcilliation program within Vantage.
Such a posting would not appear on it.

Perhaps point the misc charge to contra and then do a misc receipt
into the bank also pointing to contra.

Nigel.


--- In vantage@yahoogroups.com, "CharlieSmith" <CSmith@...> wrote:
>
> But the gotcha is that you have to fiddle with the data. Not
everyone
> has that capability.
>
>
>
> The only clean way I can see it being done is to write a credit memo
> with a misc charge pointing to the bank account for the returned
check.
>
> There might be a second misc charge for the processing fee
associated
> with the previous charge to misc income.
>
>
>
> In order to do that you have to use the (or one of) original sales
order
> (or reference an original invoice) with a 0$ line. The accounting
gets
> done properly, you don't have to create extra product groups and the
> credit memo prints cleanly. The customer has a reference they can
hang
> their hat on as well.
>
>
>
>
>
> Charlie Smith
>
> Smith Business Services / 2W Technologies LLC
>
> www.vistaconsultant.com <http://www.vistaconsultant.com/> /
> www.2WTech.com
>
>
>
>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Nigel Kerley
> Sent: Friday, February 06, 2009 7:08 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Returned checks from customers
>
>
>
> We re-open any invoices closed by the original cash receipt - we
have
> to use SQL commands to do this, there's no way of doing it within
> Vantage.
>
> Then we use the "Adjustment" (Financial Management | Accounts
> Receivable | General Operations) program to adjust the balances on
> these invoices back up to their original value before the original
> cash receipt was applied. The GL account is set to Contra.
>
> Last, we enter a miscellaneous cash receipt into the Bank Account
in
> the value of the bounced cheque and set it's GL code to Contra.
>
> Result: the contra account balances out and all the *original*
> invoices reappear on the statement and AR Aging Report. There's no
> change in invoice numbers to "confuse" the customer! and there's no
> change in the aging of the debt.
>
> Our credit controller seems very happy with the procedure.
>
> HTH,
>
> Nigel.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> Thomas Rose <t.rose@> wrote:
> >
> > It was inevitable I suppose. After a few months on Vista/Vantage,
> a deadbeat customer finally bounced a check to us. I searched the
> help files and got a list of about 500 topics, none of which seem
to
> address a procedure for dealing with these. How do you handle these?
> >
> > Thom Rose
> > Controller
> > Electric Mirror LLC
> > HOTEL LUXURY
> >
> > "The World Leader in Back-lit Mirrors & Mirror TV Technology"
> >
> > T 425 776-4946
> > F 425 491-8200
> > A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> > www.electricmirror.com
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Yep, forgot about bank reconciliation. The process would work but you
would also have to do a bank adjustment for the bank rec.

Send the returned check to some accrual/clearing account and then wash
it out with the bank adjustment. If you are using a cash clearing
account now, you could use that else use another cash clearing account
(contra account as you said).



Misc Charge (NSF): Debit A/R - Credit Clearing

Misc Charge (RCFee): Debit A/R - Credit Bank Charges

Bank Adjustment: Debit Clearing - Credit Cash



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Nigel Kerley
Sent: Friday, February 06, 2009 10:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Returned checks from customers



"the gotcha is that you have to fiddle with the data"
Agreed. Thanks, I should have mentioned that.

"misc charge pointing to the bank account"
Not if you're using the Bank Reconcilliation program within Vantage.
Such a posting would not appear on it.

Perhaps point the misc charge to contra and then do a misc receipt
into the bank also pointing to contra.

Nigel.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"CharlieSmith" <CSmith@...> wrote:
>
> But the gotcha is that you have to fiddle with the data. Not
everyone
> has that capability.
>
>
>
> The only clean way I can see it being done is to write a credit memo
> with a misc charge pointing to the bank account for the returned
check.
>
> There might be a second misc charge for the processing fee
associated
> with the previous charge to misc income.
>
>
>
> In order to do that you have to use the (or one of) original sales
order
> (or reference an original invoice) with a 0$ line. The accounting
gets
> done properly, you don't have to create extra product groups and the
> credit memo prints cleanly. The customer has a reference they can
hang
> their hat on as well.
>
>
>
>
>
> Charlie Smith
>
> Smith Business Services / 2W Technologies LLC
>
> www.vistaconsultant.com <http://www.vistaconsultant.com/> /
> www.2WTech.com
>
>
>
>
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Nigel Kerley
> Sent: Friday, February 06, 2009 7:08 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Returned checks from customers
>
>
>
> We re-open any invoices closed by the original cash receipt - we
have
> to use SQL commands to do this, there's no way of doing it within
> Vantage.
>
> Then we use the "Adjustment" (Financial Management | Accounts
> Receivable | General Operations) program to adjust the balances on
> these invoices back up to their original value before the original
> cash receipt was applied. The GL account is set to Contra.
>
> Last, we enter a miscellaneous cash receipt into the Bank Account
in
> the value of the bounced cheque and set it's GL code to Contra.
>
> Result: the contra account balances out and all the *original*
> invoices reappear on the statement and AR Aging Report. There's no
> change in invoice numbers to "confuse" the customer! and there's no
> change in the aging of the debt.
>
> Our credit controller seems very happy with the procedure.
>
> HTH,
>
> Nigel.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> Thomas Rose <t.rose@> wrote:
> >
> > It was inevitable I suppose. After a few months on Vista/Vantage,
> a deadbeat customer finally bounced a check to us. I searched the
> help files and got a list of about 500 topics, none of which seem
to
> address a procedure for dealing with these. How do you handle these?
> >
> > Thom Rose
> > Controller
> > Electric Mirror LLC
> > HOTEL LUXURY
> >
> > "The World Leader in Back-lit Mirrors & Mirror TV Technology"
> >
> > T 425 776-4946
> > F 425 491-8200
> > A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> > www.electricmirror.com
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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