RMA database needed (1 Viewer)

[mmitchell]

Hello all, just woundering if anyone knows of a RMA database that is in Access so that I can customize it rather then develope it from scratch.

Thanks.

 

[Moniker]

Assuming RMA means Return Merchandise Authorization which means an Inventory Control system, you're fishing for something pretty complex. I don't know what you'll turn up, but have you searched for "Inventory Control" or something similar in here or on the Net in general?

You'll also want to be a lot more specific with what you want. Saying, "I need a car" is great, but size, price range, options, new/used, etc. are all things even the shadiest car dealer would need to know. Saying "I need an RMA Database" is nice and all, but are you tracking just one product, many products, one product in many categories, etc.? Without any of the detail, no one will be able to help much beyond a very generalized answer.

 

[mmitchell]

Thanks for the reply, just simply need to track customers returning a steel casting, and why, then give them an RMA number and track notes about the transaction. Nothing too deep at this point. Basically used by just the QA manager.

 

[Moniker]

And what have you tried? Where are you stuck?

In a simple outline:

1) You sell a steel casting with ID# ABC123
2) For some reason, Joe Blow decides it's not what he wanted and wants to return it.
3) You look up ID# ABC123 on an RMA form. On that form is the original sale date, price, etc. and other pertinent info (CustomerID, for example).
4) On that same form, there is a drop-down of the usual reasons (didn't work, wasn't the right size, broken when it showed, etc. -- whatever reasons you expect), and there's also a Notes field for things that don't fit the usual reasons and for extra info.
5) Once this info is entered, you timestamp and datestamp the record you just entered on the RMA form.
6) When the product shows back up at the warehouse, you confirm the issue the customer described (broken, wrong size, whatever), and then you check a box that says "RMA Merchandise Received" or something.
7) A separate query looks for the "RMA Merchandise Received" checkbox at some given interval and so long as your QA Manager has signed off on it, a check is cut or another product is sent.

I know you were just seeing if this was already written, but without knowing at all what inventory program you have to begin with, I didn't know where to start, so I generalized it. The RMA part is maybe a day or two or work, at least given the detail you've provided.