Skip to Content

sundry debtors

my problem is

BP Customer has made A/R downpayment and Incoming payment Rs.100000

A/R invoice adjusted against downpayment Rs.60000

Balance remaining Rs40000

I want the above transactions as sundry debtors ledger(this is not available in SAP B1)

At another date I am making outgoing payment to refund the customer Rs.40000

Now sundry debtors balnce is Zero

Please help in creating the query for the report

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Jan 21, 2019 at 04:27 AM

    Dear Bhat,

    Once you passed the A/R Down-payment transaction this value will be booked in the down-payment intermediate account only (In Credit side),

    You have to post a manual journal Entry to move this balance from this account to BP customer account.

    Then go to Outgoing payment screen and select the customer option and select your customer and make the repayment.


    Dinesh PN

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 21, 2019 at 07:07 AM


    My problem is we want a sundry debtor ledger which shows the transactions with balance if any on date that is requested

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 21, 2019 at 08:02 AM


    May I know why you say that there is no sundry debtor legder, this is the control account that ought to be used in the Business Partner Master->Accounting Tab->Accounts Receivable, if you have mapped the sundry debtors as the default control account, in other words whatever G/L Account you have mapped here is equivalent to your sundary debtors.

    Then from either the G/L Account or the BP's Account balance you will be able to see the transactions based on specific dates.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 21, 2019 at 08:57 AM

    Hi Bhat,

    Try this query--

    T0.ShortName 'BP Code',T1.CardName 'BP Name',T0.TransId 'Transaction Id'
    ,CASE WHEN T0.TransType=24 THEN 'Incoming Payment'
    WHEN T0.TransType=13 THEN 'A/R Invoice'
    WHEN T0.TransType=14 THEN 'Credit Note'
    WHEN T0.TransType=203 THEN 'A/R Downpayment'
    WHEN T0.TransType=46 THEN 'Outgoing Payment'
    ELSE T0.TransType END AS 'Transaction Type'
    ,T0.RefDate 'Date',T0.Debit,T0.Credit,T0.LineMemo 
    FROM JDT1 T0
    LEFT JOIN OCRD T1 ON T1.CardCode=T0.ShortName
    WHERE T0.Account=[%0]
    AND T0.RefDate>=[%1]
    AND T0.RefDate<=[%2]
    ORDER BY T0.ShortName,T0.RefDate 



    Add a comment
    10|10000 characters needed characters exceeded

    • Sir,

      In your query i am getting only vendors and not customers.I should be able to choose a particular customer code and then see all his transactions like A/R invoice adjusted against downpayments.outgoing payments made and the balance outstanding on any particular date.


  • Posted on Jan 30, 2019 at 01:29 AM


    You may try out using the General Ledger Report, choose customers as well as the control account under the BP selection.

    For queries, I recommend you to try out first and mention the issue that you face, instead of asking forum members to write a report from scratch, this will fetch you more appropriate response.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 02, 2019 at 05:07 AM


    I am getting the ledger for the customer but i am not able to view the unadjusted amount remaining .Say a/r downpayment is 1 lac and incoming payment is 1 lac.Now when a/r invoice is adjusted say for 60000 ,all the columns like cumulative balance,balance due etc in ledger report are showing as zero.Actually the balance is still Rs.40000 lying unadjusted which is not showing anywhere in the ledger report.We are manually calculating and finding out the balance available.Now party asking for refund of 40000 for which we are making outgoing payment on a particular date.After this outgoing payment the balance actually becomes zero.But in the ledger report this outgoing payment is not showing.

    We want some report which shows the transactions in all respects so that we can find out the party balance at any given point of time as MIS report.Urgent.Please help

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.