AP Clearing Account

Yahoo Archive
1
Thanks. I will go back and read your post about the Production
Detail Report. I know we've come across other reports in the past
(i.e. Backlog Report) that we have had many an issue with. I'll be
curious to look at things closer once again. Our WIP accounts are
off slightly each month, but since we are on average costing we
normally chalk up the few dollars to rounding differences. I'll
check back in if I find anything new. You guys have been great with
the advice. Thanks!

--- In vantage@yahoogroups.com, "Chris Robisch" <blue.wine@v...>
wrote:
> Please re-read my email about the Production Detail Report. The
report
> totals are wrong -- they don't match their own detail nor the
Inventory WIP
> Reconciliation Report -- but they do match what's being posted. I'm
guessing
> there's shared logic between the PDR and the Capture/Post. And it's
also
> wrong in Version 8. Which means this report is wrong on all
versions of
> Vantage.
>
> Yes, procedurally we can create our own mess. But when a standard
report and
> the posting is wrong to begin with, we go nuts reconciling our mess
with
> Epicor's.
>
> ----- Original Message -----
> From: "vlgatfse" <vlgatfse@y...>
> To: <vantage@yahoogroups.com>
> Sent: Wednesday, May 04, 2005 4:36 AM
> Subject: [Vantage] Re: AP Clearing Account
>
>
> > Thanks for the advice. However, that is unforunately things that
we
> > learned the hard way early on last year. We have been fortunate
> > enough to be blessed with a very knowledgable consultant.
> > Unfortuantely, since she is so good, it's danged near impossible
to
> > get her here anymore. It was so bad with this and that that we
> > actually send out a monthly schedule of when things MUST be
completed
> > by. For the most part, everyone follows the schedule, with a few
> > occassional exceptions. Also, our finance department is little, 3
> > full time including the CFO and one part timer. So, we work
pretty
> > closely together and I try to look at the WIP reconciliation at
least
> > twice a week to try to catch things before they get ugly. I also
try
> > to review the Received but not Invoiced and also the Expense
> > Distribution.
> >
> > Thanks again. Back to looking and looking and looking.....
> >
> >
> > --- In vantage@yahoogroups.com, "Randy Lunsford" <rlunsf@e...>
wrote:
> >> Most of the time when we don't reconcile with the report, it is
> > because
> >> our A/P has entered an incorrect G/L month when entering an
invoice
> > tied
> >> to a PO receipt. For example, the receipt would be in April, she
> > would
> >> enter the A/P invoice in May and enter a G/L month of April.
When
> >> entering invoices tied to PO receipts, you always enter the G/L
> > month
> >> the same as the month your entry month, if that makes sense. In
> > other
> >> words, if you enter the invoice in May, the G/L month should be
May.
> >> You only do this with PO receipt invoices, not expenses or
invoices
> > not
> >> tied to a PO receipt. Another reason for not reconciling is when
> > you
> >> have a receipt that is corrected in the next month. If we have
to
> >> correct a PO receipt that crosses months, we always delete the
> > receipt
> >> and then re-receive the PO. Hope this makes sense.
> >>
> >> Randall Lunsford
> >> Excel Machinery, Ltd.
> >> e-mail: rlunsf@e...
> >> Phone: (806) 335-4565 ext. 531
> >> Fax: (806) 335-9017
> >>
> >> -----Original Message-----
> >> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf
> >> Of vlgatfse
> >> Sent: Tuesday, May 03, 2005 1:50 PM
> >> To: vantage@yahoogroups.com
> >> Subject: [Vantage] AP Clearing Account
> >>
> >> Hi, new here, on Vantage for about a year and a half, currently
on
> > 6.1
> >> since last summer.
> >>
> >> I'm getting relatively familar with reconciling the WIP and
> > Inventory
> >> accounts each month. However, over the last several months, my
AP
> >> Clearing account continues to be off against the Received but not
> >> Invoice report. I've looked thru the GL transactions, looked
thru
> > the
> >> WIP reconciliation, but nothing is really standing out.
> >>
> >> Any ideas anyone? Not sure why this is happening now, as it was
> > tying
> >> out into late last year. I'm not sure what the change is, but
any
> >> ideas or advice would be helpful.
> >>
> >> Thanks in advance.
> >>
> >>
> >>
> >>
> >>
> >> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must
> >> have already linked your email address to a yahoo id to enable
> > access. )
> >> (1) To access the Files Section of our Yahoo!Group for Report
> > Builder
> >> and Crystal Reports and other 'goodies', please goto:
> >> http://groups.yahoo.com/group/vantage/files/.
> >> (2) To search through old msg's goto:
> >> http://groups.yahoo.com/group/vantage/messages
> >> (3) To view links to Vendors that provide Vantage services goto:
> >> http://groups.yahoo.com/group/vantage/links
> >> Yahoo! Groups Links
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> > have already linked your email address to a yahoo id to enable
access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
2
Hi, new here, on Vantage for about a year and a half, currently on 6.1
since last summer.

I'm getting relatively familar with reconciling the WIP and Inventory
accounts each month. However, over the last several months, my AP
Clearing account continues to be off against the Received but not
Invoice report. I've looked thru the GL transactions, looked thru the
WIP reconciliation, but nothing is really standing out.

Any ideas anyone? Not sure why this is happening now, as it was tying
out into late last year. I'm not sure what the change is, but any
ideas or advice would be helpful.

Thanks in advance.
3
Most of the time when we don't reconcile with the report, it is because
our A/P has entered an incorrect G/L month when entering an invoice tied
to a PO receipt. For example, the receipt would be in April, she would
enter the A/P invoice in May and enter a G/L month of April. When
entering invoices tied to PO receipts, you always enter the G/L month
the same as the month your entry month, if that makes sense. In other
words, if you enter the invoice in May, the G/L month should be May.
You only do this with PO receipt invoices, not expenses or invoices not
tied to a PO receipt. Another reason for not reconciling is when you
have a receipt that is corrected in the next month. If we have to
correct a PO receipt that crosses months, we always delete the receipt
and then re-receive the PO. Hope this makes sense.

Randall Lunsford
Excel Machinery, Ltd.
e-mail: rlunsf@...
Phone: (806) 335-4565 ext. 531
Fax: (806) 335-9017

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vlgatfse
Sent: Tuesday, May 03, 2005 1:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] AP Clearing Account

Hi, new here, on Vantage for about a year and a half, currently on 6.1
since last summer.

I'm getting relatively familar with reconciling the WIP and Inventory
accounts each month. However, over the last several months, my AP
Clearing account continues to be off against the Received but not
Invoice report. I've looked thru the GL transactions, looked thru the
WIP reconciliation, but nothing is really standing out.

Any ideas anyone? Not sure why this is happening now, as it was tying
out into late last year. I'm not sure what the change is, but any
ideas or advice would be helpful.

Thanks in advance.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
4
There are a few things that we do that seem to help keep AP Clearing
tied out to the Recieved but not Invoiced report:
1. Post all of the invoices you have by the last day of the month.
2. Lock out recieving (by switching on Security Manager Access Only
in the Menu Security area) at the end of the last day of the month.
Turn it off once you've printed your Recieved but not Invoiced report.
3. Any invoice recieved the following month gets the new month's
invoice date.
4. Make sure recieving does not back date any reciepts.
5. Keep track of any deposits that are not matched with a reciept.
Brian W. Larcom, CFO
Metallized Carbon Corporation
Ossining, NY


--- In vantage@yahoogroups.com, "vlgatfse" <vlgatfse@y...> wrote:
> Hi, new here, on Vantage for about a year and a half, currently on
6.1
> since last summer.
>
> I'm getting relatively familar with reconciling the WIP and
Inventory
> accounts each month. However, over the last several months, my AP
> Clearing account continues to be off against the Received but not
> Invoice report. I've looked thru the GL transactions, looked thru
the
> WIP reconciliation, but nothing is really standing out.
>
> Any ideas anyone? Not sure why this is happening now, as it was
tying
> out into late last year. I'm not sure what the change is, but any
> ideas or advice would be helpful.
>
> Thanks in advance.
5
That is so easy to say ... how do you keep ship/rec from back dating a receiver....

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Brian Larcom
Sent: Tuesday, May 03, 2005 3:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AP Clearing Account


There are a few things that we do that seem to help keep AP Clearing
tied out to the Recieved but not Invoiced report:
1. Post all of the invoices you have by the last day of the month.
2. Lock out recieving (by switching on Security Manager Access Only
in the Menu Security area) at the end of the last day of the month.
Turn it off once you've printed your Recieved but not Invoiced report.
3. Any invoice recieved the following month gets the new month's
invoice date.
4. Make sure recieving does not back date any reciepts.
5. Keep track of any deposits that are not matched with a reciept.
Brian W. Larcom, CFO
Metallized Carbon Corporation
Ossining, NY


--- In vantage@yahoogroups.com, "vlgatfse" <vlgatfse@y...> wrote:
> Hi, new here, on Vantage for about a year and a half, currently on
6.1
> since last summer.
>
> I'm getting relatively familar with reconciling the WIP and
Inventory
> accounts each month. However, over the last several months, my AP
> Clearing account continues to be off against the Received but not
> Invoice report. I've looked thru the GL transactions, looked thru
the
> WIP reconciliation, but nothing is really standing out.
>
> Any ideas anyone? Not sure why this is happening now, as it was
tying
> out into late last year. I'm not sure what the change is, but any
> ideas or advice would be helpful.
>
> Thanks in advance.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
6
I'd second everything Brian has mentioned here- clean cut-off will take care of many problems. We've also had issues with new A/P people entering inventory invoices as expense items, ie: they forget to match invoice to receipt line, but use misc line instead (and let the G/L default to inventory). Creates variance in Inventory and A/P clearing. Also, in the rare case where we pay in advance for inventory, an invoice may go in first, receipt second, A/P Clearing variance third. Watch out if your company uses a credit card to pay for inventory from time to time. I can email you a procedure for clearing these off-line if it applies.

James

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Brian Larcom
Sent: Tuesday, May 03, 2005 2:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AP Clearing Account


There are a few things that we do that seem to help keep AP Clearing
tied out to the Recieved but not Invoiced report:
1. Post all of the invoices you have by the last day of the month.
2. Lock out recieving (by switching on Security Manager Access Only
in the Menu Security area) at the end of the last day of the month.
Turn it off once you've printed your Recieved but not Invoiced report.
3. Any invoice recieved the following month gets the new month's
invoice date.
4. Make sure recieving does not back date any reciepts.
5. Keep track of any deposits that are not matched with a reciept.
Brian W. Larcom, CFO
Metallized Carbon Corporation
Ossining, NY


--- In vantage@yahoogroups.com, "vlgatfse" <vlgatfse@y...> wrote:
> Hi, new here, on Vantage for about a year and a half, currently on
6.1
> since last summer.
>
> I'm getting relatively familar with reconciling the WIP and
Inventory
> accounts each month. However, over the last several months, my AP
> Clearing account continues to be off against the Received but not
> Invoice report. I've looked thru the GL transactions, looked thru
the
> WIP reconciliation, but nothing is really standing out.
>
> Any ideas anyone? Not sure why this is happening now, as it was
tying
> out into late last year. I'm not sure what the change is, but any
> ideas or advice would be helpful.
>
> Thanks in advance.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









[Non-text portions of this message have been removed]
7
How about this for a mess, Last bookkeeper, writing AP checks to customers
who we invoiced, then posting the transactions. Oh, she also didn't post
their payments. (our accounting ejection seat fires again.)

Shirley Graver
Rubber Associates Inc

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
James Martin Jr.
Sent: Tuesday, May 03, 2005 11:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: AP Clearing Account

I'd second everything Brian has mentioned here- clean cut-off will take care
of many problems. We've also had issues with new A/P people entering
inventory invoices as expense items, ie: they forget to match invoice to
receipt line, but use misc line instead (and let the G/L default to
inventory). Creates variance in Inventory and A/P clearing. Also, in the
rare case where we pay in advance for inventory, an invoice may go in first,
receipt second, A/P Clearing variance third. Watch out if your company uses
a credit card to pay for inventory from time to time. I can email you a
procedure for clearing these off-line if it applies.

James

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Brian Larcom
Sent: Tuesday, May 03, 2005 2:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AP Clearing Account


There are a few things that we do that seem to help keep AP Clearing
tied out to the Recieved but not Invoiced report:
1. Post all of the invoices you have by the last day of the month.
2. Lock out recieving (by switching on Security Manager Access Only
in the Menu Security area) at the end of the last day of the month.
Turn it off once you've printed your Recieved but not Invoiced report.
3. Any invoice recieved the following month gets the new month's
invoice date.
4. Make sure recieving does not back date any reciepts.
5. Keep track of any deposits that are not matched with a reciept.
Brian W. Larcom, CFO
Metallized Carbon Corporation
Ossining, NY


--- In vantage@yahoogroups.com, "vlgatfse" <vlgatfse@y...> wrote:
> Hi, new here, on Vantage for about a year and a half, currently on
6.1
> since last summer.
>
> I'm getting relatively familar with reconciling the WIP and
Inventory
> accounts each month. However, over the last several months, my AP
> Clearing account continues to be off against the Received but not
> Invoice report. I've looked thru the GL transactions, looked thru
the
> WIP reconciliation, but nothing is really standing out.
>
> Any ideas anyone? Not sure why this is happening now, as it was
tying
> out into late last year. I'm not sure what the change is, but any
> ideas or advice would be helpful.
>
> Thanks in advance.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

Tracking #: 6DBE8BD00CC1834FAA0BDEE50986D1721341C118


[Non-text portions of this message have been removed]
8
Thanks for the advice. However, that is unforunately things that we
learned the hard way early on last year. We have been fortunate
enough to be blessed with a very knowledgable consultant.
Unfortuantely, since she is so good, it's danged near impossible to
get her here anymore. It was so bad with this and that that we
actually send out a monthly schedule of when things MUST be completed
by. For the most part, everyone follows the schedule, with a few
occassional exceptions. Also, our finance department is little, 3
full time including the CFO and one part timer. So, we work pretty
closely together and I try to look at the WIP reconciliation at least
twice a week to try to catch things before they get ugly. I also try
to review the Received but not Invoiced and also the Expense
Distribution.

Thanks again. Back to looking and looking and looking.....


--- In vantage@yahoogroups.com, "Randy Lunsford" <rlunsf@e...> wrote:
> Most of the time when we don't reconcile with the report, it is
because
> our A/P has entered an incorrect G/L month when entering an invoice
tied
> to a PO receipt. For example, the receipt would be in April, she
would
> enter the A/P invoice in May and enter a G/L month of April. When
> entering invoices tied to PO receipts, you always enter the G/L
month
> the same as the month your entry month, if that makes sense. In
other
> words, if you enter the invoice in May, the G/L month should be May.
> You only do this with PO receipt invoices, not expenses or invoices
not
> tied to a PO receipt. Another reason for not reconciling is when
you
> have a receipt that is corrected in the next month. If we have to
> correct a PO receipt that crosses months, we always delete the
receipt
> and then re-receive the PO. Hope this makes sense.
>
> Randall Lunsford
> Excel Machinery, Ltd.
> e-mail: rlunsf@e...
> Phone: (806) 335-4565 ext. 531
> Fax: (806) 335-9017
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of vlgatfse
> Sent: Tuesday, May 03, 2005 1:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] AP Clearing Account
>
> Hi, new here, on Vantage for about a year and a half, currently on
6.1
> since last summer.
>
> I'm getting relatively familar with reconciling the WIP and
Inventory
> accounts each month. However, over the last several months, my AP
> Clearing account continues to be off against the Received but not
> Invoice report. I've looked thru the GL transactions, looked thru
the
> WIP reconciliation, but nothing is really standing out.
>
> Any ideas anyone? Not sure why this is happening now, as it was
tying
> out into late last year. I'm not sure what the change is, but any
> ideas or advice would be helpful.
>
> Thanks in advance.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
9
Thanks guys for the advice. I think, unfortunately, everything that
has been writted has been dealt with here. We've had some bumpy
roads here in the past, but have been getting rid of most of the
potholes. I'll look over all the emails to make sure there isn't
something that was said that I may have overlooked.

Thanks again guys. Have a great hump day!!!

--- In vantage@yahoogroups.com, "James Martin Jr." <jmartin@e...>
wrote:
> I'd second everything Brian has mentioned here- clean cut-off will
take care of many problems. We've also had issues with new A/P
people entering inventory invoices as expense items, ie: they forget
to match invoice to receipt line, but use misc line instead (and let
the G/L default to inventory). Creates variance in Inventory and A/P
clearing. Also, in the rare case where we pay in advance for
inventory, an invoice may go in first, receipt second, A/P Clearing
variance third. Watch out if your company uses a credit card to pay
for inventory from time to time. I can email you a procedure for
clearing these off-line if it applies.
>
> James
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf
> Of Brian Larcom
> Sent: Tuesday, May 03, 2005 2:06 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: AP Clearing Account
>
>
> There are a few things that we do that seem to help keep AP
Clearing
> tied out to the Recieved but not Invoiced report:
> 1. Post all of the invoices you have by the last day of the month.
> 2. Lock out recieving (by switching on Security Manager Access Only
> in the Menu Security area) at the end of the last day of the month.
> Turn it off once you've printed your Recieved but not Invoiced
report.
> 3. Any invoice recieved the following month gets the new month's
> invoice date.
> 4. Make sure recieving does not back date any reciepts.
> 5. Keep track of any deposits that are not matched with a reciept.
> Brian W. Larcom, CFO
> Metallized Carbon Corporation
> Ossining, NY
>
>
> --- In vantage@yahoogroups.com, "vlgatfse" <vlgatfse@y...> wrote:
> > Hi, new here, on Vantage for about a year and a half, currently
on
> 6.1
> > since last summer.
> >
> > I'm getting relatively familar with reconciling the WIP and
> Inventory
> > accounts each month. However, over the last several months, my
AP
> > Clearing account continues to be off against the Received but not
> > Invoice report. I've looked thru the GL transactions, looked
thru
> the
> > WIP reconciliation, but nothing is really standing out.
> >
> > Any ideas anyone? Not sure why this is happening now, as it was
> tying
> > out into late last year. I'm not sure what the change is, but
any
> > ideas or advice would be helpful.
> >
> > Thanks in advance.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
10
I don't know if this has been said before but if someone gets into a receiver and changes anything that can have an affect on ap clearing... we just had that this month. First of the month she went back into a receiver for last month and added a line. So the receiver was for last month but the transaction date was May.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of vlgatfse
Sent: Wednesday, May 04, 2005 6:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AP Clearing Account


Thanks guys for the advice. I think, unfortunately, everything that
has been writted has been dealt with here. We've had some bumpy
roads here in the past, but have been getting rid of most of the
potholes. I'll look over all the emails to make sure there isn't
something that was said that I may have overlooked.

Thanks again guys. Have a great hump day!!!

--- In vantage@yahoogroups.com, "James Martin Jr." <jmartin@e...>
wrote:
> I'd second everything Brian has mentioned here- clean cut-off will
take care of many problems. We've also had issues with new A/P
people entering inventory invoices as expense items, ie: they forget
to match invoice to receipt line, but use misc line instead (and let
the G/L default to inventory). Creates variance in Inventory and A/P
clearing. Also, in the rare case where we pay in advance for
inventory, an invoice may go in first, receipt second, A/P Clearing
variance third. Watch out if your company uses a credit card to pay
for inventory from time to time. I can email you a procedure for
clearing these off-line if it applies.
>
> James
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf
> Of Brian Larcom
> Sent: Tuesday, May 03, 2005 2:06 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: AP Clearing Account
>
>
> There are a few things that we do that seem to help keep AP
Clearing
> tied out to the Recieved but not Invoiced report:
> 1. Post all of the invoices you have by the last day of the month.
> 2. Lock out recieving (by switching on Security Manager Access Only
> in the Menu Security area) at the end of the last day of the month.
> Turn it off once you've printed your Recieved but not Invoiced
report.
> 3. Any invoice recieved the following month gets the new month's
> invoice date.
> 4. Make sure recieving does not back date any reciepts.
> 5. Keep track of any deposits that are not matched with a reciept.
> Brian W. Larcom, CFO
> Metallized Carbon Corporation
> Ossining, NY
>
>
> --- In vantage@yahoogroups.com, "vlgatfse" <vlgatfse@y...> wrote:
> > Hi, new here, on Vantage for about a year and a half, currently
on
> 6.1
> > since last summer.
> >
> > I'm getting relatively familar with reconciling the WIP and
> Inventory
> > accounts each month. However, over the last several months, my
AP
> > Clearing account continues to be off against the Received but not
> > Invoice report. I've looked thru the GL transactions, looked
thru
> the
> > WIP reconciliation, but nothing is really standing out.
> >
> > Any ideas anyone? Not sure why this is happening now, as it was
> tying
> > out into late last year. I'm not sure what the change is, but
any
> > ideas or advice would be helpful.
> >
> > Thanks in advance.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
11
We have discussions before we do such things so purch and accounting are in
agreement. It is sometimes necessary.
-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Wednesday, May 04, 2005 8:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: AP Clearing Account


I don't know if this has been said before but if someone gets into a
receiver and changes anything that can have an affect on ap clearing... we
just had that this month. First of the month she went back into a receiver
for last month and added a line. So the receiver was for last month but the
transaction date was May.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of vlgatfse
Sent: Wednesday, May 04, 2005 6:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AP Clearing Account


Thanks guys for the advice. I think, unfortunately, everything that
has been writted has been dealt with here. We've had some bumpy
roads here in the past, but have been getting rid of most of the
potholes. I'll look over all the emails to make sure there isn't
something that was said that I may have overlooked.

Thanks again guys. Have a great hump day!!!

--- In vantage@yahoogroups.com, "James Martin Jr." <jmartin@e...>
wrote:
> I'd second everything Brian has mentioned here- clean cut-off will
take care of many problems. We've also had issues with new A/P
people entering inventory invoices as expense items, ie: they forget
to match invoice to receipt line, but use misc line instead (and let
the G/L default to inventory). Creates variance in Inventory and A/P
clearing. Also, in the rare case where we pay in advance for
inventory, an invoice may go in first, receipt second, A/P Clearing
variance third. Watch out if your company uses a credit card to pay
for inventory from time to time. I can email you a procedure for
clearing these off-line if it applies.
>
> James
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf
> Of Brian Larcom
> Sent: Tuesday, May 03, 2005 2:06 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: AP Clearing Account
>
>
> There are a few things that we do that seem to help keep AP
Clearing
> tied out to the Recieved but not Invoiced report:
> 1. Post all of the invoices you have by the last day of the month.
> 2. Lock out recieving (by switching on Security Manager Access Only
> in the Menu Security area) at the end of the last day of the month.
> Turn it off once you've printed your Recieved but not Invoiced
report.
> 3. Any invoice recieved the following month gets the new month's
> invoice date.
> 4. Make sure recieving does not back date any reciepts.
> 5. Keep track of any deposits that are not matched with a reciept.
> Brian W. Larcom, CFO
> Metallized Carbon Corporation
> Ossining, NY
>
>
> --- In vantage@yahoogroups.com, "vlgatfse" <vlgatfse@y...> wrote:
> > Hi, new here, on Vantage for about a year and a half, currently
on
> 6.1
> > since last summer.
> >
> > I'm getting relatively familar with reconciling the WIP and
> Inventory
> > accounts each month. However, over the last several months, my
AP
> > Clearing account continues to be off against the Received but not
> > Invoice report. I've looked thru the GL transactions, looked
thru
> the
> > WIP reconciliation, but nothing is really standing out.
> >
> > Any ideas anyone? Not sure why this is happening now, as it was
> tying
> > out into late last year. I'm not sure what the change is, but
any
> > ideas or advice would be helpful.
> >
> > Thanks in advance.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links








Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
12
That would be nice but discussions don't always happen.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Sherer, Rhonda
Sent: Wednesday, May 04, 2005 8:57 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: AP Clearing Account


We have discussions before we do such things so purch and accounting are in
agreement. It is sometimes necessary.
-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Wednesday, May 04, 2005 8:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: AP Clearing Account


I don't know if this has been said before but if someone gets into a
receiver and changes anything that can have an affect on ap clearing... we
just had that this month. First of the month she went back into a receiver
for last month and added a line. So the receiver was for last month but the
transaction date was May.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of vlgatfse
Sent: Wednesday, May 04, 2005 6:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AP Clearing Account


Thanks guys for the advice. I think, unfortunately, everything that
has been writted has been dealt with here. We've had some bumpy
roads here in the past, but have been getting rid of most of the
potholes. I'll look over all the emails to make sure there isn't
something that was said that I may have overlooked.

Thanks again guys. Have a great hump day!!!

--- In vantage@yahoogroups.com, "James Martin Jr." <jmartin@e...>
wrote:
> I'd second everything Brian has mentioned here- clean cut-off will
take care of many problems. We've also had issues with new A/P
people entering inventory invoices as expense items, ie: they forget
to match invoice to receipt line, but use misc line instead (and let
the G/L default to inventory). Creates variance in Inventory and A/P
clearing. Also, in the rare case where we pay in advance for
inventory, an invoice may go in first, receipt second, A/P Clearing
variance third. Watch out if your company uses a credit card to pay
for inventory from time to time. I can email you a procedure for
clearing these off-line if it applies.
>
> James
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf
> Of Brian Larcom
> Sent: Tuesday, May 03, 2005 2:06 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: AP Clearing Account
>
>
> There are a few things that we do that seem to help keep AP
Clearing
> tied out to the Recieved but not Invoiced report:
> 1. Post all of the invoices you have by the last day of the month.
> 2. Lock out recieving (by switching on Security Manager Access Only
> in the Menu Security area) at the end of the last day of the month.
> Turn it off once you've printed your Recieved but not Invoiced
report.
> 3. Any invoice recieved the following month gets the new month's
> invoice date.
> 4. Make sure recieving does not back date any reciepts.
> 5. Keep track of any deposits that are not matched with a reciept.
> Brian W. Larcom, CFO
> Metallized Carbon Corporation
> Ossining, NY
>
>
> --- In vantage@yahoogroups.com, "vlgatfse" <vlgatfse@y...> wrote:
> > Hi, new here, on Vantage for about a year and a half, currently
on
> 6.1
> > since last summer.
> >
> > I'm getting relatively familar with reconciling the WIP and
> Inventory
> > accounts each month. However, over the last several months, my
AP
> > Clearing account continues to be off against the Received but not
> > Invoice report. I've looked thru the GL transactions, looked
thru
> the
> > WIP reconciliation, but nothing is really standing out.
> >
> > Any ideas anyone? Not sure why this is happening now, as it was
> tying
> > out into late last year. I'm not sure what the change is, but
any
> > ideas or advice would be helpful.
> >
> > Thanks in advance.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links








Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
13
Please re-read my email about the Production Detail Report. The report
totals are wrong -- they don't match their own detail nor the Inventory WIP
Reconciliation Report -- but they do match what's being posted. I'm guessing
there's shared logic between the PDR and the Capture/Post. And it's also
wrong in Version 8. Which means this report is wrong on all versions of
Vantage.

Yes, procedurally we can create our own mess. But when a standard report and
the posting is wrong to begin with, we go nuts reconciling our mess with
Epicor's.

----- Original Message -----
From: "vlgatfse" <vlgatfse@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, May 04, 2005 4:36 AM
Subject: [Vantage] Re: AP Clearing Account


> Thanks for the advice. However, that is unforunately things that we
> learned the hard way early on last year. We have been fortunate
> enough to be blessed with a very knowledgable consultant.
> Unfortuantely, since she is so good, it's danged near impossible to
> get her here anymore. It was so bad with this and that that we
> actually send out a monthly schedule of when things MUST be completed
> by. For the most part, everyone follows the schedule, with a few
> occassional exceptions. Also, our finance department is little, 3
> full time including the CFO and one part timer. So, we work pretty
> closely together and I try to look at the WIP reconciliation at least
> twice a week to try to catch things before they get ugly. I also try
> to review the Received but not Invoiced and also the Expense
> Distribution.
>
> Thanks again. Back to looking and looking and looking.....
>
>
> --- In vantage@yahoogroups.com, "Randy Lunsford" <rlunsf@e...> wrote:
>> Most of the time when we don't reconcile with the report, it is
> because
>> our A/P has entered an incorrect G/L month when entering an invoice
> tied
>> to a PO receipt. For example, the receipt would be in April, she
> would
>> enter the A/P invoice in May and enter a G/L month of April. When
>> entering invoices tied to PO receipts, you always enter the G/L
> month
>> the same as the month your entry month, if that makes sense. In
> other
>> words, if you enter the invoice in May, the G/L month should be May.
>> You only do this with PO receipt invoices, not expenses or invoices
> not
>> tied to a PO receipt. Another reason for not reconciling is when
> you
>> have a receipt that is corrected in the next month. If we have to
>> correct a PO receipt that crosses months, we always delete the
> receipt
>> and then re-receive the PO. Hope this makes sense.
>>
>> Randall Lunsford
>> Excel Machinery, Ltd.
>> e-mail: rlunsf@e...
>> Phone: (806) 335-4565 ext. 531
>> Fax: (806) 335-9017
>>
>> -----Original Message-----
>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
>> Of vlgatfse
>> Sent: Tuesday, May 03, 2005 1:50 PM
>> To: vantage@yahoogroups.com
>> Subject: [Vantage] AP Clearing Account
>>
>> Hi, new here, on Vantage for about a year and a half, currently on
> 6.1
>> since last summer.
>>
>> I'm getting relatively familar with reconciling the WIP and
> Inventory
>> accounts each month. However, over the last several months, my AP
>> Clearing account continues to be off against the Received but not
>> Invoice report. I've looked thru the GL transactions, looked thru
> the
>> WIP reconciliation, but nothing is really standing out.
>>
>> Any ideas anyone? Not sure why this is happening now, as it was
> tying
>> out into late last year. I'm not sure what the change is, but any
>> ideas or advice would be helpful.
>>
>> Thanks in advance.
>>
>>
>>
>>
>>
>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
>> have already linked your email address to a yahoo id to enable
> access. )
>> (1) To access the Files Section of our Yahoo!Group for Report
> Builder
>> and Crystal Reports and other 'goodies', please goto:
>> http://groups.yahoo.com/group/vantage/files/.
>> (2) To search through old msg's goto:
>> http://groups.yahoo.com/group/vantage/messages
>> (3) To view links to Vendors that provide Vantage services goto:
>> http://groups.yahoo.com/group/vantage/links
>> Yahoo! Groups Links
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>