Hi from a new member.
Been writing reports only for 17 years (all OJT) - never got into the source code nor do I want to. Still a novice.
My problem is more an understanding of the database logic than a programming problem.
I have two reports, first one looks at customer.sales-ytd (syteline calculation and I have no idea what the logic is to get this number).
My second report totals ledger.dom-amount (and journal entries for items not posted yet) by customer number for all sales account numbers. These two totals do not match but MY logic thinks they should. Accounting thinks RMA's are the problem but I can seem to verify that and get the totals for particular customers to match. Tried totaling lots of fields in RMA, ledger, customer tables but no luck.
Anyone with an idea to resolve this issue? or a suggested source for more information on syteline logic?
Running ver 6 progress 9.
Been writing reports only for 17 years (all OJT) - never got into the source code nor do I want to. Still a novice.
My problem is more an understanding of the database logic than a programming problem.
I have two reports, first one looks at customer.sales-ytd (syteline calculation and I have no idea what the logic is to get this number).
My second report totals ledger.dom-amount (and journal entries for items not posted yet) by customer number for all sales account numbers. These two totals do not match but MY logic thinks they should. Accounting thinks RMA's are the problem but I can seem to verify that and get the totals for particular customers to match. Tried totaling lots of fields in RMA, ledger, customer tables but no luck.
Anyone with an idea to resolve this issue? or a suggested source for more information on syteline logic?
Running ver 6 progress 9.