Skip to main content
Solved

Is Acumatica storing last Sales Order created date for a Customer?

  • October 10, 2023
  • 5 replies
  • 264 views
  • Translate All
Freshman I

Is Acumatica storing last Sales Order created date for a Customer?

Best answer by ChandraM

Hi @ranjithd46 If you are just looking to find the customer’s last order’s created datetime you have the existing Sales orders Generic Inquiry or have a new generic inquiry based on your requirements.

If you are looking to use this on your customization, then create a BQL view for the below SQL:

Example: Select max(CreatedDatetime) from SOOrder where Customerid=’ABCStudios’ or use the Current Customer.

View original

    5 replies

    Kandy Beatty
    Captain II
    Forum|alt.badge.img+18

    HI @ranjithd46 

    There is not a field that holds that. The only way to find the last order date is you could use the Sales Order Details by Customer report. 

    Translate
    Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
      Semi-Pro I
      Forum|alt.badge.img+8
      • ChandraM
      • Semi-Pro I
      • Answer
      • October 10, 2023

      Hi @ranjithd46 If you are just looking to find the customer’s last order’s created datetime you have the existing Sales orders Generic Inquiry or have a new generic inquiry based on your requirements.

      If you are looking to use this on your customization, then create a BQL view for the below SQL:

      Example: Select max(CreatedDatetime) from SOOrder where Customerid=’ABCStudios’ or use the Current Customer.

      Translate
      Chandra M
        Laura03
        Captain II
        Forum|alt.badge.img+20
        • Laura03
        • Captain II
        • October 10, 2023

        Hello @ranjithd46 ,

        You may be able to make a quick GI to show you customer and last order date, using Customer table and SoOrder table:

        Laura

        Translate
        ~ Laura Barber, WM Synergy
          Jr Varsity III
          Forum|alt.badge.img+1

          In SO screen , You need filter by customer and order the date in descending . Please refer bellow screen print 

           

           

          Translate
          Naveen Boga
          Captain II
          Forum|alt.badge.img+20

          Is Acumatica storing last Sales Order created date for a Customer?

          No, Acumatica is not storing the Last Sales Order for a Customer. As mentioned, you can work with the GI @ranjithd46 

          Translate
          Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
            Terms & ConditionsAccessibility statement
            About Acumatica ERP system
            Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
            © 2008 — 2024  Acumatica, Inc. All rights reserved