Skip to main content
Answer

Change our ID to Vender ID on Purchase order

  • September 23, 2025
  • 5 replies
  • 44 views
B
Jr Varsity II
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])

    5 replies

    jhouser
    Captain II
    Forum|alt.badge.img+6
    • 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. 

     

    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
    Chris Hackett
    B
    Jr Varsity II
    Forum|alt.badge.img
    • bbondura
    • Author
    • Jr Varsity II
    • 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. 

    jhouser
    Captain II
    Forum|alt.badge.img+6
    • 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])

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

    ​@jhouser 

     

    That worked beautifully!! 

    Thank you!

    Chris Hackett
    jhouser
    Captain II
    Forum|alt.badge.img+6
    • jhouser
    • Captain II
    • September 23, 2025

    ​@bbondura You're welcome!

    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility 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