Allow purchase orders to update supplier reorder numbers

I believe Digital Retail Solutions has an addon that can do this or you can create a SQL Trigger that will do the same.

Rob

I'll see what I can come up with this weekend. Unless someone already has something.

Rob

I have attached a text file of two Triggers, one to create the trigger and one to delete the trigger. I have done some preliminary testing on the triggers using RMS 1.3.0203 and they seem to work. Having said that, this trigger will automatically change the data in the SupplierList table. Any unforseen effects due to other addons or different version I can not control. I STRONGLY recommend testing this out before applying this to a live database. And as always make a backup of your database.

To apply the trigger copy and paste the create trigger into a new query in SO Administrator and press F5 Run. If successful you should receive this message: "Query executed successfully: -1 records(s) affected."

If you wish to remove the trigger run the Drop statement from the same file. In order to see the attached file you must use a NewsReader such as Outlook Express.

Rob

begin 666 Update_PurchaseOrderEntry_OrderNumber.txt M0U)%051%(%1224='15(@6W5T

Rob, The reorder number trigger works just perfectly. Good job. Making life much easier. I am going to go further now and look for a trigger or whatever that will change the price (or ask if you want to) - if the cost goes up, you should be prompted to change the price according to the profit margin you have set as you receive the and commit from the purchase order.

Otherwise, you must manually deal with items everytime a cost changes? Any experience or thoughts about this? Will go > Allow for updating of supplier part #?s (aka reorder #?s) when placing and

(Repeated from the first message) Rob, The reorder number trigger works just perfectly. Good job. Making life much easier. I am going to go further now and look for a trigger or whatever that will change the price (or ask if you want to) - if the cost goes up, you should be prompted to change the price according to the profit margin you have set as you receive the and commit from the purchase order.

Otherwise, you must manually deal with items everytime a cost changes? Any experience or thoughts about this? Will go into the knowledge base and look or partner site. But you guys seem to have a handle on the fields that need to change as incoming data changes. What do you think?

"Rob" wrote:

What I did for a client in the past is designate a field that they never used i.e. MSRP and placed the value of the Profit margin in there. i.e. .90 for 10% and used a trigger to update the Price. Then when ever the Cost field changed the trigger would be fired and take the new Cost and multiply it by the MSRP field and set that value to the Price. They assigned profit margin based on Dept/Cat so it was easy to update the MSRP field for a group of items using an SQL query.

Rob

Now that's what I'm talkin' about! You have got it exactly. What would it take to share this one also? I really feel like we should be giving something back to you...but I am not sure what we can do that have not already figured out.

If you have the time, it is not too difficult to get it to us, and we promise not to bug you with support, could you send it along to the community?

And anybody out there who might have something to share with Rob, lets see what he needs.

These two things will allow me to finally wrap up the "back office" part of training of one of my most important customers. Makes all of us look good. Maui is small island, but alot of "big" people show up here...you never know...might make you famous, Rob!

And if you can't get to it, no worries, we have limped al> What I did for a client in the past is designate a field that they never

Attached is the Cost update trigger. I changed the way it calculates the Price. i.e. ItemA's MSRP = $50.00 or 50% profit margin You change the cost to $10 it will change the price to $20 automatically. This trigger only works on Cost update.

Rob

begin 666 trigger_cost.txt M0U)%051%(%1224='15(@6W5T

Rob, I have not gotten a chance to thank you so much for this trigger - you have no idea how much time it saves and how much sense it makes. Well, obviously you do know what an integral part of ordering this is. I have posted one more thing that is needed and that is when ordering by the case (MPQ) or even doing the parent child thing (not sure why you have to go there to order a case of something) anyway, doesn't it make sense that on the PO you order a case for $48.00 and the pricing from supplier is case / 48.00 yet you sell by the each for $1.00 and it seems like you have to manually calculate these numbers?

Doing a bit more investigation on this one. Seems like the answer is out there somewhere. If you know I am wasting my time looking...let me know please.

In the meantime, thanks again for all of your knowledge and help.

Mahalo Aga> Attached is the Cost update trigger.

Rob can you repost the text file I cant find it. It looks like the message has expired.

Thanks, Joshua Wenger

"Rob" wrote:

It looks like I must have deleted that file. If Roxanne is still around maybe she can post it... If not I will try and just redo it.

Rob

begin 666 Update_PurchaseOrderEntry_OrderNumber.txt M0U)%051%(%1224='15(@6W5T