AP Clearing

Yahoo Archive
1
Thanks for the help.

--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> Run your WIP Reconciliation report and look at your transactions under your AP Clearing account. You can also run your received not invoiced report under AP/Reports
>
>
>
> ________________________________
> From: Millicent <millicent.massey@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, September 13, 2012 11:54 AM
> Subject: [Vantage] AP Clearing
>
>
> ÂÂ
> Can anyone help with the steps to reconcile the AP clearing account? I apologize if my request shows up twice.We are experiencing e-mail issues.
>
> Thanks.
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Does anyone know of a quick way to reconcile the AP Clearing account? I
ran a crystal report for all open receivers that haven't been invoiced
and that does not tie into the ending balance of the AP Clearing
account.

Any suggestions would be appreciated.

Thanks,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com




[Non-text portions of this message have been removed]
3
Did you check the dates of the invoice... I run the report with exaggerated dates to make sure I get anything that might have errors on the date field. 1/1/00 to 12/31/50

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Michelle de la Vega
Sent: Thursday, June 16, 2005 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] AP Clearing


Does anyone know of a quick way to reconcile the AP Clearing account? I
ran a crystal report for all open receivers that haven't been invoiced
and that does not tie into the ending balance of the AP Clearing
account.

Any suggestions would be appreciated.

Thanks,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com




[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
4
Michelle,

Gotcha's can include, but aren't limited to, material items that are
prepaid (payment is made, then parts are received), material that is
paid for with a credit card, material invoices not matched to receivers,
and timing issues like Stephanie mentioned. Many of our problems went
away when we set up a clean cut at month end. We do this by halting all
receiving after month end close, running the received not invoiced
report with a wide date range (per Stephanie), then running the GL, then
cutting loose receiving.

James

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Geary, Stephanie
Sent: Thursday, June 16, 2005 9:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] AP Clearing

Did you check the dates of the invoice... I run the report with
exaggerated dates to make sure I get anything that might have errors on
the date field. 1/1/00 to 12/31/50

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Michelle de la Vega
Sent: Thursday, June 16, 2005 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] AP Clearing


Does anyone know of a quick way to reconcile the AP Clearing account? I
ran a crystal report for all open receivers that haven't been invoiced
and that does not tie into the ending balance of the AP Clearing
account.

Any suggestions would be appreciated.

Thanks,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com
5
Timing seems to be key for a number of reports in Vantage.. I come in that last day of the month after everyone leaves to run reports, to make sure it is as clean as it can be.... I wish there was a way to "LOCK" people out of areas until month end is finished ...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of James Martin Jr.
Sent: Thursday, June 16, 2005 11:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] AP Clearing


Michelle,

Gotcha's can include, but aren't limited to, material items that are
prepaid (payment is made, then parts are received), material that is
paid for with a credit card, material invoices not matched to receivers,
and timing issues like Stephanie mentioned. Many of our problems went
away when we set up a clean cut at month end. We do this by halting all
receiving after month end close, running the received not invoiced
report with a wide date range (per Stephanie), then running the GL, then
cutting loose receiving.

James

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Geary, Stephanie
Sent: Thursday, June 16, 2005 9:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] AP Clearing

Did you check the dates of the invoice... I run the report with
exaggerated dates to make sure I get anything that might have errors on
the date field. 1/1/00 to 12/31/50

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Michelle de la Vega
Sent: Thursday, June 16, 2005 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] AP Clearing


Does anyone know of a quick way to reconcile the AP Clearing account? I
ran a crystal report for all open receivers that haven't been invoiced
and that does not tie into the ending balance of the AP Clearing
account.

Any suggestions would be appreciated.

Thanks,

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com






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
At 12:35 PM 6/16/2005, you wrote:
>Timing seems to be key for a number of reports in Vantage.. I come in that
>last day of the month after everyone leaves to run reports, to make sure
>it is as clean as it can be.... I wish there was a way to "LOCK" people
>out of areas until month end is finished

Would a stable / static copy of the data help? You can take a month-end
backup and restore it into a test database for reporting.

Also, NOT setting up all your GL periods a year in advance is highly
recommended. At a minimum, don't set up December - this rejects those
back-dated January transactions that end up 11 months forward. Even
leaving out the next month until you're done reporting and closing will
stop many transactions, since there's no GL Period associated with the
calendar date.


[Non-text portions of this message have been removed]
7
Can you use the "Budget" if the fiscal periods aren't defined?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of wmc20@...
Sent: Thursday, June 16, 2005 12:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] AP Clearing


At 12:35 PM 6/16/2005, you wrote:
>Timing seems to be key for a number of reports in Vantage.. I come in that
>last day of the month after everyone leaves to run reports, to make sure
>it is as clean as it can be.... I wish there was a way to "LOCK" people
>out of areas until month end is finished

Would a stable / static copy of the data help? You can take a month-end
backup and restore it into a test database for reporting.

Also, NOT setting up all your GL periods a year in advance is highly
recommended. At a minimum, don't set up December - this rejects those
back-dated January transactions that end up 11 months forward. Even
leaving out the next month until you're done reporting and closing will
stop many transactions, since there's no GL Period associated with the
calendar date.


[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
8
Can anyone help with the steps to reconcile the AP clearing account? I apologize if my request shows up twice.We are experiencing e-mail issues.

Thanks.
9
Run your WIP Reconciliation report and look at your transactions under your AP Clearing account. You can also run your received not invoiced report under AP/Reports



________________________________
From: Millicent <millicent.massey@...>
To: vantage@yahoogroups.com
Sent: Thursday, September 13, 2012 11:54 AM
Subject: [Vantage] AP Clearing


Â
Can anyone help with the steps to reconcile the AP clearing account? I apologize if my request shows up twice.We are experiencing e-mail issues.

Thanks.




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