Getting Error : Invalid Column NoteId

Question

I have requirement to add Image for each serial number.

I have extended the INItemLotSerial and added ImageUrl & NoteID field

[PXTable(typeof(INItemLotSerial.inventoryID),
 typeof(INItemLotSerial.lotSerialNbr),
 IsOptional = true)]
public class InfoINItemLotSerialExtNV : PXCacheExtension<INItemLotSerial>

The DAC Having the following code for NoteID

#region NoteID
    public abstract class noteID : PX.Data.IBqlField
    {
    }
    protected Guid? _NoteID;
    [PXNote]
    public virtual Guid? NoteID
    {
        get
        {
            return this._NoteID;
        }
        set
        {
            this._NoteID = value;
        }
    }
    #endregion

while saving the Purchase receipt document after entering serial numbers, I am getting error Invalid Column : NoteID

`

Did you make sure your database table has that field? and that the site either published the change or if you updated the field outside of the site, recycle the site so it sees the change. I am not sure how well PXNote would work as an extension. — Brendan
In your example what's the purpose of the PXTable attribute? I don't think this is helpful here. Invalid column error message usually means the column is not in the database table. Use a SQL management utility like SQL Management Studio to manually confirm a column named 'NoteID' is present. — Hugues Beauséjour
It looks like PXNote is not working on Extension Table. I have added the Column on INItemLotSerial and removed from extension table. This solved the Invalid column issue — Muralidharan Ramakrishnan

RuslanDev RuslanDev · Accepted Answer · 2017-06-26T18:36:19

Currently, PXNoteAttribute do not support extension tables, so your only option is use a regular extension for the INItemLotSerial DAC over an extension table.

Getting Error : Invalid Column NoteId

1 Answers