You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by snowch <sn...@coralms.com> on 2009/07/29 09:54:20 UTC
r9.04 posting unreconciled transactions.
In r9.04 it is possible to post unreconciled transactions. The transaction
have to be reverted to be reconciled. Is this the desired functionality?
--
View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24714238.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: r9.04 posting unreconciled transactions.
Posted by snowch <sn...@coralms.com>.
I have been bitten in the past offering cutting edge software to my
customers. When things have gone wrong, I have had to expend a lot of
resources (which I don't have) fixing bugs!
Perhaps the way forward is for me to use trunk for my own internal
systems...
Ashish Vijaywargiya-5 wrote:
>
> Regarding to next major release branch:
> Nothing is decided yet in this area but probably it will come at around
> March- April of next year, but I am not sure about this.
> Just so you know the release branch 9.04 came into existence after two
> years from that of release branch 4.0.
>
> So we can't say about the exact date and time at this moment.
> Why you don't want to go with the trunk?
>
> --
> Regards
> Ashish Vijaywargiya
>
> http://www.hotwaxmedia.com
> "Helping hand around the world"
>
>
> snowch wrote:
>> I don't have specific requirements for accounting functionality at the
>> moment, but my market is SME's who would probably want ofbiz to run their
>> whole business - e.g. replacing their quickbooks software, and then me
>> developing custom components for their niche needs.
>>
>> I would feel a bit nervous going with trunk for new features. When is
>> the
>> next major release of ofbiz planned?
>>
>>
>> Ashish Vijaywargiya-5 wrote:
>>
>>> Hello Chris,
>>>
>>> Please see my comments inline:
>>>
>>> --
>>> Regards
>>> Ashish Vijaywargiya
>>>
>>> http://www.hotwaxmedia.com
>>> "Helping hand around the world"
>>>
>>> snowch wrote:
>>>
>>>> Hi Sumit/Sharan,
>>>>
>>>> Would you consider the accounting functionality in 9.04 to be
>>>> production
>>>> ready?
>>>>
>>>>
>>> It depends on individuals need and the business requirements of end
>>> user.
>>> Accounting functionality is quite mature in Release Branch 9.04.
>>>
>>> Couple of work is going on in the area of AR & AP now a days.
>>> So if your requirements is moving around AR & AP then you should opt
>>> trunk revision.
>>>
>>>> What functionality is missing in 9.04 that you would require mandatory
>>>> (e.g.
>>>> ability to reconcile any account)?
>>>>
>>>>
>>> Again it depends.
>>> Please share what you are trying to do with Accounting module.
>>> This will help someone to locate those features if exists in release
>>> branch for you.
>>>
>>>
>>>> Will Sumit's new functionality for accounting that is in trunk be
>>>> back-ported to 9.04?
>>>>
>>>>
>>> Only bug fixes can be back ported to Release Branch 9.04.
>>> So if you want to see the new feature available for you then you should
>>> go with trunk.
>>>
>>>
>>>> Many thanks,
>>>>
>>>> Chris
>>>>
>>>
>>>
>>>
>>
>>
>
>
>
--
View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24736418.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: r9.04 posting unreconciled transactions.
Posted by Jacques Le Roux <ja...@les7arts.com>.
I was not aware about that, where has it been discussed ?
Jacques
From: "snowch" <sn...@coralms.com>
>
> That's excellent news!
>
>
> Ashish Vijaywargiya-5 wrote:
>>
>> I think it will be available in next 2 months. This is the information
>> that I got from my colleague Anil.
>> Community is thinking to go in the way that Ubuntu is going on. Its like
>> release branch in each 6 month.
>>
>> Sorry for giving you the wrong information as I didn't remember the
>> final words from the mailing list.
>>
>> --
>> Regards
>> Ashish Vijaywargiya
>>
>> http://www.hotwaxmedia.com
>> "Helping hand around the world"
>>
>>
>> Ashish Vijaywargiya wrote:
>>> Regarding to next major release branch:
>>> Nothing is decided yet in this area but probably it will come at
>>> around March- April of next year, but I am not sure about this.
>>> Just so you know the release branch 9.04 came into existence after two
>>> years from that of release branch 4.0.
>>>
>>> So we can't say about the exact date and time at this moment.
>>> Why you don't want to go with the trunk?
>>> --
>>> Regards
>>> Ashish Vijaywargiya
>>>
>>> http://www.hotwaxmedia.com
>>> "Helping hand around the world"
>>>
>>>
>>> snowch wrote:
>>>> I don't have specific requirements for accounting functionality at the
>>>> moment, but my market is SME's who would probably want ofbiz to run
>>>> their
>>>> whole business - e.g. replacing their quickbooks software, and then me
>>>> developing custom components for their niche needs.
>>>>
>>>> I would feel a bit nervous going with trunk for new features. When is
>>>> the
>>>> next major release of ofbiz planned?
>>>>
>>>>
>>>> Ashish Vijaywargiya-5 wrote:
>>>>
>>>>> Hello Chris,
>>>>>
>>>>> Please see my comments inline:
>>>>>
>>>>> --
>>>>> Regards
>>>>> Ashish Vijaywargiya
>>>>>
>>>>> http://www.hotwaxmedia.com
>>>>> "Helping hand around the world"
>>>>>
>>>>> snowch wrote:
>>>>>
>>>>>> Hi Sumit/Sharan,
>>>>>>
>>>>>> Would you consider the accounting functionality in 9.04 to be
>>>>>> production
>>>>>> ready?
>>>>>>
>>>>>>
>>>>> It depends on individuals need and the business requirements of end
>>>>> user.
>>>>> Accounting functionality is quite mature in Release Branch 9.04.
>>>>>
>>>>> Couple of work is going on in the area of AR & AP now a days.
>>>>> So if your requirements is moving around AR & AP then you should opt
>>>>> trunk revision.
>>>>>
>>>>>> What functionality is missing in 9.04 that you would require mandatory
>>>>>> (e.g.
>>>>>> ability to reconcile any account)?
>>>>>>
>>>>>>
>>>>> Again it depends.
>>>>> Please share what you are trying to do with Accounting module.
>>>>> This will help someone to locate those features if exists in release
>>>>> branch for you.
>>>>>
>>>>>
>>>>>> Will Sumit's new functionality for accounting that is in trunk be
>>>>>> back-ported to 9.04?
>>>>>>
>>>>>>
>>>>> Only bug fixes can be back ported to Release Branch 9.04.
>>>>> So if you want to see the new feature available for you then you should
>>>>> go with trunk.
>>>>>
>>>>>
>>>>>> Many thanks,
>>>>>>
>>>>>> Chris
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24736496.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: r9.04 posting unreconciled transactions.
Posted by snowch <sn...@coralms.com>.
That's excellent news!
Ashish Vijaywargiya-5 wrote:
>
> I think it will be available in next 2 months. This is the information
> that I got from my colleague Anil.
> Community is thinking to go in the way that Ubuntu is going on. Its like
> release branch in each 6 month.
>
> Sorry for giving you the wrong information as I didn't remember the
> final words from the mailing list.
>
> --
> Regards
> Ashish Vijaywargiya
>
> http://www.hotwaxmedia.com
> "Helping hand around the world"
>
>
> Ashish Vijaywargiya wrote:
>> Regarding to next major release branch:
>> Nothing is decided yet in this area but probably it will come at
>> around March- April of next year, but I am not sure about this.
>> Just so you know the release branch 9.04 came into existence after two
>> years from that of release branch 4.0.
>>
>> So we can't say about the exact date and time at this moment.
>> Why you don't want to go with the trunk?
>> --
>> Regards
>> Ashish Vijaywargiya
>>
>> http://www.hotwaxmedia.com
>> "Helping hand around the world"
>>
>>
>> snowch wrote:
>>> I don't have specific requirements for accounting functionality at the
>>> moment, but my market is SME's who would probably want ofbiz to run
>>> their
>>> whole business - e.g. replacing their quickbooks software, and then me
>>> developing custom components for their niche needs.
>>>
>>> I would feel a bit nervous going with trunk for new features. When is
>>> the
>>> next major release of ofbiz planned?
>>>
>>>
>>> Ashish Vijaywargiya-5 wrote:
>>>
>>>> Hello Chris,
>>>>
>>>> Please see my comments inline:
>>>>
>>>> --
>>>> Regards
>>>> Ashish Vijaywargiya
>>>>
>>>> http://www.hotwaxmedia.com
>>>> "Helping hand around the world"
>>>>
>>>> snowch wrote:
>>>>
>>>>> Hi Sumit/Sharan,
>>>>>
>>>>> Would you consider the accounting functionality in 9.04 to be
>>>>> production
>>>>> ready?
>>>>>
>>>>>
>>>> It depends on individuals need and the business requirements of end
>>>> user.
>>>> Accounting functionality is quite mature in Release Branch 9.04.
>>>>
>>>> Couple of work is going on in the area of AR & AP now a days.
>>>> So if your requirements is moving around AR & AP then you should opt
>>>> trunk revision.
>>>>
>>>>> What functionality is missing in 9.04 that you would require mandatory
>>>>> (e.g.
>>>>> ability to reconcile any account)?
>>>>>
>>>>>
>>>> Again it depends.
>>>> Please share what you are trying to do with Accounting module.
>>>> This will help someone to locate those features if exists in release
>>>> branch for you.
>>>>
>>>>
>>>>> Will Sumit's new functionality for accounting that is in trunk be
>>>>> back-ported to 9.04?
>>>>>
>>>>>
>>>> Only bug fixes can be back ported to Release Branch 9.04.
>>>> So if you want to see the new feature available for you then you should
>>>> go with trunk.
>>>>
>>>>
>>>>> Many thanks,
>>>>>
>>>>> Chris
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>
>
>
--
View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24736496.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: r9.04 posting unreconciled transactions.
Posted by Ashish Vijaywargiya <as...@hotwaxmedia.com>.
I think it will be available in next 2 months. This is the information
that I got from my colleague Anil.
Community is thinking to go in the way that Ubuntu is going on. Its like
release branch in each 6 month.
Sorry for giving you the wrong information as I didn't remember the
final words from the mailing list.
--
Regards
Ashish Vijaywargiya
http://www.hotwaxmedia.com
"Helping hand around the world"
Ashish Vijaywargiya wrote:
> Regarding to next major release branch:
> Nothing is decided yet in this area but probably it will come at
> around March- April of next year, but I am not sure about this.
> Just so you know the release branch 9.04 came into existence after two
> years from that of release branch 4.0.
>
> So we can't say about the exact date and time at this moment.
> Why you don't want to go with the trunk?
> --
> Regards
> Ashish Vijaywargiya
>
> http://www.hotwaxmedia.com
> "Helping hand around the world"
>
>
> snowch wrote:
>> I don't have specific requirements for accounting functionality at the
>> moment, but my market is SME's who would probably want ofbiz to run their
>> whole business - e.g. replacing their quickbooks software, and then me
>> developing custom components for their niche needs.
>>
>> I would feel a bit nervous going with trunk for new features. When is the
>> next major release of ofbiz planned?
>>
>>
>> Ashish Vijaywargiya-5 wrote:
>>
>>> Hello Chris,
>>>
>>> Please see my comments inline:
>>>
>>> --
>>> Regards
>>> Ashish Vijaywargiya
>>>
>>> http://www.hotwaxmedia.com
>>> "Helping hand around the world"
>>>
>>> snowch wrote:
>>>
>>>> Hi Sumit/Sharan,
>>>>
>>>> Would you consider the accounting functionality in 9.04 to be production
>>>> ready?
>>>>
>>>>
>>> It depends on individuals need and the business requirements of end user.
>>> Accounting functionality is quite mature in Release Branch 9.04.
>>>
>>> Couple of work is going on in the area of AR & AP now a days.
>>> So if your requirements is moving around AR & AP then you should opt
>>> trunk revision.
>>>
>>>> What functionality is missing in 9.04 that you would require mandatory
>>>> (e.g.
>>>> ability to reconcile any account)?
>>>>
>>>>
>>> Again it depends.
>>> Please share what you are trying to do with Accounting module.
>>> This will help someone to locate those features if exists in release
>>> branch for you.
>>>
>>>
>>>> Will Sumit's new functionality for accounting that is in trunk be
>>>> back-ported to 9.04?
>>>>
>>>>
>>> Only bug fixes can be back ported to Release Branch 9.04.
>>> So if you want to see the new feature available for you then you should
>>> go with trunk.
>>>
>>>
>>>> Many thanks,
>>>>
>>>> Chris
>>>>
>>>
>>>
>>>
>>
>>
Re: r9.04 posting unreconciled transactions.
Posted by Ashish Vijaywargiya <as...@hotwaxmedia.com>.
Regarding to next major release branch:
Nothing is decided yet in this area but probably it will come at around
March- April of next year, but I am not sure about this.
Just so you know the release branch 9.04 came into existence after two
years from that of release branch 4.0.
So we can't say about the exact date and time at this moment.
Why you don't want to go with the trunk?
--
Regards
Ashish Vijaywargiya
http://www.hotwaxmedia.com
"Helping hand around the world"
snowch wrote:
> I don't have specific requirements for accounting functionality at the
> moment, but my market is SME's who would probably want ofbiz to run their
> whole business - e.g. replacing their quickbooks software, and then me
> developing custom components for their niche needs.
>
> I would feel a bit nervous going with trunk for new features. When is the
> next major release of ofbiz planned?
>
>
> Ashish Vijaywargiya-5 wrote:
>
>> Hello Chris,
>>
>> Please see my comments inline:
>>
>> --
>> Regards
>> Ashish Vijaywargiya
>>
>> http://www.hotwaxmedia.com
>> "Helping hand around the world"
>>
>> snowch wrote:
>>
>>> Hi Sumit/Sharan,
>>>
>>> Would you consider the accounting functionality in 9.04 to be production
>>> ready?
>>>
>>>
>> It depends on individuals need and the business requirements of end user.
>> Accounting functionality is quite mature in Release Branch 9.04.
>>
>> Couple of work is going on in the area of AR & AP now a days.
>> So if your requirements is moving around AR & AP then you should opt
>> trunk revision.
>>
>>> What functionality is missing in 9.04 that you would require mandatory
>>> (e.g.
>>> ability to reconcile any account)?
>>>
>>>
>> Again it depends.
>> Please share what you are trying to do with Accounting module.
>> This will help someone to locate those features if exists in release
>> branch for you.
>>
>>
>>> Will Sumit's new functionality for accounting that is in trunk be
>>> back-ported to 9.04?
>>>
>>>
>> Only bug fixes can be back ported to Release Branch 9.04.
>> So if you want to see the new feature available for you then you should
>> go with trunk.
>>
>>
>>> Many thanks,
>>>
>>> Chris
>>>
>>
>>
>>
>
>
Re: r9.04 posting unreconciled transactions.
Posted by snowch <sn...@coralms.com>.
I don't have specific requirements for accounting functionality at the
moment, but my market is SME's who would probably want ofbiz to run their
whole business - e.g. replacing their quickbooks software, and then me
developing custom components for their niche needs.
I would feel a bit nervous going with trunk for new features. When is the
next major release of ofbiz planned?
Ashish Vijaywargiya-5 wrote:
>
> Hello Chris,
>
> Please see my comments inline:
>
> --
> Regards
> Ashish Vijaywargiya
>
> http://www.hotwaxmedia.com
> "Helping hand around the world"
>
> snowch wrote:
>> Hi Sumit/Sharan,
>>
>> Would you consider the accounting functionality in 9.04 to be production
>> ready?
>>
> It depends on individuals need and the business requirements of end user.
> Accounting functionality is quite mature in Release Branch 9.04.
>
> Couple of work is going on in the area of AR & AP now a days.
> So if your requirements is moving around AR & AP then you should opt
> trunk revision.
>> What functionality is missing in 9.04 that you would require mandatory
>> (e.g.
>> ability to reconcile any account)?
>>
> Again it depends.
> Please share what you are trying to do with Accounting module.
> This will help someone to locate those features if exists in release
> branch for you.
>
>> Will Sumit's new functionality for accounting that is in trunk be
>> back-ported to 9.04?
>>
>
> Only bug fixes can be back ported to Release Branch 9.04.
> So if you want to see the new feature available for you then you should
> go with trunk.
>
>> Many thanks,
>>
>> Chris
>
>
>
--
View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24736276.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: r9.04 posting unreconciled transactions.
Posted by Ashish Vijaywargiya <as...@hotwaxmedia.com>.
Hello Chris,
Please see my comments inline:
--
Regards
Ashish Vijaywargiya
http://www.hotwaxmedia.com
"Helping hand around the world"
snowch wrote:
> Hi Sumit/Sharan,
>
> Would you consider the accounting functionality in 9.04 to be production
> ready?
>
It depends on individuals need and the business requirements of end user.
Accounting functionality is quite mature in Release Branch 9.04.
Couple of work is going on in the area of AR & AP now a days.
So if your requirements is moving around AR & AP then you should opt
trunk revision.
> What functionality is missing in 9.04 that you would require mandatory (e.g.
> ability to reconcile any account)?
>
Again it depends.
Please share what you are trying to do with Accounting module.
This will help someone to locate those features if exists in release
branch for you.
> Will Sumit's new functionality for accounting that is in trunk be
> back-ported to 9.04?
>
Only bug fixes can be back ported to Release Branch 9.04.
So if you want to see the new feature available for you then you should
go with trunk.
> Many thanks,
>
> Chris
Re: r9.04 posting unreconciled transactions.
Posted by Sumit Pandit <su...@hotwaxmedia.com>.
Hi Chris,
Though this is a new functionality/features, which is added into trunk
only. So you can not find these into 9.04.
Only bugs in 9.04 will back-ported from trunk (e.g. it was generating
the error in posting the transactions).
--
Thanks And Regards
Sumit Pandit
On Jul 30, 2009, at 4:10 PM, snowch wrote:
>
> Hi Sumit/Sharan,
>
> Would you consider the accounting functionality in 9.04 to be
> production
> ready?
> What functionality is missing in 9.04 that you would require
> mandatory (e.g.
> ability to reconcile any account)?
> Will Sumit's new functionality for accounting that is in trunk be
> back-ported to 9.04?
>
> Many thanks,
>
> Chris
>
>
> Sumit Pandit-3 wrote:
>>
>>
>> On Jul 30, 2009, at 1:03 PM, Sharan-F wrote:
>>
>>>
>>> Hi Sumit
>>>
>>> Thanks for your reply and your work on accounting! It sounds good -
>>> I'll
>>> take a look on the online demo. I assume this is in the trunk and
>>> not 9.04.
>>>
>>> One comment though - you seem to be describing bank statement
>>> reconciliation
>>> here and not a generic chart of account reconciliation. What I mean
>>> here is
>>> that you may want to reconcile your inventory account or perhaps
>>> some form
>>> of clearing account account etc. Some of these transactions are
>>> driven off
>>> bank account transactions but not all of them. Although I used a
>>> 'bank
>>> statement' as an example in my email the reconciliation process
>>> should be
>>> pretty generic for any type account in the chart of accounts.
>>>
>>> Anyway - I'm keen to take a look and understand what you've done and
>>> see how
>>> this reconciliation process will work. I'll then update the online
>>> documentation to reflect it.
>>
>>
>> Thanks Sharan for this, I really appreciate your efforts and comments
>> for any missing functionality.
>>
>> --
>> Thanks And Regards
>> Sumit Pandit
>>
>>
>>> Thanks
>>> Sharan
>>>
>>>
>>> Sumit Pandit-3 wrote:
>>>>
>>>> Hello sharan,
>>>>
>>>> Please find comments inline -
>>>> On Jul 30, 2009, at 7:45 AM, Sharan-F wrote:
>>>>
>>>>>
>>>>> Hi
>>>>>
>>>>> I've done some work on documenting the OFBiz accounting
>>>>> functionality and
>>>>> yes it does post unreconciled transactions.
>>>> Thanks for the documentation, Please provide link to it, I'll
>>>> bookmark
>>>> it for future reference.
>>>>
>>>>> Whether you allow the system to do this is dependent on what
>>>>> business
>>>>> process you want to implement. Some businesses will do their
>>>>> reconciliations
>>>>> on posted transactions and then do any resulting reversals or
>>>>> adjustments,
>>>>> others may want to reconcile the transactions before they post.
>>>>> I've
>>>>> seen it
>>>>> done both of these ways.
>>>>>
>>>>> I think the question to ask is which way does your business do it
>>>>> now? (And
>>>>> do they want to keep doing it in the future?)
>>>>>
>>>>> From what I've seen of the account reconciliation functionality in
>>>>> OFBiz I
>>>>> personally would say that it's not complete. For example it doesnt
>>>>> show
>>>>> whether its a debit or credit transaction or if the amount to be
>>>>> reconciled
>>>>> is increasing or reducing the balance in account. It also does not
>>>>> 'carry
>>>>> forward' any balance of a previous reconciliation done on an
>>>>> account.
>>>>> I like to think of account reconciliation like a bank statement
>>>>> that
>>>>> you
>>>>> receive each month. It has an opening balance that should be the
>>>>> same as the
>>>>> closing balance of your previous statement. It then shows each
>>>>> transaction
>>>>> as a positive or a negative with a resulting balance on each line
>>>>> and a
>>>>> final closing balance (that will be the start of your next
>>>>> statement).
>>>>
>>>>
>>>> Here is little description of Reconciliation Process -
>>>> When we receive/issue a SENT/RECEIVED payment (by Deposit /
>>>> Withdraw)
>>>> (
>>>> https://localhost:8443/accounting/control/FindPaymentsForDepositOrWithdraw?finAccountId=9000&organizationPartyId=Company
>>>> )
>>>> then it will create an Financial Accounting Transaction in CREATED
>>>> status. (FinAccountTrans in created status means it will not update
>>>> the balance of your FinAccount).
>>>> Then from Bank Reconciliation screen under Transaction tab (
>>>> https://localhost:8443/accounting/control/FindFinAccountTrans?finAccountId=9000
>>>> ), you can reconcile your transaction from bank statement.
>>>> (
>>>> https://localhost:8443/accounting/control/BankReconciliation?finAccountId=9000&statusId=FINACT_TRNS_CREATED
>>>> )
>>>> On select your transaction and click on Reconciliation it will
>>>> update
>>>> set the Fin Account Trans status to APPROVED that means your
>>>> payment
>>>> is deposited/withdraw and it will reflect in your Fin Account
>>>> balance.
>>>>
>>>>
>>>> Also just FYI to verify this process - I am looking for writing a
>>>> JUnit test case for the same process which will verify the
>>>> FinAccount
>>>> balance before and after reconciliation.
>>>>
>>>>
>>>>>
>>>>> Not sure if this was the type of response you were looking for but
>>>>> hope it
>>>>> helps.
>>>>>
>>>>> Thanks
>>>>> Sharan
>>>>>
>>>>>
>>>>> snowch wrote:
>>>>>>
>>>>>> In r9.04 it is possible to post unreconciled transactions. The
>>>>>> transaction have to be reverted to be reconciled. Is this the
>>>>>> desired
>>>>>> functionality?
>>>>>>
>>>>>
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24731123.html
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24733545.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24736036.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: r9.04 posting unreconciled transactions.
Posted by snowch <sn...@coralms.com>.
Hi Sumit/Sharan,
Would you consider the accounting functionality in 9.04 to be production
ready?
What functionality is missing in 9.04 that you would require mandatory (e.g.
ability to reconcile any account)?
Will Sumit's new functionality for accounting that is in trunk be
back-ported to 9.04?
Many thanks,
Chris
Sumit Pandit-3 wrote:
>
>
> On Jul 30, 2009, at 1:03 PM, Sharan-F wrote:
>
>>
>> Hi Sumit
>>
>> Thanks for your reply and your work on accounting! It sounds good -
>> I'll
>> take a look on the online demo. I assume this is in the trunk and
>> not 9.04.
>>
>> One comment though - you seem to be describing bank statement
>> reconciliation
>> here and not a generic chart of account reconciliation. What I mean
>> here is
>> that you may want to reconcile your inventory account or perhaps
>> some form
>> of clearing account account etc. Some of these transactions are
>> driven off
>> bank account transactions but not all of them. Although I used a 'bank
>> statement' as an example in my email the reconciliation process
>> should be
>> pretty generic for any type account in the chart of accounts.
>>
>> Anyway - I'm keen to take a look and understand what you've done and
>> see how
>> this reconciliation process will work. I'll then update the online
>> documentation to reflect it.
>
>
> Thanks Sharan for this, I really appreciate your efforts and comments
> for any missing functionality.
>
> --
> Thanks And Regards
> Sumit Pandit
>
>
>> Thanks
>> Sharan
>>
>>
>> Sumit Pandit-3 wrote:
>>>
>>> Hello sharan,
>>>
>>> Please find comments inline -
>>> On Jul 30, 2009, at 7:45 AM, Sharan-F wrote:
>>>
>>>>
>>>> Hi
>>>>
>>>> I've done some work on documenting the OFBiz accounting
>>>> functionality and
>>>> yes it does post unreconciled transactions.
>>> Thanks for the documentation, Please provide link to it, I'll
>>> bookmark
>>> it for future reference.
>>>
>>>> Whether you allow the system to do this is dependent on what
>>>> business
>>>> process you want to implement. Some businesses will do their
>>>> reconciliations
>>>> on posted transactions and then do any resulting reversals or
>>>> adjustments,
>>>> others may want to reconcile the transactions before they post. I've
>>>> seen it
>>>> done both of these ways.
>>>>
>>>> I think the question to ask is which way does your business do it
>>>> now? (And
>>>> do they want to keep doing it in the future?)
>>>>
>>>> From what I've seen of the account reconciliation functionality in
>>>> OFBiz I
>>>> personally would say that it's not complete. For example it doesnt
>>>> show
>>>> whether its a debit or credit transaction or if the amount to be
>>>> reconciled
>>>> is increasing or reducing the balance in account. It also does not
>>>> 'carry
>>>> forward' any balance of a previous reconciliation done on an
>>>> account.
>>>> I like to think of account reconciliation like a bank statement that
>>>> you
>>>> receive each month. It has an opening balance that should be the
>>>> same as the
>>>> closing balance of your previous statement. It then shows each
>>>> transaction
>>>> as a positive or a negative with a resulting balance on each line
>>>> and a
>>>> final closing balance (that will be the start of your next
>>>> statement).
>>>
>>>
>>> Here is little description of Reconciliation Process -
>>> When we receive/issue a SENT/RECEIVED payment (by Deposit / Withdraw)
>>> (
>>> https://localhost:8443/accounting/control/FindPaymentsForDepositOrWithdraw?finAccountId=9000&organizationPartyId=Company
>>> )
>>> then it will create an Financial Accounting Transaction in CREATED
>>> status. (FinAccountTrans in created status means it will not update
>>> the balance of your FinAccount).
>>> Then from Bank Reconciliation screen under Transaction tab (
>>> https://localhost:8443/accounting/control/FindFinAccountTrans?finAccountId=9000
>>> ), you can reconcile your transaction from bank statement.
>>> (
>>> https://localhost:8443/accounting/control/BankReconciliation?finAccountId=9000&statusId=FINACT_TRNS_CREATED
>>> )
>>> On select your transaction and click on Reconciliation it will update
>>> set the Fin Account Trans status to APPROVED that means your payment
>>> is deposited/withdraw and it will reflect in your Fin Account
>>> balance.
>>>
>>>
>>> Also just FYI to verify this process - I am looking for writing a
>>> JUnit test case for the same process which will verify the FinAccount
>>> balance before and after reconciliation.
>>>
>>>
>>>>
>>>> Not sure if this was the type of response you were looking for but
>>>> hope it
>>>> helps.
>>>>
>>>> Thanks
>>>> Sharan
>>>>
>>>>
>>>> snowch wrote:
>>>>>
>>>>> In r9.04 it is possible to post unreconciled transactions. The
>>>>> transaction have to be reverted to be reconciled. Is this the
>>>>> desired
>>>>> functionality?
>>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24731123.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24733545.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
>
--
View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24736036.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: r9.04 posting unreconciled transactions.
Posted by Sumit Pandit <su...@hotwaxmedia.com>.
On Jul 30, 2009, at 1:03 PM, Sharan-F wrote:
>
> Hi Sumit
>
> Thanks for your reply and your work on accounting! It sounds good -
> I'll
> take a look on the online demo. I assume this is in the trunk and
> not 9.04.
>
> One comment though - you seem to be describing bank statement
> reconciliation
> here and not a generic chart of account reconciliation. What I mean
> here is
> that you may want to reconcile your inventory account or perhaps
> some form
> of clearing account account etc. Some of these transactions are
> driven off
> bank account transactions but not all of them. Although I used a 'bank
> statement' as an example in my email the reconciliation process
> should be
> pretty generic for any type account in the chart of accounts.
>
> Anyway - I'm keen to take a look and understand what you've done and
> see how
> this reconciliation process will work. I'll then update the online
> documentation to reflect it.
Thanks Sharan for this, I really appreciate your efforts and comments
for any missing functionality.
--
Thanks And Regards
Sumit Pandit
> Thanks
> Sharan
>
>
> Sumit Pandit-3 wrote:
>>
>> Hello sharan,
>>
>> Please find comments inline -
>> On Jul 30, 2009, at 7:45 AM, Sharan-F wrote:
>>
>>>
>>> Hi
>>>
>>> I've done some work on documenting the OFBiz accounting
>>> functionality and
>>> yes it does post unreconciled transactions.
>> Thanks for the documentation, Please provide link to it, I'll
>> bookmark
>> it for future reference.
>>
>>> Whether you allow the system to do this is dependent on what
>>> business
>>> process you want to implement. Some businesses will do their
>>> reconciliations
>>> on posted transactions and then do any resulting reversals or
>>> adjustments,
>>> others may want to reconcile the transactions before they post. I've
>>> seen it
>>> done both of these ways.
>>>
>>> I think the question to ask is which way does your business do it
>>> now? (And
>>> do they want to keep doing it in the future?)
>>>
>>> From what I've seen of the account reconciliation functionality in
>>> OFBiz I
>>> personally would say that it's not complete. For example it doesnt
>>> show
>>> whether its a debit or credit transaction or if the amount to be
>>> reconciled
>>> is increasing or reducing the balance in account. It also does not
>>> 'carry
>>> forward' any balance of a previous reconciliation done on an
>>> account.
>>> I like to think of account reconciliation like a bank statement that
>>> you
>>> receive each month. It has an opening balance that should be the
>>> same as the
>>> closing balance of your previous statement. It then shows each
>>> transaction
>>> as a positive or a negative with a resulting balance on each line
>>> and a
>>> final closing balance (that will be the start of your next
>>> statement).
>>
>>
>> Here is little description of Reconciliation Process -
>> When we receive/issue a SENT/RECEIVED payment (by Deposit / Withdraw)
>> (
>> https://localhost:8443/accounting/control/FindPaymentsForDepositOrWithdraw?finAccountId=9000&organizationPartyId=Company
>> )
>> then it will create an Financial Accounting Transaction in CREATED
>> status. (FinAccountTrans in created status means it will not update
>> the balance of your FinAccount).
>> Then from Bank Reconciliation screen under Transaction tab (
>> https://localhost:8443/accounting/control/FindFinAccountTrans?finAccountId=9000
>> ), you can reconcile your transaction from bank statement.
>> (
>> https://localhost:8443/accounting/control/BankReconciliation?finAccountId=9000&statusId=FINACT_TRNS_CREATED
>> )
>> On select your transaction and click on Reconciliation it will update
>> set the Fin Account Trans status to APPROVED that means your payment
>> is deposited/withdraw and it will reflect in your Fin Account
>> balance.
>>
>>
>> Also just FYI to verify this process - I am looking for writing a
>> JUnit test case for the same process which will verify the FinAccount
>> balance before and after reconciliation.
>>
>>
>>>
>>> Not sure if this was the type of response you were looking for but
>>> hope it
>>> helps.
>>>
>>> Thanks
>>> Sharan
>>>
>>>
>>> snowch wrote:
>>>>
>>>> In r9.04 it is possible to post unreconciled transactions. The
>>>> transaction have to be reverted to be reconciled. Is this the
>>>> desired
>>>> functionality?
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24731123.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24733545.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: r9.04 posting unreconciled transactions.
Posted by Sharan-F <sh...@gmail.com>.
Hi Sumit
Thanks for your reply and your work on accounting! It sounds good - I'll
take a look on the online demo. I assume this is in the trunk and not 9.04.
One comment though - you seem to be describing bank statement reconciliation
here and not a generic chart of account reconciliation. What I mean here is
that you may want to reconcile your inventory account or perhaps some form
of clearing account account etc. Some of these transactions are driven off
bank account transactions but not all of them. Although I used a 'bank
statement' as an example in my email the reconciliation process should be
pretty generic for any type account in the chart of accounts.
Anyway - I'm keen to take a look and understand what you've done and see how
this reconciliation process will work. I'll then update the online
documentation to reflect it.
Thanks
Sharan
Sumit Pandit-3 wrote:
>
> Hello sharan,
>
> Please find comments inline -
> On Jul 30, 2009, at 7:45 AM, Sharan-F wrote:
>
>>
>> Hi
>>
>> I've done some work on documenting the OFBiz accounting
>> functionality and
>> yes it does post unreconciled transactions.
> Thanks for the documentation, Please provide link to it, I'll bookmark
> it for future reference.
>
>> Whether you allow the system to do this is dependent on what business
>> process you want to implement. Some businesses will do their
>> reconciliations
>> on posted transactions and then do any resulting reversals or
>> adjustments,
>> others may want to reconcile the transactions before they post. I've
>> seen it
>> done both of these ways.
>>
>> I think the question to ask is which way does your business do it
>> now? (And
>> do they want to keep doing it in the future?)
>>
>> From what I've seen of the account reconciliation functionality in
>> OFBiz I
>> personally would say that it's not complete. For example it doesnt
>> show
>> whether its a debit or credit transaction or if the amount to be
>> reconciled
>> is increasing or reducing the balance in account. It also does not
>> 'carry
>> forward' any balance of a previous reconciliation done on an account.
>> I like to think of account reconciliation like a bank statement that
>> you
>> receive each month. It has an opening balance that should be the
>> same as the
>> closing balance of your previous statement. It then shows each
>> transaction
>> as a positive or a negative with a resulting balance on each line
>> and a
>> final closing balance (that will be the start of your next statement).
>
>
> Here is little description of Reconciliation Process -
> When we receive/issue a SENT/RECEIVED payment (by Deposit / Withdraw)
> (
> https://localhost:8443/accounting/control/FindPaymentsForDepositOrWithdraw?finAccountId=9000&organizationPartyId=Company
> )
> then it will create an Financial Accounting Transaction in CREATED
> status. (FinAccountTrans in created status means it will not update
> the balance of your FinAccount).
> Then from Bank Reconciliation screen under Transaction tab (
> https://localhost:8443/accounting/control/FindFinAccountTrans?finAccountId=9000
> ), you can reconcile your transaction from bank statement.
> (
> https://localhost:8443/accounting/control/BankReconciliation?finAccountId=9000&statusId=FINACT_TRNS_CREATED
> )
> On select your transaction and click on Reconciliation it will update
> set the Fin Account Trans status to APPROVED that means your payment
> is deposited/withdraw and it will reflect in your Fin Account balance.
>
>
> Also just FYI to verify this process - I am looking for writing a
> JUnit test case for the same process which will verify the FinAccount
> balance before and after reconciliation.
>
>
>>
>> Not sure if this was the type of response you were looking for but
>> hope it
>> helps.
>>
>> Thanks
>> Sharan
>>
>>
>> snowch wrote:
>>>
>>> In r9.04 it is possible to post unreconciled transactions. The
>>> transaction have to be reverted to be reconciled. Is this the
>>> desired
>>> functionality?
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24731123.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
>
--
View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24733545.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: r9.04 posting unreconciled transactions.
Posted by Sumit Pandit <su...@hotwaxmedia.com>.
Hello sharan,
Please find comments inline -
On Jul 30, 2009, at 7:45 AM, Sharan-F wrote:
>
> Hi
>
> I've done some work on documenting the OFBiz accounting
> functionality and
> yes it does post unreconciled transactions.
Thanks for the documentation, Please provide link to it, I'll bookmark
it for future reference.
> Whether you allow the system to do this is dependent on what business
> process you want to implement. Some businesses will do their
> reconciliations
> on posted transactions and then do any resulting reversals or
> adjustments,
> others may want to reconcile the transactions before they post. I've
> seen it
> done both of these ways.
>
> I think the question to ask is which way does your business do it
> now? (And
> do they want to keep doing it in the future?)
>
> From what I've seen of the account reconciliation functionality in
> OFBiz I
> personally would say that it's not complete. For example it doesnt
> show
> whether its a debit or credit transaction or if the amount to be
> reconciled
> is increasing or reducing the balance in account. It also does not
> 'carry
> forward' any balance of a previous reconciliation done on an account.
> I like to think of account reconciliation like a bank statement that
> you
> receive each month. It has an opening balance that should be the
> same as the
> closing balance of your previous statement. It then shows each
> transaction
> as a positive or a negative with a resulting balance on each line
> and a
> final closing balance (that will be the start of your next statement).
Here is little description of Reconciliation Process -
When we receive/issue a SENT/RECEIVED payment (by Deposit / Withdraw)
( https://localhost:8443/accounting/control/FindPaymentsForDepositOrWithdraw?finAccountId=9000&organizationPartyId=Company
)
then it will create an Financial Accounting Transaction in CREATED
status. (FinAccountTrans in created status means it will not update
the balance of your FinAccount).
Then from Bank Reconciliation screen under Transaction tab ( https://localhost:8443/accounting/control/FindFinAccountTrans?finAccountId=9000
), you can reconcile your transaction from bank statement.
( https://localhost:8443/accounting/control/BankReconciliation?finAccountId=9000&statusId=FINACT_TRNS_CREATED
)
On select your transaction and click on Reconciliation it will update
set the Fin Account Trans status to APPROVED that means your payment
is deposited/withdraw and it will reflect in your Fin Account balance.
Also just FYI to verify this process - I am looking for writing a
JUnit test case for the same process which will verify the FinAccount
balance before and after reconciliation.
>
> Not sure if this was the type of response you were looking for but
> hope it
> helps.
>
> Thanks
> Sharan
>
>
> snowch wrote:
>>
>> In r9.04 it is possible to post unreconciled transactions. The
>> transaction have to be reverted to be reconciled. Is this the
>> desired
>> functionality?
>>
>
> --
> View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24731123.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: r9.04 posting unreconciled transactions.
Posted by Sharan-F <sh...@gmail.com>.
Hi
I've done some work on documenting the OFBiz accounting functionality and
yes it does post unreconciled transactions.
Whether you allow the system to do this is dependent on what business
process you want to implement. Some businesses will do their reconciliations
on posted transactions and then do any resulting reversals or adjustments,
others may want to reconcile the transactions before they post. I've seen it
done both of these ways.
I think the question to ask is which way does your business do it now? (And
do they want to keep doing it in the future?)
>From what I've seen of the account reconciliation functionality in OFBiz I
personally would say that it's not complete. For example it doesnt show
whether its a debit or credit transaction or if the amount to be reconciled
is increasing or reducing the balance in account. It also does not 'carry
forward' any balance of a previous reconciliation done on an account.
I like to think of account reconciliation like a bank statement that you
receive each month. It has an opening balance that should be the same as the
closing balance of your previous statement. It then shows each transaction
as a positive or a negative with a resulting balance on each line and a
final closing balance (that will be the start of your next statement).
Not sure if this was the type of response you were looking for but hope it
helps.
Thanks
Sharan
snowch wrote:
>
> In r9.04 it is possible to post unreconciled transactions. The
> transaction have to be reverted to be reconciled. Is this the desired
> functionality?
>
--
View this message in context: http://www.nabble.com/r9.04-posting-unreconciled-transactions.-tp24714238p24731123.html
Sent from the OFBiz - User mailing list archive at Nabble.com.