Skip to main content
Answer

Missing Field

  • August 27, 2021
  • 2 replies
  • 176 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 

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,

    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
    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • 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
    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