myslide.es manual de programador controlssap

8/15/2019 Myslide.es Manual de Programador Controlssap

1/71

!"#$!%&'() +$,-./!$0

11,,""22,,%% 3344..$$,,##5566!!

!"##$%&

''(()) **++,,--..)) ''//))))//


2/71

"

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 023,4. 3. 5(26.2,3(7

8 9"#$!:2;;5>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> D

"%8 A.B,2,4,C2 3. *[email protected]( 3. D.E(4,(%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% F "%" 5)./4,C2 3. :2 ([email protected]( G/.76)( HIJ'*[email protected]%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% $ "%L 5)./4,C2 3. +(7 ([email protected](7 3.6/++. HIJ'M,2.7K %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% N

"%O

P6,+,Q/4,C2 3. :2 ([email protected]( 3. 2.E(4,( %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 8#

"%; R,S( 3. -/+,3/4,(2.7 3.B,2,3/7 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 88 "%F T-.26(7%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 8L

"%F%8 J+6/7U


3/71

L

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 D 1."&,B. :. &5.-, >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ?N

F%8

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> L8

$%8 A.B,2,4,C2 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ;8 $%" 5)./4,C2 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ;"

N ),$Q-.#$!&>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> LE

N%8

5)./4,C2 3. S/)`G.6)(7%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ;L

N%"

P6,+,Q/4,C2 3. S/)/G.6)(7 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ;;

R 1>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> LN

&%8 5)./4,C2 3. :2 GC3:+(%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ;& &%" 5)./4,C2 3. +(7 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> DD

8#%8 T76,+( N%N%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% FF 8#%" Z:.26.b 6/G/\( 3. +.6)/ _ 4(+() 3. +/7 S/26/++/7 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% F$ 8#%L R.V6(7 A,2`G,4(7 H5(26)(+ c A(?+.d5+,4eK%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% F$ 8#%O


4/71

O

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

88

99""##$$!!::22;;;;55


5/71

;

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 8>8 )$.$$.S25&5#!&

'/)/ 7.E:,) .+ S).7.26. G/2:/+b _ 3.7/))(++/) 4(2 5(26)(+7IJ' Z)/G.i()eb .7 S).4,7( 6.2.),276/+/3(j

• I,76.G/ *S.)/6,-( [,23(i7 l'UI.)-.) "##L

• IJ' W:7,2.77 *2. "##$ c IAm

• !,7:/+ I6:3,( "##; c %DTR Z)/G.i()e "%#

• IhM I.)-.) "###U"##;

J3,4,(2/+G.26. 7. 3.?.)` ,276/+/)j

•

M,?).)f/7 3. !"#$%& ()*+!$# HS/)/ S(3.) -,7:/+,Q/) ,2B()G.7K• M,?).)f/7 ,)-./*!)## "##N HS/)/ S(3.) 3,7.\/) B()G:+/),(7 4(2 -/),(7 4(26)(+.7K

• J33*2" Z)/G.i()e HS/)/ +/ ,26.E)/4,C2 3.+ S)(_.46( .2 IJ' W:7,2.77 *2.K

8>@ 1T#!:! :. #$,A,B!

M/ B()G/ 3. 6)/?/@/) 4(2 5(26)(+7IJ' 7.)` +/ 3. 4)./) GC3:+(7 3. 6)/?/@(% T76(7 GC3:+(7 7.)`2+,?).)f/7 H3++n7K 9:. S(3).G(7 /\/3,) .2 :2 S)(_.46( 4+,.26.% A. .76/ G/2.)/ 4(27.E:,).G(7).:6,+,Q/) .+ G,7G( 4C3,E( S/)/ -/),(7 4+,.26.7 4(2 +/7 G,7G/7 2.4.7,3/3.7%

M(7 GC3:+(7 4(276/)`2 3.j

• *[email protected](7 9:. 7. 3.?.2 4)./) .2 +/ ?/7. 3. 3/6(7 H6/?+/7b -,76/7b 4/GS(7b?a79:.3/7 B()G/6./3/7b .64%K

• *S4,(2.7 3. G.2a

• M,76/ 3. '/)`G.6)(7

• J:6(),Q/4,(2.7 S/)/ +(7 B()G:+/),(7

• D:G.)( 3. -.)7,C2 3. 3/6(7


6/71

F

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

@@ 33AA B B..##!!&& ::.. ""..CC!!;;55!! J26.7 3. 4)./) 4:/+9:,.) S/26/++/ 2.4.7,6/)f/G(7 7/?.) 9:. ([email protected](7 3. 2.E(4,( -/ / ,24+:,)2:.76)/ /S+,4/4,C2 _ 9:. ).+/4,C2 -/2 / 6.2.) .26). .++(7% T76/ .7 +/ G.@() G/2.)/ 3. .24/S7:+/)2:.76)( 4C3,E( _ S(3.)+( ).:6,+,Q/) G/7 /3.+/26. .2 3,B.).26.7 S)(_.46(7b E)/4,/7 / 9:. 6(3(2:.76)( 4C3,E( 7. ?/7/)` .2 ([email protected](7%

5(2 .76( 4(27.E:,).G(7 3.B,2,) .2 4/3/ GC3:+( :2/ S.9:.\/ ,%$% 01$)!2%3) HA1K 9:. 7. S(3)`,26.)4/G?,/) .26). 3,B.).26.7 4%!$1)!#%

@>8 F.U5"5;5


7/71

$

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 @>@ $.,;5J%5-5", .% !AB.#! :. %, A,&. :. :,#!&>1!:5U5;, %!& :,#!& :.% !AB.#!>

).$-5#. ",6.C,$ ."#$. &2& :5U.$."#.& $.C5$!&>W!& :5U.$."#.& #54!& :. W^".,& S2. 42.:. #.".$.% !AB.#!>


8/71

N

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

Public Class ContractInherits ControlsSAP.SAPObject

Public Sub New(ByVal Company As SAPbobsCOM.Company)MyBase.New(Company, "@GSP_CNTR")

End Sub

Protected Overrides Function InitializeLines() As Long

End Function

Protected Overrides Sub ModifyingObject()

End Sub

W5,:! 8Y [email protected]+( 3. 4)./4,C2 3. :2 ([email protected]( 3. 2.E(4,( G/.76)(%

A.7S:=7 7(+/G.26. 3.?.).G(7 4)./) :2/ S)(S,.3/3 S() 4/3/ 4/GS( 3. +/ 6/?+/ 9:. -/_/G(7 /S:?+,4/)% '/)/ (?6.2.) ( /7,E2/) .+ -/+() 3.+ 4/GS( 3.+ ).E,76)( /46:/+ :6,+,Q/).G(7 +/ B:24,C2+5%,(;#2,%I"!-A$.`;,-4!K%

Public ReadOnly Property Code() As StringGet

Return Me.FilaActual("Code")

End GetEnd Property

Public Property CardCode() As StringGet

Return Me.FilaActual("U_GSP_CardCode")End GetSet(ByVal value As String)

Me.FilaActual("U_GSP_CardCode") = ValueEnd Set

End Property

W5,:! @Y [email protected]+( 3. 4)./4,C2 3. S)(S,.3/3.7 .2 ([email protected]( 3. 2.E(4,(%

I, 2( 7. .7S.4,B,4/ 2,2Ea2 -/+() S/)/ .+ 4/GS( 5%6) H9:. 4)./ .2 6(3/7 +/7 6/?+/7 IJ'K 7. +./7,E2/)` .+ G,7G( -/+() 9:. 4(26.2E/ .+ 4/GS( +7)b 9:. S() 3.B.46( 7.)` .+ 4/GS( 4+/-.%

@>E $.,;5'()W5".&% T76/ 4+/7. 7.)` G:_ S/).4,3/ / +/ 3.+ '()3AB.;# S.)( 4(2 +/7S/)6,4:+/),3/3.7 3. 6)/?/@/) 4(2 ([email protected](7 3. +f2./7 S/).4,3(7 / +(7 3. +/ A1 3. IJ'%


9/71

&

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

T2 .76/ 4+/7. 6/G?,=2 6.23).G(7 G=6(3(7 S/)/ G(3,B,4/) +/ .76):46:)/ 3. 3/6(7 ,26.)2/ 3. +/4+/7. 6/+ 4(G( 7. Y/4. .2 .+ '()3AB.;#% k 3.?.).G(7 4)./) 6/G?,=2 :2/ S)(S,.3/3 S() 4/3/4/GS( 3. 2:.76)/ 6/?+/%

T2 .+ 4(276):46() 3.?.).G(7 ,23,4/) +/ 6/?+/b .+ ([email protected]( 4/?.4.)/ _ .+ 4/GS( 9:. ).+/4,(2/ +/6/?+/ 3. +f2./7 4(2 +/ 6/?+/ 4/?.4.)/%

J 3,B.).24,/ 3. +/7 +f2./7 3. +/ A1 3. IJ'b .2 +/7 '()W5".& .V,76. :2/ 3,B.).24,/ / 6.2.) .24:.26/j

I,.GS). 9:. 7. 9:,.)/ /\/3,) :2/ 2:.-/ +f2./ 7. 3.?.)` S),G.)( ++/G/) /+ G=6(3( (::IK _3.7S:=7 ).++.2/) +/7 S)(S,.3/3.7 3.+ ([email protected](% '() +( 4:/+ 7, 2( .V,76. 2,2E:2/ +f2./ +/ S)(S,.3/3!2"#IK 3.-(+-.)` #b / 3,B.).24,/ 3. +/7 +f2./7 3.+ IAm 3. IJ' 9:. 3.-:.+-.2 8 /:29:. 2(

.V,76/ 2,2E:2/ .26)/3/ 3. 3/6(7%

Public Class Contract_LinesInherits ControlsSAP.SAPLines

Friend Sub New(ByVal sapobject As Contract)MyBase.New("@GSP_CNT1", "U_GSP_CntrCode", sapobject)

End Sub

Protected Overrides Sub ModifyingLines()

End Sub

Public ReadOnly Property CntrCode() As StringGet

Return Me.FilaActual("U_GSP_CntrCode")End Get

End Property

Public Property ItemCode() As String

(G,:. 2", "2.6, %^".,>'. 4!&5;5!", ." 2", %^"., :.#.$-5",:,>J%5-5", %, %^"., ,;#2,%>

)$!4.$#5.&Y5(:26

\

1.#]!:&YcJ33cI.65:)).26M,2.cA.+.6.

3AB.;#YoIJ'M,2.7p

F.62.%6. .% #!#,% :. %^".,&>


10/71

8#

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 GetReturn Me.FilaActual("U_GSP_ItemCode")

End GetSet(ByVal value As String)

Me.FilaActual("U_GSP_ItemCode") = valueEnd Set

End Property

Public Property Import() As DoubleGet

Return Me.FilaActual("U_GSP_Import")End GetSet(ByVal value As Double)

Me.FilaActual("U_GSP_Import") = value

End SetEnd Property

W5,:! EY [email protected]+( 4)./4,C2 3. :2 ([email protected]( 3. 6,S( +f2./%

P2/ -.Q 6.2E/G(7 +/ 4+/7. +f2./7 4)./3/ 3.?.).G(7 4)./) :2/ S)(S,.3/3 S/)/ 6.2.) /44.7( /.76/7 .2 +/ 4+/7. G/.76)/% T76/ 3.?.)` 7.) 3. 7(+(d+.46:)/ . ,276/24,/)7. 7(+/G.26. 7, 2( 6,.2.-/+() +/ -/),/?+. 9:. :6,+,4.G(7 S/)/ 3.B,2,)+/% D( 2(7 (+-,3.G(7 3.7S:=7 3. ,2,4,/+,Q/) +/7 +f2./7.2 .+ G=6(3( 9"5#5,%5P.W5".&%

Private _lines As Contract_Lines

Protected Overrides Function InitializeLines() As LongMe.DestroyLines(_lines)

End Function

Public ReadOnly Property Cnt1() As Contract_LinesGet

If Me._lines Is Nothing ThenMe._lines = New Contract_Lines(Me)

End IfReturn Me._lines

End Get

End Property

W5,:! ?Y J\/3,) ).B.).24,/ 4+/7. +f2./7 .2 ([email protected]( 4/?.4.)/%

@>? a#5%5P,;5


11/71

88

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 cont.CardCode = "C000001"cont.Comments = "Ejemplo creación de contrato"Try

cont.Add()Catch ex As Exception

ControlsSAP.SAPMsg.Alert("Error creando contrato")End Try

W5,:! LY [email protected]+( 4)./4,C2 ).E,76)(%

Dim cont As Contractcont = New Contract(Me.Company)

'Consulta de un registrocont.GetByKey("1")cont.Comments = "Ejemplo actualización de contrato"Try

cont.Update()Catch ex As Exception

ControlsSAP.SAPMsg.Alert("Error actualizando contrato")End Try

W5,:! DY [email protected]+( G(3,B,4/4,C2 3. :2 ).E,76)( .V,76.26.%

T76. .7 :2 [email protected]+( 3. :6,+,Q/4,C2 S() 4C3,E(b /:29:. +( 4(Ga2 7.)` 6)/6/) 2:.76)(7 ([email protected](7 3.

2.E(4,( G.3,/26. B()G:+/),(7 -,7:/+.7% T2 .+ S)CV,G( 4/Sf6:+( -.).G(7 4(G( .V,76.2B()G:+/),(7 4)./3(7 .VS+f4,6/G.26. S/)/ 6)/?/@/) 4(2 .76. 6,S( 3. ([email protected](7 _ 3. :2/ G/2.)/7.24,++/ S(3.) 4)./)b 4(27:+6/)b /46:/+,Q/) _ .+,G,2/) ).E,76)(7%

@>L b54! :. 6,%5:,;5!".& :.U5"5:,&

TV,76,)`2 L 6,S(7 3. /6),?:6(7 9:. :6,+,Q/).G(7 .2 +/7 S)(S,.3/3.7 3. +(7 4+/7.7 '()3AB.;# _'()W5".& S/)/ )./+,Q/) 3,B.).26.7 6,S(7 3. -/+,3/4,(2.7j

•

1,":,#!$Xj Z()Q/).G(7 9:. .2 +/ S)(S,.3/3 7. Y/_/ ,23,4/3( :2 -/+() /26.7 3.E:/)3/)% I, +( Y/4.G(7 .2 :2/ S)(S,.3/3 9:. 3.-:.+-. :2 '()W5".& .26(24.7 .V,E,)`9:. 4(26.2E/ /+ G.2(7 8 +f2./%

• c,&d.%,#5!"j *?+,E/ / 9:. .+ -/+() 3. +/ S)(S,.3/3 .76. ).+/4,(2/3( 4(2 :23.6.)G,2/3( 4/GS( 3. (6)/ 6/?+/%

• V!"a4:,#,A%.j D( S.)G,6. 9:. 7. S:.3/ G(3,B,4/) .+ -/+() 3. +/ S)(S,.3/3 :2/ -.Q 7.Y/ 4)./3( .+ ([email protected](%

R/G?,=2 .V,76.2 " B:24,(2.7 S() +/7 9:. S(3).G(7 7/?.) 7, 3.73. 2:.76)/ 4+/7. 4/?.4.)/'()3AB.;# 7. Y/2 /\/3,3( +f2./7 .2 :2/ 3.6.)G,2/3/ 4+/7. '()W5".& ( 6/G?,=2 7, 7. Y/2.+,G,2/3(j

• TV,76J33.3M,2.7


12/71

8"

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7• TV,76A.+.6.3M,2.7%

JB.-4%!j

5)./G(7 :2 ([email protected]( 4!)#8*8)#$+ . ,26.26/G(7 7,G:+/) .+ G,7G( B:24,(2/G,.26( 9:. :23(4:G.26( 3. +/ A1 3. IJ'% R.23).G(7 -/),(7 4/GS(7 .26). .++(7 .+ 4C3,E( 3. 4+,.26. _ .+2(G?).% A.?.).G(7 6.2.) +/7 7,E:,.26.7 ).76),44,(2.7j

8% '/)/ .26)/) :2/ 4!)#8*8)#$+ .7 (?+,E/6(),( .26)/) .+ 4C3,E( 3. 4+,.26.%

"% T+ 4C3,E( 3. 4+,.26. _ .+ 2(G?). 2( S:.3.2 G(3,B,4/)7. :2/ -.Q 4)./3( .+ 4!)#8*8)#$+%

L%

T+ -/+() 3.+ 4C3,E( 3. 4+,.26. 3.?. .V,76,) .2 +/ 6/?+/ 3. 4+,.26.7 q9(,:%!7+7)r

O%

P2/ -.Q 4)./3( .+ 4!)#8*8)#$+ 2( 7. S.)G,6,)` /\/3,) 2:.-/7 +f2./7 2, .+,G,2/)+/7%

Public Class PresupuestoInherits ControlsSAP.SAPObject

'...

_ _ _Public Property CardCode() As String

GetReturn Me.FilaActual("U_GSP_CardCode")

End GetSet(ByVal Value As String)

Me.FilaActual("U_GSP_CardCode") = ValueEnd Set

End Property

_Public Property CardName() As String

GetReturn Me.FilaActual("U_GSP_CardName")

End Get

Set(ByVal Value As String)Me.FilaActual("U_GSP_CardName") = Value

End SetEnd Property

Private Sub Oferta_Updating(ByVal Obj As SAPObject) HandlesMe.Updating

If Me.ExistAddedLines(Me.Lines) ThenThrow New ValidationException("No se puede añadir

una línea una vez creado eldocumento")

End IfIf Me.ExistDeletedLines(Me.Lines) Then

Throw New ValidationException("No se puede borrar unafila una vez creado eldocumento ")


13/71

8L

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 End IfEnd Sub

W5,:! OY [email protected]+( 3. :6,+,Q/4,C2 3. /6),?:6(7 3. -/+,3/4,C2

T76. G,7G( 6,S( 3. ).76),44,(2.7 +/7 S(3)f/G(7 6.2.) S/)/ .+ ([email protected]( +f2./7%

@>D J6."#!&

A:)/26. .+ G(G.26( 3. +/ [email protected]:4,C2 3. +/7 3,B.).26.7 /44,(2.7 9:. 7(S()6/2 +(7 ([email protected](7 3.2.E(4,Cb S(3.G(7 /+6.)/) +(7 3/6(7 /26.7 3. 9:. .76(7 7. E:/)3.2 ( S(3.G(7 )./+,Q/)-/+,3/4,(2.7 S)(S,/7 S/)/ 4/24.+/) 3.6.)G,2/3/7 /44,(2.7 7.Ea2 2:.76)/7 2.4.7,3/3.7% T+ ()3.27.4:.24,/+ 3. +(7 3,B.).26.7 .-.26(7 G`7 4(G:2.7 .7j


14/71

8O

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7@>D>8 (%#,&e1!:5U5;,;5!".&

J33UPS3/6.

W/7. 3.A/6(7

!/+,3/6,2E


15/71

8;

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7@>D>@ J%5-5",;5!".&

^.G(-.HK

W/7. 3.

A/6(7

^.G(-,2E

^.G(-.3

J%5-5",-!& ;,:, %^"., :.% '()W5".&Y

^.4()). +/7 +f2./7

A.+.6.HK


16/71

8F

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

EE FF55&&..GG!! ::.. 44,,""##,,%%%%,,&& 6655&&22,,%%..&&

M/ +,?).)f/ 3. 5(26)(+7IJ' ,24+:_. :2/ 7.),. 3. 4(26)(+.7 _ B()G:+/),(7 %DTR S.)( 4(2 .+;++))& 3. IJ'b .76(7 2(7 /_:3/)/2 / 6)/?/@/) 7,2 +/7 +,G,6/4,(2.7 9:. 6,.2. +/ P1 _/ 9:.S)(E)/G/).G(7 .2 +/ S+/6/B()G/ 3.


17/71

8$

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7• '()W5"0.:f2##!"Y 5(26)(+ 3. -,24:+( ( B+.4Y/ 2/)/2@/%

•

'()h$5:Y 4(26)(+ 3. E),3%

• '()b$..Y 4(26)(+ 3. `)?(+%

• b$..'.,$;]Y 4(26)(+ 3. ?a79:.3/7 .2 :2/ E),3 G.3,/26. :2/ 7.),. 3. B,+6)(7B,@/3(7%

• '()(##,;]-."#&Y 4(26)(+ S() .+ 4:/+ S(3).G(7 /2.V/) ( -,7:/+,Q/) 3,B.).26.7/)4Y,-(7 ).+/4,(2/3(7 4(2 :2 ).E,76)(%

E>8>8 '()b.g#f!g

T76. .7 .+ 4(26)(+ G/7 :7/3( @:26( 4(2 +/7 .6,9:.6/7 '()W,A.%% I(2 4/@/7 3. 6.V6( 3(23. .+:7:/),( S(3)` ,26)(3:4,) ( 4(27:+6/) 3/6(7%

'(3).G(7 3.B,2,) 9:. 6,S( 3. 3/6(7 -/ / :6,+,Q/) .+ 4(26)(+ _ +/ .26)/3/ ( 7/+,3/ -/),/)` 7.Ea2.76.%

F,#,bX4. '2AF,#,bX4.

').4,( J\/3. .+ 7fG?(+( 3. G(2.3/ _ G:.76)/ +(7 3.4,G/+.7,23,4/3(7 .2 IJ' S/)/ .+ 6,S( ').4,(%

1GS()6. J\/3. .+ 7fG?(+( 3. G(2.3/ _ G:.76)/ +(7 3.4,G/+.7,23,4/3(7 .2 IJ' S/)/ .+ 6,S( 1GS()6.%

5/26,3/3


18/71

8N

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

M/7 S)(S,.3/3.7 G`7 :6,+,Q/3/7j

• i,%2.1.-A.$Y 123,4/ 3. 9:. 4(+:G2/ (?6.23).G(7 .+ -/+() :2/ -.Q7.+.44,(2/3( :2 ).E,76)(%

• F5&4%,X1.-A.$Y 123,4/ +/ 4(+:G2/ 7.)` +/ 9:. :6,+,Q/).G(7 S/)/ G(76)/) .2 .+4(26)(+ :2/ -.Q 7.+.44,(2/3( :2 -/+()%

• '.%.;#.:i,%2.Y ')(S,.3/3 .2 +/ 9:. S(3).G(7 /7,E2/) : (?6.2.) .+ -/+() 3.+

).E,76)( 7.+.44,(2/3( _ 9:. Y.G(7 ,23,4/3( .+ +/ S)(S,.3/3 i,%2.1.-A.$%

*6)(7 3. +(7 G=6(3(7 G`7 4(G:2.7j

• (::!%2-"j J\/3,).G(7 +/7 4(+:G2/7 9:. 9:.).G(7 -,7:/+,Q/) .2 +/ +,76/ 3.).E,76)(7%

• '.#9#.-i,%2.j A.73. .76. G=6(3( S(3.G(7 /7,E2/) 6/G?,=2 :2 -/+() /+ 4(26)(+S.)( 7,2 S)(-(4/) .+ .-.26( '.%.;#.:i,%2.],C.:b / 3,B.).24,/ 3. Y/4.)+( 4(2'.%.;#.:i,%2.%

M/ +,76/ 3. 3/6(7 9:. G(76)/)` .+ 4(26)(+ S:.3. -.2,) 3. 3,B.).26.7 ()fE.2.7j

• 123,4/23( +/ 6/?+/ 3. +/ 9:. 7. (?6.23)`2 +(7 3/6(7

With Me.SapListBox1.Table = "OCRD".ValueMember = "CardCode".DisplayMember = "CardName".Condition = "CardType='C'".Company = Me._company

End With

• J7,E2`23(+. :2 ([email protected]( F,#,b,A%. / 7: S)(S,.3/3 F,#,'!2$;.j


19/71

8&

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 Dim dt as DataTabledt = ControlsSAP.DoQuery(“SELECT * FROM OCRD”)Me.SapListBox1.DataSource = dt

• J\/3,.23( +(7 -/+().7 G/2:/+G.26. 4(2 .+ G=6(3( 9"&.$#d!/

With Me.SapListBox1.InsertRow("O", "Abierto").InsertRow("C", "Cerrado").InsertRow("P", "Pendiente")

End With

• R/G?,=2 S(3).G(7 /\/3,) -/+().7 4(2j

o (::i,%5:i,%2.&j 5(27:+6/ +/ +,76/ 3. -/+().7 -/+,3(7 3.B,2,3(7 S/)/ :24/GS( 3. IJ'%

o (&&5C"J"2-j G:.76)/ +/ +,76/ 3. -/+().7 3. +/ .2:G.)/4,C2 ,23,4/3/%

5:/23( /7,E2.G(7 +(7 3/6(7 G.3,/26. +/ S)(S,.3/3 b,A%. _ 9:.)/G(7 /\/3,) :2 ).E,76)( S)(S,(4/3/ -.Q 9:. 7. 4/)E:.2 +(7 3/6(7b :6,+,Q/).G(7 .+ .-.26( '()W5f!g>f!2":b,A%.%

Private Sub lstIC_BoundTable(...) Handles SapListBox1.BoundTable

Me.lstIC.InsertRow("-1", "-Ningún Interlocutor comercial-", 0)End Sub

W5,:! NY A.7S:=7 3. 4/3/ 4/)E/ 3. 15b /\/3,G(7 :2 2:.-( -/+()%

R/G?,=2 S(3.G(7 :6,+,Q/) +/ S)(S,.3/3 F5&4%,X!"#$!% S/)/ .7S.4,B,4/) (6)( 4(26)(+ .2 .+ 9:.7. -(+4/)`2 +(7 3/6(7 4()).7S(23,.26.7 / +/ 4(+:G2/ .7S.4,B,4/3/ .2 .+ F5&4%,X1.-A.$% T2 -.Q3. G(76)/)7. +/ 3.74),S4,C2 .2 .+ G,7G( 4(26)(+ 7. G(76)/)` .2 .+ 4(26)(+ 9:. ,23,9:.G(7%

E>8>E '()!-A!f!g

T+ 4(26)(+ '()!-A!f!g ,24()S()/ +/ G/_()f/ 3. B:24,(2.7 _ S)(S,.3/3.7 3.+ 4(26)(+'()W5f!g /26.),() S.)( 4(2 .+ /7S.46( 3. :2 4(26)(+ 4(G?(% T76. 7. :6,+,Q/ 2()G/+G.26. S/)/G(76)/) +,76/7 S.9:.\/7 3. -/+().7%


20/71

"#

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

'/)/ +(7 4(26)(+.7 3. +,76/ 7. Y/ /\/3,3( 2:.-/ B:24,(2/+,3/3 S/)/ S(3.) /\/3,) ).E,76)(7

2:.-(7 3.73. .+ G,7G( 4(26)(+b /Y())`23(2(7 .+ 6)/?/@( 3. 6.2.) 9:. ,) / ?:74/) +/ (S4,C2 3.G.2a 4()).7S(23,.26. / .76/ /44,C2%

'(3).G(7 /\/3,) ).E,76)(7 ,23,4/23(j

• T+ 2(G?). 3. +/ 6/?+/j 9:. /?),)` :2 B()G:+/),( 3. /+6/ 3. ).E,76)(7 6fS,4(H+!$-'()(%#,K

• T+ 6,S( 3. B()G:+/),(j /?),)` .+ B()G:+/),( 3. G/26.2,G,.26( .2 G(3( 4)./)% T76. 6,.2.

9:. Y.).3/) 3. +!$-J:5#'()%• T+ ,3% 3. G.2a 3. IJ'j 4(2 .76. ,3.26,B,4/3() HA)18B0,K /?),).G(7 +/ S/26/++/

4()).7S(23,.26. .2 IJ'% '/)/ .76. 6,S( 3. B()G:+/),(7 2( 7. S(3)`2 /\/3,) +(7 ).E,76)(74)./3(7 .2 .+ 4(26)(+b 7(+/G.26. 7.)-,)` S/)/ /?),) .+ B()G:+/),( 3. IJ'%

M/7 B:24,(2.7 9:. :6,+,Q/).G(7 S/)/ .+ '()W5f!g 7(2j

• '.#+!$-b!$.,#.j h:. /\/3,)` .+ ?(6C2 3. wD:.-(x .2 .+ B()G:+/),( 3. 7.+.44,C2%

k S/)/ .+ 4(26)(+ '()!-A!f!gj

• 9"&.$#$.,#.d!/j h:. 4)./)` :2 2:.-( ).E,76)( wA.B,2,) 2:.-(x%


21/71

"8

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7E>8>? '()h$5:

5(GS+.@( 4(26)(+ 3. X),3 9:. 2(7 7.)-,)` S/)/ G(76)/) :2 4(2@:26( 3. -/+().7 _ S/)/ )./+,Q/) .+G/26.2,G,.26( 3. +(7 ([email protected](7 '()W5".&%

'(3).G(7 /\/3,) 3,B.).26.7 6,S(7 3. 4(+:G2/7 7.Ea2 .+ 6,S( 3. 3/6(7 9:. 9:.)/G(7 G(76)/)j

• (::!%2-"Y J\/3. :2/ 4(+:G2/ E.2=),4/ 7.Ea2 .+ 6,S( 3. 3/6(7 9:. -/_/ /G(76)/)%

• (::)$5;.!%2-"Y 4(+:G2/ S/)/ 3/6(7 3. 6,S( S).4,(% !,7:/+,Q/)` .+ 7fG?(+( 3.G(2.3/ _ +(7 3.4,G/+.7 3.B,2,3(7 .2 IJ' S/)/ .+ 6,S( ').4,(%

• (::9-4!$#!%2-"Y 4(+:G2/ S/)/ 3/6(7 3. 6,S( ,GS()6.% !,7:/+,Q/)` .+ 7fG?(+(3. G(2.3/ _ +(7 3.4,G/+.7 3.B,2,3(7 .2 IJ' S/)/ .+ 6,S( 1GS()6.%

• (::j2,"#5#X!%2-"Y 4(+:G2/ S/)/ 3/6(7 3. 6,S( 4/26,3/3% !,7:/+,Q/)` +(73.4,G/+.7 3.B,2,3(7 .2 IJ' S/)/ .+ 6,S( 5/26,3/3%

• (::).$;."#,#C.!%2-"Y -,7:/+,Q/ .+ 7fG?(+( 3. tun


22/71

""

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7• (::f!!%.,"'()!%2-"j -,7:/+,Q/)/ :2/ 4(+:G2/ 4(2 B()G/6( ;].;0A!g S/)/

3/6(7 /+B/2:G=),4(7 4(2 -/+().7 k ( D Hk.7UV(K • (::W5!%2-"j S/).4,3( /+ 4(26)(+ '()W5f!gb 3(23. +. ,23,4/).G(7 :2

(),E.2 3. 3/6(7 _ +/ 4.+3/ 3. +/ E),3 7(+/G.26. S(3)` 7. :2 -/+() 3. .76/ +,76/%

• (::!-A!f!g!%2-"j -,7:/+,Q/)/ :2/ 4.+3/ 3. 6,S( 4(G?( S/)/ +/ 7.+.44,C23. :2 -/+() .2 :2/ +,76/ ,23,4/3/ 3. -/+().7%

• (::)$!C$.&&f,$!%2-"j G:.76)/ :2/ ?/))/ 3. S)(E).7( 7.Ea2 .+ -/+() /46:/+3. +/ 4.+3/%

(::1.-!!%2-"j S(3).G(7 /\/3,) 4(+:G2/7 4(2 6.V6(7 +/E(7 .2 -/),/7 +f2./7%

(::9-,C.!%2-"j /\/3,).G(7 4(+:G2/7 S/)/ G(76)/) ,G`E.2.7 3.73. :2/ ):6/% A.?.).G(7

,23,4/) :2 4/GS( 9:. 7.)` .+ 9:. 4(26.2E/ +/ ):6/ .7S.4fB,4/ 3. +/ ,G/E.2%

*6)/7 4(2B,E:)/4,(2.7 9:. S:.3. 6.2.) +/ E),3j

• 3AB.;#'!2$;.j S)(S,.3/3 S/)/ /7,E2/) +(7 3/6(7 3. :2 ([email protected]( '()W5".& 4(G((),E.2 3. 3/6(7%

• (;;.4#&(::W5".&j 2(7 ,23,4/ 7, 7. S:.3.2 /\/3,) 2:.-/7 +f2./7 .2 +/ E),3%

• (;;.4#&F.%.#.W5".&j ,23,4/ 7, S(3).G(7 .+,G,2/) ).E,76)(7 3. +/ E),3%

• J:5#,A%.j 123,4/ 7, +/ E),3 S.)G,6,)` .3,4,C2 3. 7:7 4.+3/7

• ']!/J-4#XW5".j G:.76)/ :2/ B,+/ -/4f/ S/)/ +/ .26)/3/ 3. 2:.-(7 ).E,76)(7%

•

1,$0d!/j


23/71


24/71

"O

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, 8Y [email protected]+( 3. /3-.)6.24,/ /+ ,26.26/) ,26)(3:4,) :2 -/+() .2 :2/ 4(+:G2/ 3,B.).26. / +/ ,23,4/3/

4(G( (?+,E/6(),/%

I. Y/ S:?+,4/3( 6/G?,=2 :2 .-.26( ']!/5"CJ:5#!$ S() .+ 9:. S(3).G(7 4(27.E:,) .B.46(7S/).4,3(7 /+ /26.),()b ( 7./ 2( S.)G,6,) +/ .3,4,C2 3. :2/ 4.+3/ G,.26)/7 2( 7. 4:GS+/23.6.)G,2/3(7 4),6.),(7%

[email protected]+(j

D( S(3.G(7 ,26)(3:4,) 2,2Ea2 -/+() .2 +/ E),3 G,.26)/7 2( 7. Y/_/ ,26)(3:4,3( .+ 4C3,E( 3.+4+,.26. H4/GS( 3. 4/?.4.)/Kj

Private Sub SapGrid1_ShowingEditor(...) Handles SapGrid1.ShowingEditor

If Not Me.lstCardCode.HasValue ThenControlsSAP.SAPMsg.StatusBarMsg("Falta código de

interlocutor comercial", True)e.Cancel = True

End If

End Sub

E>8>L '()b$..'.,$;]

5(26)(+ 3. -,76/ 3. 3/6(7 S/)/ )./+,Q/) 3,B.).26.7 6,S(7 3. B,+6)(7 HS/2.+ ,Q9:,.)3/K% J3.G`7 3.S(3.) B,+6)/) .2 6,.GS( 3. [email protected]:4,C2%


25/71

";

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

E>8>D '()(##,;]-."#&

5(26)(+ :6,+,Q/).G(7 S/)/ /3@:26/) ( -,7:/+,Q/) /)4Y,-(7 .2 :2/ 4/)S.6/ 3. 3(4:G.26(7 /2.V(73. :2/ G/2.)/ 7.24,++/%

'(3).G(7 )./+,Q/) +/7 7,E:,.26.7 /44,(2.7j

TVS+()/)j I.+.44,(2/).G(7 :2 /)4Y,-( _ +( /2.V/).G(7 S() 3.B.46( .2 +/ 4/)S.6/ 3. 7+386)1$+#7) %1)/+ .7S.4,B,4/3/ .2 IJ'% I, ,23,4/G(7 :2/ ):6/ G.3,/26. +/ S)(S,.3/3 (##,;]-."#),#] .26(24.7 7. :6,+,Q/)` .76/ ):6/ S/)/ )./+,Q/) :2/ 4(S,/ 3.+ /)4Y,-(%

!,7:/+,Q/)j J?),)` .+ 3(4:G.26( 7.+.44,(2/3(%

W())/)j T+,G,2/)` .+ 3(4:G.26( 7.+.44,(2/3( 3. +/ +,76/ 3. 3(4:G.26(7 3.+ 4(26)(+%

A)/EyA)(Sj T+ 4(26)(+ S.)G,6. +/ S(7,?,+,3/3 3. /))/76)/) _ 7(+6/) /)4Y,-(7 3.26)( 3. .76.b 4(2 +(9:. 7. 4)./)/ :2/ 4(S,/ 3.+ /)4Y,-( .2 +/ ):6/ 3. /2.V(7 .7S.4,B,4/3/%

R/G?,=2 S.)G,6,)` /))/76)/) _ 7(+6/) G.27/@.7 3. 4()).( 3.73.


26/71

"F

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 I. :6,+,Q/)` S/)/ E:/)3/) 3(4:G.26(7 /3@:26(7 S() [email protected]+( .2 :2 '()3AB.;#% '/)/ .++(7(+/G.26. 2.4.7,6/).G(7 :2/ S)(S,.3/3 3. 6,S( '#$5"C 3(23. E:/)3/).G(7 +/ +,76/ 3.

/)4Y,-(7 .2 4/3.2/ _ 7.S/)/3(7 S() S:26( _ 4(G/%

'/)/ (?6.2.) +/ +,76/ 3. /)4Y,-(7 :6,+,Q/).G(7 +/ S)(S,.3/3 (##,;]-."#& 3.+ 4(26)(+%

E>@ ),"#,%%,&

TV,76.2 -/),(7 6,S(7 3. S/26/++/7 4(2 +/7 9:. S(3).G(7 6)/?/@/)% M/ ?/7. 3. 6(3/7 .++/7 7.)` +/4+/7. !"#$!%&'()>+!$-&>+!$-'()% T76/ 4+/7. 7.)` +/ 9:. :6,+,4.G(7 2()G/+G.26. _ +/ 9:.S)(S()4,(2/)` / 2:.76)(7 B()G:+/),(7 .+ /7S.46( 3. S/26/++/ 3. IJ' . ,24+:,)`2 6(3(7 +(7G.4/2,7G(7 3. ,26.E)/4,C2 .2 IJ' W:7,2.77 *2. 4(G( 7, B:.)/2 S/26/++/7 S)(S,/7 3. +/ P1%

E>@>8 +!$-'()

T76. 6,S( 3. B()G:+/),( 7.)` +/ 4+/7. ?/7. 3. +/7 9:. Y.).3/)`2 6(3(7 2:.76)(7 B()G:+/),(7% 5(2.76( 3,7S(23).G(7 3. 6(3(7 +(7 G=6(3(7b B:24,(2.7 _ S)(S,.3/3.7 9:. 2(7 7.)-,)`2 S/)/,26.)/46:/) 4(2 +/7 3.G`7 S/26/++/7 _ B/4,+,6/)`2 +/ ,26.E)/4,C2 4(2 IJ'%

'(3).G(7 ,26.)/46:/) 4(2 /+E:2(7 ?(6(2.7 3. +/ ?/))/ 3. Y.))/G,.26/7 3. IJ' W:7,2.77 *2.

4(G( 7(2 +(7 3. TV4.+b +(7 3. [()3b +(7 3. ,GS).7,C2 _ S).7.26/4,C2 S).+,G,2/)b _ 6/G?,=2 +(73. G/,+,2E% '/)/ .++( 3,7S(2.G(7 3. :2/ 7.),. 3. .-.26(7 _ 3. S)(S,.3/3.7 S/)/ Y/?,+,6/) ( 2(+(7 ?(6(2.7 3. +/ ?/))/ 3. Y.))/G,.26/7j

• (;;.4#&Jg;.%j s/?,+,6/ .+ ?(6C2 3. TV4.+ 3. +/ ?/))/ 3. Y.))/G,.26/7 _ S(3.G(74/S6:)/) +/ S:+7/4,C2 / 6)/-=7 3.+ .-.26( Jg;.%%

• l!$: s/?,+,6/ .+ ?(6C2 3. [()3 3. +/ ?/))/ 3. Y.))/G,.26/7 _ S(3.G(74/S6:)/) +/ S:+7/4,C2 / 6)/-=7 3.+ .-.26( l!$:%

• (;;.4#&)$5"#e(;;.4#&)$.65./j s/?,+,6/ +/ ,GS).7,C2US).7.26/4,C2 S).+,G,2/)9:. 4/S6:)/).G(7 3.73. .+ .-.26( )$5"#

•

.1,5%5"Cj 7.)` .+ .-.26( 9:. 4/S6:)/).G(7 7, 9:.).G(7 G(3,B,4/) +/ S/26/++/ 3.G/,+,2E 9:. /S/).4.)` S() 3.B.46(% 5(G( S() [email protected]+( /\/3,) :2 3.76,2/6/),(b3/6(7 /3@:26(7b .64%

R/G?,=2 6.23).G(7 B:24,(2.7 G:_ :6,+,Q/3/7 4(G(j

• 34."+!$-j J?). :2 B()G:+/),( _ +( ,26.E)/ .2 IJ' /:6(G`6,4/G.26.%

• 34."+!$-F5,%!CY /?). :2 B()G:+/),( .2 G(3( 3,/+(E( S/)/ (?6.2.) :2).7:+6/3(%

• 34."+!$-J:5#Y /?). :2 B()G:+/),( 3. .3,4,C2 H9:. -.).G(7 .2 .+ S)CV,G(/S/)6/3(K _ 7. 7,6a/ .2 :2 ).E,76)( ,23,4/3(%

•

34."d.4!$#Y G:.76)/ :2/ S).d-,7:/+,Q/4,C2 3. :2 ,2B()G. 3. 5)_76/+^.S()67%


27/71

"$

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7E>@>@ +!$-J:5#'()

D(7 S.)G,6. )./+,Q/) .+ G/26.2,G,.26( 3. +(7 ([email protected](7 3. 2.E(4,( 4)./3(7 / S/)6,) 3. :2'()3AB.;# 3. :2/ G/2.)/ )`S,3/ _ 7.24,++/% T76. .7 B()G:+/),( G/7 4(GS+.@( 9:. .V,76. S.)(6/G?,=2 .+ G/7 :6,+,Q/3(b S() +( 9:. 3.3,4/).G(7 :2 4/S,6:+( .7S.4,B,4( S/)/ Y/?+/) 3. .+%

T76. 6,S( 3. B()G:+/),(7 ,26.)/46a/ 4(2 +(7 ?(6(2.7 3. +/ ?/))/ 3. Y.))/G,.26/7 ).B.).26.7 /+G/26.2,G,.26( 3. 3/6(7b / 3.G`7 3. +(7 _/ G.24,(2/3(7 /26.),()G.26. S() .+ Y.4Y( 3.Y.).3/) 3. +!$-'()% T76(7 7(2j

• (;;.4#&(::Y S.)G,6. 6.2.) Y/?,+,6/3( .+ ?(6C2 3. D:.-(%

• (;;.4#&F.%.#.Y Y/?,+,6/ +/ (S4,C2 3. G.2a 3. .+,G,2/)%

• (;;.4#&'.,$;]Y /46,-/ .+ ?(6C2 3. ?a79:.3/7

•

(;;.4#&a4:,#.Y Y/?,+,6/ +(7 ?(6(2.7 3. 3.7S+/Q/G,.26( 3. ).E,76)(7 HS),G.)(b/26.),()b 7,E:,.26.b :+6,G(K

P2/ -.Q 4(2B,E:)/3/7 +/7 /44,(2.7 9:. 9:.).G(7 6.2.) 3,7S(2,?+.7 .2 2:.76)/ S/26/++/3.?.).G(7 4(2(4.) +(7 .76/3(7 9:. S:.3. 6.2.) .+ B()G:+/),( S() G(6,-( 3. )./+,Q/)4:/+9:,.)/ 3. .76/7 /44,(2.7% A.73. +/ S)(S,.3/3 J,# S(3).G(7 7/?.) 7, .76/G(7 .2 /+E:2( 3.+(7 .76/3(7 7,E:,.26.7j

• 3V'aWb9Vhj ,23,4/ 9:. .76/G(7 .2 :2 .76/3( 3. 4(27:+6/% I. S)(-(4/ .2 .+G(G.26( 3. 3.7S+/Q/)7. .26). +(7 ).E,76)(7

• a)F(bJY ,23,4/ 9:. .76/G(7 )./+,Q/23( :2/ /46:/+,Q/4,C2 .2 :2 ).E,76)( _/

.V,76.26.% M/ G/_()f/ 3. +(7 4(26)(+.7 -,76(7 Y/76/ /Y()/ 3,7S(2.2 3. :2/S)(S,.3/3 ,2&.&(;#5!"a4:,#. 9:. 7, .76/ /46,-/3/ ,23,4/)` 9:. 4:/+9:,.)4/G?,( .2 .7. 4(26)(+ S)(-(4/)` :2 4/G?,( 3. .76/3( .2 .+ B()G:+/),(%

• 'J(dcj 2( 7. :6,+,Q/%

• (FFe(FF9VhY 2(7 ,2B()G/ 3. 9:. 7. .76/ /\/3,.23( :2 2:.-( ).E,76)(%

TV,76. :2/ S)(S,.3/3 f2##!"+!$- S/)/ ,23,4/) 9:. ?(6C2 3.+ B()G:+/),( 7.)` .+ ,23,4/3( .2).4,?,) +(7 4/G?,(7 3. .76/3( 3.+ B()G:+/),( _ S)(4.3.) / :2 6,S( 3. /44,C2 : (6)/ 3.S.23,.23(3. .76.j

J,:! b.g#! :.% f2##!"+!$- (;;5


28/71

"N

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7• F!F.%.#.j )./+,Q/ +/ /44,C2 3. .+,G,2/) .+ ).E,76)( /46:/+% I. [email protected]:6/ 4:/23(

S:+7/G(7 7(?). +/ (S4,C2 3. G.2a A/6(7à T+,G,2/)• F!'.,$;]j )./+,Q/ :2/ ?a79:.3/ .26). 6(3(7 +(7 3/6(7% I. (?6,.2. 4:/23(

S:+7/G(7 7(?). ?:74/)%

• h!b!+5$j 7. 3.7S+/Q/ /+ S),G.) ).E,76)(%

• h!b!W,j 2(7 3.7S+/Q/G(7 /+ a+6,G( ).E,76)(%

• h!b!)$.65!2&j 2(7 3.7S+/Q/G(7 /+ ).E,76)( /26.),()%

• h!b!V.g#j ).E,76)( 7,E:,.26.

• h!b!m.Xj 3. S(7,4,(2/ .2 .+ ).E,76)( 9:. 4(,24,3/ 4(2 +/ 4+/-. ,23,4/3/%

E>@>@>8 ,$C, :. :,#!&

TV,76,)`2 " G/2.)/7 3. 4/)E/) 3/6(7 .2 :2 +!$-J:5#'() 6)/?/@/23( 4(2 :2 ([email protected]( 3. 2.E(4,('()3AB.;#%

• P7/23( h.#(%%3AB.;#&j

T76/ .7 +/ G/2.)/ G`7 :7:/+ 3. (?6.2.) +(7 3/6(7 .2 :2 +!$-J:5#'()%'(3).G(7 4(27:+6/) 6(3(7 +(7 3/6(7 3.+ ([email protected]( .V,76.26.7 .2 .7. G(G.26(% I.S:.3. 6/G?,=2 ,23,4/) S() 9:. 4/GS( 9:.).G(7 9:. /S/).Q4/2 ()3.2/3(7 +(7).E,76)(7%


29/71

"&

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

A.?.).G(7 /7,E2/) .+ ([email protected]( /+ B()G:+/),( _ .76. 7. .24/)E/)` 3. 4(27:+6/) +(73/6(7 3.+ ).E,76)( ,23,4/3( .2 4/3/ G(G.26(%

_of = New Oferta(_company)Me.GetAllObjects(_of, "U_GSP_CardName")

W5,:! 8MY 1276/24,/4,C2 _ :7( 3.+ :2 '()3AB.;# .2 :2 +!$-J:5#'()>

• P7/23( .+ h.#'()3AB.;# 3.+ ([email protected](j

*6)/ G/2.)/ 3. 4(27:+6/) +(7 3/6(7 3. :2 ([email protected]( .7 +/ 3. /7,E2/)+. S).-,/G.26..+ (),E.2 3. 3/6(7 HS() .+ 9:. 9:.).G(7 2/-.E/)K /+ f$!/&.$ 3.+ ([email protected](% T72.4.7/),( 9:. .2 .+ (),E.2 3. 3/6(7 .V,76/ :2 4/GS( 4(2 +/ 4+/-. S),24,S/+ 3.+([email protected](%

'/)/ .++( :6,+,Q/).G(7 .+ G=6(3( h.#'()3AB.;# 9:. ,23,4/)` /+ B()G:+/),( 9:.3.?. 6)/?/@/) 4(2 +(7 3/6(7 3.+ ([email protected]( /46:/+%

JB.-4%!Y I(+/G.26. S(3).G(7 2/-.E/) S() ).E,76)(7 3(23. .+ 6(6/+ 7./ G/_()3. 8###%

W)(i7.)

W/7. 3.3/6(7


30/71

L#

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 Dim dt As DataTabledt =DoQuery("SELECT Code, U_CardCode, U_CardName, U_DocDate

FROM [@GSP_DEMO_OFERTA]WHERE (U_GSP_DocTotal > '1000')", Me._company)

If dt.Rows.Count > 0 Then_of.Browser.RecordSet = dt

End IfMe.GetSAPObject(_of)

W5,:! 88Y P6,+,Q/4,C2 3.+ f$!/&.$ _ :7( 3.+ h.#'()3A.B;#%

I(+( S(3).G(7 3.7S+/Q/)2(7 S() +(7 ).E,76)(7 7.+.44,(2/3(7 .2 .+ G(G.26( 3. 4/)E/) .+

f$!/&.$ 3.+ ([email protected](% '() +(7 9:. 7, .V,76.2 2:.-(7 ).E,76)(7 4)./3(7 S(76.),()G.26. S() (6)(7:7:/),( ( S)(4.7(7 2( 7. -,7:/+,Q/)`2b S.)( 7, +(7 4/G?,(7 _/ 9:. .2 4/3/ G(-,G,.26( 7.).B).74/)`2 +(7 3/6(7 3.+ ([email protected]( /46:/+%

'() 3.B.46( 7, 2( 7. .7S.4,B,4/ 2,2E:2/ /44,C2 .2 .+ G(G.26( 3. +/ 4/)E/ .+ B()G:+/),( 7.S(7,4,(2/)` .2 .+ a+6,G( ).E,76)(%

E>@>E +!$-l5P,$:

T76. 6,S( 3. B()G:+/),( S:.3. 7.) G:_ a6,+ S/)/ )./+,Q/) S/26/++/7 /7,76.26.7 3. B()G/ )`S,3/ _

S)`46,4/% 5(27,76,)` .2 :2 B()G:+/),( 4(2 :2 4(26)(+ 3. S.76/\/7 9:. .2 .+ G(G.26( [email protected]:4,C2 7. -,7:/+,Q/)` 4(G( :2/ S/26/++/ /7,76.26. S)(S,/ 3. +/7 3. IJ'%

'.)G,6,).G(7 )./+,Q/) :2 4/G?,( 3. S`E,2/ 3.S.23,.23( 3. 7, 7. 4:GS+.2 +/7 -/+,3/4,(2.7 9:.4)..G(7 (S()6:2/7b 4/S6:)/23( +(7 .-.26(7j

•

),C.],"C.:

• ),C.],"C5"C


31/71

L8

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7T76(7 .-.26(7 2(7 ,2B()G/)`2 3. 9:. SÈ,2/ -.2,G(7 _ / 9:. SÈ,2/ 2(7 3,),E,G(7% '(3).G(7

4/G?,/) +/ ,2B()G/4,C2 3.74),S6,-/ 3. +/ SÈ,2/ /46:/+ S() G.3,( 3. +/ S)(S,.3/3 F.&;$54#5!"%R/G?,=2 S(3).G(7 3.7S+/Q/)2(7 S() +/7 SÈ,2/7 / 6)/-=7 3. 4C3,E( G.3,/26.j

• V.g#),C.j 2(7 3.7S+/Q/G(7 / +/ SÈ,2/ 7,E:,.26.%

• )$.65!2&),C.j 2(7 G(-.G(7 / +/ /26.),() SÈ,2/%

• (;#2,%),C.% '(3.G(7 (?6.2.) .2 9:. S/E,2/ .76/G(7 /46:/+G.26. _ S(3.G(73.7S+/Q/)2(7 6/G?,=2 / :2/ SÈ,2/ .2 4(24).6( /7,E2`23(+. :2 -/+()%

T+ B()G:+/),( /7,76.26. S(3)` 6.2.) " 4(2B,E:)/4,(2.7 3,B.).26.7 7.Ea2 +/ S)(S,.3/3 ),C.J":j

8% I, .7 wZ/+7.x /+ ++.E/) / +/ a+6,G/ SÈ,2/ .+ ?(6C2 3. 4(26,2:/) 9:.3/)`3.7Y/?,+,6/3(%

"%

I, .7 wR):.x .2 +/ a+6,G/ SÈ,2/ /S/).4.)` :2 ?(6C2 3. B,2/+,Q/) 9:. +/2Q/)` :2.-.26( +5",%5P.l5P,$: 9:. 3.?.).G(7 4/S6:)/) S/)/ [email protected]:6/) +/7 /44,(2.72.4.7/),/7 /+ B,2/+,Q/) .+ /7,76.26.%

E>@>? +!$-'()(%#,

T7 :2 7.24,++( _ S)`46,4( 6,S( 3. B()G:+/),( 9:. :6,+,Q/).G(7 S/)/ 4)./) ( /46:/+,Q/) ).E,76)(7 .2:2/ 6/?+/ 3. :7:/),( 3. IJ'% T76/7 S/26/++/7 7(2 a6,+.7 S/)/ 6/?+/7 ?`7,4/7b 3(23. 7(+/G.26. 7./2.4.7/),( ,23,4/) :2 4C3,E( _ :2/ 3.74),S4,C2%

'(3).G(7 :6,+,Q/)+/7 7(?). 6(3( S/)/ )./+,Q/) G/26.2,G,.26(7 3. 6/?+/7 .2 .26()2(7 B:.)/ 3.

IJ' W:7,2.77 *2.%

+5C2$, @Y [email protected]+( 3. S/26/++/ 6,S( +!$-'()(%#,%


32/71

L"

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7E>@>L +!$-(44%5;,#5!"

I, 9:.).G(7 ).:6,+,Q/) 2:.76)( 4C3,E( .2 :2 .26()2( B:.)/ 3. IJ' W:7,2.77 *2.b S(3).G(77,G:+/) :2 .26()2( S/).4,3( .2 /7S.46( _ B:24,(2/+,3/3.7 -,76/7b :6,+,Q/23( .+ 6,S( 3.B()G:+/),( +!$-(44%5;,#5!"% 5(2 .+ 3,7S(23).G(7 3. :2/ @1$)!2@3@) S/).4,3/ / +/ 3. IJ',24+:_.23( +/ ?/))/ 3. Y.))/G,.26/7b ?/))/ 3. G.2ab G.2a S),24,S/+b .64% A,7S(2. 3. G=6(3(7S/)/j

• 5(2.46/) / +/ ?/7. 3. 3/6(7

• J\/3,) +(7 GC3:+(7 3. 6)/?/@( _ 7:7 G.2a7

• J?),) B()G:+/),(7

• A.7S+/Q/)7. S() +(7 ).E,76)(7b 4)./)b ?:74/)b .64%z

•

X.76,(2/) +/7 /S+,4/4,(2.7

• 5(26)(+ 3. -.)7,(2.7

T2 .+ .-.26( W!,: 3.+ B()G:+/),( ++/G/).G(7 / +/ B:24,C2 !"".;#% T76/ B:24,C2 )./+,Q/)` +/4(2.V,C2 / +/ a+6,G/ ?/7. 3. 3/6(7 3. IJ' 4(2.46/3/% I, .7 +/ S),G.)/ -.Q 7. G(76)/)` :2B()G:+/),( .2 .+ 9:. ,23,4/).G(7 +(7 3/6(7 2.4.7/),(7 S/)/ +/ 4(2.V,C2%

'/)/ 4/)E/) GC3:+(7 3. 6)/?/@( :6,+,Q/).G(7 (::V./1!:2%.U(::9#.-1!:2%. _ +()./+,Q/).G(7 .2 .+ .-.26( W!,:1!:2%.&% I, .76(7 2.4.7,6/2 4)./) 6/?+/7b 4/GS(7b .64% +()./+,Q/)`2 /26.7 3. ,2,4,/)7. +/ /S+,4/4,C2 ,2B()G/23( /+ :7:/),( 3. +(7 4/G?,(7 9:. 7. -/2 /

)./+,Q/) S/)/ 4/3/ GC3:+(%

Public Class frmMenu

Private Sub frmMenu_Load(ByVal sender As Object, ByVal e AsEventArgs) Handles MyBase.Load

Me.Connect()End Sub

Private Sub frmMenu_LoadModules(ByVal sender As Object, ByVal e AsEventArgs) Handles Me.LoadModules

Me.AddItemsModule(DLL.LoadDLL(Me.Company))End Sub

End Class

W5,:! 8@Y 5(2.V,C2 _ /))/29:. 3. :2 GC3:+( 3.73. :2 B()G:+/),( +!$-(44%5;,#5!"%


33/71

LL

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, EY [email protected]+( +!$-(44%5;,;5!">


34/71

LO

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

?? ++!!$$--22%%,,$$55!! ::.. ..::55;;55


35/71


36/71

LF

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7P2/ -.Q 3.B,2,3( .+ 4(276):46() S/7/).G(7 / 4(2B,E:)/) +(7 4(26)(+.7 9:. :6,+,Q/)` .+ B()G:+/),(%

'/)/ .++( :6,+,Q/).G(7 .+ .-.26( W!,: 3.+ B()G:/+),(% A.B,2,).G(7 6/G?,=2 4(2 .+ G=6(3(i5./!%2-"9"'.,$;] +/7 4(+:G2/7 9:. 9:.).G(7 9:. 7. G:.76).2 .2 .+ G(G.26( 3. +/7?a79:.3/7%

Private Sub FormEditSAP1_Load(ByVal sender As Object, _ByVal e As EventArgs) Handles MyBase.Load

'Configuración de la busqueda del formularioMe.ViewColumnInSearch("Code", "Código")Me.ViewColumnInSearch("U_GSP_CardCode", "Código cliente")Me.ViewColumnInSearch("U_GSP_DataIn", "Fecha inicio")Me.ViewColumnInSearch("U_GSP_DateOut", "Fecha de fin")

'Configuración del Listbox de clientesWith lstCardCode

.Company = Me._company

.AddColumn("CardCode", "Código")

.AddColumn("CardName", "Nombre", 200)

.AddColumn("Phone1", "Teléfono")End With

'Configuración de la GridWith grdCnt1

.AddListColumn("Cod. Artículo", "U_GSP_ItemCode", _Me._company, "OITM", "ItemCode", _New String() {"ItemName"})

.AddColumn("Descripción", "ItemName")

.AddQuantityColumn("Cantidad inicial", "U_GSP_QuantIn")

.AddQuantityColumn("Cantidad final", "U_GSP_QuantOut")

.AddImportColumn("Importe", "U_GSP_Import")End With

W5,:! 8?Y [email protected]+( 4(2B,E:)/4,C2 3.+ B()G:+/),( _ 7:7 4(26)(+.7%

TV,76. +/ S(7,?,+,3/3 6/G?,=2b .2 .+ G(G.26( 3. ?:74/) b 3. Y/4.) /S/).4.) 3/6(7 3. (6)/76/?+/7 7(?).74),?,.23( +/ 4(27:+6/ 3.+ B()G:+/),(%

'/)/ .++( 3.?.).G(7 4/S6:)/) .+ .-.26( f2%:5"C'.,$;]% 5(G( ).9:,7,6( ,23,7S.27/?+. 3.?.

/S/).4.) 4(G( Gf2,G( .+ 4/GS( 4+/-. 3.+ ([email protected]( .2 +/ 2:.-/ ?a79:.3/%

Private Sub frmOferta_BuldingSearch(ByRef sqlQuery As String) Handles _Me.BuldingSearch

sqlQuery = "SELECT [@GSP_DEMO_OFERTA].Code, OCRD.CardCode,OCRD.CardName, OCRD.AddressFROM [@GSP_DEMO_OFERTA] INNER JOIN OCRDON [@GSP_DEMO_OFERTA].U_GSP_CardCode =

OCRD.CardCode"End Sub

W5,:! 8LY [email protected]+( :6,+,Q/4,C2 ?a79:.3/ S)(S,/ 4(2 f2%:5"C'.,$;]%

R/G?,=2 ,276/24,/).G(7 .+ ([email protected]( _ 4/)E/).G(7 6(3(7 +(7 3/6(7 S() 3.B.46( 3.+ ([email protected]( 3.2.E(4,( S/)/ S(3.) .GS.Q/) / 6)/?/@/) 4(2 .+b 3.26)( 3.+ .-.26( M(/3%


37/71


38/71

LN

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, LY [email protected]+( B()G:+/),( 3. .3,4,C2 .2 6,.GS( 3. [email protected]:4,C2%

?>? b$,A,B,$ ;!" %,& C$5:&

'/)/ 4(GS+.6/) 2:.76)( G/26.2,G,.26( 4(2 +/7 +f2./7b 3.?.).G(7 )./+,Q/) /+E:2/7 -/+,3/4,(2.7b_ 4(GS+.6/) /+E:2(7 3/6(7 4(G( S() [email protected]+(j .2 .+ 4/7( 3. .26)/) :2 4C3,E( 3. /)6f4:+(9:.)).G(7 9:. 2(7 /S/).Q4/ /:6(G`6,4/G.26. +/ 3.74),S4,C2% '/)/ .++( 2.4.7,6/).G(7 4/S6:)/):2 .-.26( 3. +/ E),3 9:. 2(7 ,2B()G. 9:. 7. Y/ G(3,B,4/3( _ /46:/+,Q/) +/ S)(S,.3/3 3. +/ +f2./4()).7S(23,.26.%

Private Sub grdCnt1_UpdateSAPLine(ByVal l As ControlsSAP.SAPLines,ByVal ColumnName As String) Handles grdCnt1.UpdateSAPLine

If ColumnName = "U_GSP_ItemCode" ThenDim it As SAPbobsCOM.Itemsit = Me._company.GetBusinessObject(oItems)it.GetByKey(Me._obj.Cnt1.ItemCode)

'Actualizamos la descripciónMe._obj.Cnt1.ItemName = it.ItemName

End IfEnd Sub

'/)/ -/+,3/) S() [email protected]+( 9:. +/ 4/26,3/3 ,2,4,/+ 7./ 7,.GS). G.2() 9:. +/ 4/26,3/3 B,2/+

Y/)f/G(7 +( 7,E:,.26.j


39/71

L&

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 Private Sub grdCnt1_ValidateSAPLine(ByVal l As ControlsSAP.SAPLines, _ByVal e As DevExpress.XtraGrid.Views.Base.RowAllowEventArgs) HandlesgrdCnt1.ValidateSAPLine

With Me._obj.Cnt1If .QuantIn > .QuantOut Then

ControlsSAP.SAPMsg.StatusBarMsg("La cantidad inicialdebe de ser mayor que la cantidad final", True)

e.Allow = FalseEnd If

End WithEnd Sub

T7 ).4(G.23/?+. 9:. 6(3/7 +/7 -/+,3/4,(2.7 9:. 3.?/G(7 )./+,Q/) 7(?). +(7 ([email protected](7 3.2.E(4,( 7. )./+,4.2 3.26)( 3.+ S)(S,( ([email protected](% k/ 9:. 7, .2 (6)( G(G.26( +( :6,+,Q/G(7 7,2 .+B()G:+/),( 4()).7S(23,.26.b 2(7 7.)-,)`2 +/7 G,7G/7 -/+,3/4,(2.7 _ 4:GS+,).G(7 .2 4:/+9:,.)

.26()2( +/7 ).E+/7 3. 2.E(4,( 7,.GS).%


40/71

O#

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

LL 99--44$$..&&55!!""..&& T+ Z)/G.i()e 3. 5(26)(+7IJ' 3,7S(2. 3. :6,+,3/3.7 S/)/ B/4,+,6/) .+ 6)/?/@( 4(2 ,2B()G.7)./+,Q/3(7 4(2 +/ Y.))/G,.26/ "#$%& ()*+!$#% T76( B/4,+,6/ +/ ,24()S()/4,C2 3. ,2B()G.7 .2 +/7/S+,4/4,(2.7 )./+,Q/3/7%

L>8 3AB.#! d.4!$#

TV,76. :2 ([email protected]( d.4!$# 9:. S(3.G(7 :6,+,Q/) S/)/ ,GS),G,)b S).-,7:/+,Q/)b .VS()6/) / S3Bb .64%b,2B()G.7 4)./3(7 4(2 +/ Y.))/G,.26/ 3. !"#$%& ()*+!$#%

M/7 S)(S,.3/3.7 _ G=6(3(7 G/7 :7/3(7 S/)/ .76. 6,S( 3. ([email protected]( 7(2j

• d.4!$#V,-.j 123,4/).G(7 +/ ):6/ 3.+ B,4Y.)( w!*$ x% T+ ,2B()G. 3.?.)` .76/) 3.26)( 3. +/):6/ .7S.4,B,4/3/ .2 .+ B()G:+/),( 3. 4(2B,E:)/4,C2 HZ,E:)/ FK%

• '.#),$,-.#.$i,%2.j I, .+ ,2B()G. 4(26,.2. S/)`G.6)(7 S(3).G(7 ,23,4/)+. +(7 -/+().7/ .76(7 G.3,/26. .76. G=6(3(%

• )$5"#j ^./+,Q/ +/ ,GS).7,C2 3.+ ,2B()G. ,23,4/3( .2 +/ S)(S,.3/3 d.4!$#V,-.% I, .+,2B()G. ,24+:_. S/)`G.6)(7 _ 2( Y.G(7 ,23,4/3( 7:7 -/+().7 /S/).4.)` :2 B()G:+/),(3. 3.G/23/ HZ,E:)/ $K% R/G?,=2 7. G(76)/)` :2 3,/+(E( 3. ,GS).7,C2 S/)/ .7S.4,B,4/)+/ ,GS).7()/ _ .+ 2:G.)( 3. 4(S,/7 HZ,E:)/ NK% I, 2( 9:.).G(7 ,GS),G,) 3,).46/G.26.S() :2/ ,GS).7()/ 7,2 G(76)/) .+ 3,/+(E( 3. ,GS).7,C2 .26(24.7 :6,+,Q/).G(7 .+ G=6(3(F5$.;#)$5"#%

• F5$.;#)$5"#j ^./+,Q/ +/ ,GS).7,C2 3,).46/ 3.+ ,2B()G.% Z:24,(2/)` ,E:/+ 9:. .+ G=6(3()$5"# S.)( 7,2 G(76)/) .+ 3,/+(E( 3. ,GS).7,C2% A.?.).G(7 .7S.4,B,4/) :2/ ,GS).7()/ _.+ 2aG.)( 3. 4(S,/7% I, 2( .7S.4,B,4/G(7 2,2E:2/ 7. ,GS),G,)` :2/ 4(S,/ S() +/,GS).7()/ S() 3.B.46(%

• )$.65./j ^./+,Q/)` :2/ ,GS).7,C2 S).+,G,2/)% I, .+ ,2B()G. ,24+:_. S/)`G.6)(7 _ 2(Y.G(7 ,23,4/3( 7:7 -/+().7 /S/).4.)` :2 B()G:+/),( 3. 3.G/23/%


41/71

O8

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7• '.%.;#5!"+!$-2%,j '(3.G(7 ,23,4/) :2/ B()G:+/ 4(2 B()G/6( 3. !"#$%& ()*+!$# S/)/

S(3.) B,+6)/) +(7 ).E,76)(7 S() .+ 4),6.),( ,23,4/3(%

T2 .+ 4(276):46() 3.?.).G(7 .7S.4,B,4/) .+ ([email protected]( '()f!A&31>!-4,"X% T76. 7. :6,+,Q/)`S/)/ 4(2.46/) +/ ?/7. 3. 3/6(7 3.+ ,2B()G. Y/4,/ +/ ,23,4/3/ .2 .+ ([email protected](% '() +( 9:. S(3).G(7).:6,+,Q/) 4:/+9:,.) ,2B()G. /:29:. .76. 7. Y/_/ 4)./3( 4(2 :2/ 4(2.V,C2 3,B.).26.%

T7 ,GS()6/26. 9:. )./+,4.G(7 +/ +,?.)/4,C2 3.+ ([email protected]( ^.S()6 4(2 .+ G=6(3( A,7S(7.% '/)/ 2(

6.2.) S)(?+.G/7 S(76.),().7 3. G.G(),/%

+5C2$, DY Z()G:+/),( 3. 4(2B,E:)/4,C2% T7S.4,B,4/) +/ ):6/ 3. +(7 ,2B()G.7

+5C2$, OY Z()G:+/),( 3. 3.G/23/ 3. S/)`G.6)(7


42/71

O"

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, N

L>@ b54! :. ;!".g5E

i.$&5!".& $X,% d.4!$#&

'(3.G(7 3,7.\/) ,2B()G.7 9:. 7./2 4(GS/6,?+.7 4(2 +/7 -.)7,(2.7 3. !"#$%& ()*+!$# MN (!"#$%& ()*+!$# *%!% 5.O P:N ( +/ :+6,G/ -.)7,C2 3. !"#$%& ()*+!$# PNNQ%

T+ ([email protected]( d.4!$# +( S(3).G(7 .24(26)/) .2 :2/ 3. +/7 7,E:,.26.7 +,?).)f/7b 3.S.23,.23( 3. 9:.-.)7,C2 3. !"#$%& ()*+!$# 9:. 2.4.7,6.G(7j

• 5(26)(+7IJ'%5)_76/+^.S()67%-8#%3++

• 5(26)(+7IJ'%5)_76/+^.S()67%-8"%3++


43/71

OL

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7'(3).G(7 :6,+,Q/) :2/ : (6)/b ( +/7 3(7 / +/ -.Q% T2 .76/7 +,?).)f/7 .24(26)/).G(7 .+ ([email protected](

d.4!$#% T+ ([email protected]( +( .24(26)/).G(7 .2 .+ 1%6)#*%3)j• 5(26)(+7IJ'%5)_76/+^.S()67 %5)8#%^.S()6

• 5(26)(+7IJ'%5)_76/+^.S()67 %5)8"%^.S()6

L>? i5&!$ :. 5"U!$-.&

5/3/ -,7() ,24+:,)` 7: S)(S,/ ?/))/ 3. Y.))/G,.26/7b /3.G`7 S(3).G(7 :6,+,Q/) 6/G?,=2 +/ ?/))/3. Y.))/G,.26/7 3. IJ' ( 3.+ B()G:+/),( 3. /S+,4/4,C2 7, .76/G(7 S() B:.)/%

L>L !"U5C2$,$ 5"U!$-.& ." U!$-2%,$5!&

TV,76.2 S)(S,.3/3.7 _ G=6(3(7 .2 +(7 B()G:+/),(7 3. 6,S( +!$-'()b 9:. 2(7 S.)G,6,)`2 /\/3,),26.)2/G.26. ,2B()G.7 S/)/ S(76.),()G.26. S(3.)+(7 S).-,7:/+,Q/) ( ,GS),G,)% R/G?,=2S.)G,6,).G(7 /\/3,) ,2B()G.7 .V6.)2/G.26. / 2,-.+ 3. :7:/),(b S:3,.23( 3:S+,4/) ,2B()G.7.V,76.26.7 ( /\/3,.23( 2:.-(7%

'/)/ :6,+,Q/) .76/ 2:.-/ B:24,(2/+,3/3 3.?.).G(7 /46,-/) +/ S)(S,.3/3 a&.'X.-)$5"#5"C% '()3.B.46( .76/ S)(S,.3/3 .76/)` / nZ/+7.xb S() +( 9:. /+ S:+7/) 7(?). ,GS),G,)US).-,7:/+,Q/) 7.

[email protected]:6/)` .+ G=6(3( 3")$5"# _ .+ .-.26( )$5"#5"C+!$-% '.)( 7, 9:.).G(7 :6,+,Q/) .76/B:24,(2/+,3/3 .76/ S)(S,.3/3 3.?.)` .76/) / nR):.xb _ _/ 2( 7. [email protected]:6/)`2 +(7 G=6(3(7 _

.-.26(7 /26.),()G.26. G.24,(2/3(7%


44/71

OO

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7'/)/ /\/3,) :2 ,2B()G. 6.2.G(7 :2/ S)(S,.3/3 d.4!$#& 9:. 2(7 S.)G,6,)` /\/3,) -/),(7

,2B()G.7 /+ B()G:+/),( 3.+ 7,E:,.26. G(3(j

Me.Reports.Add("Facturas", New cr12.Report(GetType(misfacturas),Me._company))

Me.Reports.Add("Factura2", New cr12.Report(GetType(factura1),Me._company), _

New CrystalReportsParameter("Code",Me.txtCode))

48R&@3 K8R I77H,)#3!@*$@+1 %# K$!@1FS

()*+!$9RT IK +1$!+KI4:!"#$%&()*+!$#:0()*+!$S

4%!%6I!!%" 4%!%6)$)!# !"#$%&()*+!$#4%!%6)$)!HJJ

A.74),S6,(2j A.74),S4,C2 9:. +. 3/).G(7 /+ ,2B()G.% A.?.)` 7.) a2,4/ S/)/ +(7 ,2B()G.7 3.+B()G:+/),(%

^.S()6*?@j 1276/24,/).G(7 :2 ([email protected]( d.4!$# ,23,4`23(+. .+ 6,S( 3. +/ 4+/7. 9:. Y/4. ).B.).24,//+ ,2B()G. !"#$%&()*+!$#b _ +/ 3+6*%1" 3.73. +/ 9:. (?6.23)` +(7 3/6(7%

'/)/G.6.)7j M,76/ 3. S/)`G.6)(7 9:. 9:.)/G(7 S/7/) / .+ ,2B()G. .2 .+ G(G.26( 3.

,GS),G,)+(% M(7 S/)`G.6)(7 S(3)`2 7.) 3. 6,S( A,74).6( ( 3. 6,S( ^/2E(% D.4.7,6/).G(7 ,23,4/).+ 2(G?). 3.+ S/)`G.6)( _ 3. 9:. 4(26)(+ 3.+ B()G:+/),( (?6.23).G(7 .+ -/+()% R/G?,=2S(3).G(7 S/7/) -/+().7 4(276/26.7%

'/)/ S(3.) ,24+:,) ,2B()G.7 3.26)( 3. 2:.76)(7 S)(_.46(7 _ /7f :6,+,Q/)+(7 4(G( :2/ 4+/7.3.?.).G(7 6.2.) ,276/+/3( /+E:2/ -.)7,C2 3. !"#$%& ()*+!$# 9:. ,24+:_/ Y.))/G,.26/7 3.,26.E)/4,C2 S/)/ U@#8%& K$87@+%

'(3.G(7 (?6.2.) :2/ 3.73. +/ Y.))/G,.26/ 3. ,276/+/4,C2 3. !,7:/+ I6:3,( "##;b G/)4/23( +/4/7,++/ 5)_76/+ ^.S()67 S/)/ !,7:/+ I6:3,( 9:. ,276/+/)` +/7 +,?).)f/7 S/)/ 5)_76/+ ^.S()67 8#HZ,E:)/ &K%


45/71

O;

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, RY 5)_76/+ ^.S()67 S/)/ !,7:/+ I6:3,( "##;

I, 6.2.G(7 .76/ B:24,(2/+,3/3 _/ S(3).G(7 /2.V/) 3(4:G.26(7 }%)S6 .2 2:.76)( S)(_.46(% J+/2.V/)+(7 /+ S)(_.46( /:6(G`6,4/G.26. 7. E.2.)/)` :2/ 4+/7. }%-? 9:. :6,+,Q/).G(7 S/)/ Y/4.)).B.).24,/ / .76(7 ,2B()G.7%

5(2 .76( _/ 6.23)f/G(7 3.B,2,3(7 -/),(7 ,2B()G.7 3. 7,76.G/% JY()/ S(3)f/G(7 3.B,2,) (6)(7,2B()G.7 3. :7:/),(b S)(S,(7 S/)/ 4/3/ 6,S( 3. 4+,.26.% '/)/ .++( :6,+,Q/).G(7 .+ ?(6C2 3.+

3,7.\/3() 3. &%"%+8$# 3. IJ' HZ,E:)/ 8#j F5&.G,:!$ :. 5"U!$-.&K%


46/71

OF

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, 8MY A,7.\/3() 3. ,2B()G.7

A.73. .+ 3,7.\/3() S(3).G(7 )./+,Q/) +/7 7,E:,.26.7 /44,(2.7j

+5B,$ ;!-! .Q":,$Y '(3).G(7 3.B,2,) 9:. B()G:+/),( 9:.).G(7 B,@/) S() 3.B.46(%'(3).G(7 ,23,4/) 7, +( 9:.).G(7 S/)/ 6(3(7 +( :7:/),(7 ( 7(+/G.26. S/)/ .+ :7:/),( /46:/+%

I, /+Ea2 :7:/),( 6:-,.)/ :2/ 4(2B,E:)/4,C2 S)(S,/ 2( 7. +. 4/G?,/)f/ 7, ,23,4/G(7 9:. +(9:.).G(7 S/)/ 6(3(7 +(7 :7:/),(7% I(+/G.26. /B.46/)/ 4:/23( .+ :7:/),( 2( 6.2E/ 2,2Ea2,2B()G. 3.B,2,3( S() 3.B.46( S/)/ .+%

F24%5;,$Y 5)./)` :2/ 4(S,/ 3.+ ,2B()G. 7.+.44,(2/3( .2 :2 /)4Y,-( !*$ b .2 +/ ):6/ 3. +(7,2B()G.7 ,23,4/3/ .2 +/ 4(2B,E:)/4,C2%

V2.6! 5"U!$-.Y '(3).G(7 /\/3,) :2 2:.-( ,2B()G. 3. !"#$%&()*+!$#% '/)/ .++(3.?.).G(7 ,23,4/) :2/ 3.74),S4,C2 9:. 2( 7. S(3)` ).S.6,) _ 7.+.44,(2/) :2 ,2B()G. !*$ 9:. 4)./)` :2/ 4(S,/ .2 +/ ):6/ 3. +(7 !)*+!$#%

P2/ -.Q 7.+.44,(2/3( .+ B,4Y.)( 4(2 .+ !)*+!$ /S/).4.)`2 +(7 S/)`G.6)(7 3. .76.% I,9:.).G(7 9:. .+ S/)`G.6)( .76. ).+/4,(2/3( 4(2 /+Ea2 4(26)(+ 3.+ B()G:+/),( 3.?.).G(7,23,4/) .+ 2(G?). 3. .76. 4(26)(+% I, S() +( 4(26)/),( 9:.).G(7 ,23,4/) :2 -/+() B,@( 7. +(,23,4/).G(7 .26). ++/-.7 H~!/+()•Kb _ 7, +( 3.@/G(7 .2 ?+/24( .26(24.7 .2 .+ G(G.26( 3. +/,GS).7,C2 7. +( S.3,)` /+ :7:/),(%

R/G?,=2 S(3).G(7 ,23,4/) .+ 2aG.)( 3. 4(S,/7 S() 3.B.46(% I, ,23,4/G(7 :2/ ,GS).7()/B,@/ 7. ,GS),G,)` 3,).46/G.26. S() .++/b 7, +( 3.@/G(7 .2 ?+/24( .2 .+ G(G.26( 3. ,GS),G,)/S/).4.)` .+ 3,/+(E( 3. ,GS).7,C2 4(2 +/ ,GS).7()/ S() 3.B.46( 3.+ 7,76.G/%


47/71

O$

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, 88Y J\/3,) :2 2:.-( ,2B()G.%

J:5#,$Y '.)G,6,)` .3,6/) :2/ ,2B()G. 3. :7:/),(% M(7 ,2B()G.7 3. 7,76.G/ 2( 7. S:.3.2G(3,B,4/)% I, 9:.).G(7 -/),/) /+Ea2 -/+() 3.?.).G(7 3:S+,4/) .+ ,2B()G. _ .26(24.7 .3,6/).+ 2:.-( ,2B()G. 3. :7:/),(%

J%5-5",$Y T+,G,2/).G(7 .+ ,2B()G. 3. :7:/),( 7.+.44,(2/3(%

F5&.G,$j '.)G,6. /?),) .+ ,2B()G. S/)/ 7: 3,7.\( 7,.GS). _ 4:/23( 6.2E/G(7 +/7Y.))/G,.26/ 3. !"#$%& ()*+!$# ,276/+/3/ .2 +/ G`9:,2/%

P2/ -.Q 4(2B,E:)/3(7 +(7 ,2B()G.7 7, S:+7/G(7 S).-,7:/+,Q/) 2(7 /S/).4.)` :2/ +,76/ 4(2 +(7,2B()G.7 ,24+:,3(7 .2 .+ B()G:+/),(%

I, S:+7/G(7 .+ ?(6C2 3. ,GS),G,) b ,GS),G,).G(7 .+ ,2B()G. 4(27,3.)/3( S() 3.B.46(%


48/71

ON

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

DD 11..""&&,, B B.. ::.. &&55&#..--,, A,7S(2.G(7 3. :2/ 7.),. 3. G.27/@.7 3. 7,76.G/ 4(2 +/ /S/),.24,/ 3. IJ' W:7,2.77 *2.b S/)/B/4,+,6/) +/ 4(G:2,4/4,C2 .26). .+ :7:/),( _ +/ /S+,4/4,C2%

TV,76,)`2 3,B.).26.7 6,S(7 3. G.27/@.7j

• 12B()G/6,-(

• J-,7(

• A.4,7,C2

•

T))()

• J44,C2

• T26)/3/ 3. 3/6(7

D>8 1."&,B.& :. :5,%!C!

TV,76.2 :2/ 7.),. 3. G.27/@.7 _/ 3.B,2,3(7 7.Ea2 .+ 6,S( 3. G.27/@. 9:. 9:.)/G(7 G(76)/)j

9;! b54!

'()1&C>j2.!"

'()1&C>(%.$#

'()1&C>$5#5;,%eJg;.4#5!"

'()1&C>9"U!

'(3.G(7 4(2B,E:)/) 2:.76)( S)(S,( G.27/@. 4(2 +/ B:24,C2 '()1&C>']!/ ,23,4/23( .+G.27/@.b .+ ,4(2(b +(7 ?(6(2.7%

':+7/23( V+1$!+& W X /+ /S/).4.2 :2/ G.27/@. 3.+ 6,S( '()1&Cb S(3).G(7 4(S,/) .+ 6.V6( 3.+G.27/@.%


49/71

O&

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7'/)/ :6,+,Q/) G.27/@.7 9:. G:.76).2 .V4.S4,(2.7 4/S6:)/3/7 S(3.G(7 :6,+,Q/) +/ B:24,C2

'()1&C>']!/ _ S/7/)+. +/ .V4.S4,C2% T76. 6,S( 3. G.27/@.7 S.)G,6. 9:. Y/4,.23( 3(?+. 4+,47(?). .+ G.27/@. 3. .))()b S(3.) -,7:/+,Q/) +/ S,+/ 3. +/ .V4.S4,C2 HZ,E:)/ 8"j 1."&,B.-!$,":! %, .g;.4;5


50/71

;#

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, 8EY [email protected]+( 9"42#f!g 3. 6,S( B.4Y/%

Dim d As DateTimed = SAPMsg.InputBox( _

"Hasta que fecha quieres eliminar los registros del 'Log demodificaciones'", _

SAPMsg.InputType.Date, Today)


51/71


52/71

;"

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, 8?

'() 3.B.46( 6(3/7 +/7 /:6(),Q/4,(2.7 2:.-/7 9:. 7. 4)..2 +( Y/)`2 S() 3.B.46( 4(2

wJ:6(),Q/4,C2 6(6/+x%

O>@ $.,;5


53/71

;L

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

NN )),,$$QQ--..##$$!!&& TV,76. :2/ 4+/7. S() +/ 9:. S(3.G(7 4)./) 3. :2/ G/2.)/ B`4,+ ([email protected](7 9:. 4(26.23)`2 :2/ +,76/3. S/)`G.6)(7 9:. 2(7 S:.3. 7.)-,) S/)/ +/ S/)/G.6),Q/4,C2 3.+ GC3:+(% I,2 +/ 2.4.7,3/3 3.4)./) 2:.-(7 ([email protected](7 _ 2, 6/?+/7 .2 +/ ?/7. 3. 3/6(7%

T76(7 7. S(3)`2 G(3,B,4/) _/ 7./ 3.73. .+ S)(S,( ([email protected]( ( S() .+ :7:/),( 3. +/ /S+,4/4,C2G.3,/26. .+ B()G:+/),( 3. 4%!Z6)$!+# .2 .+ G.2a C)#$@D1%

N>8

$.,;5),$,-.#.$&>),$,-.#.$(##$5A2#.% A(23. S(3).G(7 .7S.4,B,4/)j

• T+ 6,S( 3. S/)`G.6)( 9:. 2()G/+G.26. 4(,24,3,)` 4(2 .+ 6,S( 3. +/ -/),/?+.%

• T+ 2(G?). 3.+ S/)`G.6)( H(S4,(2/+K%

•

A.74),S4,C2%• !/+() S() 3.B.46(%

• !,7,?,+,3/3 3.+ S/)`G.6)(% I, .7 :2 S/)`G.6)( 3. 7,76.G/ 7(+/G.26. 7.)` S(7,?+.G(3,B,4/)+( .26)/23( .2 +/ /S+,4/4,C2 .2 G(3( J3G,2,76)/3()%

• 5(G.26/),(7%

'(3.G(7 ,23,4/) /+ S/)`G.6)( 3/6(7 .V6)/7 G.3,/26. (6)(7 /6),?:6(7 4(G( F,#, _ 1,&0j

• P2/ 7.26.24,/ IhM 4(2 +(7 -/+().7 -/+,3(7 S/)/ .+ S/)`G.6)(%

•

P2/ +,76/ 3. -/+().7 9:. 7.)`2 +(7 -/+().7 -/+,3(7 9:. S:.3. /4.S6/) .+S/)`G.6)(%


54/71

;O

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7• P2/ G/74/)/ 3. .26)/3/ 3. 3/6(7%

'(3.G(7 -.) :2 [email protected]+( 3. 4CG( 3.B,2,) :2/ 4+/7. 4(2 " S/)`G.6)(7j

Imports ControlsSAPImports ControlsSAP.ParametersImports ControlsSAP.Parameters.ParameterType

Public Class Parametros1Inherits ControlsSAP.Parameters.ApplicationParameters

Public Sub New(ByVal c As SAPbobsCOM.Company)MyBase.New(c)

End Sub

' Cantidad inicial _Public CANTINI As Integer

' Ruta plantillas _Public PATHPLANT As String

End Class

[email protected]+(7 S/)/ ,23,4/) :2 (),E.2 3. 3/6(7 4(2 .+ /6),?:6( !"#$!%&'()>),$,-.#.$&>F,#,> T+(),E.2 S(3)` 7.) :2/ 7.26.24,/ IhMb ( :2/ +,76/ 3. -/+().7 3.+ G,7G( 6,S( 3.B,2,3( .2 +/-/),/?+.j

'Valores posibles: Numeros par del 0 al 20

_ _Public NumeroPar As Integer

'Valores posibles: Las listas de precios _ _Public ListaPrecios


55/71

;;

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7TV,76. (6)( 6,S( 3. /6),?:6( !"#$!%&'()>),$,-.#.$&>1,&0% 5(2 +(7 9:. S(3).G(7 3.B,2,)

G/74/)/7 4(2 .VS).7,(2.7 ).E:+/).7b S/)/ +/ .26)/3/ 3. 3/6(7 3.73. .+ B()G:+/),( 3.S/)`G.6)(7%

[email protected]+(j

'Solamente se podrán introducir direcciones ftp _ _Public DireccionFtp As String

N>@

a#5%5P,;5


56/71

;F

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, 8L

A.73. +/ 4+/7. (44%5;,#5!"),$,-.#.$&b 3(23. 3.B,2,G(7 +(7 S/)`G.6)(7 3. 2:.76)( GC3:+(bS(3).G(7 ,23,4/)+. /+ 4(276):46() .+ 2(G?). 3. :2/ 4/6.E()f/ S() +/ 9:. 7. /E):S/)`2 +(7S/)`G.6)(7 3. :2 G,7G( GC3:+(b 4:/23( 7. G:.76).2 3.73. .+ B()G:+/),( 3. S/)`G.6)(7HZ,E:)/ 8FK%

Public Class ParemetersDemoInherits ControlsSAP.Parameters.ApplicationParameters

Public Sub New(ByVal c As SAPbobsCOM.Company)MyBase.New(c, "Demo Categoria")

End Sub...


57/71

;$

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

+5C2$, 8D

'() +( 9:. S(3).G(7 6.2.) ).E,76)/3(7 .2 :2 G,7G( GC3:+(U+,?).)f/ -/),/7 4+/7.7 3.S/)`G.6)(7% h:. 7. +(4/+,Q/)`2 .2 +/ G,7G/ S.76/\/ _ 7. /E):S/)`2 S() +/7 4/6.E()f/7 ,23,4/3/7%

X):S( 8

X):S( "


58/71

;N

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

RR

11


59/71

;&

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 R>8 $.,;5+!$-&>+!$-FWW% P6,+,Q/).G(7.+ 3,7.\/3() 3.+ B()G:+/),( S/)/ 4)./) .+ G.2a 3. 2:.76)( G(3:+( /\/3,.23( -/),(7 1."2'#$54 S/)/ 4/3/ 6,S( 3. G.2a%

R>@ $.,;5


60/71


61/71

F8

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7A.73. 2:.76)( B()G:+/),( ,).G(7 /\/3,.23( 6(3(7 +(7 ([email protected](7 2.4.7/),(7 S/)/ S(3.) [email protected]:6/)

2:.76)( G(3:+( _ .2 .+ G(G.26( 3.+ /))/29:. .76(7 7. 4)./)`2 7, .7 2.4.7/),(% '/)/ .76( .V,76.+/ S)(S,.3/3 F,#,f,&. 9:. 2(7 S)(S()4,(2/ :2 ([email protected]( 3. 6,S( +,76/b S/)/ ,) /\/3,.23( 6/?+/7b4/GS(7 _ 3.G`7 ([email protected](7 9:. 3.?.)` 4)./) 2:.76)( G(3:+( /+ /))/24/) ( /+ 4/G?,/) 3. -.)7,C2%

A.?.).G(7 7(?).74),?,) .+ G=6(3( $.,#.F,#,f,&.3AB.;#&IK . ,) /\/3,.23( +/7 6/?+/7 _4/GS(7% M(7 ([email protected](7 7. 3.B,2,)`2 ,E:/+ 9:. +( Y/)f/G(7 3.73. .+ 3,7.\/3() 3. IJ' H7,2 .+ tn3.+/26. 3. +/7 6/?+/7 _ 7,2 .+ tP !n 3.+/26. 3. +(7 4/GS(7K%

A.B,2,).G(7 " 6/?+/7 4(2 7:7 3,B.).26.7 4/GS(7j

Public Overrides Sub CreateDataBaseObjects()MyBase.CreateDataBaseObjects()

With Me.DataBase.AddTable("GSP_CNTR", "Contratos").Fields.AddAlfanumerico("GSP_CardCode", "Código cliente", 50).AddAlfanumerico("GSP_CardName", "Nombre", 100).AddFecha("GSP_DataIn", "Fecha inicio").AddFecha("GSP_DateOut", "Fecha de fin").AddMemo("GSP_Comments", "Comentarios")

End With

With Me.DataBase.AddTable("GSP_CNT1", "Lineas decontratos").Fields

.AddAlfanumerico("GSP_CntrCode", "Cód.contrato", 8)

.AddAlfanumerico("GSP_ItemCode", "Cod. Artículo", 50)

.AddAlfanumerico("GSP_ItemName", "Descripción", 150)

.AddCantidad("GSP_QuantIn", "Cantidad inicial")

.AddCantidad("GSP_QuantOut", "Cantidad final")

.AddImporte("GSP_Import", "Importe")End With

End Sub

'(3.G(7 /\/3,) / +/ +,76/ ([email protected](7 3. 6,S(j

• R/?+/7j 3.26)( 3. 4/3/ 6/?+/ S(3.G(7 /\/3,) ([email protected](7 4(G( 4/GS(7b -/+().7 -/+,3(7b .

f23,4.7%• !,76/7

• ')(4.3,G,.26(7 /+G/4.2/3(7

• J44,(2.7 IhMj 4(G( @1#)!$#S 8*7%$)#S 7)&)$)#%

• 5/6.E()f/7 IJ'j 3.26)( 3. 4/3/ 4/6.E()f/ S(3.G(7 3.B,2,) ?a79:.3/7 B()G/6./3/7b4(27:+6/7 S).3.B,2,3/7%


62/71

F"

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 R>? !"#$!% :. 6.$&5!".&

'/)/ .+ 4(26)(+ 3. -.)7,(2.7 .V,76. :2 G.4/2,7G( G.3,/26. :2 /6),?:6( 3. .27/G?+/3( S() .+4:/+ .+ S)(E)/G/3() S(3)` G(3,B,4/) . ,23,4/)` 9:. .+ G(3:+( .2 4:.76,C2 3.?. 7.) /46:/+,Q/3(%T76. 7. 3.?.)` ,23,4/) .2 .+ /)4Y,-( (&&.-A%X9"U! 3.+ S)(_.46(%

T2 .+ G(G.26( 3. /))/24/) 7. 3.6.46/)` 7, 7. Y/ G(3,B,4/3( +/ -.)7,C2 ( 7, .7 :2 2:.-( GC3:+(S() +( 9:. 7. /-,7/)` /+ :7:/),( 9:. 7. -/2 / [email protected]:6/) G(3,B,4/4,(2.7 .2 IJ'% A. .76/ G/2.)/ 2(Y/)` B/+6/ 9:. .+ 4(27:+6() ( +(7 :7:/),(7 3. IJ' 7.S/2 9:. 4/GS(7 ( 6/?+/7 7. 6,.2.2 9:. 4)./).2 :2/ 2:.-/ -.)7,C2%

R>L $.,;5


63/71

FL

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

R>D ($$,"S2. :. 2" -


64/71


65/71

F;

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7


66/71

FF

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

88MM 99""##..CC$$,,;;55N

M/7 S/26/++/7 7. ).S,26/)`2 7.Ea2 .+ .76,+( .+.E,3( .2 IJ' W:7,2.77 *2.% I,2 +/ 2.4.7,3/3 3.)./+,Q/) 2,2E:2/ G(3,B,4/4,C2 3.73. .+ 3,7.\/3() 3. 4C3,E(%

• T76,+( 4+`7,4(j

• D:.-( T76,+( N%Nj


67/71

F$

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 8M>@ +2."#.p #,-,G! :. %.#$, X ;!%!$ :. %,& 4,"#,%%,&

T2 .+ G(G.26( 3. /?),)7. +(7 B()G:+/),(7 7. G(76)/)`2 4(2 +/ 4(2B,E:)/4,C2 3. B:.26. _ 4(+().76/?+.4,3(7 .2 IJ' W:7,2.77 *2.%

T2 G(3( 3,7.\( 7. 4(26,2:/)f/ 3,7.\/23( +/7 S/26/++/7 6/+ _ 4(G( Y/76/ /Y()/% '/)/ 9:. 7.S:.3/ :6,+,Q/) .76/ 2:.-/ B:24,(2/+,3/3 .+ B()G:+/),( 3.?. 6.2.) +/ S)(S,.3/3 (2#!';,%.1!:. / +!"#% '() 3.B.46( +(7 B()G:+/),(7 _/ 7. 4)./2 4(2 .76. -/+()%

8M>E b.g#!& F5"Q-5;!& I!"#$!% q F!A%.r%5;0K

I. S(3)`2 G(3,B,4/) +(7 6.V6(7 3. +/7 .6,9:.6/7 3. /+E:2(7 4(26)(+.7b 6/+ _ 4(G( Y/4. IJ'bS:+7/23( s3Vbd3Wt _ Y/4,.23( F3fWJrW9m 4(2 .+ )/6C2%

M(7 4(26)(+.7 4(2 .76/ B:24,C2 Y/?,+,6/3/ 7.)`2j

• '()W,A.% H.6,9:.6/7K

• '()b,A),C. H'.76/\/7K

• '()d,:5!f2##!"U'()].;0f!g

• 5(+:G2/7 3. +/ E),3

T76/ B:24,(2/+,3/3 7. E)/?/)` .2 +/ ?/7. 3. 3/6(7 3(23. 7. 4(2.46. S() 3.B.46( .+ I7791%


68/71

FN

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 8M>? 1."o& 4,$, '() f2&5".&& 3".

'/)/ 4)./) 2:.76)( G.2a 3. /S+,4/4,C2 3.73. .+ B()G:+/),( +!$-FWW .V,76,)` :2 6,S( 3. 4(26)(+9:. 2(7 S.)G,6,)` /\/3,) +/ (S4,C2 3. G.2a 3.26)( 3. :2/7 4(()3.2/3/7 .7S.4fB,4/7 .2 .+G.2a 3. IJ'%

M/ S)(S,.3/3 9:. :6,+,Q/).G(7 S/)/ .++( 7.)` ',4W!;,#5!" 3.73. +/ 9:. S(3).G(7 .7S.4,B,4/)j

• ),$."#a9Fj 13.26,B,4/3() 3.+ G.2a S/3). 3. +/ 9:. 4(+E/)/ 2:.76)/ (S4,C2% I, 2( 7..7S.4,B,4/ 2,2Ea2 -/+()b 7. S,26/)` +/ (S4,C2 .2 7: +:E/) S() 3.B.46(% I, 7. .7S.4,B,4/ # (.+ -/+() OL;"# 7. /\/3,)` .2 .+ G.2a )/fQ%

• )!&5#5!"j '(7,4,C2 9:. (4:S/)` 2:.76)/ (S4,C2 3.26)( 3. +/7 (S4,(2.7 9:. 4:.+E/2 3.G.2a ,23,4/3( .2 .+ ),$."#a9F% I, +/ S(7,4,C2 .7 d8b +/ (S4,C2 7. /\/3,)` /+ B,2/+%

'/)/ S(3.) :6,+,Q/) .76. 2:.-( 4(26)(+ .2 (S4,(2.7 _/ 4)./3/7b S(3.G(7 4(2-.)6,) +/ (S4,C2 3.G.2a / '()1."29#.- B`4,+G.26.% A.73. +/ (S4,C2 [ 5+1-)!$@! )1%%%x .2 .+ G.2a 4(26.V6:/+ 9:..V,76. .2 .+ 3,7.\/3() 3. G.2a7 3. !,7:/+ I6:3,( Y/4,.23( 4+,4 3.).4Y( 7(?). .+ 4(26)(+%

V2.6! #54! :. -."o


69/71

F&

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7

8888 FF,,##,,AA,,&&.. T2 .76. 4/S,6:+( -.).G(7 :2/ 7.),. 3. ([email protected](7 9:. S(3.G(7 4)./) .2 +/ ?/7. 3. 3/6(7 3. IJ'W:7,2.77 *2.% R(3(7 .++(7 ,GS+.G.26/2 :2/ @1$)!2@3@) 9:. ,24+:_. :2 G=6(3( Jg.;2#.% h:.7,)-. S/)/ 4)./)U/46:/+,Q/) .+ ([email protected]( .2 +/ ?/7. 3. 3/6(7%

I, 2.4.7,6/G(7 4)./) .2 :2 G(G.26( 3/3( 4:/+9:,.)/ 3. .76(7 ([email protected](7 :6,+,Q/)f/G(7 .76.G=6(3(% '.)( +( 2()G/+ 7.)` 9:. 7. 4)..2 +(7 ([email protected](7 .2 .+ G(G.26( 3. /))/29:. 3.+ GC3:+(%k S/)/ .++( .2 -.Q 3. :6,+,Q/) .+ G=6(3( Jg.;2#. +( 9:. Y/)f/G(7 .7 /\/3,) +(7 ([email protected](7 .2 +/4(+.44,C2 +!$-FWW>F,#,f,&. 3.26)( 3.+ G=6(3( +!$-FWW>$.,#.F,#,f,&.3AB.;#&%

88>8 b,A%,&p ;,-4!&p ^":5;.&

'(3.G(7 4)./) 6/?+/7 .2 IJ' W:7,2.77 *2. 4(2 .+ ([email protected]( '()a&.$b,A%.% 123,4`23(+. :2 2(G?)._ :2/ 3.74),S4,C2%

88>8>8 ,-4!&

'/)/ 3.B,2,) +(7 4/GS(7 :6,+,Q/).G(7 +/ 4(+.44,C2 +5.%:&%

'(3.G(7 3.B,2,) 4/GS(7 4(2 +(7 G=6(3(7 7,E:,.26.7j

• J33J+B/2:G.),4(j J\/3. :2 4/GS( 3. 6,S( /+B/2:G=),4(%

• J33W((+./2(j J\/3. :2 4/GS( /+B/2:G=),4( 3. +(2E,6:3 8 4/)`46.)b 4(2 +(7 -/+().7-`+,3(7 HkK.7UHDK(%

• J335/26,3/3j 3.B,2. :2 4/GS( 3. 6,S( 4/26,3/3%

• J331GS()6.j 4)./ :2 4/GS( .2 +/ 6/?+/ 3. 6,S( ,GS()6.%

• J33').4,(j 3.B,2. :2 4/GS( 3. 6,S( S).4,(%

• J33Z.4Y/j 3.B,2. :2 4/GS( 3. 6,S( B.4Y/%

• J33s()/j 3.B,2. :2 4/GS( 3. 6,S( Y()/%


70/71


71/71

! " # $ ! % & ' ( ) + $ , - . / ! $ 0

7 T+ ([email protected]( '()(;#5!" 2( .76/ S.27/3( S/)/ )./+,Q/) /44,(2.7 .2 +/ ?/7. 3. 3/6(7 B:.)/ 3. +(7B()G:+/),(7 3. 6,S( +!$-FWW IS/)/ /\/3,)+(7 .2 .+ ([email protected]( F,#,A,&.K% '/)/ )./+,Q/) .76. 6,S(

/44,(2.7 7. 3.?. :6,+,Q/) +/ B:24,C2 !"#$!%&'()>F!(;#5!"%

88>L ,#.C!$^,&p ;!"&2%#,& 4$.:.U5"5:,&p Ao&S2.:,&U!$-,#.,:,&

'(3.G(7 /\/3,) 4(27:+6/7 S).3.B,2,3/7b _ ?a79:.3/7 B()G/6./3/7 S)(S,/7 3. IJ'% '/)/ .++(3.?.).G(7 /\/3,) S),G.)( :2/ 4/6.E()f/% P6,+,Q/).G(7 .+ ([email protected]( '()j2.$X,#.C!$5.& ,23,4/23( :2 2(G?).%

M/ .76):46:)/ 3. .76(7 ([email protected](7 .2 IJ' .7 +/ 7,E:,.26.j

88>L>8 !"&2%#,& 4$.:.U5"5:,&

A.73. .+ G=6(3( (::j2.$X 3.+ ([email protected]( '()j2.$X,#.C!$5.& 4)./).G(7 :2/ 4(27:+6/S).3.B,2,3/ 3. IJ' 3. 6,S( '()a&.$j2.$X% A.?.).G(7 ,23,4/)+. :2 2(G?). / +/ 4(27:+6/ _ +/7.26.24,/ IhM / [email protected]:6/)%

'(3).G(7 /\/3,) /+ ([email protected]( '()a&.$j2.$X ?a79:.3/7 B()G/6./3/7 3. IJ'%

88>L>@

fo&S2.:,& U!$-,#.,:,&'/)/ /\/3,) ?a79:.3/7 B()G/6./3/7 S)(S,/7 3. IJ' W:7,2.77 *2. 2.4.7,6/).G(7 /\/3,)+/73.73. .+ ([email protected]( '()a&.$j2.$X% 5(2 .+ G=6(3( (::+!$-,#.:'.,$;] /7,E2/).G(7 .76/7?a79:.3/7 / +/7 4(27:+6/7 3. IJ'%

5/6.E()f/7

5(27:+6/7 S).3.B,2,3/7

Wa79:.3/7 B()G/6./3/7

myslide.es manual de programador controlssap

Documents