| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034 |
- &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:
- <none>
- Output Parameters:
- <none>
- 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: <none>
- ------------------------------------------------------------------------------*/
- 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: <none>
- ------------------------------------------------------------------------------*/
- /* 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: <none>
- 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: <none>
- 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: <none>
- 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: <none>
- 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: <none>
- 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: <none>
- 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
|