Skip to main content
Solved

Change our ID to Vender ID on Purchase order

  • September 23, 2025
  • 5 replies
  • 81 views
  • Translate All
Jr Varsity III
Forum|alt.badge.img

Hello! 

I am looking to change our inventory ID to our Vendor ID on purchase orders. I’ve seen it done using the alternate ID field but I’ve seen it done with comparing tables and using different techniques. Is it that difficult to do? Please help!

Brent

Best answer by jhouser

Try the formula below:

 

=IIf([POLine.InventoryID]<>Null, Format( '{0}: {1}', (IsNull([POLine.AlternateID],[POLine.InventoryID])),[POLine.TranDesc]),[POLine.TranDesc])

View original

    5 replies

    jhouser
    Captain II
    Forum|alt.badge.img+7
    • jhouser
    • Captain II
    • September 23, 2025

    Hi ​@bbondura - You mean on the printed PO, correct? Should be pretty easy. You can open the form in report designer and replace POLine.InventoryID with =IsNull(POLine.AlternateID, POLine.InventoryID). Give it a try and let me know. 

     

    Translate
    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
      Jr Varsity III
      Forum|alt.badge.img
      • bbondura
      • Author
      • Jr Varsity III
      • September 23, 2025

      ​@jhouser 

      So replace =IIf([POLine.InventoryID]<>Null, Format( '{0}: {1}', [POLine.InventoryID],[POLine.TranDesc]),[POLine.TranDesc]) with =IsNull(POLine.AlternateID, POLine.InventoryID)

      Sorry, I’m terrible with these IIF statements. 

      Translate
      jhouser
      Captain II
      Forum|alt.badge.img+7
      • jhouser
      • Captain II
      • Answer
      • September 23, 2025

      Try the formula below:

       

      =IIf([POLine.InventoryID]<>Null, Format( '{0}: {1}', (IsNull([POLine.AlternateID],[POLine.InventoryID])),[POLine.TranDesc]),[POLine.TranDesc])

      Translate
      Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
        Jr Varsity III
        Forum|alt.badge.img
        • bbondura
        • Author
        • Jr Varsity III
        • September 23, 2025

        ​@jhouser 

         

        That worked beautifully!! 

        Thank you!

        Translate
          jhouser
          Captain II
          Forum|alt.badge.img+7
          • jhouser
          • Captain II
          • September 23, 2025

          ​@bbondura You're welcome!

          Translate
          Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
            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