AP invoice entry

Matt,



Thanks for the reply on this subject. We would definitely favor the 3rd
option as well.



If I could ask one more question: What do you do if the amount received
was in excess of the amount ordered?



Our old system allowed us to make a negative misc. entry. This doesn't
appear to be possible on Vantage.



Thanks again for your assistance.



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





[Non-text portions of this message have been removed]
We have been live on 804 for 1 month and are beginning to accumulate
a number of entries that can't be completed. We'd like to nip this
one in the bud before the pile gets too high.

Does anyone know if there is a way to mark an invoice line as
complete if the invoice qty doesn't match the received qty.

We have cases all the time where the amount received according to our
counting scales doesn't match the amount ordered. (ex. 1000 ordered,
995 received, invoiced for 1000)

We can enter a misc. entry if the amount received is greater (ie
1005) but unlike our old system we can't enter a negative qty.

The end game in all of this is to ensure the item in question is
removed from the Received not Invoiced report.

How are others dealing with this common problem? Thanks in advance
for any wisdom.

John
Receiving should only make an entry for the actual quantity
received. They can use the "Received Complete" checkbox which will
close the PO line.

--- In vantage@yahoogroups.com, "jahatcher43" <johnh@...> wrote:
>
> We have been live on 804 for 1 month and are beginning to
accumulate
> a number of entries that can't be completed. We'd like to nip this
> one in the bud before the pile gets too high.
>
> Does anyone know if there is a way to mark an invoice line as
> complete if the invoice qty doesn't match the received qty.
>
> We have cases all the time where the amount received according to
our
> counting scales doesn't match the amount ordered. (ex. 1000
ordered,
> 995 received, invoiced for 1000)
>
> We can enter a misc. entry if the amount received is greater (ie
> 1005) but unlike our old system we can't enter a negative qty.
>
> The end game in all of this is to ensure the item in question is
> removed from the Received not Invoiced report.
>
> How are others dealing with this common problem? Thanks in advance
> for any wisdom.
>
> John
>
Yes - we found that checkbox. Our main concern is on the accounting
side.



1. we enter the actual amount received of 995 and mark it complete.
(let's say this differs from what was ordered due to the size of part
and use of counting scale).
2. accounting receives an invoice for the 1000 pieces. We want to
post it with 1000 pieces. It all nets out in the end with various +/-
entries.
3. when we do this the system sees that 995 were received but 1000
are being posted and wants the other 5 accounted for. We want to be
able to tell the system "forget about it!"



Any suggestions?



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





[Non-text portions of this message have been removed]
There are a couple different ways we have found to handle a situation
like this (supplier under ships the quantity):



1.) Epicor told us to: a.) reject the supplier invoice b.)
tell supplier you only received 995 and they need to re-invoice. c.)
wait for the re-invoice and do not enter the original or delete it if
you have already entered it.



Because of timing factors and SOX / GAAP issues, documenting of all
transactions for later retrieval and dispute resolution with supplier,
we have chosen not to do it this way. Plus it takes a heck of a lot of
extra communication and admin time dealing in this manner with the
supplier.



2.) Short pay the invoice by: a.) changing the invoice
amount, so when receipt lines are brought into the invoice there is no
variance. This too has SOX / GAAP issues, but is obviously less admin
intensive. Since the Vantage payment statement/check stub has limited
data there is no way to add comments to the invoice that appear on the
check stub (unless you customize that form) and usually the suppliers
are not happy when a short pay has no info. to explain what is going on.



We are using option #3:

3.) Pay the invoice at full amount, then create a debit
for the shortage on the quantity. We prefer to handle matters this way
as it has the most documentation and at the end of the day less admin
time dealing with supplier complaints.



Do this by brining in the receipt lines to the invoice; this creates a
variance due to the qty discrepancy. Then add a misc. invoice line for
the difference. This extra lines keeps the original receipt intact for
audit purposes. We put a note in the reference field on the misc.
invoice line that states the debit memo number. I believe the reference
field is printed on the pay stub, so this ties both transactions
together when the supplier sees the payment.



This method also allows us to do reporting on supplier fulfillment, and
reporting on supplier metrics related to debit activities.



Matt Sweny

Purchasing Manager

Modern Industries Inc.

814-455-8061

matts@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Hatcher, John
Sent: Tuesday, July 08, 2008 7:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: AP invoice entry



Yes - we found that checkbox. Our main concern is on the accounting
side.

1. we enter the actual amount received of 995 and mark it complete.
(let's say this differs from what was ordered due to the size of part
and use of counting scale).
2. accounting receives an invoice for the 1000 pieces. We want to
post it with 1000 pieces. It all nets out in the end with various +/-
entries.
3. when we do this the system sees that 995 were received but 1000
are being posted and wants the other 5 accounted for. We want to be
able to tell the system "forget about it!"

Any suggestions?

John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)

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





This e-mail transmission and any attachments to it are intended
solely for the use of the individual or entity to whom it is
addressed and may contain confidential and privileged
information. If you are not the intended recipient, your use,
forwarding, printing, storing, disseminating, distribution, or
copying of this communication is prohibited. If you received
this communication in error, please notify the sender
immediately by replying to this message and delete it from your
computer.

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