set_gifi_to_chart_of_accounts
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | set_gifi_to_chart_of_accounts [2016/08/21 19:50] (current) – created sweitmann | ||
---|---|---|---|
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