Skip to main content
Answer

Invalid Column Name

  • August 23, 2021
  • 3 replies
  • 791 views
J
Freshman I

I'm having issues regarding with Invalid Column name '[POReceiptLine].[LotSerialNbr]' at Purchase Receipts - PO302000  , already tried to add the missing field to its database, but the error message still occurs.
Am i missing something?

Best answer by vkumar

Hi @jonahgomez92 

Looks like there is another post with this issue. I have suggested to run Acumatica Configuration wizard and perform ‘Update DB’ and ‘Update site’. Let us know the result. That should fix / update any missing default data columns. 

 

Regards,

    3 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • August 23, 2021

    Hi @jonahgomez92  This is something wired.  “LotSerialNbr” is default field of POReceiptLine.

    Did you check in your database table that is this field is available? 

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    J
    Freshman I
    • jonahgomez92
    • Author
    • Freshman I
    • August 23, 2021

    Hello @Naveen B , yes i did, but upon checking the LotSerialNbr field, it is already missing. So i tried to add.

    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • Answer
    • September 7, 2021

    Hi @jonahgomez92 

    Looks like there is another post with this issue. I have suggested to run Acumatica Configuration wizard and perform ‘Update DB’ and ‘Update site’. Let us know the result. That should fix / update any missing default data columns. 

     

    Regards,

    VijayKumarU
    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