Customer product return (RMA) with restocking fee

Hi Everyone,

I recently had to take products back from one of my customers. A credit note was issued for the amount the customer paid minus a restocking fee.

EX:

  • Products Cost: $100.00ea
  • Products Sold: $120.00ea
  • Credit note issued upon return: $102.00 ($120.00 - 15% restocking fee)

Products are once again showing in my inventory which is fine since I intend to resell them. BUT, their cost still show up at their original unit cost price.

I need them to show unit cost - restocking fee (i.e.: $82.00).

I went into the inventory adjustment and transfer window to adjust the units cost BUT, it's now showing doubled what I actually have in stock at the moment.

Anyone can tell me how in Sage 50 Premium I can do this adjustment to A) reflect the products' new cost and B) without messing up the quantities of what I actually have in stock?

Thanks in advance to all who reply,

Marc

  • why would the restocking fee affect the inventory cost of the item ?
    if no fee was charged, wouldn't the item cost 100$ ?
    isn't the fee just an admin charge (miscellaneous income) ?

    or it the item worth less once it has been returned ? if so, shouldn't it be tagged as a different item (reconditioned item) ?

  • in reply to Roger L
    You hit it right on the nail Roger L.

    A restocking fee was charged because the items returned were damaged and will now be sold as reconditionned units.

    Logically, I have to zero out the inventory on that product (I only have the items that were returned on hand), create another SKU# for them (as reconditioned), and indicate the cost for those reconditioned units.

    Using Sage 50s on-line help, I "tried" to do just that BUT, something went wrong and it's now showing me double the quantity (of the new ones) in stock. Hence the reason for posting this request for assistance
  • in reply to MarcDu

    not sure what you did, sounds like you adjusted one unit into stock (qty = 1), giving a new qty of 2

    qty = -1 takes one out of stock, you shouldn't need to change the unit cost

    this entry takes one out of inventory at the standard cost (i just entered -1) and adds one to inventory @ 30$ (i entered qty = 1, cost = 30$)

  • in reply to Roger L
    That makes sense. Will try what you just showed here and let you know. Thank-you Roger L