Starforce2011
Active Member
Localized \"Customer Ledger\" Program-Subtotal by Doc Ty
Dear Fellows;
We have some Turkish localization programs in JDE World A.7.3. which are not working properly. One of them is "Customer Ledger". The only problem is : although this report produces correct information in terms of details, it gives all the lines of the same invoices/documents. We would like to view the report more summarized as grouped by document number. For example:
Doc Date Doc Ty Doc No Debit Credit Expl.
-------- ------ ------ ----- ------ -----
01/02/12 RI 41900321 1.500 Item#1..
01/02/12 RI 41900321 1.000 Item#2..
01/02/12 RI 41900321 3.200 Item#1..
01/04/12 RC 41920111 5.700 Payment
(*) How can we group the report by document number and so shorten and summarize it to let it in a format that can be submitted to our customers complaining about our long detailed reports as follows?
Doc Date Doc Ty Doc No Debit Credit Expl.
-------- ------ ------ ----- ------ -----
01/02/12 RI 41900321 5.700 SalesInv
01/04/12 RC 41920111 5.700 Payment
I investigated and tried everything to fix it from "processing options" ; "data selection" and "report parameters" , but not able to make it.
My concern is to take your idea , where to make the change or modification in the report so that it can run it <group by doc no"..Somehow, it should be a change in the sql query running at behind. How can I monitor the sql code of this program/query?
Many thanks and regards...
Ozgur
Dear Fellows;
We have some Turkish localization programs in JDE World A.7.3. which are not working properly. One of them is "Customer Ledger". The only problem is : although this report produces correct information in terms of details, it gives all the lines of the same invoices/documents. We would like to view the report more summarized as grouped by document number. For example:
Doc Date Doc Ty Doc No Debit Credit Expl.
-------- ------ ------ ----- ------ -----
01/02/12 RI 41900321 1.500 Item#1..
01/02/12 RI 41900321 1.000 Item#2..
01/02/12 RI 41900321 3.200 Item#1..
01/04/12 RC 41920111 5.700 Payment
(*) How can we group the report by document number and so shorten and summarize it to let it in a format that can be submitted to our customers complaining about our long detailed reports as follows?
Doc Date Doc Ty Doc No Debit Credit Expl.
-------- ------ ------ ----- ------ -----
01/02/12 RI 41900321 5.700 SalesInv
01/04/12 RC 41920111 5.700 Payment
I investigated and tried everything to fix it from "processing options" ; "data selection" and "report parameters" , but not able to make it.
My concern is to take your idea , where to make the change or modification in the report so that it can run it <group by doc no"..Somehow, it should be a change in the sql query running at behind. How can I monitor the sql code of this program/query?
Many thanks and regards...
Ozgur