Posting Script

AP



"Usage: ap_post company transid dbtrans doctype display DB=dbname"

        DISPLAY "    where company     - company_id"

        DISPLAY "          transid     - transaction id"

        DISPLAY "          dbtrans     - 0=OFF, 1=ON"

        DISPLAY "          doctype     - ADJ/CRN/INV/PAY/DRN"

        DISPLAY "          display     - 0=OFF, 1=ON"

        DISPLAY "          dbname      - database name"



e.g

         i.      AP Inv à run ap_post UPM 000324 1 INV 0 DB=umplive

        ii.      CRN à run ap_post UPM 000324 1 CRN 0 DB=umplive

      iii.      AP Pay à run ap_post UPM 000324 1 PAY 0 DB=umplive

      iv.      AP Adj à run ap_post UPM 000324 1 ADJ 0 DB=umplive

---------------------------------------------------------------------------------



AR



"Usage: ar_post company transid dbtrans doctype display DB=dbname"

        DISPLAY "    where company     - company_id"

        DISPLAY "          transid     - transaction id"

        DISPLAY "          dbtrans     - 0=OFF, 1=ON"

        DISPLAY "          doctype     - ADJ/CRN/INV/CSH/DRN/DEP"

        DISPLAY "          display     - 0=OFF, 1=ON"

        DISPLAY "          dbname      - database name"

        SLEEP 4

        CALL gp_exitprog("ar_post")



e.g

                     i.      AR Csh – run ar_post UPM 000324 1 CSH 0 DB=umplive



---------------------------------------------------------------------------------



BI



"Usage: bi_post company postid dbtrans doctype display DB=dbname"

        DISPLAY "    where company     - company_id"

        DISPLAY "          postid      - postid id or \"ALL\" "

        DISPLAY "          dbtrans     - 0=OFF, 1=ON"

        DISPLAY "          doctype     - INV/CRN"

        DISPLAY "          display     - 0=OFF, 1=ON"

        DISPLAY "          dbname      - database name"

        SLEEP 4

        CALL gp_exitprog("bi_post")



e.g

                     i.      AR Billing Invoice à run bi_post UPM 0001432 1 INV 0 DB=upmlive



---------------------------------------------------------------------------------



GL



"Usage: gl_post journal dbtrans display DB=dbname"

        DISPLAY "    where journal     - [journal id|YREND|RECLOSE|ALL]"

        DISPLAY "          dbtrans     - 0=OFF, 1=ON"

        DISPLAY "          display     - 0=OFF, 1=ON"

        DISPLAY "          approved    - 0=OFF, 1=ON (optional)"

        DISPLAY "          dbname      - database name"

        SLEEP 4

        CALL gp_exitprog("gl_post")

grun gl_post <ID> 1 0 0 DB=lzslive

---------------------------------------------------------------------------------



CB



"Usage: cb_post company_code transid dbtrans doctype display DB=dbname"

        DISPLAY "    where company     - company code"

        DISPLAY "          batchid     - [transaction id|ALL]"

        DISPLAY "          dbtrans     - 0=OFF, 1=ON"

        DISPLAY "          doctype     - PAY/CSH/ADJ"

        DISPLAY "          display     - 0=OFF, 1=ON"

        DISPLAY "          dbname      - database name"

        SLEEP 4

        CALL gp_exitprog("cb_post")



e.g

                     i.      CB Receipt à run cb_post 0032 0001234 1 CSH 0 DB=upmlive

---------------------------------------------------------------------------------


"Usage: pu_ordcmt company ordid dbtrans display DB=dbname"
            DISPLAY "    where company     - company_id"
            DISPLAY "          ordid       - purchase order"
            DISPLAY "          dbtrans     - 0=OFF, 1=ON"
            DISPLAY "          display     - 0=OFF, 1=ON"
            DISPLAY "          DB=dbname   - database name"


------------------------------------------------------------------------------------

usage of bc_adjustment post

run bc_adjpost batchid ADJ 1 0 DB=uji74


-------------------------------------------------------------------------------------

run mj_post AGI ALL MYR 1 0 DB=lzslive

DISPLAY "Usage: mj_post company journal currency dbtrans display DB=dbname"
DISPLAY "    where company     - company_id"
DISPLAY "          journal     - journal id"
DISPLAY "          curcode     - currency code"
DISPLAY "          dbtrans     - 0=OFF, 1=ON"
DISPLAY "          display     - 0=OFF, 1=ON"
DISPLAY "          dbname      - database name"

While Loop Sample in Jitterbit

<trans>

$BatchNo=DbExecute("<TAG>MFUND-CBRCP/Sources/kwaplive</TAG>",

"Select cbrb_batchid 

from cb_rcptbatch 

where cbrb_batchtot = 1 

and cbrb_batchid matches 'MF*'");

$No_of_Batch = Length($BatchNo);

$i=0;

while($i<$No_of_Batch,

$BatchTotal=DbExecute("<TAG>MFUND-CBRCP/Sources/kwaplive</TAG>",

"Select sum(cbrh_amount) 

from cb_rcpthdr 

where cbrh_batchid '"+trimchars($BatchNo[$i],"{}")+"'");

$SumAmount=trimchars($BatchTotal,"{}");

DbExecute("<TAG>MFUND-CBRCP/Targets/kwaplive</TAG>",

"update cb_rcptbatch  

set cbrb_batchtot = "+$SumAmount+", 

cbrb_usrctltot = "+$SumAmount+" 

where cbrb_batchid = '"+trimchars($BatchNo[$i],"{}")+"'");

$i=$i+1

)

</trans>