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.
