ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> AP credit memo problem with freight
http://www.istechforum.com/YaBB.pl?num=1119475849

Message started by Cyndee Pappas on 06/22/05 at 13:30:49

Title: AP credit memo problem with freight
Post by Cyndee Pappas on 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.

Title: Re: AP credit memo problem with freight
Post by Lynn Pantic on 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 :(

Title: Re: AP credit memo problem with freight
Post by 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.

Title: Re: AP credit memo problem with freight
Post by lmk223a on 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.

Title: Re: AP credit memo problem with freight
Post by Cyndee Pappas on 09/09/05 at 07:45:18

Cyndee Pappas wrote:

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.

Title: Re: AP credit memo problem with freight
Post by lmk223a on 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.