Manual Purchase Orders not adding Supplier to Items Supplier List.

Posted by RMS Rookie on January 23, 2006, 9:20 am

Please log in for more thread options

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

Posted by Jeff on January 23, 2006, 3:08 pm

Please log in for more thread options

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!!

--
*
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

Posted by RMS Rookie on January 23, 2006, 3:58 pm

Please log in for more thread options

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:

> 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!!

> --

> *

> 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

Posted by Jeff on January 23, 2006, 5:11 pm

Please log in for more thread options

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; http://tinyurl.com/7b6sn

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.
http://tinyurl.com/c395e

Another option is Retail Realm's product http://tinyurl.com/bmnkh 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!
--
*
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:

> 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!!

> --

> *

> 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