Skip to Content

Customer Report

dathulworksaccounts-chennai7-2-1915-02-19.png

Hi all,

I want one query report with following details

1. SL.No

2. Origin

3. Document No.

4. Posting Date

5. Item Details (1st line item / full item)

6. Item Total

7. Document Total

8. Balance Due

9. Customer Name

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Feb 20, 2019 at 09:48 AM

    No problem, will check it

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 21, 2019 at 01:07 PM

    Could you specify which details you wants ?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 15, 2019 at 09:53 AM

    Hi Athul,

    You can get the above query by using the relationship between tables OITR, ITR1, OJDT.

    I remain ready to provide you with support, when and if you need it.

    Thank you,

    Aziz

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 20, 2019 at 07:44 AM
    Select
    		w1.ReconNum,
    		W1.ReconDate,
    		W1.Total,
    		W2.Shortname,
    		W2.Transid,
    		W2.SrcObjTyp,
    		w2.SrcObjAbs,
    		W2.ReconSum,
    		(select Memo from OJDT t1 where t1.Transid=W2.Transid) as 'Remarks',
                    (select Refdate from OJDT t1 where t1.Transid=W2.Transid) as 'Posting Date'
    FROM OITR w1 inner join ITR1 w2 on W1.ReconNum=W2.ReconNum
    and W2.Shortname ='your BP code'
    
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 20, 2019 at 08:48 AM

    You must specify your "BP Code" !

    and W2.Shortname ='your BP code'
    Add a comment
    10|10000 characters needed characters exceeded

    • ok now its working, but I dnt want reconciliation details, I want the following details only

      1. Document No

      2. Posting Date

      3. Item details (Code풟ptn)

      4.Item price

      5. Reference

      6. Customer Code

      7. Customer Name

      8. Document Total

      9. Balance Due

      10. Paid/Credited

      11. Origin (Invoice / Creditmemo)