Monday, February 23, 2015

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"

No comments:

Post a Comment