Skip to main content

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?

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? 

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

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,

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