Welcome, Guest. Please Login.
05/09/25 at 16:40:55
News:
Home Help Search Login


Pages: 1
Send Topic Print
AP credit memo problem with freight (Read 735 times)
Cyndee Pappas
Senior Member
****


EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female
AP credit memo problem with freight
06/22/05 at 13:30:49
 
When entering freight on a credit memo, the total credit is overstated.
Example:  
on first screen, enter invoice amount as -294.54
pick one line, qty -1 at 290.00
yes to apply to freight and taxes question.
Next screen shows Invoice Amount as -294.54, but should be only -290.00.  
Enter freight of -4.54. Screen updates total to -299.08
Credit memo is posted to GL and Aging at -299.08 instead of -294.54.
 
AP-C banner date is 2/4/05
 
This happened once before, but I figured that I had screwed up. This time, I duplicated in my sandbox company with the same results.
Back to top
 
 

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: AP credit memo problem with freight
Reply #1 - 06/22/05 at 16:56:48
 
Thanks Cyndee - I think I know what the problem is, although I don't really like it - won't be easy to fix  Sad
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Cyndee Pappas
Senior Member
****


EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female
Re: AP credit memo problem with freight
Reply #2 - 09/08/05 at 14:15:43
 
AP-C Banner 6/13/05  
 
Found this in the DBA help file--
Invoice Amount
 
The amount of the invoice to be distributed among PO line items.  It can either be entered as the invoice total including tax and freight or a subtotal amount excluding tax and freight.
Is this new or have I just missed it?
 
The overstatement still happens if you enter the total credit including the freight. But, if you enter only the subtotal excluding the tax & freight, it works just fine.
Back to top
 
 

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: AP credit memo problem with freight
Reply #3 - 09/09/05 at 04:11:53
 
I have the same problem - what I have elected to do is create an inventory part number called "Freight on RMA" and code it as "N" non-inventory, set up a product class that charges the GL for incoming freight.
 
I edit the purchase order for the negative qty to be returned to the vendor as well as adding a line for the "Freight on RMA".  Then receive each line item on the purchase order so that AP-C will show two items, the inventory being returned to the vendor and the corresponding freight.
 
Hope this helps until a fix is created.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Cyndee Pappas
Senior Member
****


EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female
Re: AP credit memo problem with freight
Reply #4 - 09/09/05 at 07:45:18
 
Quote from Cyndee Pappas   on 09/08/05 at 14:15:43:
AP-C Banner 6/13/05

Found this in the DBA help file--
Invoice Amount

The amount of the invoice to be distributed among PO line items.  It can either be entered as the invoice total including tax and freight or a subtotal amount excluding tax and freight.
Is this new or have I just missed it?

The overstatement still happens if you enter the total credit including the freight. But, if you enter only the subtotal excluding the tax & freight, it works just fine.

 
Sorry I wasn't more clear.  
If you enter only the subtotal on the first screen, you will still be allowed to enter the freight amount on the last screen. It will update the invoice total.  
Back to top
 
 

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: AP credit memo problem with freight
Reply #5 - 09/09/05 at 09:22:06
 
Thanks, Cyndee!  I never tried just entering the subtotal without tax/freight, but will do so for the next occurrence.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Pages: 1
Send Topic Print