You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "skip@theDevers" <sk...@thedevers.org> on 2007/09/12 08:20:51 UTC

More Confusion

Just to verify this, I cleaned everything out to start from scratch.  I used
the Order-Order Entry module to make a sale for $100 + shipping and tax and
quick shipped it.
This was to a billing account.

I now have a single entry for OrderPaymentPreference of $100++ and
paymentMethodId=EXT_BILLACT and statusId = PAYMENT_RECEIVED
I have a single entry for PaymentApplication where amountApplied = $100++
and a billingAccountId and invoiceId.

I call the service getBillingAccountBalance() in BillingAccountWorker and
get returned $5000 when the account limit is $5000.  It should have been
$4900--.

I added some logging to getBillingAccountBalance() and discovered that the
OrderPaymentPreference was not subtracted because it was  status
PAYMENT_RECEIVED.

PaymentApplication was also ignored because invoiceId != null.

As expected, when I recorded a payment of $100++ on the account, I now have
a $5100++ balance.

Did I miss a step or is this logic in getBillingAccountBalance() wrong or
should the order application have made a second posting to
OrderPaymentPreferences.

Maybe these billing accounts are not intended for Customer sales?  Is
OrderPaymentPreference maybe mis-named and should be OrderPayments?

Any help understanding these issues would be appreciated.  I am writing a
real A/R application with aging and the like and want to keep it as clean
and compatible with Ofbiz core code as possible.



Skip


RE: More Confusion

Posted by "skip@theDevers" <sk...@thedevers.org>.
Yep, and that might be the issue, I am exploring it.

Thanks

Skip

-----Original Message-----
From: Rashko Rejmer [mailto:rrejmer@iguanait.com]
Sent: Wednesday, September 12, 2007 6:52 AM
To: user@ofbiz.apache.org
Subject: Re: More Confusion



Hi Skip,

I don't know if this might help.
Do you have financials component in your hot-deploy folder?

I have encountered the same issue and the problem was because Financials
component have different approach for handling payments with billing
accounts. I my case the problem was that the opentaps service
captureBillingAccountPayments
(com.opensourcestrategies.financials.accounts.BillingAccountServices)
overrides the existing OFBiz service with the same name. These services have
complately different logic - the ofbiz one don't create payment but opentaps
creates.

Regards,
Rashko Rejmer
--
View this message in context:
http://www.nabble.com/More-Confusion-tf4427228.html#a12635900
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: More Confusion

Posted by Rashko Rejmer <rr...@iguanait.com>.
Hi Skip, 

I don't know if this might help. 
Do you have financials component in your hot-deploy folder?

I have encountered the same issue and the problem was because Financials
component have different approach for handling payments with billing
accounts. I my case the problem was that the opentaps service
captureBillingAccountPayments
(com.opensourcestrategies.financials.accounts.BillingAccountServices)
overrides the existing OFBiz service with the same name. These services have
complately different logic - the ofbiz one don't create payment but opentaps
creates.

Regards,
Rashko Rejmer
-- 
View this message in context: http://www.nabble.com/More-Confusion-tf4427228.html#a12635900
Sent from the OFBiz - User mailing list archive at Nabble.com.


RE: More Confusion

Posted by "skip@theDevers" <sk...@thedevers.org>.
I tried this link and the results were not the same, the account balance was
computed correctly.

I am using the latest Opentaps (as of two weeks ago) code.  I will download
the Ofbiz latest and see where there differences lie.

Thanks

Skip

-----Original Message-----
From: Jacopo Cappellato [mailto:tiz@sastau.it]
Sent: Tuesday, September 11, 2007 11:32 PM
To: user@ofbiz.apache.org
Subject: Re: More Confusion


What OFBiz version are you using? Could you please try to recreate the
same issue here:

https://demo.hotwaxmedia.com/ordermgr/control/main

Thanks,

Jacopo


skip@theDevers wrote:
> Just to verify this, I cleaned everything out to start from scratch.  I
used
> the Order-Order Entry module to make a sale for $100 + shipping and tax
and
> quick shipped it.
> This was to a billing account.
>
> I now have a single entry for OrderPaymentPreference of $100++ and
> paymentMethodId=EXT_BILLACT and statusId = PAYMENT_RECEIVED
> I have a single entry for PaymentApplication where amountApplied = $100++
> and a billingAccountId and invoiceId.
>
> I call the service getBillingAccountBalance() in BillingAccountWorker and
> get returned $5000 when the account limit is $5000.  It should have been
> $4900--.
>
> I added some logging to getBillingAccountBalance() and discovered that the
> OrderPaymentPreference was not subtracted because it was  status
> PAYMENT_RECEIVED.
>
> PaymentApplication was also ignored because invoiceId != null.
>
> As expected, when I recorded a payment of $100++ on the account, I now
have
> a $5100++ balance.
>
> Did I miss a step or is this logic in getBillingAccountBalance() wrong or
> should the order application have made a second posting to
> OrderPaymentPreferences.
>
> Maybe these billing accounts are not intended for Customer sales?  Is
> OrderPaymentPreference maybe mis-named and should be OrderPayments?
>
> Any help understanding these issues would be appreciated.  I am writing a
> real A/R application with aging and the like and want to keep it as clean
> and compatible with Ofbiz core code as possible.
>
>
>
> Skip




Re: More Confusion

Posted by Jacopo Cappellato <ti...@sastau.it>.
What OFBiz version are you using? Could you please try to recreate the 
same issue here:

https://demo.hotwaxmedia.com/ordermgr/control/main

Thanks,

Jacopo


skip@theDevers wrote:
> Just to verify this, I cleaned everything out to start from scratch.  I used
> the Order-Order Entry module to make a sale for $100 + shipping and tax and
> quick shipped it.
> This was to a billing account.
> 
> I now have a single entry for OrderPaymentPreference of $100++ and
> paymentMethodId=EXT_BILLACT and statusId = PAYMENT_RECEIVED
> I have a single entry for PaymentApplication where amountApplied = $100++
> and a billingAccountId and invoiceId.
> 
> I call the service getBillingAccountBalance() in BillingAccountWorker and
> get returned $5000 when the account limit is $5000.  It should have been
> $4900--.
> 
> I added some logging to getBillingAccountBalance() and discovered that the
> OrderPaymentPreference was not subtracted because it was  status
> PAYMENT_RECEIVED.
> 
> PaymentApplication was also ignored because invoiceId != null.
> 
> As expected, when I recorded a payment of $100++ on the account, I now have
> a $5100++ balance.
> 
> Did I miss a step or is this logic in getBillingAccountBalance() wrong or
> should the order application have made a second posting to
> OrderPaymentPreferences.
> 
> Maybe these billing accounts are not intended for Customer sales?  Is
> OrderPaymentPreference maybe mis-named and should be OrderPayments?
> 
> Any help understanding these issues would be appreciated.  I am writing a
> real A/R application with aging and the like and want to keep it as clean
> and compatible with Ofbiz core code as possible.
> 
> 
> 
> Skip