Hi Ingo

I think you might be focussing on the money part too much rather than the 
accounting part. If you issue an invoice to a customer for 1000 Euros and they 
pay 1000 Euros based on that invoice, then it needs to be officially recorded 
that they paid all of it. 

What you need to do is what I would call a sort of an invoice match followed by 
a payment breakdown (and at the moment you are missing the invoice match and 
are just doing the payment breakdown)

To fix it, you could look at matching the invoice with the customer paid amount 
(including the bank fees) before you process the bank fees transaction. So 
effectively you are re-creating the true customer payment, then doing the 
transaction to deduct the bank fees afterwards.

Thanks
Sharan


On 2018/03/22 09:54:07, Ingo Wolfmayr <ingo.wolfm...@wolfix.at> wrote: 
> Hi Sharan,
> 
> the fee has already been taken out and the whole processing is done manually. 
> 
> Invoice is created via import.
> Payment is created and assigned. --> Invoice paid.
> Move fee from "bank glaccount" to "bank charges glaccount".
> 
> I do not want the invoice with an open amount in the system (write off), as 
> the customer paid 100%. If there is another way I would be happy if you can 
> share it.
> 
> Thanks a lot !
> 
> Best regards,
> Ingo
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: Sharan Foga <sha...@apache.org> 
> Gesendet: Mittwoch, 21. März 2018 22:00
> An: user@ofbiz.apache.org
> Betreff: Re: Financial transaction - accounting transactions
> 
> Hi Ingo
> 
> So you've setup a financial account to mirror you bank account and when the 
> customer payment comes in, it already has the fees taken out? Or does the 
> whole customer amount come into the account as one figure and then the bank 
> takes out their fee? 
> 
> Also are you manually depositing (i.e creating deposits) for customer 
> payments or are you letting OFBiz automatically do it when the customer pays?
> 
> Either way - I'll take a look and get back to you.
> 
> Thanks
> Sharan
> 
> On 2018/03/21 10:33:30, Ingo Wolfmayr <ingo.wolfm...@wolfix.at> wrote: 
> > Hi,
> > 
> > I have a question regarding financial transaction, in detail the service 
> > "postFinAccountTransToGl".
> > 
> > When I create a "deposit" or a "withdraw" it creates the same accounting 
> > transactions except changing the type of accounting transaction.
> > 
> > Maybe I missunderstand the financial transactions. This is what I am trying 
> > to do:
> > A customer made a payment 100$. The bank subtracts a fee from my account 
> > 5$. I thought by making a transaction "withdraw" I could submit the fee to 
> > the appropriate glaccount and subtracting it from the financial account 
> > (2nd part is fine).
> > Goal:
> > Debit: 5$ Fees
> > Credit: 5$ Bank
> > 
> > Current situation:
> > Credit: 5$ Fees
> > Debit: 5$ Bank
> > 
> > Creating a deposit creates the same financial transactions.
> > 
> > When I create an adjustment with a negativ amount, the glaccounts are on 
> > the right side, but the value is negativ, which at the end leads to the 
> > same result.
> > 
> > I would be glad if someone could help me on this.
> > 
> > Best regards,
> > Ingo
> > 
> 

Reply via email to