Skip to main content
Solved

Missing Field

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 

Please run Acumatica configuration wizard and perform an ‘update DB’ and ‘Update site’. This should update missing default column if any at database level.

Let us know the result. 

 

Regards,

View original
    Did this topic help you find an answer to your question?

    2 replies

    kristianharianja
    Semi-Pro I
    Forum|alt.badge.img+3

    Are you doing customization on that screen or running generic inquiry/report and found that error?

    I typically use POReceiptLineSplit data access class in report to extract lot/serial number. If you don’t do any customization and that error occurs when processing PO receipt, I suggest opening ticket to support as it might be a software issue.

    Kristian Harianja
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • 866 replies
    • Answer
    • September 7, 2021

    Hi @jonahgomez92 

    Please run Acumatica configuration wizard and perform an ‘update DB’ and ‘Update site’. This should update missing default column if any at database level.

    Let us know the result. 

     

    Regards,

    VijayKumarU
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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