<>3- ,33PL2SQL - RETRIEVE 3PL API QUERY INTO MSSQL3 " $.ReadOnly.CustomerId, .CompanyInfo.CompanyName, .PrimaryContact.Name, .PrimaryFacilityIdentifier.Name, .PrimaryFacilityIdentifier.Id6CUSTID,CompanyName,ContactName,FacilityName,FacilityIdz/customers?pgsiz=99@@(R$$JSBFI_,.tpl1, `*$p$,p q+R$$AXSUMb,.tpl1, c,R$$JCUSTT,.tpl1, U-R$$CCSMSV,.tpl1, W/S$$TSS3PL,.tpl1, 0Z$$ gl_ax_convert,.tpl1, 2R$$AXINVr,.tpl1, s4R$$CH3PLw,.tpl1, x5W$;TRANSID|CUSTID|TSSCUST|WHSETRANSTYPE|PEREND|QTY|SKU|ITEMID| 09<$%' $otherhead>A+$G' pagetitle3PLC API to MS SQLFw$<5 P@@R"$#400$8003for popupsZ$SUBFUNC[\5$-]A$-9a!$ &PGMFUNC=CALL۩#i:$ -###,###,##0" -$#####0.00( -######0.00j-$.-$###,###.0000;-###,###,##0.00k'$D-###,###,###.00E-######0A$td class="td" <>< nowrap>3L3---------- handle customersV$ dbo.CUSTOMERS`$ .ResourceListyl@3T=$0ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#V$X"Y YE2^ ERRORPAGE3-------- EMAIL ERROR MESSAGE+$1'WFDIRtmp/000_last_error.txt,O_CREATE,O_TRUNC1=$0ERROR ۩(Ө AT LINE ۩(Ө" IN ۩# L0E$21$3' error_email40(JBMAILTO3546728@ }$q
Order is not valid. Click and fix the problem(s).#(U 39000 OUTTA HERE#<$
C
#F $&N /3--- export AXINV to MSSQL - with related JCUSTN%$ dbo.INVOICESN*R$$JCUSTT,.tpl1, UN4R$$AXINVr,.tpl1, sN>:$2INV,CUSTID,PEREND,CREATED,APPROVED,APPBY,INV_TOTALN@ N 1rsN1TJ1@NUN @201901NN @NN/@t @ @N$@@t@@N$@@@@N$@@@@N $@0O@OBNy#3---------- get ITEMID and store ity3${FILENAMEGET3PLCzGET{|yy$}y z0y$[۩(}]y$U$|z | |z$z;I$ClassificationClass IdentifierIdz< $z=^$OptionsOpt PackageUnitPkImperialz? zD7$ | U$" zb${ 3{ $@|83----- end of cloop|B $}}y|3----|8UV$`<$'WFDIR tmp/3plget0_۩(Өө.jsonj $~ >  2>&1t(3A=SCALL("echo -e ""\n\n"" >>"+OUTFILE$)~$$,3^1001B?3^100n8 U3--------$A3LET J=UNT; OPEN (J)"&1"*3READ RECORD(J,SIZ=99999)JQOUT$; CLOSE (J)($~cat { | jq -c '' U$*8)U3GET THE CUST/PERIOD TOTALS FROM AXSUM$SE$SS Invoice Customer Period Brand Service Description )    Rate    '   Qty    *   Charge    GL Code1 Source AX GL AX Dim 1 AX Dim 2 1b@a& s s1r@as$QPR'1b<c @d@e@a<&1TJ1@aU0 $RR:& @mOA$QQ@gND @fS $PP@gl @i@j@g$@k$SS @t @a  @l @m @n @k @o ۩(@g-$###,###,###.00 @h @f ><3doneF$SS
 8@/340000 " TURN TEMPLATED VAR INTO COLUMNS VALUESJ&$ ,T/ N[۩(]:c(32*)$ ^$h r$ @|O$' /$V@(Өө@A$@,۫ө@,* dbo.CH3PLq$ DELETE FROM  WHERE TRANSID = '۩@' AND WHSETRANSPRICECALCID = '۩@'; Z dbo.SKUINFOC$ DELETE FROM  WHERE ITEMID = '۩@'; X$ INSERT INTO  ( ) VALUES ();@MSSQL1SQLPROD.CHAMPLOG.COM WMSReports$CC  89U 3^1000 "----- PARAMETERS TO START AUTO ORDER PROCESS$A: 8pt;$ reportparamK$/=
 K$>C $>]$ RO3LET DOCUST$="17"; LET CUSTNOTE$="3PLC Account forced to '17' until production"WL$%f3RESULT1$=""; GOTO 43210 $)8 , utsub.wbb)> SELECTED>#$ $$E$ &$' 9 :$) $?
Customer@ Year+Month@Assign/BIND Invoice? 

		 ) $
8P vZ&$v|:C(1*=),n8x]ô vþ$$v8(]  !$ $+$< width="۩(">8"], 6! $ @8J]T ^,$ $
h8r]| Ć ĚĐ/$//Ě8Ĥ]Į ĸ$"",8]( $, ۩5$۩ ۩ 8] $ ($ܨ8] $$$ө8&]D N# $JŞS$./X( K M:N(1*=47),D:N(1*=47),Y:N(1*=47)b($K/// @L $@L@Lg$M@L@N@OŔl$J M%Y%Mz%DzŔŀŞŔ $JŞ8Jţ]Ũ< // Ų vż$vv' 8v] ? #pH vW$vv$vv WAREHOUSEWHSEvv TRANSACTIONTRANSP$v.,$,||:C(1*),8]8  B3$?L3$?V$ ǜ^$ ǜǰn$
SHOWING  B$ Excel ǰ`$ f$ONCLICK ?$ )" @$ө'thcolor $#FFFFFFc$ǜ^$ǜǰn$
SHOWING  B$Excelǰ`$f$ONCLICK ?$)"@$ө'thcolor $#FFFFFFc$