Received but not Invoiced

Yahoo Archive
1
It should tie in with your Accounts Payable-Clearing account in your GL.
The only way, that I have found, that it doesn't agree is if you pay in
advance for inventory (unreceived billing). You then have to adjust the
report by the amount you paid but had not received into inventory. We use
it all the time, but I'm not sure who else does.

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

-----Original Message-----
From: rhondareilly [mailto:rreilly@...]
Sent: Friday, December 05, 2003 11:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Received but not Invoiced

Could anyone tell me if the "Received but not Invoiced" report in 5.2
ties with the GL.

Thanks




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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
We have POs that were never attached on the system to their appropriate
invoice. Therefore we have POs that we actually were invoiced for showing
up on our Received but not Invoiced report. What is the best way to clear
these POs off of this report?

Thanks,
Kara
3
Kara,
We had the same situation... Epicor had a document fix method to clear these from your system. I am sure if you call them they will let you know how to do it. I may still have it somewhere but I know they have it. You have to create dummy invoices and then do invoice adjustment to bring them back to zero dollars.
Kara Stoller <kstoller@...> wrote: We have POs that were never attached on the system to their appropriate
invoice. Therefore we have POs that we actually were invoiced for showing
up on our Received but not Invoiced report. What is the best way to clear
these POs off of this report?

Thanks,
Kara

Yahoo! Groups SponsorADVERTISEMENT

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more

[Non-text portions of this message have been removed]
4
Here is what they sent to me... I hope this helps.
Summary PM - How do we correct the PO receipt not invoiced?
Book Vantage General Information
Page 1292MPS

Page ID 1292MPS

You will need to research these invoices to see what accounts were hit
and
when the miscellaneous invoices were created. Also, realize that the
clearing account has not been debited until you add the receipt billing
line
in invoicing. You will want to remove the receipts by creating dummy
invoices and then creating Debit Memos to offset the dummy invoices.

Step 1: Research each miscellaneous invoice to verify what transaction
took
place during the time of invoicing. This can be accomplished by
using vendor tracker or invoice tracker and
drill down on the invoices to the point of the general ledger entry.

Step 2: Create invoices using the receipt billing line and bring in
the
receipts.

Step 3: Print invoice edit list to verify general ledger entries

Step 4: Post invoices

Step 5: Enter Debit Memos - identical to the invoices that were newly
created

Step 6: Print edit list and verify that the general ledger entries
offset
the same entries in step 3 (you will need to use some
of your own discretion depending what general ledger
accounts are impacted).

Step 7: Post the debit memos

Step 8: The new invoices will be offset by the debit memos

Step 9: To get clear the invoice and debit memo issue a zero payment.





---------------------------------
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more

[Non-text portions of this message have been removed]
5
Thanks Stephanie. This makes sense. I think I'll have my work cut out for
me, though -we have many, many of these types of POs.

Kara

> -----Original Message-----
> From: Stephanie Geary [SMTP:sageary25@...]
> Sent: Tuesday, April 23, 2002 5:46 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Received but not Invoiced
>
>
> Here is what they sent to me... I hope this helps.
> Summary PM - How do we correct the PO receipt not invoiced?
> Book Vantage General Information
> Page 1292MPS
>
> Page ID 1292MPS
>
> You will need to research these invoices to see what accounts were hit
> and
> when the miscellaneous invoices were created. Also, realize that the
> clearing account has not been debited until you add the receipt billing
> line
> in invoicing. You will want to remove the receipts by creating dummy
> invoices and then creating Debit Memos to offset the dummy invoices.
>
> Step 1: Research each miscellaneous invoice to verify what transaction
> took
> place during the time of invoicing. This can be accomplished
> by
> using vendor tracker or invoice tracker and
> drill down on the invoices to the point of the general ledger entry.
>
> Step 2: Create invoices using the receipt billing line and bring in
> the
> receipts.
>
> Step 3: Print invoice edit list to verify general ledger entries
>
> Step 4: Post invoices
>
> Step 5: Enter Debit Memos - identical to the invoices that were newly
> created
>
> Step 6: Print edit list and verify that the general ledger entries
> offset
> the same entries in step 3 (you will need to use some
> of your own discretion depending what general ledger
> accounts are impacted).
>
> Step 7: Post the debit memos
>
> Step 8: The new invoices will be offset by the debit memos
>
> Step 9: To get clear the invoice and debit memo issue a zero payment.
>
>
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> Click Here!
> <http://rd.yahoo.com/M=194081.1994012.3473453.1261774/D=egroupweb/S=170500
> 7183:HM/A=1036972/R=0/*http://www.ediets.com/start.cfm?code=3466>
>
> <http://us.adserver.yahoo.com/l?M=194081.1994012.3473453.1261774/D=egroupm
> ail/S=1705007183:HM/A=1036972/rand=967829147>
>
> 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>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.
6
Another option to avoid entering all those debit memos is to use the
Adjustment feature to reverse and zero out the duplicate invoices. Saves a
bit of work. Same theory as what Stephanie uses.

Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0


-----Original Message-----
From: Kara Stoller [mailto:kstoller@...]
Sent: Wednesday, April 24, 2002 9:25 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Received but not Invoiced


Thanks Stephanie. This makes sense. I think I'll have my work cut out for
me, though -we have many, many of these types of POs.

Kara

> -----Original Message-----
> From: Stephanie Geary [SMTP:sageary25@...]
> Sent: Tuesday, April 23, 2002 5:46 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Received but not Invoiced
>
>
> Here is what they sent to me... I hope this helps.
> Summary PM - How do we correct the PO receipt not invoiced?
> Book Vantage General Information
> Page 1292MPS
>
> Page ID 1292MPS
>
> You will need to research these invoices to see what accounts were hit
> and
> when the miscellaneous invoices were created. Also, realize that the
> clearing account has not been debited until you add the receipt billing
> line
> in invoicing. You will want to remove the receipts by creating dummy
> invoices and then creating Debit Memos to offset the dummy invoices.
>
> Step 1: Research each miscellaneous invoice to verify what transaction
> took
> place during the time of invoicing. This can be accomplished
> by
> using vendor tracker or invoice tracker and
> drill down on the invoices to the point of the general ledger entry.
>
> Step 2: Create invoices using the receipt billing line and bring in
> the
> receipts.
>
> Step 3: Print invoice edit list to verify general ledger entries
>
> Step 4: Post invoices
>
> Step 5: Enter Debit Memos - identical to the invoices that were newly
> created
>
> Step 6: Print edit list and verify that the general ledger entries
> offset
> the same entries in step 3 (you will need to use some
> of your own discretion depending what general ledger
> accounts are impacted).
>
> Step 7: Post the debit memos
>
> Step 8: The new invoices will be offset by the debit memos
>
> Step 9: To get clear the invoice and debit memo issue a zero payment.
>


[Non-text portions of this message have been removed]
7
Can you tell me more about the adjustment feature?

> -----Original Message-----
> From: Wilmoth, Deb [SMTP:Deb@...]
> Sent: Wednesday, April 24, 2002 10:42 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Received but not Invoiced
>
> Another option to avoid entering all those debit memos is to use the
> Adjustment feature to reverse and zero out the duplicate invoices. Saves
> a
> bit of work. Same theory as what Stephanie uses.
>
> Deb Wilmoth
> Controller
> Reeder & Kline Machine Company, Inc.
> Vantage 5.0
>
>
> -----Original Message-----
> From: Kara Stoller [mailto:kstoller@...]
> Sent: Wednesday, April 24, 2002 9:25 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Received but not Invoiced
>
>
> Thanks Stephanie. This makes sense. I think I'll have my work cut out
> for
> me, though -we have many, many of these types of POs.
>
> Kara
>
> > -----Original Message-----
> > From: Stephanie Geary [SMTP:sageary25@...]
> > Sent: Tuesday, April 23, 2002 5:46 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Received but not Invoiced
> >
> >
> > Here is what they sent to me... I hope this helps.
> > Summary PM - How do we correct the PO receipt not invoiced?
> > Book Vantage General Information
> > Page 1292MPS
> >
> > Page ID 1292MPS
> >
> > You will need to research these invoices to see what accounts were hit
> > and
> > when the miscellaneous invoices were created. Also, realize that the
> > clearing account has not been debited until you add the receipt billing
> > line
> > in invoicing. You will want to remove the receipts by creating dummy
> > invoices and then creating Debit Memos to offset the dummy invoices.
> >
> > Step 1: Research each miscellaneous invoice to verify what transaction
> > took
> > place during the time of invoicing. This can be
> accomplished
> > by
> > using vendor tracker or invoice tracker and
> > drill down on the invoices to the point of the general ledger
> entry.
> >
> > Step 2: Create invoices using the receipt billing line and bring in
> > the
> > receipts.
> >
> > Step 3: Print invoice edit list to verify general ledger entries
> >
> > Step 4: Post invoices
> >
> > Step 5: Enter Debit Memos - identical to the invoices that were newly
> > created
> >
> > Step 6: Print edit list and verify that the general ledger entries
> > offset
> > the same entries in step 3 (you will need to use some
> > of your own discretion depending what general ledger
> > accounts are impacted).
> >
> > Step 7: Post the debit memos
> >
> > Step 8: The new invoices will be offset by the debit memos
> >
> > Step 9: To get clear the invoice and debit memo issue a zero payment.
> >
>
>
> [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>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.
8
A/P
General Operations
Adjustment
Enter the data in the designated fields including
amount, G/L # to credit and explanation.....

It's possible to zero out the invoice or just a partial amount as is needed.

It's another nice Vantage feature..... the next time I'm grousing, I just
need to remember that there are good things too!


Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0


-----Original Message-----
From: Kara Stoller [mailto:kstoller@...]
Sent: Wednesday, April 24, 2002 9:46 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Received but not Invoiced


Can you tell me more about the adjustment feature?
>
>
> 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>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.


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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



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

> -----Original Message-----
> From: Wilmoth, Deb [SMTP:Deb@...]
> Sent: Wednesday, April 24, 2002 11:10 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Received but not Invoiced
>
> A/P
> General Operations
> Adjustment
> Enter the data in the designated fields including
> amount, G/L # to credit and explanation.....
>
> It's possible to zero out the invoice or just a partial amount as is
> needed.
>
> It's another nice Vantage feature..... the next time I'm grousing, I just
> need to remember that there are good things too!
>
>
> Deb Wilmoth
> Controller
> Reeder & Kline Machine Company, Inc.
> Vantage 5.0
>
>
> -----Original Message-----
> From: Kara Stoller [mailto:kstoller@...]
> Sent: Wednesday, April 24, 2002 9:46 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Received but not Invoiced
>
>
> Can you tell me more about the adjustment feature?
> >
> >
> > 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>>
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> > < <http://docs.yahoo.com/info/terms/>>.
>
>
> 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>
>
> Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> <http://rd.yahoo.com/M=217097.2003762.3481930.1261774/D=egroupweb/S=170500
> 7183:HM/A=1042587/R=0/*http://service.bfast.com/bfast/click?bfmid=29150849
> &siteid=39282504&bfpage=account>
>
> <http://us.adserver.yahoo.com/l?M=217097.2003762.3481930.1261774/D=egroupm
> ail/S=1705007183:HM/A=1042587/rand=377545137>
>
> 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>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.
10
Could anyone tell me if the "Received but not Invoiced" report in 5.2
ties with the GL.

Thanks
11
Yes it does, but printing the report at the right time is the key to
balancing with the GL. I print on the last day of the month after everyone
has left for the day or the first day of the following month before AP posts
anything. I do not allow posting into the prior month for invoices with
purchase order numbers. If any of these invoices are posted into the prior
month, you need to take them off your report manually.



Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
-----Original Message-----
From: rhondareilly [mailto:rreilly@...]
Sent: Friday, December 05, 2003 9:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Received but not Invoiced


Could anyone tell me if the "Received but not Invoiced" report in 5.2
ties with the GL.

Thanks



Yahoo! Groups Sponsor



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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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