add new column in the account

i-dcar
2004-09-29
2013-05-02
  • i-dcar
    i-dcar
    2004-09-29

    hello everybody..

    i have a problem. actually i want to include one more column "approveQty" in the account table. there is anybody know how to create this new column in the accounting part and how to parse this parameter from invoice during posting.
    if i want to modify the source code which package i can find the source code.

    tq,

    i-dcar

     
    • Redhuan D. Oon
      Redhuan D. Oon
      2004-09-30

      Hi i-dcar,
      You have an interesting case scenario. THere maybe more than one way to solve it, and not necessary to tamper with the FACT_ACCT detail table.
      You may just use the Invoice table where the extra field is needed.
      What u want to do seems to be extracting that info out during accounts reporting.
      Perhaps jsut a view query on the FACT_ACCT with an inner join to the Invoice table will do (look for a similar relationship IDs to tie correctly).
      Thus u may not even touch the codes which are dangerous. *coughs*
      But if u still want to, the codes handling FACT_ACCT passing are in the DOC_*. classes.
      You can refer more info from our compilo document at http://sourceforge.net/projects/compilo

      I also answered your USER1_ID, and USER2_ID questions in the accounting chat.

      regards
      "in the name of the Master"
      red1