Forum

How to Replace the Input on Basis and Open Other Object Form?

Samuel Harris	#1 Nov 16, 2011 04:54 PM
Active user Points:: 32 Joined:: Sep 16, 2011	I would like to prevent a manager to create duplicated Invoices for Customer Orders. To do that I want the new Invoice not to be created when Create Based On operation is performed for the Customer Order which to the other Invoice is already referenced. In that case I want the previously created Invoice to be opened. Please give and an advice how could I do that?
	Profile

Timofey Bugaevsky

Nov 17, 2011 08:29 AM

Guest

Points::
Joined::

You can use OnCreateAtServer(Cancel, StandardProcessing) procedure for that, here is an example:

Code

&AtServer
Procedure OnCreateAtServer(Cancel, StandardProcessing)
   
   If Not ValueIsFilled(Object.Ref) Then
      Query = New Query("SELECT
                        |   MyDocument.Ref
                        |FROM
                        |   Document.MyDocument AS MyDocument
                        |WHERE
                        |   MyDocument.UnderlyingDocument = &UnderlyingDocument");
      Query.SetParameter("UnderlyingDocument", Object.UnderlyingDocument);
      
      Result = Query.Execute();
      
      If Not Result.IsEmpty() Then
         ValueToFormAttribute(Result.Unload()[0].Ref.GetObject(), "Object");
         Return;
      EndIf;
   EndIf;

EndProcedure

Profile

Users browsing this topic (guests: 1, registered: 0, hidden: 0)