on 11-14-2007 9:03 AM
Dear All,
I am having problem to create approval procedure query. Is it possible to do that? If user want to add the delivery note based on sales order, system will refuse if there is no approval. the standard in SAP B1 can't be used by us. The condition is approval signature.
There must be a certain field that set yes or no in the sales order or delivery note, I still do not know. Please give advice which one is better and is there another option.
Could FMS in SAP B1 create automatic save draft ? if yes, could you please let me know the query for that ? I mean when document like purchase order blocked because is purchase qty exceeding sales order or forecast qty, by using FMS, the system with directly add the document to draft folder, without manually save. I also skip theusing of SAP B1 standard.
Thanks in advance.
Rgd
Steve
Hello,
I think it is very difficult to have your requirement defined in SAp B1 perfectly. You could use approval procedure but the problem is that when you approved it and then add it, the draft document is still sent to user that requested the approval, so, there will be 2 subject i.e. info document generation approve and approved of the document. let me know if the problem still persists.
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Steve,
Could you explain what this Approval of Sales Order means? Is it some kind of Credit Approval you are trying to check.
The reason I am asking this is If you have an Order Not Approved (Sales Order > Logistics tab), The user can not perform any delivery operation for this Order. This will do the Job.
Unless you are trying to check something else?
Please let me know
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Steve,
in your first question you have mentioned a field approval signature set to yes or no. Do you mean to define a UDF with two possible values yes and no in the sales documents? And do you mean to make the approval procedure dependent of this fields, e.g. only if it is set to no? If so, it is possible to specify a query in the conditions to start the approval procedure. In this query you could return true (SELECT DISTINCT 'true' FROM ...) in the case your UDF is equal to yes resp. no to start the approval query.
Maybe I got you wrong?!
To your second question: There is no way to do things like this with a formatted search. One reason is that SQL queries from within SAP are only allowed to read (SELECT ... FROM ... WHERE ...) data from the database and not to write into it. The only way to do this you asked for is to program it using the UI and DI.
Why do you want to generate the draft automatically? Is it because you users forget to do it manual? In this case you could write a FMS query which writes some kind of warning message to save a draft in a UDF under certain conditions to be evaluated in the query.
Regards,
Frank Romeni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Frank,
I am interested to this topic. Although
I have tried to use this query :
Select distinct 'true' from ODLN where $[odln.u_allowCL] ='yes' for browse or Select distinct 'true' from ODLN where $[odln.u_allowCL] =" for browse but I still can add the delivery. I agree with you about SBO query can't perform the task like save draft automatically but your answer could lead us confusing too, that's why I need you to share about this topic. I am also still confusing about select 'distinct' for approval process. I usually use mandatory option in UDF.
Rgds,
User | Count |
---|---|
95 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.