Is is possible to add new column to standard table?

Question

Is is possible to add new column to standard table like OEORDD? I'm converting the old system to c# and noticed that there are two new columns on OEORDD table based from this site: http://sageaom.kcsvar.com/AOM2019/OE0500.xml New columns named: PDTLNUM and PARENTUNIQ In the source code they are using like this: 
 vOEORDD.Fields.FieldByName["PARENTUNIQ"].PutWithoutVerification(vOEORDDParent.Fields.FieldByName["ORDUNIQ"].get_Value());
vOEORDD.Fields.FieldByName["PDTLNUM"].PutWithoutVerification(vOEORDDParent.Fields.FieldByName["DETAILNUM"].get_Value()); 
 But when I'm running it to my project solution. I'm getting the COM error. 
 Error HRESULT E_FAIL has been returned from a call to a COM component. 
 I've query the OEORDD table and those fields are existing.

Django · Answer

You can't add fields to Sage tables without using the SDK. Technically you can add the fields in SQL and then update them manually but you're asking for trouble at some point. Your best bet would be to add those two fields as detail line optional fields. If those fields are already in your table then I would think that you had some other third-party SDK add-on installed that is no longer installed.

Sage 300

Is is possible to add new column to standard table?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING