1 Topic by DrCard (edited by DrCard 11/01/2021 08:31:41 pm)

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 28

Topic: incorrect customer balance after Cash collection transactions

Main Post here
https://frontaccounting.com/punbb/viewt … 192#p40192

I run a delivery service which is collecting money from customers, I charge my clients 10$, the clients charge his customers $50 for the items being delivered by my company.

I invoice the client $10 and I have $50 cash in hand which will be deposited in my bank account.  I reconcile the $10  from the $50 and pay the client $40  however we have remaining $10 in customers payments to allocate in the system and by doing so. we will have incorrect customer balance.

*how the we did the entry's

Direct Invoice the $10 then Receive the $50 ...Go
Banking and General Ledger ->Journal Entry

Journal Date    Account Code    Account Name                                Debit           Credit      Memo
01/11/2021    1060    Checking Account                                      50.00       
01/11/2021    1200 00001    Accounts Receivables: Donald Easter             10.00   
01/11/2021    2100 00001    Accounts Payable: Dino Saurius                     40.00   
                                                                                   Total          50.00            50.00

Before second Payment
https://ibb.co/b5LpQvK customer balance correct
https://ibb.co/pWNyS5g remaining for the customer to pay (shouldn't be anything left)

After second Payment
https://ibb.co/4gyd4SR customer Balance Incorrect

as kvvaradha said we need to fix the code

any suggestion or help in how to fix this bug

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: incorrect customer balance after Cash collection transactions

This bug is related to Mantis Bug 5510 on Mantis. Fixed a couple of days ago.

Please download /sales/includes/db/custalloc_db.inc here.
And please download /reporting/rep108.php here.

Replace the files and you should be running ok.

Joe

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 28

Re: incorrect customer balance after Cash collection transactions

thank you so much
ill download it and tell you how its goes

Regards

4 Reply by DrCard (edited by DrCard 11/03/2021 10:05:32 am)

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 28

Re: incorrect customer balance after Cash collection transactions

joe wrote:

This bug is related to Mantis Bug 5510 on Mantis. Fixed a couple of days ago.

Please download /sales/includes/db/custalloc_db.inc here.
And please download /reporting/rep108.php here.

Replace the files and you should be running ok.

Joe

Still same issue

this is what i did

First Order Amount to be collected $50 from end customer. Fees $10.

Direct Invoice -> made an invoice of $10. Payment terms -> due within 10 days.
input an address and I have -> placed invoice.

Sales -> Customer Payments. This allocation which is for invoice -> All -> Add Payment

Banking and General Ledger -> Journal Entry -> Account : Checking account Dr. 40 -> Add Item -> Account: Account receivable -> Counter Party (Customer) -> Cr. 40 -> Process Journal Entry.

https://ibb.co/qmx5wdr

Second Order No Amounts to be collected from end customer. Fees $10.

Direct Invoice -> made an invoice of $10. Payment terms -> due within 10 days.
input an address and I have -> placed invoice.

https://ibb.co/c38W80G

Before second payment the Customer balance Report is correct but the payment is still outstanding in sales> customer payments.
So, if I want to clear this payment (second payment) the customer balance report will become incorrect. it should reconcile with the customer balance from the beginning which is the $40 that is in the customer account. As in with the customer balance report it becomes $ -30 and the payment is still pending.
If I do the payment, the balance changes back to $ -40.

https://ibb.co/ZMg8PJM

so the bug is still there

Regards

  • From: Anacortes, WA USA
  • Registered: 11/01/2015
  • Posts: 51

Re: incorrect customer balance after Cash collection transactions

It would be great if a CPA chimed in on this and described the proper way to deal with this.

ScriptBASIC's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: incorrect customer balance after Cash collection transactions

@DrCard

the Journal Entry Cr post of 40 is handled as a Payment (You are reducing the debt from the customer).
So everything is handled correctly.
You can use the Journal Entry with Cr 40 in 'Allocate Customer Payments or Credit Notes' to allocate other debts.

Joe

7 Reply by DrCard (edited by DrCard 11/03/2021 03:41:36 pm)

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 28

Re: incorrect customer balance after Cash collection transactions

Thank you Joe for the reply


this is the entry for the $40 that is Credited to account receivable under customer account in this case KK.

https://ibb.co/BZkBJkH

as you can see we took $50 the order price is $10 USD and we Credited the customer account with $40 as in the report we have to pay $40 to the customer -$40 is showing in the report

https://ibb.co/TqtfCH7

The second order is $10 as there is no money to be collected just the order fee.

https://ibb.co/02wC8bJ

as you can see that the $10 is Debited to the customer account and the balance amount is correct.

https://ibb.co/FW9kcmK

the issue come when you go to customer payments as you can see the amount is still $10 balance on the customer

https://ibb.co/tKTwnNS

once paid the Customer balance becomes -$40 again witch is incorrect

https://ibb.co/h1cctLC

i tried Credit note it adds to the outstanding and it still does not fix the second order Balance

https://ibb.co/BVTPhtc

so if his balance was -$40 it will become -$50 after payment it processed

https://ibb.co/sWZVZdR

Please post for me the entries if my way is incorrect to take off the $10 payment for the second order.
Thank you so much Joe

Post's attachments

CustBalScreenshots.zip 280.4 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: incorrect customer balance after Cash collection transactions

@DrCard

Your discussion is right until
'once paid the customer balance....'
You still haven't allocated the -40 that was booked in the Journal Entry.
They should not be paid (it is already some kind of payment). They should instead be used for allocation as I told in my former answer.
I can understand that this is tricky to see, but this is the way it is done.

Joe

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: incorrect customer balance after Cash collection transactions

I will try to make things a little more clear.

You started with a Journal Entry with 40 Cr.
This is handled as some kind of a pre payment. Your customer owes this money. Hasn't got any services yet.
Then you invoiced a 10.
Instead of using the customer payment you could use the pre payment for allocating the invoice in the menu 'Allocate Customer payments ...'.
You still have 30 Cr, on the pre payment so this can also be used for allocating the second invoice.

I hope you see this. You have been overpaid by your customer.

Regarding the Balance of -40 is that your customer owes it. Thats the reason it is in minus.

Joe

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 28

Re: incorrect customer balance after Cash collection transactions

Thank you so much Mr Joe  'Allocate Customer payments' fully did the job nicely now i have to do it throw API

i have made Purchase (suppliers) & edit/delete APIs if you like i can push them in a git if you like , i have fully tested them and they are working fine

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: incorrect customer balance after Cash collection transactions

You are welcome and thanks.

I have nothing to do with the api. I don't recall who is maintaining this.
We will try to CALL for him, please.
So the author of the API, please help us with Mr. DrCard's contribution.

Joe

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 28

Re: incorrect customer balance after Cash collection transactions

Great! I'm now nearly Finished with the (Allocate Customer payments) Api also

just testing it to make sure it works with no problems

please tell me where you want me to push and I'm reedy

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,182

Re: incorrect customer balance after Cash collection transactions

You can push the codes to github and share it to Joe or itronics, 

They will further review the code. Or speak with cambell or Andrews,  who worked initially  to connected them to push the contribution the github.

Or you can speak with apmuthu, who actually maintains separate repository for it. Either way it's good to go with existing developers..

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website