Can Microsoft RMS figure unit of measure for fabric

We have a similar situation selling chain, rope, tubing, etc. We buy it my the spool or bucket and sell it by the foot. Your initial purchase is for the whole bolt. I don't know what is on a bolt, but let's say it is 20 yards. You buy the bolt for $20 ($1/yd) and sell it for $2/yd. If you were to sell the whole bolt, it would go for $40. What I do is set up a parent/child relationship. The UPC for this item is 123456789012 and the reorder number from your supplier is 987654. So when you sell 3 yards of material, the sale would be $6 with a corresponding COGS for $3.

Order the bolt by the UPC and sell it by the reorder number. Your > For example- we need to be able to sell fabric by the fraction as well as by

You can sell fractional quantities of any item simply by entering "1.5" (for example) in the quantity field. I think there are some other issues with fabrics that you may have to work around, but I don't remember what they were... Something about the way cloth is measured and inventoried...

I have a similar problem. I do not see how the COGS gets taken into account on the child item unless you manually input the item cost on the child item when received.

After many months of using RMS I am still having trouble wrapping my head around how inventory values can be maintained on parent/child items. If I purchase items in cases, but sell in singles or cases, I create a parent/child relationship. When I receive the item, RMS assigns the case (parent) a value (item cost). However, when I break the case, the case is gone, and the child items have a quantity, but no value.

Simple example:

I purchase a case of cola (24 cans) for $6. My cost is recorded for the parent item (case) at $6 and I have a quantity of 1, so my inventory value is $6.

Now, I sell one can. The parent quantity is now 0 and the child quantity is

1. Howeverm the child cost is 23. Howeverm the child cost is $0, so my inventory is understated by 23 x $0.25 = $5.75., so my inventory is understated by 23 x 23. Howeverm the child cost is $0, so my inventory is understated by 23 x $0.25 = $5.75..25 = .75.

Do I have to manually input the cost of all child items, and manually update them every time I receive something? This can't be! I would have to hire a team of database admins with the number of items I have.

Jason

"TV hardware" wrote:

Ivan, would you care to elaborate?

I believe I have described my usage of RMS accurately, and my child items do not have item costs associated with them upon receiving or after a "break." Therefore, my inventory value is understated because broken cases (child items) are not counted in my inventory value.

"Ivan Brebner" wrote:

You need to assign the child costs manually. I'm not sure if that's what Ivan meant or not...

I think there may be an add-in that assists with this - if not, there should be. I just looked for this type of Add-in but didn't find one - it still sticks in my mind that I saw something like this though...

Wow. That baffles me.

This completely defeats the purpose of an automated inventory control program that offers parent child relationships! The child elements should be updated the same way kit costs are automatically calculated.

in other words, every time I receive a PO, I need to figure out which items might have children, and then manually calculate the new child cost and enter it one by one. That is severely disappointing.

i can't imagine I am the only one with this complaint. It seems like this would be a common problem, no?

Jas> You need to assign the child costs manually. I'm not sure if that's what

You try writing an SQL Trigger to this for you.

Rob

I am a business owner, not a programmer.

When I purchase a software package, I expect it to do what it says.

a) handle parent/child relationships b) track inventory value [accurately]

RMS does not live up to its literature promises.

That being said, is there anyone out there that would like to offer thier expertise. How fast, and how much, please...

Jason

"Rob" wrote:

Jason, I recommend starting with the partner you purchased RMS through. Things will be much simpler if you have a single point of contact for support. Most RMS Add-in vendors sell their products through a partner channel anyway.

That being said, I just put this on my list of projects - no promises about when it gets to the top though...