Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Aged Debtor Analysis
08-25-2016, 05:42 AM
Post: #10
RE: Aged Debtor Analysis
(08-23-2016 08:54 AM)phil Wrote:  It shouldn't be possible to have settled=1
if debtortrans.alloc NOT == (debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount)
these miserable rounding issues normally arise out of currency exchange arithmetic.
So, your
Code:
UPDATE debtortrans
SET debtortrans.alloc=debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount
WHERE debtortrans.settled=1
SHOULD be ok ... but just check your debtors control account (from company preferences) agrees to the total of all balances as converted to local currency from DebtorsAtPeriodEnd.php script with a period end after today.

Thanks for all the help I am using only one currency so that should not be an issue.
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)