Skip to main content
Solved

Non-existent in BD

  • Mar 19, 2023 6:31 PM UTC
  • 4 replies
  • 303 views
  • Translate All
Freshman I

Hi

I Need Help in this Non-existent column the data is not fetching  in the GI 

 

 

In the Sql query i need to marge the those two columns in single column how to use in the GI 

Best answer by aaghaei

1) As for SQL query, you can use either one of the below based on your needs. You can add more fields to the second one separated by “,”

SELECT ISNULL(FSARTran.ServiceOrderRefNbr, FSARTran.ServiceContractRefNbr) AS 'MyRefNbr', * FROM FSARTran
SELECT COALESCE(FSARTran.ServiceOrderRefNbr, FSARTran.ServiceContractRefNbr) AS 'MyRefNbr', * FROM FSARTran
SELECT ISNULL(FSARTran.ServiceOrderRefNbr, '') + ' - ' + ISNULL(FSARTran.ServiceContractRefNbr, '') AS 'MyRefNbr', * FROM FSARTran

 

2) As for the Unbound field, if it is supposed to return value based on the associated DAC properties it will. If it is not, then no matching value is found for that record. What Screen is this?

View original

4 replies

aaghaei
Captain II
Forum|alt.badge.img+11
  • aaghaei
  • Captain II
  • Answer
  • Mar 19, 2023 9:21 PM UTC

1) As for SQL query, you can use either one of the below based on your needs. You can add more fields to the second one separated by “,”

SELECT ISNULL(FSARTran.ServiceOrderRefNbr, FSARTran.ServiceContractRefNbr) AS 'MyRefNbr', * FROM FSARTran
SELECT COALESCE(FSARTran.ServiceOrderRefNbr, FSARTran.ServiceContractRefNbr) AS 'MyRefNbr', * FROM FSARTran
SELECT ISNULL(FSARTran.ServiceOrderRefNbr, '') + ' - ' + ISNULL(FSARTran.ServiceContractRefNbr, '') AS 'MyRefNbr', * FROM FSARTran

 

2) As for the Unbound field, if it is supposed to return value based on the associated DAC properties it will. If it is not, then no matching value is found for that record. What Screen is this?

Translate
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Naveen Boga
    Captain II
    Forum|alt.badge.img+20
    • Naveen Boga
    • Captain II
    • Mar 20, 2023 5:18 AM UTC

    @Mounishg  Can you please share your GI here?

    Translate
    Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
      Freshman I
      • mounish
      • Author
      • Freshman I
      • Mar 20, 2023 6:48 AM UTC

      @aaghaei

      thank you 

      your inputs helped me  now im able to fetch the data 

       

      Translate
        aaghaei
        Captain II
        Forum|alt.badge.img+11
        • aaghaei
        • Captain II
        • Mar 20, 2023 6:53 AM UTC

        Great. Glad you got what you needed 

        Translate
        Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
          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