&ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1 &ANALYZE-RESUME &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME D-Dialog &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS D-Dialog /*------------------------------------------------------------------------ File: Description: from cntnrdlg.w - ADM SmartDialog Template Input Parameters: Output Parameters: Author: Created: ------------------------------------------------------------------------*/ /* This .W file was created with the Progress UIB. */ /*----------------------------------------------------------------------*/ /* Create an unnamed pool to store all the widgets created by this procedure. This is a good default which assures that this procedure's triggers and internal procedures will execute in this procedure's storage, and that proper cleanup will occur on deletion of the procedure. */ CREATE WIDGET-POOL. /* *************************** Definitions ************************** */ /* Parameters Definitions --- */ /* Local Variable Definitions --- */ DEF SHARED VAR VBuchen AS DEC EXTENT 10. DEF SHARED VAR VAnsatz AS DEC EXTENT 10. DEF VAR VFaknr AS INT NO-UNDO. DEF VAR VBuchtxt1 AS CHAR NO-UNDO. DEF VAR VBuchtxt2 AS CHAR NO-UNDO. DEF VAR VWpfl AS DEC EXTENT 12 NO-UNDO. DEF VAR VWust AS DEC EXTENT 12 NO-UNDO. DEF VAR VWW AS DEC NO-UNDO. DEF VAR VFakBetr AS DEC NO-UNDO. DEF VAR VKto_De AS CHAR NO-UNDO. DEF VAR VKto_Ar AS CHAR NO-UNDO. DEF VAR VKto_Wu AS CHAR NO-UNDO. DEF VAR VTrNr1 AS INT NO-UNDO. DEF VAR VTrNr2 AS INT NO-UNDO. DEF VAR ok AS LOG NO-UNDO. DEF VAR cMwstCB AS CHAR NO-UNDO. DEF WORKFILE WFile FIELD Kto1 AS CHAR FORMAT "x(12)" FIELD Kto2 AS CHAR FORMAT "x(12)" FIELD Betrag AS DEC FIELD MWST_Cd AS INT. DEF BUFFER BBonusAbr FOR BonusAbr. DEF BUFFER BSteuer FOR Steuer. DEF TEMP-TABLE tAnsatz NO-UNDO FIELD Ansatz AS DEC FIELD MWST_Cd AS INT FIELD Betrag AS DEC. /* ---------- Globale Variablen ---------------------------------- */ { v8/globvar.i " " " " "SHARED" } { v8/debivar.i " " " " "SHARED" } { v8/artivar.i " " " " "SHARED" } { v8/contvar.i " " " " "SHARED" } /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK /* ******************** Preprocessor Definitions ******************** */ &Scoped-define PROCEDURE-TYPE SmartDialog &Scoped-define DB-AWARE no &Scoped-define ADM-CONTAINER DIALOG-BOX /* Name of designated FRAME-NAME and/or first browse and/or first query */ &Scoped-define FRAME-NAME D-Dialog /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS RECT-1 CB_MWST_1 F_Betrag_1 F_MWST_1 ~ CB_MWST_2 F_Betrag_2 F_MWST_2 CB_MWST_3 F_Betrag_3 F_MWST_3 CB_MWST_4 ~ F_Betrag_4 F_MWST_4 Btn_OK Btn_Cancel F_Betrag_5 F_Datum F_FibuKonto &Scoped-Define DISPLAYED-OBJECTS CB_MWST_1 F_Betrag_1 F_MWST_1 CB_MWST_2 ~ F_Betrag_2 F_MWST_2 CB_MWST_3 F_Betrag_3 F_MWST_3 CB_MWST_4 F_Betrag_4 ~ F_MWST_4 F_Betrag_5 F_Datum F_FibuKonto /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-1 F_Betrag_1 F_MWST_1 F_Betrag_2 F_MWST_2 F_Betrag_3 ~ F_MWST_3 F_Betrag_4 F_MWST_4 F_Betrag_5 F_Datum F_FibuKonto /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define a dialog box */ /* Definitions of the field level widgets */ DEFINE BUTTON Btn_Cancel AUTO-END-KEY LABEL "&Abbrechen" SIZE 18.2 BY 1.24 BGCOLOR 8 . DEFINE BUTTON Btn_OK AUTO-GO LABEL "OK" SIZE 18.2 BY 1.24 BGCOLOR 8 . DEFINE VARIABLE CB_MWST_1 AS CHARACTER FORMAT "X(256)":U VIEW-AS COMBO-BOX INNER-LINES 5 LIST-ITEM-PAIRS "Item1","Item1" DROP-DOWN-LIST SIZE 35 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE CB_MWST_2 AS CHARACTER FORMAT "X(256)":U VIEW-AS COMBO-BOX INNER-LINES 5 LIST-ITEM-PAIRS "Item1","Item1" DROP-DOWN-LIST SIZE 35 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE CB_MWST_3 AS CHARACTER FORMAT "X(256)":U VIEW-AS COMBO-BOX INNER-LINES 5 LIST-ITEM-PAIRS "Item1","Item1" DROP-DOWN-LIST SIZE 35 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE CB_MWST_4 AS CHARACTER FORMAT "X(256)":U VIEW-AS COMBO-BOX INNER-LINES 5 LIST-ITEM-PAIRS "Item1","Item1" DROP-DOWN-LIST SIZE 35 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Betrag_1 AS DECIMAL FORMAT "z,zzz,zz9.99-":U INITIAL 0 VIEW-AS FILL-IN NATIVE SIZE 21 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Betrag_2 AS DECIMAL FORMAT "z,zzz,zz9.99-":U INITIAL 0 VIEW-AS FILL-IN NATIVE SIZE 21 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Betrag_3 AS DECIMAL FORMAT "z,zzz,zz9.99-":U INITIAL 0 VIEW-AS FILL-IN NATIVE SIZE 21 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Betrag_4 AS DECIMAL FORMAT "z,zzz,zz9.99-":U INITIAL 0 VIEW-AS FILL-IN NATIVE SIZE 21 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Betrag_5 AS DECIMAL FORMAT "z,zzz,zz9.99-":U INITIAL 0 VIEW-AS FILL-IN NATIVE SIZE 20 BY 1 BGCOLOR 15 FGCOLOR 12 NO-UNDO. DEFINE VARIABLE F_Datum AS DATE FORMAT "99.99.9999":U LABEL "Rechnungsdatum" VIEW-AS FILL-IN NATIVE SIZE 20 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_FibuKonto AS CHARACTER FORMAT "x(12)":U LABEL "FibuKonto (ER)" VIEW-AS FILL-IN NATIVE SIZE 20 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_MWST_1 AS DECIMAL FORMAT "zz,zz9.99-":U INITIAL 0 VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_MWST_2 AS DECIMAL FORMAT "zz,zz9.99-":U INITIAL 0 VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_MWST_3 AS DECIMAL FORMAT "zz,zz9.99-":U INITIAL 0 VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_MWST_4 AS DECIMAL FORMAT "zz,zz9.99-":U INITIAL 0 VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-1 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 122 BY 10. /* ************************ Frame Definitions *********************** */ DEFINE FRAME D-Dialog CB_MWST_1 AT ROW 2.52 COL 6 COLON-ALIGNED NO-LABEL F_Betrag_1 AT ROW 2.52 COL 68 COLON-ALIGNED NO-LABEL F_MWST_1 AT ROW 2.52 COL 103 COLON-ALIGNED NO-LABEL CB_MWST_2 AT ROW 3.52 COL 6 COLON-ALIGNED NO-LABEL F_Betrag_2 AT ROW 3.52 COL 68 COLON-ALIGNED NO-LABEL F_MWST_2 AT ROW 3.52 COL 103 COLON-ALIGNED NO-LABEL CB_MWST_3 AT ROW 4.52 COL 6 COLON-ALIGNED NO-LABEL F_Betrag_3 AT ROW 4.52 COL 68 COLON-ALIGNED NO-LABEL F_MWST_3 AT ROW 4.52 COL 103 COLON-ALIGNED NO-LABEL CB_MWST_4 AT ROW 5.52 COL 6 COLON-ALIGNED NO-LABEL F_Betrag_4 AT ROW 5.52 COL 68 COLON-ALIGNED NO-LABEL F_MWST_4 AT ROW 5.52 COL 103 COLON-ALIGNED NO-LABEL Btn_OK AT ROW 7.52 COL 9.4 Btn_Cancel AT ROW 7.52 COL 29 F_Betrag_5 AT ROW 7.52 COL 99 COLON-ALIGNED NO-LABEL F_Datum AT ROW 8.52 COL 99 COLON-ALIGNED F_FibuKonto AT ROW 9.52 COL 99 COLON-ALIGNED RECT-1 AT ROW 1.24 COL 2 SPACE(0.99) SKIP(0.37) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "OP-Gutschrift Buchen" CANCEL-BUTTON Btn_Cancel. /* *********************** Procedure Settings ************************ */ &ANALYZE-SUSPEND _PROCEDURE-SETTINGS /* Settings for THIS-PROCEDURE Type: SmartDialog Allow: Basic,Browse,DB-Fields,Query,Smart Other Settings: COMPILE */ &ANALYZE-RESUME _END-PROCEDURE-SETTINGS &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB D-Dialog /* ************************* Included-Libraries *********************** */ {src/adm/method/containr.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********** Runtime Attributes and AppBuilder Settings *********** */ &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES /* SETTINGS FOR DIALOG-BOX D-Dialog FRAME-NAME L-To-R */ ASSIGN FRAME D-Dialog:SCROLLABLE = FALSE FRAME D-Dialog:HIDDEN = TRUE. /* SETTINGS FOR FILL-IN F_Betrag_1 IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_Betrag_2 IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_Betrag_3 IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_Betrag_4 IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_Betrag_5 IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_Datum IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_FibuKonto IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_MWST_1 IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_MWST_2 IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_MWST_3 IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_MWST_4 IN FRAME D-Dialog 1 */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX D-Dialog /* Query rebuild information for DIALOG-BOX D-Dialog _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX D-Dialog */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME D-Dialog &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL D-Dialog D-Dialog ON WINDOW-CLOSE OF FRAME D-Dialog /* OP-Gutschrift Buchen */ DO: /* Add Trigger to equate WINDOW-CLOSE to END-ERROR. */ APPLY "END-ERROR":U TO SELF. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_OK &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK D-Dialog ON CHOOSE OF Btn_OK IN FRAME D-Dialog /* OK */ DO: DO WITH FRAME {&FRAME-NAME}: ASSIGN {&List-1}. IF F_Betrag_1 = 0 AND F_Betrag_2 = 0 AND F_Betrag_3 = 0 AND F_Betrag_4 = 0 THEN RETURN NO-APPLY. IF F_Datum = ? THEN F_Datum = TODAY. END. DISABLE Btn_OK WITH FRAME {&FRAME-NAME}. DISABLE Btn_Cancel WITH FRAME {&FRAME-NAME}. RUN OP_BUCHEN. ENABLE Btn_OK WITH FRAME {&FRAME-NAME}. ENABLE Btn_Cancel WITH FRAME {&FRAME-NAME}. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB_MWST_1 &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_MWST_1 D-Dialog ON VALUE-CHANGED OF CB_MWST_1 IN FRAME D-Dialog DO: i1 = INTEGER(SELF:SCREEN-VALUE). FIND FIRST tAnsatz WHERE tAnsatz.MWSt_Cd = i1 AND tAnsatz.Ansatz = VAnsatz[01] NO-ERROR. IF NOT AVAILABLE tAnsatz THEN DO: FIND FIRST tAnsatz WHERE tAnsatz.Ansatz = VAnsatz[01] NO-ERROR. END. IF AVAILABLE tAnsatz THEN SELF:SCREEN-VALUE = STRING(tAnsatz.Mwst_Cd,'99'). ELSE RETURN. VAnsatz[01] = tAnsatz.Ansatz. RUN RECHNEN. DISPLAY {&List-1} WITH FRAME {&FRAME-NAME}. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB_MWST_2 &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_MWST_2 D-Dialog ON VALUE-CHANGED OF CB_MWST_2 IN FRAME D-Dialog DO: i1 = INTEGER(SELF:SCREEN-VALUE). FIND FIRST tAnsatz WHERE tAnsatz.MWSt_Cd = i1 AND tAnsatz.Ansatz = VAnsatz[02] NO-ERROR. IF NOT AVAILABLE tAnsatz THEN DO: FIND FIRST tAnsatz WHERE tAnsatz.Ansatz = VAnsatz[02] NO-ERROR. END. IF AVAILABLE tAnsatz THEN SELF:SCREEN-VALUE = STRING(tAnsatz.Mwst_Cd,'99'). ELSE RETURN. VAnsatz[02] = tAnsatz.Ansatz. RUN RECHNEN. DISPLAY {&List-1} WITH FRAME {&FRAME-NAME}. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB_MWST_3 &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_MWST_3 D-Dialog ON VALUE-CHANGED OF CB_MWST_3 IN FRAME D-Dialog DO: i1 = INTEGER(SELF:SCREEN-VALUE). FIND FIRST tAnsatz WHERE tAnsatz.MWSt_Cd = i1 AND tAnsatz.Ansatz = VAnsatz[03] NO-ERROR. IF NOT AVAILABLE tAnsatz THEN DO: FIND FIRST tAnsatz WHERE tAnsatz.Ansatz = VAnsatz[03] NO-ERROR. END. IF AVAILABLE tAnsatz THEN SELF:SCREEN-VALUE = STRING(tAnsatz.Mwst_Cd,'99'). ELSE RETURN. VAnsatz[03] = tAnsatz.Ansatz. RUN RECHNEN. DISPLAY {&List-1} WITH FRAME {&FRAME-NAME}. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB_MWST_4 &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_MWST_4 D-Dialog ON VALUE-CHANGED OF CB_MWST_4 IN FRAME D-Dialog DO: i1 = INTEGER(SELF:SCREEN-VALUE). FIND FIRST tAnsatz WHERE tAnsatz.MWSt_Cd = i1 AND tAnsatz.Ansatz = VAnsatz[04] NO-ERROR. IF NOT AVAILABLE tAnsatz THEN DO: FIND FIRST tAnsatz WHERE tAnsatz.Ansatz = VAnsatz[04] NO-ERROR. END. IF AVAILABLE tAnsatz THEN SELF:SCREEN-VALUE = STRING(tAnsatz.Mwst_Cd,'99'). ELSE RETURN. VAnsatz[04] = tAnsatz.Ansatz. RUN RECHNEN. DISPLAY {&List-1} WITH FRAME {&FRAME-NAME}. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Betrag_5 &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Betrag_5 D-Dialog ON ENTRY OF F_Betrag_5 IN FRAME D-Dialog DO: APPLY 'TAB' TO SELF. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK D-Dialog /* *************************** Main Block *************************** */ DEF VAR abDatum AS DATE FORMAT "99.99.9999" NO-UNDO. DEF VAR MwstDat AS DATE FORMAT "99.99.9999" NO-UNDO. FIND BSteuer USE-INDEX Steuer-k1 WHERE BSteuer.Firma = GVFirma NO-LOCK NO-ERROR. DO WITH FRAME {&FRAME-NAME}: CB_MWST_1:DELIMITER = ";". CB_MWST_2:DELIMITER = ";". CB_MWST_3:DELIMITER = ";". CB_MWST_4:DELIMITER = ";". cMwstCB = ''. abDatum = DATE(01,01,YEAR(TODAY) - 1). FOR EACH Wust NO-LOCK USE-INDEX Wust-k2 WHERE Wust.WuCd < 12 AND Wust.Incl = FALSE: FIND LAST MWSTAns NO-LOCK WHERE MWSTAns.Mwst_Cd = Wust.WuCd AND MWSTAns.Datum <= TODAY NO-ERROR. IF NOT AVAILABLE MWSTAns THEN NEXT. MwstDat = MWSTAns.Datum. cMwstCB = cMwstCB + (IF cMwstCB = '' THEN '' ELSE ';') + MWSTAns.Bez + ';' + STRING(MWSTAns.Mwst_Cd,'99'). CREATE tAnsatz. ASSIGN tAnsatz.Ansatz = MWSTAns.Ansatz tAnsatz.MWST_Cd = MWSTAns.MWSt_Cd. FIND LAST MWSTAns NO-LOCK WHERE MWSTAns.Mwst_Cd = Wust.WuCd AND MWSTAns.Datum < MwstDat NO-ERROR. IF NOT AVAILABLE MWSTAns THEN NEXT. IF MWSTAns.Datum < abDatum THEN NEXT. cMwstCB = cMwstCB + (IF cMwstCB = '' THEN '' ELSE ';') + MWSTAns.Bez + ';' + STRING(MWSTAns.Mwst_Cd,'99'). CREATE tAnsatz. ASSIGN tAnsatz.Ansatz = MWSTAns.Ansatz tAnsatz.MWST_Cd = MWSTAns.MWSt_Cd. END. ASSIGN CB_MWST_1:LIST-ITEM-PAIRS = cMwstCB CB_MWST_2:LIST-ITEM-PAIRS = cMwstCB CB_MWST_3:LIST-ITEM-PAIRS = cMwstCB CB_MWST_4:LIST-ITEM-PAIRS = cMwstCB. DISPLAY {&List-1}. END. {src/adm/template/dialogmn.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects D-Dialog _ADM-CREATE-OBJECTS PROCEDURE adm-create-objects : /*------------------------------------------------------------------------------ Purpose: Create handles for all SmartObjects used in this procedure. After SmartObjects are initialized, then SmartLinks are added. Parameters: ------------------------------------------------------------------------------*/ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-row-available D-Dialog _ADM-ROW-AVAILABLE PROCEDURE adm-row-available : /*------------------------------------------------------------------------------ Purpose: Dispatched to this procedure when the Record- Source has a new row available. This procedure tries to get the new row (or foriegn keys) from the Record-Source and process it. Parameters: ------------------------------------------------------------------------------*/ /* Define variables needed by this internal procedure. */ {src/adm/template/row-head.i} /* Process the newly available records (i.e. display fields, open queries, and/or pass records on to any RECORD-TARGETS). */ {src/adm/template/row-end.i} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI D-Dialog _DEFAULT-DISABLE PROCEDURE disable_UI : /*------------------------------------------------------------------------------ Purpose: DISABLE the User Interface Parameters: Notes: Here we clean-up the user-interface by deleting dynamic widgets we have created and/or hide frames. This procedure is usually called when we are ready to "clean-up" after running. ------------------------------------------------------------------------------*/ /* Hide all frames. */ HIDE FRAME D-Dialog. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI D-Dialog _DEFAULT-ENABLE PROCEDURE enable_UI : /*------------------------------------------------------------------------------ Purpose: ENABLE the User Interface Parameters: Notes: Here we display/view/enable the widgets in the user-interface. In addition, OPEN all queries associated with each FRAME and BROWSE. These statements here are based on the "Other Settings" section of the widget Property Sheets. ------------------------------------------------------------------------------*/ DISPLAY CB_MWST_1 F_Betrag_1 F_MWST_1 CB_MWST_2 F_Betrag_2 F_MWST_2 CB_MWST_3 F_Betrag_3 F_MWST_3 CB_MWST_4 F_Betrag_4 F_MWST_4 F_Betrag_5 F_Datum F_FibuKonto WITH FRAME D-Dialog. ENABLE RECT-1 CB_MWST_1 F_Betrag_1 F_MWST_1 CB_MWST_2 F_Betrag_2 F_MWST_2 CB_MWST_3 F_Betrag_3 F_MWST_3 CB_MWST_4 F_Betrag_4 F_MWST_4 Btn_OK Btn_Cancel F_Betrag_5 F_Datum F_FibuKonto WITH FRAME D-Dialog. VIEW FRAME D-Dialog. {&OPEN-BROWSERS-IN-QUERY-D-Dialog} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE INTERFACE D-Dialog PROCEDURE INTERFACE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ FOR EACH WFile WHERE WFile.Betrag <> 0 BY WFile.Kto1: FIND LAST Interf USE-INDEX Interf-k1 WHERE Interf.Firma = BSteuer.FBFirma AND Interf.TrNr1 = VTrNr1 AND Interf.TrNr2 = VTrNr2 NO-LOCK NO-ERROR. IF AVAILABLE Interf THEN ix = Interf.Trnr + 1. ELSE ix = 1. CREATE Interf. ASSIGN Interf.Firma = BSteuer.FBFirma Interf.TrNr1 = VTrNr1 Interf.TrNr2 = VTrNr2 Interf.TrNr = ix Interf.Kto1 = WFile.Kto1 Interf.Kto2 = WFile.Kto2 Interf.Herk = TransNr.Herk Interf.Datum = F_Datum Interf.Buchtxt1 = VBuchtxt1 Interf.Buchtxt2 = VBuchtxt2 Interf.Betrag = WFile.Betrag Interf.Betrag_Frw = WFile.Betrag Interf.FRW = Debop.FRW Interf.Faktor = Debop.Faktor Interf.Kurs = Debop.Kurs Interf.Verbucht = FALSE Interf.Faknr = STRING(Debop.Faknr,"9999999") Interf.Knr = Debop.Knr Interf.MWST_Nr = "" Interf.MWST_Cd = WFile.MWST_Cd Interf.HKFirma = Debop.Firma. DELETE WFile. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-view D-Dialog PROCEDURE local-view : /*------------------------------------------------------------------------------ Purpose: Override standard ADM method Notes: ------------------------------------------------------------------------------*/ RUN dispatch IN THIS-PROCEDURE ( INPUT 'view':U ) . {&WINDOW-NAME}:MOVE-TO-TOP(). DO WITH FRAME {&FRAME-NAME}: F_Betrag_1 = VBuchen[01]. F_Betrag_2 = VBuchen[02]. F_Betrag_3 = VBuchen[03]. F_Betrag_4 = VBuchen[04]. F_Datum = TODAY. RUN RECHNEN. DO ix = 1 TO 4 WITH FRAME {&FRAME-NAME}: IF VBuchen[ix] = 0 THEN LEAVE. FIND FIRST tAnsatz WHERE tAnsatz.Ansatz = VAnsatz[ix] NO-ERROR. IF NOT AVAILABLE tAnsatz THEN NEXT. CASE ix: WHEN 1 THEN CB_MWST_1:SCREEN-VALUE = STRING(tAnsatz.MWSt_Cd,'99'). WHEN 2 THEN CB_MWST_2:SCREEN-VALUE = STRING(tAnsatz.MWSt_Cd,'99'). WHEN 3 THEN CB_MWST_3:SCREEN-VALUE = STRING(tAnsatz.MWSt_Cd,'99'). WHEN 4 THEN CB_MWST_4:SCREEN-VALUE = STRING(tAnsatz.MWSt_Cd,'99'). END CASE. END. FIND SteuNr USE-INDEX SteuNr-k1 WHERE SteuNr.Firma = GVFirma NO-LOCK. F_FibuKonto = SteuNr.Konto_Ertrag. DEF VAR xKonto AS CHAR NO-UNDO. GET-KEY-VALUE SECTION 'Grundeinstellungen' KEY 'Bonuskonto' VALUE xKonto. IF xKonto <> ? AND xKonto <> '' THEN F_FibuKonto = xKonto. DISPLAY {&List-1}. IF VBuchen[01] = 0 THEN DISABLE CB_MWST_1 F_Betrag_1 F_MWST_1. IF VBuchen[02] = 0 THEN DISABLE CB_MWST_2 F_Betrag_2 F_MWST_2. IF VBuchen[03] = 0 THEN DISABLE CB_MWST_3 F_Betrag_3 F_MWST_3. IF VBuchen[04] = 0 THEN DISABLE CB_MWST_4 F_Betrag_4 F_MWST_4. END. {&WINDOW-NAME}:MOVE-TO-BOTTOM(). END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE OP_BUCHEN D-Dialog PROCEDURE OP_BUCHEN : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ VWpfl = 0. VWust = 0. VWW = 0. Rundbetr = 0. FOR EACH WFile: DELETE WFile. END. FIND BonusAbr WHERE RECID(BonusAbr) = LVRecid NO-LOCK. FIND Steuer USE-INDEX Steuer-k1 WHERE Steuer.Firma = GVFirma NO-LOCK. FIND SteuNr USE-INDEX SteuNr-k1 WHERE SteuNr.Firma = GVFirma NO-LOCK. VKto_De = SteuNr.Konto_Debit. VKto_Ar = F_FibuKonto. IF VKto_Ar = '' THEN VKto_Ar = SteuNr.Konto_Ertrag. PUT-KEY-VALUE SECTION 'Grundeinstellungen' KEY 'Bonuskonto' VALUE VKto_Ar. DO WITH FRAME {&FRAME-NAME}: IF F_Betrag_1 <> 0 THEN DO: i1 = INTEGER(SUBSTRING(CB_MWST_1:SCREEN-VALUE,01,02)). VWpfl[i1] = VWpfl[i1] + F_Betrag_1. VWust[i1] = VWust[i1] + F_MWST_1. END. IF F_Betrag_2 <> 0 THEN DO: i1 = INTEGER(SUBSTRING(CB_MWST_2:SCREEN-VALUE,01,02)). VWpfl[i1] = VWpfl[i1] + F_Betrag_2. VWust[i1] = VWust[i1] + F_MWST_2. END. IF F_Betrag_3 <> 0 THEN DO: i1 = INTEGER(SUBSTRING(CB_MWST_3:SCREEN-VALUE,01,02)). VWpfl[i1] = VWpfl[i1] + F_Betrag_3. VWust[i1] = VWust[i1] + F_MWST_3. END. IF F_Betrag_4 <> 0 THEN DO: i1 = INTEGER(SUBSTRING(CB_MWST_4:SCREEN-VALUE,01,02)). VWpfl[i1] = VWpfl[i1] + F_Betrag_4. VWust[i1] = VWust[i1] + F_MWST_4. END. END. DO ix = 1 TO 12: VWpfl[ix] = - VWpfl[ix]. VWust[ix] = - VWust[ix]. VWW = VWW + VWpfl[ix]. Rundbetr = Rundbetr + VWpfl[ix] + VWust[ix]. END. Rundcode = 1. RUN "v8/runden.p". VFakbetr = Rundbetr. REPEAT TRANSACTION ON ERROR UNDO, LEAVE: RUN "v8/steunr.p" ( INPUT 2, OUTPUT VFaknr ). IF RETURN-VALUE <> '' THEN RETURN. FIND Adresse USE-INDEX Adresse-k1 WHERE Adresse.Firma = AdFirma AND Adresse.Knr = LVKnr NO-LOCK NO-ERROR. FIND Debst USE-INDEX Debst-k1 WHERE Debst.Firma = GVFirma AND Debst.Knr = LVKnr. VBuchtxt1 = 'Bonusgutschrift:' + STRING(VFaknr," 999999"). VBuchtxt2 = Adresse.Anzeig_Br. FIND Kondi USE-INDEX Kondi-k1 WHERE Kondi.Sprcd = GVSprcd AND Kondi.Kond = Debst.Kond NO-LOCK NO-ERROR. IF NOT AVAILABLE Kondi THEN DO: FIND Kondi USE-INDEX Kondi-k1 WHERE Kondi.Sprcd = GVSprcd AND Kondi.Kond = 1 NO-LOCK NO-ERROR. END. FIND LAST TransNr USE-INDEX TransNr-k1 WHERE TransNr.Firma = StFirma NO-LOCK NO-ERROR. IF AVAILABLE TransNr THEN DO: VTrNr1 = TransNr.TrNr1 + 1. VTrNr2 = 1. END. ELSE DO: VTrNr1 = 1. VTrNr2 = 1. END. CREATE TransNr. ASSIGN TransNr.Firma = StFirma TransNr.TrNr1 = VTrNr1 TransNr.TrNr2 = VTrNr2 TransNr.Herk = 51. CREATE Debop. ASSIGN Debop.Firma = GVFirma Debop.Knr = LVKnr Debop.Faknr = VFaknr Debop.Fakdat = F_Datum Debop.Faellig = F_Datum + Kondi.Faellig Debop.Skber = 0 Debop.WW = VWW Debop.Fakbetr = VFakBetr Debop.Saldo = VFakBetr Debop.Kond = Debst.Kond Debop.Transp = 0 Debop.Porto = 0 Debop.Verpack = 0 Debop.Konto = VKto_De Debop.Vertr = Debst.Vertr Debop.Kte = 'BON' Debop.TrNr1 = VTrNr1 Debop.TrNr2 = VTrNr2 Debop.FRW = Steuer.Fwc03 Debop.Kurs = 1.0 Debop.Faktor = 1. IF Steuer.MWST = 0 THEN Debop.WustAbr = TRUE. /* vereinbahrt */ ELSE Debop.WustAbr = FALSE. /* vereinnahmt */ DO ix = 1 TO 12: FIND FIRST Wust USE-INDEX Wust-k2 WHERE Wust.WuCd = ix NO-LOCK NO-ERROR. ASSIGN Debop.FakWpfl[ix] = VWpfl[ix] Debop.FakWust[ix] = VWust[ix]. IF AVAILABLE Wust THEN DO: ASSIGN Debop.FakWPro[ix] = Wust.Proz Debop.FakIncl[ix] = Wust.Incl. END. END. CREATE Debfa. ASSIGN Debfa.Firma = Debop.Firma Debfa.Knr = Debop.Knr Debfa.Faknr = Debop.Faknr Debfa.Fakdat = Debop.Fakdat Debfa.Faellig = Debop.Faellig Debfa.Fakbetr = Debop.Fakbetr Debfa.Skber = Debop.Skber Debfa.WW = Debop.WW Debfa.Transp = Debop.Transp Debfa.Porto = Debop.Porto Debfa.Verpack = Debop.Verpack Debfa.Konto = Debop.Konto Debfa.Vertr = Debop.Vertr Debfa.Kte = Debop.Kte Debfa.TrNr1 = Debop.TrNr1 Debfa.TrNr2 = Debop.TrNr2 Debfa.FRW = Debop.FRW Debfa.Kurs = Debop.Kurs Debfa.Faktor = 1. DO ix = 1 TO 12: ASSIGN Debfa.FakWpfl[ix] = Debop.FakWpfl[ix] Debfa.FakWust[ix] = Debop.FakWust[ix]. END. FIND LAST Debhi USE-INDEX Debhi-k1 WHERE Debhi.Firma = Debop.Firma AND Debhi.Knr = Debop.Knr NO-LOCK NO-ERROR. IF AVAILABLE Debhi THEN ix = Debhi.Trnr + 1. ELSE ix = 1. CREATE Debhi. ASSIGN Debhi.Firma = Debop.Firma Debhi.Knr = Debop.Knr Debhi.Trnr = ix Debhi.Datum = Debop.Fakdat Debhi.Faknr = Debop.Faknr Debhi.Kte = Debop.Kte Debhi.Soll = Debop.Fakbetr Debhi.Transp = Debop.Transp Debhi.Porto = Debop.Porto Debhi.Verpack = Debop.Verpack Debhi.Konto = Debop.Konto Debhi.TrNr1 = Debop.TrNr1 Debhi.TrNr2 = Debop.TrNr2 Debhi.FRW = Debop.FRW Debhi.Kurs = 1.0 Debhi.Faktor = 1 Debhi.Saldo = Debst.Saldo + Debop.Fakbetr. IF Steuer.MWST = 0 THEN DO: /* Mehrwertsteuer vereinbart */ CREATE Debwu. ASSIGN Debwu.Firma = Debop.Firma Debwu.Knr = Debop.Knr Debwu.Faknr = Debop.Faknr Debwu.Trnr = 1 Debwu.Datum = Debop.Fakdat Debwu.Betrag = Debop.Fakbetr Debwu.Konto = Debop.Konto Debwu.Kte = Debop.Kte Debwu.TrNr1 = Debop.TrNr1 Debwu.TrNr2 = Debop.TrNr2 Debwu.FRW = Debop.FRW Debwu.Kurs = 1.0 Debwu.Faktor = 1. DO ix = 1 TO 12: IF Debop.FakWpfl[ix] = 0 THEN NEXT. ASSIGN Debwu.Wustpfl[ix] = Debop.FakWpfl[ix] Debwu.Wust [ix] = Debop.FakWust[ix]. END. END. /* ---- Interface fuer Mehrwertsteuer -------------------------------------- */ DO ix = 1 TO 10: IF VWpfl[ix] = 0 THEN NEXT. FIND FIRST Wust USE-INDEX Wust-k2 WHERE Wust.WuCd = ix NO-LOCK. IF Steuer.MWST = 0 THEN VKto_Wu = Wust.Konto. ELSE VKto_Wu = SteuNr.Konto_Wust_H. IF Wust.incl THEN DO: IF VKto_Ar <> VKto_Wu THEN DO: RundBetr = VWpfl[ix] / (100 + Wust.Proz) * Wust.Proz. Rundcode = 1. RUN "v8/runden.p". FIND FIRST WFile WHERE WFile.Kto1 = VKto_Ar AND WFile.Kto2 = VKto_Wu NO-ERROR. IF NOT AVAILABLE WFile THEN DO: CREATE WFile. ASSIGN WFile.Kto1 = VKto_Ar WFile.Kto2 = VKto_Wu WFile.MWST_Cd = 0. END. ASSIGN WFile.Betrag = WFile.Betrag + Rundbetr. END. END. ELSE DO: FIND FIRST WFile WHERE WFile.Kto1 = VKto_De AND WFile.Kto2 = VKto_Wu NO-ERROR. IF NOT AVAILABLE WFile THEN DO: CREATE WFile. ASSIGN WFile.Kto1 = VKto_De WFile.Kto2 = VKto_Wu WFile.MWST_Cd = 0. END. ASSIGN WFile.Betrag = WFile.Betrag + VWust[ix]. END. END. RUN INTERFACE. Debst.Saldo = Debst.Saldo + Debop.Fakbetr. LVDat = BonusAbr.VonDatum. FOR EACH BBonusAbr USE-INDEX BonusAbr-k1 WHERE BBonusAbr.Firma = GVFirma AND BBonusAbr.Bon_Sta = 0 AND BBonusAbr.Knr = LVKnr AND BBonusAbr.VonDatum = LVDat. BBonusAbr.Bon_Sta = 1. END. LEAVE. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE RECHNEN D-Dialog PROCEDURE RECHNEN : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ F_MWST_1 = F_Betrag_1 * VAnsatz[01] / 100. F_MWST_2 = F_Betrag_2 * VAnsatz[02] / 100. F_MWST_3 = F_Betrag_3 * VAnsatz[03] / 100. F_MWST_4 = F_Betrag_4 * VAnsatz[04] / 100. Rundbetr = F_Betrag_1 + F_Betrag_2 + F_Betrag_3 + F_Betrag_4 + F_MWST_1 + F_MWST_2 + F_MWST_3 + F_MWST_4. Rundcode = 1. RUN "v8/runden.p". F_Betrag_5 = Rundbetr. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE send-records D-Dialog _ADM-SEND-RECORDS PROCEDURE send-records : /*------------------------------------------------------------------------------ Purpose: Send record ROWID's for all tables used by this file. Parameters: see template/snd-head.i ------------------------------------------------------------------------------*/ /* SEND-RECORDS does nothing because there are no External Tables specified for this SmartDialog, and there are no tables specified in any contained Browse, Query, or Frame. */ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE state-changed D-Dialog PROCEDURE state-changed : /* ----------------------------------------------------------- Purpose: Parameters: Notes: -------------------------------------------------------------*/ DEFINE INPUT PARAMETER p-issuer-hdl AS HANDLE NO-UNDO. DEFINE INPUT PARAMETER p-state AS CHARACTER NO-UNDO. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME