Client inquiries on status of salesorder

  • reinier

    reinier - 2006-04-06


    I guess could do with some help on this one:

    I stumbled across a very basic question from a sales point of view.

    A customer can have a salesorder with multiple ordered items, not being delivered from stock, but purchased at different vendors.

    When the customer inquires about the status of his order, it would be nice (or even mandatory) to tell him which items are already delivered by the vendor and what items we are still waiting for. The typical delivery-rule on the Salesorder is 'Complete order', so the shipment-process does not pick up anything for this SO yet.

    I can't find any report or window that provides this information on the SO. Does anyone know of a report or window that will serve my purpose ?



    • Alain

      Alain - 2006-04-20

      Yes ! We have had that problem too.

      We could not find any report or window in Compiere to handle this.
      So we resolved it by creating a new view in the database combining data from SO and PO's related to  SO (PO's are created with 'Create PO from SO function' in Compiere).
      View matches a table and a new screen in Compiere, and as one of the colums is C_Order_ID, we access the 'Order status' data directly from the sales order window using the zoomaccross functionality (magnifying glass button).

      If you have any further question, don't hesitate to contact me: ama<at>



    • reinier

      reinier - 2006-05-10

      Hello Alain,

      Thanks for your reply. I understand the solution. It will be an interesting excersise for me to get this one working!




Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks