Mailing-List: contact ofbiz-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ofbiz-user@incubator.apache.org
Mime-Version: 1.0 (Apple Message framework v752.2)
In-Reply-To: <9958e20d0610031355s527272b1oa0a879931c00a7e1@mail.gmail.com>
References: <9958e20d0610021251r4a78e9cdw908027c66d02f608@mail.gmail.com>
 <23CEFACD-0AD2-4450-B869-295043410BB0@opensourcestrategies.com>
 <9958e20d0610031355s527272b1oa0a879931c00a7e1@mail.gmail.com>
Content-Type: multipart/alternative; boundary=Apple-Mail-56--844146351
Message-Id: <121E85B2-E9CE-4926-88F7-9BB680BAB7E1@opensourcestrategies.com>
From: Si Chen <sichen@opensourcestrategies.com>
Subject: Re: Accounting configuration
Date: Wed, 4 Oct 2006 14:59:23 -0700
To: ofbiz-user@incubator.apache.org

--Apple-Mail-56--844146351
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=ISO-8859-1;
	delsp=yes;
	format=flowed

David,

The setup of the accounts payable could be accomplished by adding a =20
PartyGlAccountTypeSetting or some kind of entity and then adding a =20
simple Util method to check it.  This should be pretty easy to do.  I =20=

don't really have this planned, but if you'd like to work on it, I =20
can help you.

The foreign exchange matching is not something that is supported =20
right now.  Again, if you'd like to work on it, I can help you with =20
it.  It would be a good feature to have and, in my opinion, maybe a =20
little harder but also higher priority than the other task.

Also, since the financials module is not officially a part of ofbiz, =20
maybe we should discuss it here instead:
http://sourceforge.net/forum/forum.php?forum_id=3D540292


Si

On Oct 3, 2006, at 1:55 PM, David Zelaya Herrera wrote:

> Si,
>
> Thanks for the answer, that idea looks good to me.
> I comment to you that for the Peruvian accounting we need to credit to
> different payables accounts, the choice of the account is based in the
> supplier country and the currency. This distinction (of supplier =20
> country and
> currency) helps us to know which accounts need an adjustment for =20
> exchange
> rates. That takes me to another question. Where and when opentaps =20
> calculates
> the gained or lost amount for the exchange rates?
>
> For example if I have the next transactions:
>
> Purchase invoice 10001 for the amount of 10000 euros. (03/10/2006 =20
> Exchange
> rates from currency EUR to currency USD is 1.288)
>
> Dr. Uninvoiced Item Receipts
> Cr. Accounts Payable (10000 EUR x 1.288 =3D 12880 dollars)
>
> Pay to purchase invoice 10001 (12/12/2006 Exchange rates from =20
> currency EUR
> to currency USD is 1.088)
>
>
> Dr. Accounts Payable (10000 EUR x 1.088 =3D 10880 dollars)
> Cr. Payment Method GL account
>
> My account payable was 12880 dollars and I paid 10880 dollars, I =20
> gained 2000
> dollars for the exchange rates. Where can I do this operation in =20
> opentaps?
>
>
>
>
> 2006/10/2, Si Chen <sichen@opensourcestrategies.com >:
>>
>> The functionality you're referring to is actually part of the
>> opentaps financials module which is fully compatible with OFBiz.
>>
> Right now, purchase invoices are only credited to the configured
>> Accounts Payable account.  If you want to credit to different
>> payables accounts... the only idea I have right now is to extend the
>> general ledger posting routine to create another invoice item type
>> which posts to another accounts payable account.  This is fairly easy
>> to do actually, since the ledger posting stuff is very modular.  Of
>> course, if you have any other suggestions, I'd be happy to consider
>> them as well.
>>
>> We're planning a lot for the financials module right now.  You can
>> see most of it here: http://www.opensourcestrategies.com/ofbiz/
>> ofbiz_development_roadmap.php
>>
>> Si
>>
>>
>> On Oct 2, 2006, at 12:51 PM, David Zelaya Herrera wrote:
>>
>> > Hello everybody,
>> >
>> > Some friends and I want to implement the ofbiz in some companies in
>> > Per=FA
>> > (Latin Am=E9rica). I am studying the accounting component and I =
have
>> > some
>> > questions about the accounting configuration.
>> >
>> > When the invoice is marked Ready, the following entries are posted:
>> >
>> > Dr. Uninvoiced Item Receipts (A)
>> > Dr. Purchase Price Variance (Expense account), if any (B)
>> > Cr. Accounts Payable (C)
>> >
>> > I can get (A) and (B) of four ways (InvoiceItemType,
>> > InvoiceItemTypeGlAccount, GlAccountTypeDefault, ProductGlAccount).
>> > But I
>> > only can get (C) of one way (GlAccountTypeDefault).
>> >
>> > So, if I have in GlAccountTypeDefault somethings like this:
>> >
>> > glAccountTypeId =3D ACCOUNTS_PAYABLE
>> > organizationPartyId =3D Company
>> > glAccountId =3D 211000 (Account payable - merchandise)
>> >
>> > When the invoice is marked ready (C) is always going to be equals
>> > to 211000.
>> > What can I do if in some cases I want (C) to be equals to 211000
>> > (Account
>> > payable - merchandise) and anothers cases 212000 (Account payable -
>> > operating)? I also want to know what new features are coming out to
>> > accounting component?.
>> >
>> > Thanks in advance,
>> >
>> >
>> > David Zelaya Herrera
>>
>>
>
>
> --=20
> David Zelaya Herrera

Best Regards,

Si
sichen@opensourcestrategies.com


--Apple-Mail-56--844146351--