And retry to Update your Approval Template, sometimes it’s already solved by this workaround (it’s enough to set your draft status to closed for all pending/cancelled draft from Document Draft Report)īut, if it’s still shows an error, and not successful to update the template, move to the next step. Make sure you already update the Draft Status from Open to Closed to all documents shows from that query. Open menu “ Document Draft Report ”, find your document type (ex: Sales Order/ Purchase Request/ etc). OWDD Status: W for Pending, C for Canceled. TransType: you can modify a transtype based on your own preference Object Type, that query is created for purchase request document. ismaelhmg, si bien es buena educación agradecer, por favor evita responder a cada persona diciendo solamente gracias, o mensajes de agradecimiento relacionados.En vez de crear una respuesta agradeciendo, lo debes hacer es darle al botón que tiene debajo el mensaje que te han enviado. You must find all of PENDING or CANCELED Draft that can trigger your problem when updating a template.Ĭopy and paste this query: SELECT D.DocEntry, D.DocNum, B.Name, B.Remarks, D.DocStatus AS DraftStatus, D.CANCELED, A.DocDate, A.Status AS ApprovalStatus, ISNULL(A.Remarks,'-') AS 'REMARKS', A.UserSign, A.CreateDate, A.IsDraft FROM OWDD A INNER JOIN ODRF D ON A.DocEntry = D.DocEntry INNER JOIN OWTM B ON A.WtmCode=B.WtmCode INNER JOIN WTM3 C ON B.WtmCode=C.WtmCode WHERE A.ObjType='112' And A. Using Price Update Wizard on Price List.Create Approval Based on Credit Limit Condition I generally start out like this, always including the research line in the SQL below: Do not run this it will not work (just part of a CASE coming later) T0.TransType, CASE WHEN T0.TransType 13 THEN ‘AR Invoices’ WHEN T0.TransType 14 THEN ‘AR Credit Memo’ WHEN T0.Crystal Report Formula Default Value for NULL. We have tips for help you solve these problems. ismaelhmg, si bien es buena educación agradecer, por favor evita responder a cada persona diciendo solamente gracias, o mensajes de agradecimiento relacionados. TransId FROM OJDT T0 INNER JOIN JDT1 T1 ON T0. You know that you must finalize all pending documents on approval phase. Or Create SP Transaction Notification, you can paste this query into SQL Management Studio or HANA studio: -SQL VERSION- IF (transactiontype ‘A’ OR transactiontype ‘U’) AND objecttype ’30’ BEGIN IF EXISTS ( SELECT T0. It’s troublesome isn’t it? How to solve these errors? There are existing authorization processes based on the current template. But, sometimes you’ll get an error “ Cannot update stages. If you want to update your approval template on SAP Business One, either for add new originator, edit conditions, add/ modify/ delete stages, it’s an easy job to do by yourself.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |