In r9.04 it is possible to post unreconciled transactions. The transaction have to be reverted to be reconciled. Is this the desired functionality?
|
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
|
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. > |
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
|
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. > |
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
|
Hello Chris,
Please see my comments inline: -- Regards Ashish Vijaywargiya http://www.hotwaxmedia.com "Helping hand around the world" snowch wrote: It depends on individuals need and the business requirements of end user.Hi Sumit/Sharan, Would you consider the accounting functionality in 9.04 to be production ready? 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. Again it depends.What functionality is missing in 9.04 that you would require mandatory (e.g. ability to reconcile any account)? 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 smime.p7s (4K) Download Attachment |
In reply to this post by snowch
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. > |
In reply to this post by Ashish Vijaywargiya-5
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?
|
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 smime.p7s (4K) Download Attachment |
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: smime.p7s (4K) Download Attachment |
In reply to this post by Ashish Vijaywargiya-5
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...
|
In reply to this post by Ashish Vijaywargiya-5
That's excellent news!
|
Administrator
|
I was not aware about that, where has it been discussed ?
Jacques From: "snowch" <[hidden email]> > > 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. > |
Free forum by Nabble | Edit this page |