FrontAccounting forum — Journal Entry From External Application

Re: Journal Entry From External Application

2008-01-30T16:34:38Z

Yes I think you are right. Please do not try this on serious data. Make a dummy company before you try this out.

/Joe

Re: Journal Entry From External Application

2008-01-30T16:00:46Z

joe wrote:

Generally speaking, you have to update the table gl_trans (possible with a leading prefix like 0_). But you have to ensure that the dates are inside the fiscal year, that the account exist in chart_master table, that you understand the journal type no's. Look in the database with a tool to see the types and finally you should download the modules Import Items and Import Customers to get an idea of how to write the module.
Or if this seems too difficult, you could try to get another person to write this. Use the specific forum for this.
Joe

When i try to entry journal sample data, i see some tables are update. The updated tables is refs, sys_types, gl_trans and comments (possible with a leading prefix like 0_). am i right ? if my prediction is right, i will write some script to update that tables. and follow FA System.

Re: Journal Entry From External Application

2008-01-30T08:59:15Z

Generally speaking, you have to update the table gl_trans (possible with a leading prefix like 0_). But you have to ensure that the dates are inside the fiscal year, that the account exist in chart_master table, that you understand the journal type no's. Look in the database with a tool to see the types and finally you should download the modules Import Items and Import Customers to get an idea of how to write the module.
Or if this seems too difficult, you could try to get another person to write this. Use the specific forum for this.

Joe

Journal Entry From External Application

2008-01-30T04:24:37Z

How if i want make automatic journal from another aplication?What tables must i update and insert? tanks