Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
  • Insert Data in Acumatica ERP

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 913
    Comment on it

    Hi Friends,

    Today i will tell you to how to insert values in acumatica ERP.

    The Code below is used to insert data in the acumatica erp. Suppose i want to insert data into the EPApproval table. Here firstly i need to create instance of current class(PXGraph).


    var maint = PXGraph.CreateInstance<NewTimeActivity>();


    Here PXGraph is The base type that defines the common interface of business logic controllers (graphs), which you should derive from either PX.Data.PXGraph`1 or PX.Data.PXGraph`2.

    Use the below syntax to insert the data into the EPApproval table. You need to specify all the parametrs i am just specifying some parameters.

    var detailsCache = maint.ProviderInsert<PX.Objects.EP.EPApproval>(
               new PXDataFieldAssign("AssignmentMapID", AssignmentMapID),
               new PXDataFieldAssign("WorkgroupID", WorkgroupID),
               new PXDataFieldAssign("OwnerID", OwnerID),
               new PXDataFieldAssign("Status", Status),
               new PXDataFieldAssign("BAccountID", BAccountID),
    //Log the exception

    Where ProviderInsert is used to performs a database delete operation. The table is specified as the DAC through the type parameter.

    We need to provide all the values for a table which are not null otherwise it will give use exception.

    There is another way which acumatica ERP uses i will justify you in my other blog.

    References :- 


    Happy Coding !!


 0 Comment(s)

Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: