Solved

Custom DAC issues

  • 2 September 2021
  • 2 replies
  • 43 views

I have a new screen which utilizes a custom DAC class based on a table I imported in to the Acumatica database. When I manually add rows to the SQL table, the data is present in the new screen but the save functionality is not working. I don’t receive any errors but the data is not actually saved to the database for new or existing rows. The delete button does not work either.

 

Because I can view the data properly, but not save, I am lead to believe that this is an issue with some of the DAC attributes but I followed the documentation in the partner learning program (and I got the example to work) but now this project isn’t working.

 

Here is new custom DAC:

using System;
using PX.Data;

namespace MyCustomImport
{

[PXCacheName("myTable")]
public class myTable: IBqlTable
{
#region Ord_type
[PXDBString(1, IsKey = true, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXDefault]
[PXUIField(DisplayName = "Ord_type")]
public virtual string Ord_type { get; set; }
public abstract class ord_type : PX.Data.BQL.BqlString.Field<ord_type> { }
#endregion

#region Ord_no
[PXDBString(8, IsKey = true, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXDefault]
[PXUIField(DisplayName = "Ord_no")]
public virtual string Ord_no { get; set; }
public abstract class ord_no : PX.Data.BQL.BqlString.Field<ord_no> { }
#endregion

#region Entered_dt
[PXDBDate()]
[PXDefault]
[PXUIField(DisplayName = "Entered_dt")]
public virtual DateTime? Entered_dt { get; set; }
public abstract class entered_dt : PX.Data.BQL.BqlDateTime.Field<entered_dt> { }
#endregion

#region Ord_dt
[PXDBDate()]
[PXDefault]
[PXUIField(DisplayName = "Ord_dt")]
public virtual DateTime? Ord_dt { get; set; }
public abstract class ord_dt : PX.Data.BQL.BqlDateTime.Field<ord_dt> { }
#endregion

#region Apply_to_no
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Apply_to_no")]
public virtual string Apply_to_no { get; set; }
public abstract class apply_to_no : PX.Data.BQL.BqlString.Field<apply_to_no> { }
#endregion

#region Oe_po_no
[PXDBString(25, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Oe_po_no")]
public virtual string Oe_po_no { get; set; }
public abstract class oe_po_no : PX.Data.BQL.BqlString.Field<oe_po_no> { }
#endregion

#region Cus_no
[PXDBString(20, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cus_no")]
public virtual string Cus_no { get; set; }
public abstract class cus_no : PX.Data.BQL.BqlString.Field<cus_no> { }
#endregion

#region Bill_to_name
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_name")]
public virtual string Bill_to_name { get; set; }
public abstract class bill_to_name : PX.Data.BQL.BqlString.Field<bill_to_name> { }
#endregion

#region Bill_to_addr_1
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_addr_1")]
public virtual string Bill_to_addr_1 { get; set; }
public abstract class bill_to_addr_1 : PX.Data.BQL.BqlString.Field<bill_to_addr_1> { }
#endregion

#region Bill_to_addr_2
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_addr_2")]
public virtual string Bill_to_addr_2 { get; set; }
public abstract class bill_to_addr_2 : PX.Data.BQL.BqlString.Field<bill_to_addr_2> { }
#endregion

#region Bill_to_addr_3
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_addr_3")]
public virtual string Bill_to_addr_3 { get; set; }
public abstract class bill_to_addr_3 : PX.Data.BQL.BqlString.Field<bill_to_addr_3> { }
#endregion

#region Bill_to_addr_4
[PXDBString(44, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_addr_4")]
public virtual string Bill_to_addr_4 { get; set; }
public abstract class bill_to_addr_4 : PX.Data.BQL.BqlString.Field<bill_to_addr_4> { }
#endregion

#region Bill_to_country
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_country")]
public virtual string Bill_to_country { get; set; }
public abstract class bill_to_country : PX.Data.BQL.BqlString.Field<bill_to_country> { }
#endregion

#region Cus_alt_adr_cd
[PXDBString(15, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cus_alt_adr_cd")]
public virtual string Cus_alt_adr_cd { get; set; }
public abstract class cus_alt_adr_cd : PX.Data.BQL.BqlString.Field<cus_alt_adr_cd> { }
#endregion

#region Ship_to_name
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_name")]
public virtual string Ship_to_name { get; set; }
public abstract class ship_to_name : PX.Data.BQL.BqlString.Field<ship_to_name> { }
#endregion

#region Ship_to_addr_1
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_addr_1")]
public virtual string Ship_to_addr_1 { get; set; }
public abstract class ship_to_addr_1 : PX.Data.BQL.BqlString.Field<ship_to_addr_1> { }
#endregion

#region Ship_to_addr_2
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_addr_2")]
public virtual string Ship_to_addr_2 { get; set; }
public abstract class ship_to_addr_2 : PX.Data.BQL.BqlString.Field<ship_to_addr_2> { }
#endregion

#region Ship_to_addr_3
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_addr_3")]
public virtual string Ship_to_addr_3 { get; set; }
public abstract class ship_to_addr_3 : PX.Data.BQL.BqlString.Field<ship_to_addr_3> { }
#endregion

#region Ship_to_addr_4
[PXDBString(44, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_addr_4")]
public virtual string Ship_to_addr_4 { get; set; }
public abstract class ship_to_addr_4 : PX.Data.BQL.BqlString.Field<ship_to_addr_4> { }
#endregion

#region Ship_to_country
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_country")]
public virtual string Ship_to_country { get; set; }
public abstract class ship_to_country : PX.Data.BQL.BqlString.Field<ship_to_country> { }
#endregion

#region Shipping_dt
[PXDBDate()]
[PXUIField(DisplayName = "Shipping_dt")]
public virtual DateTime? Shipping_dt { get; set; }
public abstract class shipping_dt : PX.Data.BQL.BqlDateTime.Field<shipping_dt> { }
#endregion

#region Ship_via_cd
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_via_cd")]
public virtual string Ship_via_cd { get; set; }
public abstract class ship_via_cd : PX.Data.BQL.BqlString.Field<ship_via_cd> { }
#endregion

#region Ar_terms_cd
[PXDBString(2, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ar_terms_cd")]
public virtual string Ar_terms_cd { get; set; }
public abstract class ar_terms_cd : PX.Data.BQL.BqlString.Field<ar_terms_cd> { }
#endregion

#region Ship_instruction_1
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_instruction_1")]
public virtual string Ship_instruction_1 { get; set; }
public abstract class ship_instruction_1 : PX.Data.BQL.BqlString.Field<ship_instruction_1> { }
#endregion

#region Ship_instruction_2
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_instruction_2")]
public virtual string Ship_instruction_2 { get; set; }
public abstract class ship_instruction_2 : PX.Data.BQL.BqlString.Field<ship_instruction_2> { }
#endregion

#region Slspsn_no
[PXDBInt()]
[PXUIField(DisplayName = "Slspsn_no")]
public virtual int? Slspsn_no { get; set; }
public abstract class slspsn_no : PX.Data.BQL.BqlInt.Field<slspsn_no> { }
#endregion

#region Slspsn_pct_comm
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_pct_comm")]
public virtual Decimal? Slspsn_pct_comm { get; set; }
public abstract class slspsn_pct_comm : PX.Data.BQL.BqlDecimal.Field<slspsn_pct_comm> { }
#endregion

#region Slspsn_comm_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_comm_amt")]
public virtual Decimal? Slspsn_comm_amt { get; set; }
public abstract class slspsn_comm_amt : PX.Data.BQL.BqlDecimal.Field<slspsn_comm_amt> { }
#endregion

#region Slspsn_no_2
[PXDBInt()]
[PXUIField(DisplayName = "Slspsn_no_2")]
public virtual int? Slspsn_no_2 { get; set; }
public abstract class slspsn_no_2 : PX.Data.BQL.BqlInt.Field<slspsn_no_2> { }
#endregion

#region Slspsn_pct_comm_2
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_pct_comm_2")]
public virtual Decimal? Slspsn_pct_comm_2 { get; set; }
public abstract class slspsn_pct_comm_2 : PX.Data.BQL.BqlDecimal.Field<slspsn_pct_comm_2> { }
#endregion

#region Slspsn_comm_amt_2
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_comm_amt_2")]
public virtual Decimal? Slspsn_comm_amt_2 { get; set; }
public abstract class slspsn_comm_amt_2 : PX.Data.BQL.BqlDecimal.Field<slspsn_comm_amt_2> { }
#endregion

#region Slspsn_no_3
[PXDBInt()]
[PXUIField(DisplayName = "Slspsn_no_3")]
public virtual int? Slspsn_no_3 { get; set; }
public abstract class slspsn_no_3 : PX.Data.BQL.BqlInt.Field<slspsn_no_3> { }
#endregion

#region Slspsn_pct_comm_3
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_pct_comm_3")]
public virtual Decimal? Slspsn_pct_comm_3 { get; set; }
public abstract class slspsn_pct_comm_3 : PX.Data.BQL.BqlDecimal.Field<slspsn_pct_comm_3> { }
#endregion

#region Slspsn_comm_amt_3
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_comm_amt_3")]
public virtual Decimal? Slspsn_comm_amt_3 { get; set; }
public abstract class slspsn_comm_amt_3 : PX.Data.BQL.BqlDecimal.Field<slspsn_comm_amt_3> { }
#endregion

#region Tax_cd
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Tax_cd")]
public virtual string Tax_cd { get; set; }
public abstract class tax_cd : PX.Data.BQL.BqlString.Field<tax_cd> { }
#endregion

#region Tax_pct
[PXDBDecimal()]
[PXUIField(DisplayName = "Tax_pct")]
public virtual Decimal? Tax_pct { get; set; }
public abstract class tax_pct : PX.Data.BQL.BqlDecimal.Field<tax_pct> { }
#endregion

#region Tax_cd_2
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Tax_cd_2")]
public virtual string Tax_cd_2 { get; set; }
public abstract class tax_cd_2 : PX.Data.BQL.BqlString.Field<tax_cd_2> { }
#endregion

#region Tax_pct_2
[PXDBDecimal()]
[PXUIField(DisplayName = "Tax_pct_2")]
public virtual Decimal? Tax_pct_2 { get; set; }
public abstract class tax_pct_2 : PX.Data.BQL.BqlDecimal.Field<tax_pct_2> { }
#endregion

#region Tax_cd_3
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Tax_cd_3")]
public virtual string Tax_cd_3 { get; set; }
public abstract class tax_cd_3 : PX.Data.BQL.BqlString.Field<tax_cd_3> { }
#endregion

#region Tax_pct_3
[PXDBDecimal()]
[PXUIField(DisplayName = "Tax_pct_3")]
public virtual Decimal? Tax_pct_3 { get; set; }
public abstract class tax_pct_3 : PX.Data.BQL.BqlDecimal.Field<tax_pct_3> { }
#endregion

#region Discount_pct
[PXDBDecimal()]
[PXUIField(DisplayName = "Discount_pct")]
public virtual Decimal? Discount_pct { get; set; }
public abstract class discount_pct : PX.Data.BQL.BqlDecimal.Field<discount_pct> { }
#endregion

#region Job_no
[PXDBString(20, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Job_no")]
public virtual string Job_no { get; set; }
public abstract class job_no : PX.Data.BQL.BqlString.Field<job_no> { }
#endregion

#region Mfg_loc
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Mfg_loc")]
public virtual string Mfg_loc { get; set; }
public abstract class mfg_loc : PX.Data.BQL.BqlString.Field<mfg_loc> { }
#endregion

#region Profit_center
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Profit_center")]
public virtual string Profit_center { get; set; }
public abstract class profit_center : PX.Data.BQL.BqlString.Field<profit_center> { }
#endregion

#region Dept
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Dept")]
public virtual string Dept { get; set; }
public abstract class dept : PX.Data.BQL.BqlString.Field<dept> { }
#endregion

#region Ar_reference
[PXDBString(45, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ar_reference")]
public virtual string Ar_reference { get; set; }
public abstract class ar_reference : PX.Data.BQL.BqlString.Field<ar_reference> { }
#endregion

#region Tot_sls_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_sls_amt")]
public virtual Decimal? Tot_sls_amt { get; set; }
public abstract class tot_sls_amt : PX.Data.BQL.BqlDecimal.Field<tot_sls_amt> { }
#endregion

#region Tot_sls_disc
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_sls_disc")]
public virtual Decimal? Tot_sls_disc { get; set; }
public abstract class tot_sls_disc : PX.Data.BQL.BqlDecimal.Field<tot_sls_disc> { }
#endregion

#region Tot_tax_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_tax_amt")]
public virtual Decimal? Tot_tax_amt { get; set; }
public abstract class tot_tax_amt : PX.Data.BQL.BqlDecimal.Field<tot_tax_amt> { }
#endregion

#region Tot_cost
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_cost")]
public virtual Decimal? Tot_cost { get; set; }
public abstract class tot_cost : PX.Data.BQL.BqlDecimal.Field<tot_cost> { }
#endregion

#region Tot_weight
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_weight")]
public virtual Decimal? Tot_weight { get; set; }
public abstract class tot_weight : PX.Data.BQL.BqlDecimal.Field<tot_weight> { }
#endregion

#region Misc_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Misc_amt")]
public virtual Decimal? Misc_amt { get; set; }
public abstract class misc_amt : PX.Data.BQL.BqlDecimal.Field<misc_amt> { }
#endregion

#region Frt_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Frt_amt")]
public virtual Decimal? Frt_amt { get; set; }
public abstract class frt_amt : PX.Data.BQL.BqlDecimal.Field<frt_amt> { }
#endregion

#region Sls_tax_amt_1
[PXDBDecimal()]
[PXUIField(DisplayName = "Sls_tax_amt_1")]
public virtual Decimal? Sls_tax_amt_1 { get; set; }
public abstract class sls_tax_amt_1 : PX.Data.BQL.BqlDecimal.Field<sls_tax_amt_1> { }
#endregion

#region Sls_tax_amt_2
[PXDBDecimal()]
[PXUIField(DisplayName = "Sls_tax_amt_2")]
public virtual Decimal? Sls_tax_amt_2 { get; set; }
public abstract class sls_tax_amt_2 : PX.Data.BQL.BqlDecimal.Field<sls_tax_amt_2> { }
#endregion

#region Sls_tax_amt_3
[PXDBDecimal()]
[PXUIField(DisplayName = "Sls_tax_amt_3")]
public virtual Decimal? Sls_tax_amt_3 { get; set; }
public abstract class sls_tax_amt_3 : PX.Data.BQL.BqlDecimal.Field<sls_tax_amt_3> { }
#endregion

#region Comm_pct
[PXDBDecimal()]
[PXUIField(DisplayName = "Comm_pct")]
public virtual Decimal? Comm_pct { get; set; }
public abstract class comm_pct : PX.Data.BQL.BqlDecimal.Field<comm_pct> { }
#endregion

#region Comm_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Comm_amt")]
public virtual Decimal? Comm_amt { get; set; }
public abstract class comm_amt : PX.Data.BQL.BqlDecimal.Field<comm_amt> { }
#endregion

#region Cmt_1
[PXDBString(35, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cmt_1")]
public virtual string Cmt_1 { get; set; }
public abstract class cmt_1 : PX.Data.BQL.BqlString.Field<cmt_1> { }
#endregion

#region Cmt_2
[PXDBString(35, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cmt_2")]
public virtual string Cmt_2 { get; set; }
public abstract class cmt_2 : PX.Data.BQL.BqlString.Field<cmt_2> { }
#endregion

#region Cmt_3
[PXDBString(35, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cmt_3")]
public virtual string Cmt_3 { get; set; }
public abstract class cmt_3 : PX.Data.BQL.BqlString.Field<cmt_3> { }
#endregion

#region Inv_no
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Inv_no")]
public virtual string Inv_no { get; set; }
public abstract class inv_no : PX.Data.BQL.BqlString.Field<inv_no> { }
#endregion

#region Inv_dt
[PXDBDate()]
[PXUIField(DisplayName = "Inv_dt")]
public virtual DateTime? Inv_dt { get; set; }
public abstract class inv_dt : PX.Data.BQL.BqlDateTime.Field<inv_dt> { }
#endregion

#region Lost_sale_cd
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Lost_sale_cd")]
public virtual string Lost_sale_cd { get; set; }
public abstract class lost_sale_cd : PX.Data.BQL.BqlString.Field<lost_sale_cd> { }
#endregion

#region Orig_ord_type
[PXDBString(1, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Orig_ord_type")]
public virtual string Orig_ord_type { get; set; }
public abstract class orig_ord_type : PX.Data.BQL.BqlString.Field<orig_ord_type> { }
#endregion

#region Orig_ord_dt
[PXDBDate()]
[PXUIField(DisplayName = "Orig_ord_dt")]
public virtual DateTime? Orig_ord_dt { get; set; }
public abstract class orig_ord_dt : PX.Data.BQL.BqlDateTime.Field<orig_ord_dt> { }
#endregion

#region Orig_ord_no
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Orig_ord_no")]
public virtual string Orig_ord_no { get; set; }
public abstract class orig_ord_no : PX.Data.BQL.BqlString.Field<orig_ord_no> { }
#endregion

#region User_def_fld_1
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_1")]
public virtual string User_def_fld_1 { get; set; }
public abstract class user_def_fld_1 : PX.Data.BQL.BqlString.Field<user_def_fld_1> { }
#endregion

#region User_def_fld_2
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_2")]
public virtual string User_def_fld_2 { get; set; }
public abstract class user_def_fld_2 : PX.Data.BQL.BqlString.Field<user_def_fld_2> { }
#endregion

#region User_def_fld_3
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_3")]
public virtual string User_def_fld_3 { get; set; }
public abstract class user_def_fld_3 : PX.Data.BQL.BqlString.Field<user_def_fld_3> { }
#endregion

#region User_def_fld_4
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_4")]
public virtual string User_def_fld_4 { get; set; }
public abstract class user_def_fld_4 : PX.Data.BQL.BqlString.Field<user_def_fld_4> { }
#endregion

#region User_def_fld_5
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_5")]
public virtual string User_def_fld_5 { get; set; }
public abstract class user_def_fld_5 : PX.Data.BQL.BqlString.Field<user_def_fld_5> { }
#endregion

#region Packing_no
[PXDBInt()]
[PXUIField(DisplayName = "Packing_no")]
public virtual int? Packing_no { get; set; }
public abstract class packing_no : PX.Data.BQL.BqlInt.Field<packing_no> { }
#endregion

#region CreatedDateTime
[PXDBCreatedDateTime()]
public virtual DateTime? CreatedDateTime { get; set; }
public abstract class createdDateTime : PX.Data.BQL.BqlDateTime.Field<createdDateTime> { }
#endregion

#region CreatedByID
[PXDBCreatedByID()]
public virtual Guid? CreatedByID { get; set; }
public abstract class createdByID : PX.Data.BQL.BqlGuid.Field<createdByID> { }
#endregion

#region CreatedByScreenID
[PXDBCreatedByScreenID()]
public virtual string CreatedByScreenID { get; set; }
public abstract class createdByScreenID : PX.Data.BQL.BqlString.Field<createdByScreenID> { }
#endregion

#region LastModifiedDateTime
[PXDBLastModifiedDateTime()]
public virtual DateTime? LastModifiedDateTime { get; set; }
public abstract class lastModifiedDateTime : PX.Data.BQL.BqlDateTime.Field<lastModifiedDateTime> { }
#endregion

#region LastModifiedByID
[PXDBLastModifiedByID()]
public virtual Guid? LastModifiedByID { get; set; }
public abstract class lastModifiedByID : PX.Data.BQL.BqlGuid.Field<lastModifiedByID> { }
#endregion

#region LastModifiedByScreenID
[PXDBLastModifiedByScreenID()]
public virtual string LastModifiedByScreenID { get; set; }
public abstract class lastModifiedByScreenID : PX.Data.BQL.BqlString.Field<lastModifiedByScreenID> { }
#endregion

#region Tstamp
[PXDBTimestamp()]
[PXUIField(DisplayName = "Tstamp")]
public virtual byte[] Tstamp { get; set; }
public abstract class tstamp : PX.Data.BQL.BqlByteArray.Field<tstamp> { }
#endregion

#region Noteid
[PXNote()]
public virtual Guid? Noteid { get; set; }
public abstract class noteid : PX.Data.BQL.BqlGuid.Field<noteid> { }
#endregion

}
}

And the main graph tied to the screen:

using System;
using PX.Data;
using PX.Data.BQL.Fluent;

namespace MyCustomImport
{
public class OEHeaderMaint : PXGraph<OEHeaderMaint>
{

public PXSave<myTable> Save;
public PXCancel<myTable> Cancel;
public SelectFrom<myTable>.View OEHeaderView;

public PXFilter<myTable> MasterView;
public PXFilter<DetailsTable> DetailsView;

[Serializable]
public class MasterTable : IBqlTable
{

}

[Serializable]
public class DetailsTable : IBqlTable
{

}


}
}

 

The primary key of the SQL table is CompanyID (int), ord_type (nchar(1)), and ord_no (nchar(8)) and none of the other fields are required except for the system fields (created, last modified, tstamp, noteid, etc.)

 

Thanks in advance for any help!

icon

Best answer by Naveen B 2 September 2021, 17:33

View original

2 replies

Userlevel 7
Badge +10

Hi @ryanmoon32  Can you please let me know that the Primary View and Data Member of the form in   .aspx page ?

And, remove the unnecessary code from the graph.

 

using System;
using PX.Data;
using PX.Data.BQL.Fluent;

namespace MyCustomImport
{
public class OEHeaderMaint : PXGraph<OEHeaderMaint>
{

public PXSave<myTable> Save;
public PXCancel<myTable> Cancel;

public SelectFrom<myTable>.View OEHeaderView;

}
}

 

@Naveen B

Wow.. Simply removing the extra code in my graph solved all of the issues. I am thankful that it was such an easy solution and for your help. Thank you!

 

 

Reply


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 — 2020  Acumatica, Inc. All rights reserved