Partially Invoiced Sale Order

This question is answered

Dear All

I want to close all partial invoice sale order and the status of these order is open order.

Regards

Verified Answer
  • Hi Adny2k,

    I think you delivered partially and invoiced only the delivered goods. Then indeed you can have older open orders. You can during posting of the packing slip or invoice specify whether the remaining quantity should be closed or not. This is a possible way to close the orders already. As you don't have to deliver and invoice any goods, you can manually use the deliver remainder function on the sales order lines.

    It could be automated, but then you have to write some logic within a script (AOT: Job)

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

All Replies
  • Hi Adny2k,

    I think you delivered partially and invoiced only the delivered goods. Then indeed you can have older open orders. You can during posting of the packing slip or invoice specify whether the remaining quantity should be closed or not. This is a possible way to close the orders already. As you don't have to deliver and invoice any goods, you can manually use the deliver remainder function on the sales order lines.

    It could be automated, but then you have to write some logic within a script (AOT: Job)

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

  • Thanks for Answer . Can u guide or any other AOT script for closing. actually there thousands of order open.

    Regards

  • Hi,

    Unfortunately I cannot help you right now. When I had this script myself available I would have shared it. It needs to be created with knowledge of the datamodel and x++ programming language. If you don't have the skills you can find someone to do it for you.

    The SalesLine contains the fields RemainSalesPhysical and RemainInventPhysical. Also related to the sales line a record exists in the InventTrans. This record should be set to zero or deleted.

    You can look on the form SalesUpdateRemainder for some ideas how to call the logic.

    Then you also have to think about on which conditions an sales order can be considered as really closed and thus update the deliver remainder.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.