Need to figure out Outstanding amount for Invoice against Payment in ofbiz framework

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Need to figure out Outstanding amount for Invoice against Payment in ofbiz framework

Mrinmoy Pal
Hi,

I have a client requirement where the Outstanding Amount for the Invoices
against the payment need to be calculated.
For Example: Invoice=$1500, Payment=$800. Then Outstanding Amount =
1500-800=$700.

I first took a shot at Orders, Invoices and Payments flow in ofbiz and found
Outstanding Amount in following two places.

1. Outstanding amount on the *FindPayments* (
https://localhost:8443/accounting/control/findPayments) screen is calculated
as below
Outstanding Amount = Product.amount minus ProductApplication.amountApplied
(Logic is given in PaymentWorker.java)
For e.g. After making payment of $800, I check the tables and columns and
found that
Outstanding Amount = 800 (Product.amount) minus 0
(ProductApplication.amountApplied) = $800.
I was hoping that Outstanding Amount will give the answer, but the result
($800) is not matching with expected output ($700)

2. Invoices (https://localhost:8443/accounting/control/*findInvoices*) are
only getting created once the full Payments (Receive Payment) is made on the
orders. So if the $800 payment is made for $1500 Order amt, then Invoice is
not getting generated.

So using both find Invoice and Payment screens, I havent been able to find
the Outstanding amount.
Looking forward from the community to see if anybody has faced similar
situation to find the Outstanding amount.

Cheers