Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Aged Debtor Analysis
08-23-2016, 12:33 AM
Post: #8
RE: Aged Debtor Analysis
(08-19-2016 12:16 AM)agaluski Wrote:  My mistake - you said they were already settled. I was looking to close them out - which they already are closed.

What version are you running?
In AgedDebtors.php my version has a line around 362 in the show detail section that limits showing these fractions.
AND ABS(debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc)>0.004";

You can also add "AND settled=0" to your detailed query. This will hide settled transactions from the details.

Version 4.12.3

What I did is run this script below on lab server and seems to clean up all the issues with .01 -.01 also there are some that had -0.00 show up.
Also there were some on the statements showing .01 and -.01 that the script cleared up.
Would this have any other affects on the data that I am missing all seems well after running.

UPDATE debtortrans
SET debtortrans.alloc=debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount
WHERE debtortrans.settled=1

Thanks for all the help
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Aged Debtor Analysis - daveparrish - 08-11-2016, 12:51 PM
RE: Aged Debtor Analysis - agaluski - 08-12-2016, 11:03 PM
RE: Aged Debtor Analysis - daveparrish - 08-13-2016, 01:52 AM
RE: Aged Debtor Analysis - daveparrish - 08-13-2016, 12:00 PM
RE: Aged Debtor Analysis - agaluski - 08-18-2016, 07:46 AM
RE: Aged Debtor Analysis - daveparrish - 08-18-2016, 12:16 PM
RE: Aged Debtor Analysis - agaluski - 08-19-2016, 12:16 AM
RE: Aged Debtor Analysis - daveparrish - 08-23-2016 12:33 AM
RE: Aged Debtor Analysis - phil - 08-23-2016, 08:54 AM
RE: Aged Debtor Analysis - daveparrish - 08-25-2016, 05:42 AM
RE: Aged Debtor Analysis - agaluski - 08-26-2016, 01:08 AM
RE: Aged Debtor Analysis - daveparrish - 08-26-2016, 02:06 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)