User Tools

Site Tools


set_gifi_to_chart_of_accounts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

set_gifi_to_chart_of_accounts [2016/08/21 19:50] (current)
sweitmann created
Line 1: Line 1:
 +Delete old gifi accounts if any
  
 +    delete from gifi; 
 +
 +Copy chart of accounts to gifi chart of accounts
 +
 +    insert into gifi (accno, description) select accno, description from chart; ​
 +
 +update chart and set gifi account to account number ​   ​
 +
 +    update chart set gifi_accno=accno; ​
set_gifi_to_chart_of_accounts.txt ยท Last modified: 2016/08/21 19:50 by sweitmann