on 2020 Apr 02 3:32 PM
Good Afternoon Experts,
My SAP knowledge is growing thanks to this great forum however this one is beating me.
I want a button on the BP that runs an SQL Query and then automatically puts the results onto a PO for that business partner.
I believe it can be done, or i think it should be able to be done, by a macro :-! but i'm lost.
Grateful and thankful in advance for any help!
Request clarification before answering.
Hi Laurent,
Apologies, you've just confused me! (Not sure what classic scenario is).
I have a SQL query that returns a list of products based on stock levels, I then want to put the results of this query directly onto a PO automatically. I think it may be possible using a Macro with @Store and Transfer but I don't know how. I can then assign this to a Button on the BP
I will then review this on the PO and send to the supplier manually.
Regards,
Simon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Simon,
still do not understand your request.
Sending a PO to a supplier means a Requester ask to a vendor to provide him items: either those items are available (at supplier side) or not.
Stock you are talking about seem to be at Company level (the one making the purchase).
It seems you want to reinvent the MRP and the Stock Transfer...
I advise you to challenge your functional consultant.
Regards.
Laurent.
Hi Laurent,
Thanks for your reply.
It's a functional requirement - raising daily Purchase Orders automatically from SQL script results.
It would be against a supplier BP - to then raise the PO to them.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
what is your need: is it a technical one or a functional one?
Which kind of Business Partner are you talking about: Requester, Goods Recipient, Supplier...?
In which SRM transaction you would like to have this functionality?
Regards.
Laurent.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.