Skip to main content
Answer

Looking for alternative solution-Missing fields in the 23R1

  • October 12, 2023
  • 2 replies
  • 39 views
M
Freshman I

Hi Team,

In the 22R1 version, we utilized the SOOrder.CCCardNumber fields in our reports to display Card Number details. However, these fields have been removed in the 23R1 version, leading to an "Invalid column" issue.

Is there an alternative solution available?

Thanks in advance.

Best answer by jinin

Hi @mounikaka96 ,

Did you try with CustomerPaymentMethod table join with PMInstanceID? CustomerPaymentMethod table Decr field we can use. 
 

 

    2 replies

    jinin
    Pro I
    Forum|alt.badge.img+11
    • jinin
    • Pro I
    • Answer
    • October 12, 2023

    Hi @mounikaka96 ,

    Did you try with CustomerPaymentMethod table join with PMInstanceID? CustomerPaymentMethod table Decr field we can use. 
     

     

    Jini N
    Dmitrii Naumov
    M
    Chris Hackett
    M
    Freshman I
    • mounikaka96
    • Author
    • Freshman I
    • October 13, 2023

    Its worked jini.Thank you!

    jinin
    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