Archives

Archives / 2019 / September
  • How to imitate click on Confirm shipment in Acumatica

    Hello everybody,

    Today I want to describe how to imiate click on menu item "Confirm shipment" in Acumatica. 

    Probably your first guess will be just call method ConfirmShiment of graph SOShipmentEntry. But for now Acumatica team has another advice in order to call this action. Instead of calling method ConfirmShipment you'll need to have a bit more steps.

    Code sample below demonstrates those necessary steps:

    SOShipmentEntry shipmentGraph = PXGraph.CreateInstance<SOShipmentEntry>(); //Create instance of Graph

    PXAutomation.CompleteSimple(shipmentGraph.Document.View);

    PXAdapter adapter2 = new PXAdapter(new DummyView(shipmentGraph, shipmentGraph.Document.View.BqlSelect,

     new  … more

  • Pagination in custom inquiry

    Hello everybody,

    today I want to share with everybody, and with myself code fragment, that allows to achieve pagination in custom inquiry pages. 

    Take a look on the code below:

      public class YourGraphInquiry : PXGraph<YourGraphInquiry>

      {

        public PXCancel<YourDACFilter> Cancel;

            public PXFilter<YourDACFilter> Filter;

            [PXFilterable]

            public PXSelect<YourDACDetails,

                Where2<

                    Where<YourDACDetails.Someid, Equal<Current<YourDACFilter.SomeID>>, 

                        Or<Current<YourDACFilter.SomeID>, IsNull>>,

                    And<

                        Where<YourDACDetails.Somepartid, Equal<Current<YourDACFilter.SomePartId>>, 

         … more

  • Database of Acumatica is in Recovery Pending condition

    Hello everybody,

    recently I've got interesting situation, when my database for Acumatica developed turned to be in Pending condtion. In order to deal with it, I've executed following SQL:

    ALTER DATABASE YourDatabase SET EMERGENCY;GOALTER DATABASE YourDatabase set single_userGODBCC CHECKDB (YourDatabase, REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;GO ALTER DATABASE YourDatabase set multi_userGO

    and my database turned back to normal.

    Update on 10/08/2019

    declare @dbName nvarchar(50);

    set @dbName = 'yourDatabase';

    exec( 'ALTER DATABASE' +@dbName  + ' SET EMERGENCY;')

    exec ('ALTER DATABASE ' + @dbName + '  set single_user')

    exec ('DBCC CHECKDB (' + @dbName + ' , REPAIR_ … more

  • Three states of fields in Acumatica

    Hello everybody,

    today I want to write a short note on three states of fields existing in Acumatica:

    Exists but is empty

    Exist and have value

    Has null

    If to speak about string, it can exist like this:

     

    Some value

     

    Do you see difference between 1 and 3? Not easy. As usually developers of C#, show this difference like this:

    ""

    "Some Value"

    null

    And following screenshot with explanation shows how it works in case of SOAP contracts:

    so, while you make integration, keep that in mind more