Manual Purchase Orders not adding Supplier to Items Supplier List.

My customer has created a manual po to receive items that were already purchased and being stocked on the shelves in their convenience store. She asked me if this would add the supplier to the item if it had not already been entered there.

I said I thought so. I was wrong.

Help me understand why the system does not add the supplier when a supplier and more importantly the reorder number and cost are update items on the "committed" po.

Sincerley Kent Smtih RMS rookie

Reply to
RMS Rookie
Loading thread data ...

Kent,

Cuz the program is stupid. I created a suggestion about 2 years ago and another when the suggestion box was trashed, should still be there. Go vote for it!!

Reply to
Jeff

Veeeeerrrrrrrriiiiii interesting..... I admire your direct answer and to reward your candor, I clicked 'YES' on the button that asked my if your response answered my question. My next question is:

How do I make good on my committment to my customer to get the po, ItemlookupCode, Supplier, Cost, Qty, Reorder Number, and any other data fields required for proper accounting in the SBA 2006 package that I just sold them?

I suppose the Cost, Qty data is updated. I now need to use the "Store Operations import utility" to get the Item to Supplierlist records updated correctly. I have attempted this in the past sometimes with success, other times not.

So the question resolves down to explicitly:

What fields should be contained in the CSV import data, (and what ordering) in order to properly link item, supplier, reorder number, (child qty or parent qty,........ I get confused) and other fundamental data to properly purchase and receive goods in the future?

This would be a wonderful opportunity for some tall, good looking, talented, and respected RMS guru to publish a QSRules program that shows how to do this task. Perhaps I could persuade Todd Berger, my soul Microsoft support Engineer to aid in our plight.

If Todd could send this message to the customization team, I will purchase diner for two at the Herford House Steak house here in Kanasas City should he choose to visit. One diner for Todd, one for me. :) I will also purchase a support incident for $50 to pay for any unintended aggravation I may have caused.

I do suspect that the parent Item is necessary to exist in the CSV before a child can declare it as a parent in the child record but this is just a guess:) The documentation that I have read is not complete on this matter. At any rate, I anybody has an idea on how I can keep the small credibility I have with my customer on this matter, expecially as I install the Small Business Accounting 2006 package that I have just sold them, I would be grateful. If we can post the receipe here, it would form a solution for others that may fail due to following my original assumption.

Sincerely (hopefully with enough humor along the way to avoid boredom:)

Jeff, I will try to find your original suggestion and add my vote.

Kent Smith aka RMS rookie Columbus Park, LLC Microsoft Retail Management Store Operations Certified, Medicated, MBA, BS/CS, Systems Engineer, Consultant, trustworthy, loyal, brave, Father, Husband, starving amateur humorist...

ps My customer will almost certainly read this message, so please be kind.

"Jeff" wrote:

Reply to
RMS Rookie

Kent,

First, you should probably take this and your other questions into the RMS reseller newsgroups.

Second, none of this info transfers to SBA or any accounting program, only GL dollar amounts transfer. If they are using SBA, you should download and install the RMS=>SBA connector located here;

formatting link
I've never used the Import tool as I found it too limiting. We usually use EMS' Data Import to have more control over what info is sent where. If you know a little about databases, take a look at it. $65 for business use.
formatting link
Another option is Retail Realm's product
formatting link
on the left side, download the product brochure. Never used it though, again on the reseller newsgroup, there are more discussions on it. Todd, also answers question there too, except you don't need to be as nice to him over there! ;-) (g,d & r from Todd). He a 'Softie, and as most 'Softies are thick skinned, so he can take it!

Reply to
Jeff

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.