D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Customer Payment Settlement by batch in D365

  • 1.  Customer Payment Settlement by batch in D365

    SILVER CONTRIBUTOR
    Posted Jul 29, 2019 03:28 PM
    ​Hi All,

    Below is the scenerio that i am runnign through.
    My customer has a subscription based business where revenue must be recognized over a period of 12 months.

    1. All customer sales order are created out of D365 in some third party tool.
    2. All customer payment is being processed out of D365 in some third party tool.

    Requirement

    1. All the sales invoice needs to be brought to D365.
    2. All the payment needs to be posted to defered revenue account whcih is acomplished by the item posting profile. Item is set to post revenue to defered revenue instead of Revenue

    Revenue Recognition process

    1. We are bringing all sales order invocie daily into D365 by batch job
    2. We are bringing all payment to D365 by batch job.
    3. We will recogninze revenue on the last working day of every month and post them with future date for the next 12 month.

    Key challenges.
    1. How can we settle customer payemnt with invoice with batch job. Has anyone went through this process if it is possible?

    Please advise.

    Thank you

    Sudhir



    ------------------------------
    [Sudhir] [Maharjan] [srmaharjan@hotmail.com]
    [AX Consultant]
    Lawrenceville NJ
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Customer Payment Settlement by batch in D365

    SILVER CONTRIBUTOR
    Posted Jul 30, 2019 11:15 AM
    Hi, Sudhir

    Are you looking for a product-based solution or a technical-coding solution?  Since you are importing both the invoices and the payment into Dynamics 365, it sounds like you are mostly looking for a technical solution to settle payments against invoices.  Can you clarify?

    ------------------------------
    Patrick Hodo
    Chief Technical Officer
    Red Maple
    boerne TX
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: Customer Payment Settlement by batch in D365

    SILVER CONTRIBUTOR
    Posted Jul 30, 2019 11:50 AM
    Hi Patrik,

    I am looking into technical or out of box solution for this. Since we are bringing sales order invocie and payment, I am looking for a way to settle them in D365.

    Please advise.
    thank you

    sudhir



    ------------------------------
    [Sudhir] [Maharjan] [srmaharjan@hotmail.com]
    [AX Consultant]
    [SAGlobal]
    Lawrenceville NJ
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: Customer Payment Settlement by batch in D365

    SILVER CONTRIBUTOR
    Posted Jul 30, 2019 12:16 PM
    If that is the case, I would look at MCRCustPaymTotals.settlePayments to see how it would be done.

    ------------------------------
    Patrick Hodo
    Chief Technical Officer
    Red Maple
    boerne TX
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: Customer Payment Settlement by batch in D365

    SILVER CONTRIBUTOR
    Posted Jul 30, 2019 01:48 PM
    Hi PAtrick,

    I am not able to see this data entity.

    Thank you

    Sudhir


    ------------------------------
    [Sudhir] [Maharjan] [srmaharjan@hotmail.com]
    [AX Consultant]
    [SAGlobal]
    Lawrenceville NJ
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: Customer Payment Settlement by batch in D365

    SILVER CONTRIBUTOR
    Posted Jul 31, 2019 10:45 AM
    Hi, Sudhir

    It is not a data entity.  It is a class.

    ------------------------------
    Patrick Hodo
    Chief Technical Officer
    Red Maple
    boerne TX
    ------------------------------

    Conference-AXUG_200x200


  • 7.  RE: Customer Payment Settlement by batch in D365

    TOP CONTRIBUTOR
    Posted Jul 31, 2019 01:59 AM
    1. One simple way to get customer receipts (payments) to settle against invoices is to turn on the auto-settlement (through an AR parameter, and a checkbox on the posting profile on both the sales invoice and the payment.

    This tend to be a bit "brute force" as you only have limited control about which payment settles with what invoice, but it works well in many scenarios.

    2. In current project we used LogicApps scripts to interface into D365, and I believe that script was able to also perform the settlement - this was more specific (since we wanted to payment to be settled with one specific invoice out of all the other existing invoices of that customer)

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role