Solved

Invalid Column Name

  • 23 August 2021
  • 3 replies
  • 555 views
J
Rank

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?

icon

Best answer by vkumar 7 September 2021, 05:58

View original

3 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

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
J
Rank

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

V
Rank
Userlevel 7
Badge +11

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

Reply


Terms & ConditionsCookie 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