We post those AP invoices in February but give them the actual invoice date.
Your AP register will tie to the GL if you run the AP Aging by Fiscal
Period.
There can be issues with purchase adjustments on the Received But Not
Invoiced report, too. For example, there have been times that AP has posted
an invoice on the report back into the previous period in error. If there is
a purchase adjustment, the amount of the adjustment will post on the entry
date, which is in the next period. The result is that your Received but Not
invoiced report will be out of balance with the GL by the amount of the
purchase adjustment. Of course, this is an issue only because an error was
made during processing.
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: Wilmoth, Deb [mailto:Deb@...]
Sent: Thursday, February 05, 2004 6:09 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Accrued Accounts Payable
Truly, these work arounds are okay...........but goofy. So how to you
date January 28-31 invoices that arrive in February?
Do you give them February dates?
Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0
-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Thursday, February 05, 2004 8:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Accrued Accounts Payable
Yeah ours ties every month as well... I just stay until everyone else is
out
of Vantage the last day of the month and run a couple of reports that have
this neat little timing issue... Received not invoiced - Stock Status -
Backlog - Open DMR List - Inspection Pending - I think that is about it
I would think that if you printed the report at the right time one month
made the adjustment for that month end then printed it the right time
going
forward it should be accurate... at least that is what worked for us..
ours
wasn't tying at first....
Stephanie
-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Wednesday, February 04, 2004 5:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Accrued Accounts Payable
Ours ties out every month. The trick is to run the "Received But Not
Invoiced Report" on the last day of the month after all items are
received.
The reason for the timing issue is that once an invoice that is on the
Received report is pulled over and posted, it disappears off the report,
no
matter what "as of" date you set the report for. After the month end, AP
is
not allowed to post an item on the report back into the previous period.
If
an invoice on the report is posted back into the previous month, you must
manually remove that invoice from the report to keep it in balance.
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: rmrindler [mailto:rrindler@...]
Sent: Wednesday, February 04, 2004 12:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Accrued Accounts Payable
We have been on Vantage for a couple years, and we have not had the
Received but not Invoiced Report tie out to the AP Clearing Account
once. We tried asking Epicor how to reconcile this account, and
their answer to us was that it was almost impossible to reconcile
because of a "timing issue."
Ryan Rindler
Network Admin.
Norwood Tool Company
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
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
[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 Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cl0914d/M=268585.4464812.5643763.1261774/D=egroup
web/S=1705007183:HM/EXP=1076021919/A=1950450/R=0/*http://ashnin.com/clk/mury
utaitakenattogyo?YH=4464812&yhad=1950450> click here
<http://us.adserver.yahoo.com/l?M=268585.4464812.5643763.1261774/D=egroupmai
l/S=:HM/A=1950450/rand=172907688>
_____
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/> .
[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
[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
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Your AP register will tie to the GL if you run the AP Aging by Fiscal
Period.
There can be issues with purchase adjustments on the Received But Not
Invoiced report, too. For example, there have been times that AP has posted
an invoice on the report back into the previous period in error. If there is
a purchase adjustment, the amount of the adjustment will post on the entry
date, which is in the next period. The result is that your Received but Not
invoiced report will be out of balance with the GL by the amount of the
purchase adjustment. Of course, this is an issue only because an error was
made during processing.
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: Wilmoth, Deb [mailto:Deb@...]
Sent: Thursday, February 05, 2004 6:09 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Accrued Accounts Payable
Truly, these work arounds are okay...........but goofy. So how to you
date January 28-31 invoices that arrive in February?
Do you give them February dates?
Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0
-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Thursday, February 05, 2004 8:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Accrued Accounts Payable
Yeah ours ties every month as well... I just stay until everyone else is
out
of Vantage the last day of the month and run a couple of reports that have
this neat little timing issue... Received not invoiced - Stock Status -
Backlog - Open DMR List - Inspection Pending - I think that is about it
I would think that if you printed the report at the right time one month
made the adjustment for that month end then printed it the right time
going
forward it should be accurate... at least that is what worked for us..
ours
wasn't tying at first....
Stephanie
-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Wednesday, February 04, 2004 5:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Accrued Accounts Payable
Ours ties out every month. The trick is to run the "Received But Not
Invoiced Report" on the last day of the month after all items are
received.
The reason for the timing issue is that once an invoice that is on the
Received report is pulled over and posted, it disappears off the report,
no
matter what "as of" date you set the report for. After the month end, AP
is
not allowed to post an item on the report back into the previous period.
If
an invoice on the report is posted back into the previous month, you must
manually remove that invoice from the report to keep it in balance.
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: rmrindler [mailto:rrindler@...]
Sent: Wednesday, February 04, 2004 12:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Accrued Accounts Payable
We have been on Vantage for a couple years, and we have not had the
Received but not Invoiced Report tie out to the AP Clearing Account
once. We tried asking Epicor how to reconcile this account, and
their answer to us was that it was almost impossible to reconcile
because of a "timing issue."
Ryan Rindler
Network Admin.
Norwood Tool Company
> welllllll.............to balance when you've missed the timingto the
> thing..........is hard work, but possible..........
>
> It is important to note that Vantage use a SYSTEM DATE (major DUH
> extreme!!!!!!) rather than going by invoice date,subsequent period
> G/L group date, etc.
>
> So, understanding that, run the Inventory/WIP report the
> (ie February when reconciling January) for the dates following monthinvoices had
> end...........Look for ADJ-PUR transactions to identify which
> miscellaneous charges for the prior month. Alternatively, if youcomb
> through Invoice Edit lists for January invoices entered inFebruary, it will
> net you the same sort of info.should
>
> For example, my A/P clearing account number is (G/L #2899) which
> reflect the total $ received, but not invoiced per that report youJanuary
> mentioned. So I run that report after I've entered and posted my
> invoices dated with January dates with merchandise received inJanuary,
> entered and posted in a JANUARY GROUP, today. I will scour theInvoice edit
> list for miscellaneous freight charges etc. (added to the line)because they
> are Posted IN FEBRUARY! SO naturally, that throws off the balancefor
> February. I enter a reversing entry and away I balance.run to
>
> Confusing huh! It's been a pet peeve of mine for years. People
> take cover around here when I mention CLEARING ACCOUNT. Please e-mail me
> privately if you want more info. Like my phone # to callme...........
>in
> Deb Wilmoth
> Controller
> Reeder & Kline Machine Company, Inc.
> Vantage 5.0
>
>
> -----Original Message-----
> From: Cheryl Rigsbee [mailto:Cherylr@u...]
> Sent: Tuesday, February 03, 2004 2:44 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Accrued Accounts Payable
>
>
> I hate to say it, but it is timing.
>
>
>
> -----Original Message-----
> From: Judith Wayne [mailto:wayne@d...]
> Sent: Tuesday, February 03, 2004 2:40 PM
> To: VANTAGE@Y...
> Subject: [Vantage] Accrued Accounts Payable
>
>
> So tell me, there must be a secret to getting the "received but not
> invoiced" report to balance to the accrued accounts payable account
> the general ledger at the end of every month. Please don't tell meit's
> a "timing thing"! Any helpful hints will be greatly appreciated.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
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
[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 Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cl0914d/M=268585.4464812.5643763.1261774/D=egroup
web/S=1705007183:HM/EXP=1076021919/A=1950450/R=0/*http://ashnin.com/clk/mury
utaitakenattogyo?YH=4464812&yhad=1950450> click here
<http://us.adserver.yahoo.com/l?M=268585.4464812.5643763.1261774/D=egroupmai
l/S=:HM/A=1950450/rand=172907688>
_____
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/> .
[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
[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
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]