how to import transactions from Excel to webERP

View: New views

2 Messages — Rating Filter: Alert me

how to import transactions from Excel to webERP

by Pak Ricard :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi.

We are moving part of our real accounting to webERP and have a bunch of transactions recorded in an excel file (all against a bank account). For legal reasons we need to show the detail, so it’s not an option to just post today’s status for all accounts.

We plan to import all these tx’s to weberp, so we are preparing a script to do so.

Excel contains:

Date, GL account number, amount, currency, description notes

Is it Ok to import this data to gltrans and later on run Z_RePostGLFromPeriod and adjust then the systypes counters properly?

Any other detail we are (for sure) missing somewhere?

Thanks,

Ricard

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: how to import transactions from Excel to webERP

by Phil Daintree-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Just general ledger transactions?
Yes rerun Z_RePostGLFromPeriod.php will repost everything

Importing open items into debtortrans, supptrans is easy since the
balances are calculated from the open items directly.

Phil
Pak Ricard wrote:

> Hi.
>
>
>
> We are moving part of our real accounting to webERP and have a bunch of
> transactions recorded in an excel file (all against a bank account). For
> legal reasons we need to show the detail, so it’s not an option to just
> post today’s status for all accounts.
>
>
>
> We plan to import all these tx’s to weberp, so we are preparing a script
> to do so.
>
>
>
> Excel contains:
>
> Date, GL account number, amount, currency, description notes
>
>
>
> Is it Ok to import this data to gltrans and later on run
> Z_RePostGLFromPeriod and adjust then the systypes counters properly?
>
>
>
> Any other detail we are (for sure) missing somewhere?
>
>
>
>
>
> Thanks,
>
> Ricard
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers