FrontAccounting forum — Customer Balances report don't show amount of "prompt payment discount

Re: Customer Balances report don't show amount of "prompt payment discount

2013-09-18T10:05:44Z

ohh, ok
I will try to do it by myself

Re: Customer Balances report don't show amount of "prompt payment discount

2013-09-18T06:11:50Z

No, we do not have the resources to help you. We are not changing the existing reports. You may use the forum Jobs wanted / offered for this.

Joe

Re: Customer Balances report don't show amount of "prompt payment discount

2013-09-17T21:57:54Z

ok, thanks Joe
now i want to edit that report file , so can you plz tell me where should i change to have that discount in customer report?

Re: Customer Balances report don't show amount of "prompt payment discount

2013-09-17T11:24:41Z

Customer Receipts and Supplier Remittances now includes discount info.
The repo has been updated and the changes is going into next minor release.

Joe

Re: Customer Balances report don't show amount of "prompt payment discount

2013-09-16T22:35:14Z

If you need to give your customer such information you could create a custom report. The Customer Balance report is used to show the balances of your customers AR-ledger for your own use.

Re: Customer Balances report don't show amount of "prompt payment discount

2013-09-16T21:35:19Z

It seems its using file rep101.php to make the report, so please lead me how to change it to how i need

Re: Customer Balances report don't show amount of "prompt payment discount

2013-09-16T20:26:46Z

yes of course to make balance it should be do this in background but when we want to give a balance report to customer, report should separate it otherwise customer come back after 2 months later and say: in my last invoice you agreed to give me 99.50$ discount but i paid all of the 799.50$ so now please give my discount in my new invoice

http://www.4shared.com/download/7Bp6WFbc/cust.png?tsid=20130916-202006-4ca4b4f
http://www.4shared.com/photo/7Bp6WFbc/cust.html?

so it would better to show the discount amount in customer report too .. it can be great if the report could split discount and paid amount and show them in separated way

Re: Customer Balances report don't show amount of "prompt payment discount

2013-09-16T17:07:08Z

To have the report balance we must print the total payment + discount, otherwise balance is not correct. The fully amount is deducted from the AR account.

Joe

Customer Balances report don't show amount of "prompt payment discount

2013-09-16T14:31:38Z

Hello all,

actually i sent this to bug tracker too , but i just wanted to see the reactions and thinks about it here , maybe it's not really a problem but i need to fix it to myself

In customer payment when we give discount to a customer , we can see it in customer inquiry as how it should be, like this

General Ledger Transaction Details Reference Date Person/Item
Customer Payment #10 10 12/31/2011 Customer Jack

Account Code Account Name    Dimension Debit Credit Memo
1060    Checking Account       700.00
1200    Accounts Receivables    799.50
4500    Prompt Payment Discounts       99.50
Total    799.50 799.50

but when we want to give a report to that customer it only show the total amount of the payment . payment amount + discount

Customer Payment 10 12/31/2011 799.50 0.00 -799.50