Welcome, Guest. Please Login.
11/01/24 at 01:36:20
News:
Home Help Search Login


Pages: 1
Send Topic Print
Correcting Vendor Overcharge in Inventory (Read 613 times)
CCKEITH
Full Member
***


Thanks, Lynn and
Allen and Lori!

Posts: 151
Gender: female
Correcting Vendor Overcharge in Inventory
01/15/08 at 15:13:19
 
We received an item in PO-C and were invoiced incorrectly for the item, but the incorrect invoice was processed in AP-C before the overcharge was noticed.
 
We were credited for the overcharge and I know we can enter it as a credit memo in AP-B but the correcting invoice which was a credit for the overcharge has no relationship in Evo to the original receipt and AP-C.  How do we make sure that the last and average cost of the item is correct?
Back to top
 
 

Charlene Keith
Hillco Technologies, Inc.
Evo-ERP 2015.1
(30 users)
WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Correcting Vendor Overcharge in Inventory
Reply #1 - 01/16/08 at 05:05:46
 
You may consider entering a new PO with a negative line at the old price and a positive line at the new price. The total should come up to the credit memo you received and the withdrawal/re-receipt should fix the average cost, but may not depending on what it was before.
 
Another way is to manually figure out what the new last and average cost should be and change it in IN-K. You may then want to make a GL-B entry.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 379
Re: Correcting Vendor Overcharge in Inventory
Reply #2 - 01/16/08 at 07:15:50
 
What I usually do is make 2 entries in Accounts Payable.
 
In this situation, first reverse the first invoice entered in AP-C, by entering the invoice number and respond, yes, to the question - do you want to reverse this invoice.
 
Then I enter in AP-C only the properly billed price from the first invoice which shows the incorrrect price.
I.E.  if I was charged $12 each instead of $10 each, I would enter the $10 price in AP-C.  This ensures inventory has the proper cost.
 
Then I make a second entry in AP-B for the $2 overcharge times quantity received.  The total of these 2 entries equals the incorrectly billed invoice.
 
When the credit memo arrives, I enter the credit memo in AP-B for the $2 overcharge.
 
This way ensures the Vendor's Accounts Receivable can match the invoiced amount and credit memo amount on their set of books when I remit payment.  The payment stub will show the total amount of the incorrect invoice (though 2 entries) and the credit memo amount.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
CCKEITH
Full Member
***


Thanks, Lynn and
Allen and Lori!

Posts: 151
Gender: female
Re: Correcting Vendor Overcharge in Inventory
Reply #3 - 01/16/08 at 09:41:23
 
Thanks David and lmk223a.
 
I decided to process the overcharge using lmk223a's suggestion.  It worked great.  The entries will be easy for our vendor to follow.
Back to top
 
 

Charlene Keith
Hillco Technologies, Inc.
Evo-ERP 2015.1
(30 users)
WWW   IP Logged
Pages: 1
Send Topic Print