| Author |
Message |
|
awtohost
|
Post subject: Customer Statement  Posted: Mon Feb 27, 2012 7:03 am |
|
Joined: Thu May 06, 2010 1:27 am
Posts: 108
|
|
Here is a problem with the customer statement.
If I have a invoice lets say 6000 USD plus Shipping 1000 USD and I want to give 1500 USD discount
the invoice total 5500 and that is correct on the invoice form, but now on the customer statement it would be listed as follows:
Sales invoice journal (12) 7000 USD
Discount -1500 USD ( showing up under payments )
Balance Due 8500 USD
It should have been 5500 USD
|
|
  |
|
 |
|
hucka
|
Post subject: Re: Customer Statement Posted: Mon Feb 27, 2012 3:59 pm |
|
Joined: Wed Sep 21, 2011 11:42 am
Posts: 93
Location: Brno, Czech Republic
|
|
How are you posting the discount. Is it discount posted as regular invoice line or is it posted while you are entering payment? There is no option in the invoice form to make special discount.
If you use the payment entry form, I think that you are just use the opposite sign. I'm not sure, because this is not a custom in Czech Republic, but the account for the discount has to be expense type account and the discount must be with + sign.
But, please forgive me if I'm wrong
Rosta
|
|
| |
|
|
|
awtohost
|
Post subject: Re: Customer Statement Posted: Mon Feb 27, 2012 8:35 pm |
|
Joined: Thu May 06, 2010 1:27 am
Posts: 108
|
|
Hi no on the sales order is a Discount line, and also on the invoice.
I enter the discount at the sales order level, and then I invoice, and the discount automatic show up on the invoice as a extra field, and the invoice is 100% correct it would look like this
Sub Total $6000.000
Discount $1500.00
Freight $1000.00
Total $5500.00
Payment 0.00
Balance $5500.00
But in the Customer Statement it has added the discount to the balance
|
|
| |
|
|
|
dave
|
Post subject: Re: Customer Statement Posted: Mon Feb 27, 2012 9:39 pm |
|
Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3498
Location: Colorado, US
|
|
I did a lot of work on the statement for R3.4. Are you using a version from a previous release? You may want to delete your current version and re-import a new one from the R3.4 source.
Dave
|
|
| |
|
|
|
awtohost
|
Post subject: Re: Customer Statement Posted: Mon Feb 27, 2012 11:10 pm |
|
Joined: Thu May 06, 2010 1:27 am
Posts: 108
|
|
Yes I spend lot of time making the form, and then I saved it, and now it is the form from V3.3 I'm using
|
|
| |
|
|
|
dave
|
Post subject: Re: Customer Statement Posted: Fri Mar 02, 2012 4:03 pm |
|
Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3498
Location: Colorado, US
|
|
Export the form and post it here or email it to me. I'll take a look.
Dave
|
|
| |
|
|
|
dave
|
Post subject: Re: Customer Statement Posted: Tue Mar 13, 2012 4:34 pm |
|
Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3498
Location: Colorado, US
|
|
The problem seems that the discount is showing for sales but shouldn't as the discount has already been factored into the total. I have made some mods to the statement_builder.php file to show the discount as a reference only for invoices. Replace the file in the /modules/phreebooks/classes/ directory.
Dave
|
|
| |
|
|
|
awtohost
|
Post subject: Re: Customer Statement Posted: Wed Mar 14, 2012 3:31 am |
|
Joined: Thu May 06, 2010 1:27 am
Posts: 108
|
|
| |
|
|
|
