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