Sage 100

Sage 100 v2015 - Client takes trade ins on sales, then refurbishes and resells. How do others handle this? I need to be able to bring the unit back into inventory (preferably via inv or CM) and assign a cost to it. Would like to assign a serial number (because I want it all). It would seem this should be a simple concept but I am struggling with it. Been a long day and it is only noon.... Thanks in advance.

I would look at DSD's Service Center enhancement. I don't know of any way to do this without something like Service Center.

I'll have to look at service Center., but we have a client doing the same thing. they bring the items in through Sales Order usually as a trade in on an invoice. they have a separate item code for the product they are bringing into inventory (if memory serves the last character of the part no is N-new, T-trade-in, and R-Refurbished). they create a work order (WO module) with a blank BOM since they don't know exactly what they are going to replace/repair on the product. they issue the trade in item to the work order, then manually issue materials and labor to that Work Order. When it is complete they do a work order completion and use the ""R"" part number as the parent item. The work order takes the original cost they assigned to the trade-in, adds labor and materials they have issued to the WO; the sum of those costs is what is assigned to the refurbished part. Tthey use Sage 100 serial numbers so they know the exact cost of each refurbished item and can use that to determine selling price and/or margin when selling it.

You could create a purchase order for the trade in, and an SO invoice for the new item. Then, link the customer and vendor, and apply the payable to the receivable. You could then use BOM and/or WO to add costs and refurbish the item.

I have to say it .... JobOps!

The resell is to different customer right? The original trade-in from customer A provides customer A a reduced price on another item that they are purchasing. The trade-in item after refurbishing though could be sold to customer B, C, etc., right? Enter the trade in as a negative qty on the order/invoice using a separate warehouse code to distinguish the trade-in yet to be refurbished. Enter no cost, just a price which will discount the sale of the other items on the order/invoice. Create a new item using BoM or WO, to track trade-in, additional parts, labor and use the refurbishing warehouse code for trade-in component. The parts, labor, etc. become the 'cost' of the refurbished item.

I have to say that DSD's Service Center module handles the situation beautifully, with full traceability and minimal data entry. No workarounds!

We have a retail client that uses the PO method Doug Higgs suggests, although I can't recall if they link the vendor to the customer. They track the serial number. It was long ago when we set it up, but it keeps the audit trail of the serialized item clean (new vendor / new customer). Client was a firearms dealer, and this method worked best for reporting on serial number histories.

We have a client that is using a DSD BOM enhancement that allows parent items to be a component items for serial items. Then when they process the repairs / refurb the cost assigned to the item when it was brought back into stock along with the repair items are all included in the final cost.

I would have to agree with @JaneScanlan . . . JobOps (or Sage Manufacturing).

Sorry, but it appears I asked a confusing question. ALL I want to do is to enter a credit memo (or an invoice with a negative) for an item to bring it back into inventory AND assign a cost value (not let Sage guess at it) I would used a catch all item number (e.g. 99999) that would be serialized so that I could keep track of the returned units by cost in the item valuation. I would then use BOM entry to refurb the unit. I would love for the client to look at Job Ops, but that would be akin to using an atomic warhead to stop Donald Trump. Just a bit of overkill at this point.

#AtomicWarheadsAgainstTrump

@JeffSchwenk that will teach you for asking simple questions... Lol

Ok so what about doing credit memo using the item as a lot and a script that uses a UDF (cost of item ) to put the cost you want into the cost field. Wouldn't that work?

Suppose.... Then I would have to do a IM transaction to pull the item out of inventory at whatever cost Sage assigned and put it back in at the cost I wanted to use???? I know 20 years ago when I was an actual user, this was a PITA but that was before I had 90+ minds to bounce this off of. Sounds like there ISN'T a way to assign a cost via CM creation.

Well, now that you put it that way - if you use RMA to create the CM, and you have Cost Override checked in RMA options, you can assign a cost to the item and that is the cost that it will go into inventory at.

RMA was going to be my suggestion as well.

Hmmm. I may have to become acquainted with RMA in the near future... Does anyone have the training manual from 2003? I doubt the module features have changed much since then........ So just to EXPAND on this question a bit, how does one handle this on the original invoice where a trade in (allowance) is part of the sale? New Machine Sale - XXXXX trade in allowance - (yyyy) net invoice - (zzzzzz) I would like add the trade in unit back to inventory at that time as well AND assign a realizable cost value (not necessarily the trade allowance value at this time. Yes, I want it ALL!!! Thanks in advance.

And serve you up an Ice Cream Sundae Jeff?

Now you're just being greedy.

Here is the manual. I'm sure it is as good today as when it was published.

Wow, look at you @JaneCavanaugh!!

I know, I'm a hoarder. You should see my closet!