Skip to Content

Want to display outstanding amount in Sales Order

Hi,

Please help me , I want to display a outstanding amount in sales order after selecting the customer in Sales order.I want to display only overdue amounts .

Please provide the FMS query for it.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Oct 15, 2018 at 02:13 PM

    Hi,

    No need FMS to get outstanding balance. Just drag account balance from Business partner master and release it sales order form.

    Refer attached image,

    image-5.png


    image-5.png (175.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 16, 2018 at 05:16 AM

    Thanks for your answer. But i cant drag from BP master to Sales Order. The field is not moving .If i tried through edit ui template , its not moving to a sales order form.

    One more question , if I want aging report link on sales order according to customer , how can i fetch it on sales order. When I post the sales order for particular customer , i required aging report for that particular customer in Sales Order

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2018 at 06:31 PM

    Use this query in your FMS on sales order

    Select BalanceFC from OCRD where cardcode = $[ORDR.CardCode]

    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.