Invoice paid by two Business partner

128 views
Skip to first unread message

Mellina Videv

unread,
Feb 13, 2019, 6:43:35 AM2/13/19
to iDempiere
Hi,

We have a case where we sell some products that is surcharged by the government

ex : a sales order with one product of 300$,
      the gov pay 80% which is 240$ by invoice in the end of month
      a cash client pay 20%  which is  60$ at the time of sale.

Could you please tell me if iDempiere can handle this case  or something out of the box already exists to manage this situation

best regards

Jesús Castillo

unread,
Feb 14, 2019, 7:11:12 AM2/14/19
to iDempiere
Hi, I had the same issue, I work with this  http://wiki.idempiere.org/en/Plugin:_Two_Business_Partner_Allocation

But I had to solve accounting problem.

Hiep Lq

unread,
Feb 14, 2019, 7:48:30 AM2/14/19
to Mohemmed Bilal Ilyas
how about use a charge to mention it pay by a other partner

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/190b76ec-3313-4a0d-9e43-85d8a8752fc2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


--
Lê Quý Hiệp
Email: hie...@hasuvimex.vn
Skype: admin.hasuvimex

Company: Thanh Hoa Fishery Import - Export J.s.c  (HasuvimexDL 47
Add: Lot E, Le Mon Industrial Zone, Thanh Hoa, Vietnam

Steven Sackett

unread,
Mar 3, 2019, 3:35:21 AM3/3/19
to iDempiere
Hi Mellina
One option is to apply the $60 payment from the Customer against the invoice to the Customer leaving $240 outstanding on that invoice.
Create a Charge (say) "Government Contribution" pointing a to a clearing account in the balance sheet
Then take up the payment of $240 from the "Gov" BP and put it to the Charge and enter some useful information in the description so you know which Customer BP the receipt relates to.
Go back to the Payment Allocation Window and select the Customer and then select the the invoice which will say $300 and open $240 ... then select the Charge "Government Contribution" and process.

[It would help if there was a new field called "Description" which carried through to the GL posting of the Payment Allocation so you could put information to allow you to easily reconcile the GL account linked to the Charge "Government Contribution"]

The above would keep all the accounting correct but whether it was a practical solution may depend on volume of transactions.

There is a downside to to not directly linking the Invoice BP to the Payment BP.  At present you can use the Automatic Account Reconciliation to reconcile AR Control Account(s) and create a report which shows the amount outstanding for each BP for each AR Control account and it lets you see which invoices make up the balance.  If you allow an invoice from BP1 to be cleared by a payment from BP2 then you would lose that capability. In fact I do not see how you could prove to an auditor what made up the balance of the AR Control Account particularly if you had multiple AR Control Accounts.

regards   
Reply all
Reply to author
Forward
0 new messages