Copy Entry Types Via Web Services In Acumatica From One Instance Into Another

 

Hello everybody.

Today I want to share how to copy Entty Types items in acumaticca from one instance into another instance.

The first step was to create import export settings in both instances of acumatica as described in acumatica manual similar to this screenshot:

The second step was to create project, which I decided to make as windows forms application with the following input fields:

For the button click at entry types write the following:

           var context = new ImportEt.Screen
                {
                    CookieContainer = new CookieContainer(), AllowAutoRedirect = true, EnableDecompression = true, Timeout = 1000000, Url = txtFrom.Text
                };

           var lgRes = context.Login(txtUserName.Text, txtPassword.Text);
           if (lgRes.Code == ErrorCode.OK)
           {
                var ca203000 = context.CA203000GetSchema();
                context.CA203000Clear();


                var export = context.CA203000Export(
                    new Command[]
                        {
                            ca203000.EntryType.EntryTypeID, ca203000.EntryType.DisbReceipt, ca203000.EntryType.EntryTypeDescription, ca203000.EntryType.Module, 
ca203000.EntryType.BusinessAccount, ca203000.EntryType.DefaultOffsetAccount, ca203000.EntryType.UseForPaymentsReclassification,
ca203000.EntryType.ReclassificationAccount, ca203000.EntryType.DeductFromPayment }, null, 0, false, false); context.Url = txtTo.Text; var lgRes2 = context.Login(txtUserName.Text, txtPassword.Text); if (lgRes2.Code == ErrorCode.OK) { ca203000 = context.CA203000GetSchema(); context.CA203000Clear(); foreach (var et in export) { var ca203000ImportResults = context.CA203000Submit( new Command[] { new Value { Value = et[0], LinkedCommand = ca203000.EntryType.EntryTypeID}, new Value { Value = et[1], LinkedCommand = ca203000.EntryType.DisbReceipt }, new Value { Value = et[2], LinkedCommand = ca203000.EntryType.EntryTypeDescription }, new Value { Value = et[3], LinkedCommand = ca203000.EntryType.Module }, new Value { Value = et[4], LinkedCommand = ca203000.EntryType.BusinessAccount }, new Value { Value = et[5], LinkedCommand = ca203000.EntryType.DefaultOffsetAccount }, new Value { Value = et[6], LinkedCommand = ca203000.EntryType.UseForPaymentsReclassification }, new Value { Value = et[7], LinkedCommand = ca203000.EntryType.ReclassificationAccount }, new Value { Value = et[8], LinkedCommand = ca203000.EntryType.DeductFromPayment }, ca203000.Actions.Save }); } } }

 

All activities in Acumatica are done via interface context, whic is of type screen. 

As for me, the easiest way to get some data is via command "screenID" + export. In my code you can see construction CA203000Export. Inside of it you can point to id of screen, data of which you want to receive. For example CA203000Export.

The simplest way to send something to acumatica another instance is function "screen id" + "Submit". In my code you can see method CA203000Submit. Fields Value is self-explanatory as for me. The most important and hard to understand for me was LinkedCommand. It can be name of the field. That means values has to be putted into a field. It can be action name to push on and etc. 

Another important facet of mentioned code is Actions.Save. If it is not mentioned, than code will post data to web services, but they wil not be saved.

 

P.S.    source code

 

 

Liqpay For Nopcommerce Version 3 2

 

Hello everybody who is reader of my post.

As it was requested, I created also version of liqpay for nopcommerce of version 3.2. In case if you need it you can enjoy. 

For downloading of new module you can  click here.  

In case if you want to express your thankfullness, you can do it here:

http://payment.zaletskyy.com/send-600 just enter some price and choose currency which is convenient for you.

Also at forum: http://payment.zaletskyy.com/boards/forum/1/liqpay you can express your proposals in any convenient language for you.

If to compare versions 3.1 and 3.2 they have some small differences, and the biggest difference is in the interface IPaymentMethod and as result in processor LiqPayPaymentProcessor.</

No Comments

 

Add a Comment
 

 

Nopcommerce Liqpay Payment Module

 

Hello everybody.

Today I just want to share with everybody liqpay payment module for pryvatbank. Pryvatbank is Ukrainian bank which makes possible to accept credit cards payments on your web site. If you'll install nopcommerce, then you can use my payment module absolutely for free. Later  I will modify this article with description of process of development.

You can Download  it and use it for your own. 

For downloading of 3.2 module you can  click here.  

If you wish to support future extensions of this module, you can do it here.

Web sites which use this module:

http://abc-device.com

http://payment.zaletskyy.com/en/

If you use this module as well let me know in comments

2 Comments

  • Andrey said

    Удалённая работа (Israel)

    We looking for NopCommerce expert for full time job (permanent job).

    To work on small projects (3-4 projects a month).

    Payment:

    1200$ a month.

    Skills:
    Programming Languages Required: c# asp.net-mvc, html5, css3, javascript, jquery.
    Software Frameworks that will be used: entity-framework .net-framework

    Please answer questions when applying:
    Please send 3 best nopcommerce website examples.
    Please send links to extensions if you make any.
    Whats the current version of nopcommerce?

    Please do not apply without links.
    Language
    Speaking - Russian.
    Documentation - English.

  • docotor said

    Thanks for your proposal, but for now I can't accept it

 

Add a Comment
 

 

Autonumbering In Acumatica

Autonumbering in Acumatica

Today I want to share with you how I implemented autonumbering feature in acumatica for page CA304000.

My task originally was the following: add autonumbering feature to the "Document Ref" field with following rules:

  a. step of incrementing is 1

  b. length of field should be six characters. For example 000001, 000002, ... ,  000223,  001024, ..., and so on

First of all I want to state that my way of adding much simpler then "canonical" ( according to acumatica manuals ) way of adding autonumbering.  If you wish to use standard way you should accomplish so many steps that I should admit that my brain wasn't able to boil them in one project. 

Instead of this I used the following steps.

1. In the page CA304000 I found class, which provides data for the page. It looks like this:

<px:PXDataSource ID="ds" runat="server" Visible="True" Width="100%" PrimaryView="CAAdjRecords" TypeName="PX.Objects.CA.CATranEntry">

2. Created extention of class in the following way:

public class CATranEntryExt : PXGraphExtension<CATranEntry>
    {

3. Located method which returns list of records for the page CA304000, it was the method: CAAdjRecords.

4. According to rules of acumatica, if I want to modify behaviour of method CAAdjRecords I should implement method caadjrecords.

5. 

protected virtual IEnumerable caadjrecords()
        {

6. Implemented method which digs in DB, and returns needed number in string format:

protected string GetExtRefNbr()
        {
            var maxNbr = 1;
            foreach (var cAddjRec in PXSelect<CAAdj>.Select(Base, new byte[0]))
            {
                var extRefNbr = ((CAAdj) cAddjRec).ExtRefNbr;
                int curNbr = 0;
                if (int.TryParse(extRefNbr, out curNbr))
                {
                    maxNbr = curNbr + 1;
                }
            }
            var result = maxNbr.ToString(CultureInfo.InvariantCulture).PadLeft(defaultLength, '0');
            return result;
        }

7. Used GetExtRefNbr in the method caadjrecords in the following way:

protected virtual IEnumerable caadjrecords()
        {
            var res = new List<CAAdj>();
            var availableCashAccounts = GetAvailableCashAccounts();

            foreach (
                var doc in
                    PXSelect<CAAdj, Where<CAAdj.draft, Equal<False>>>.Select(Base, new byte[0]))
            {
                
                if (((CAAdj)doc).RefNbr.Contains("NEW"))
                {
                    ((CAAdj) doc).ExtRefNbr = GetExtRefNbr();
                }
                    
            }
            return res;
        }

8. Enjoyed results:

the field Document Ref.: was inserted automatically.

4 Comments

  • Angie Osorno said

    Hi,

    It's me, again hahaha

    I read your articule

    I read your article but I get it ... in my case I have a custom screen that I want to generate the automatic numerical value, but I do not know how.

    could you it teach me how you do?

  • docotor said

    Describe a bit more what kind of autonumbering you need?

  • angie said

    Hi,


    I have selector that it have to search registers about your numbering

    for example, how invoice screen it do...

    I sent an email to you

  • docotor said

    I can't say that I understood what you mean.

Add a Comment

Acumatica Active Directory

 

Hello,

today I want to share just simple record of how to join acumatica and your Active Directory.

For example you have the following data:

Active directory url:LDAP://RT1:389

User name yura_zale@dot.com, password: 123

For cases like this you need the following record in your web.config file:

<activeDirectory enabled="true" path="RT1:389" user="dot\yura_zale" password="123" />

 

Acumatica Certificate

 

Hello everybody,

this will be the first post in December. I want to boast that I got T101 certificate from acumatica univercity which proves that I'm certified developer for acumatica!!!!

you can download it from  Download

The screenshot of it:

 

Find Table By Column Name

 

Quite common task, which I bored to google and as it is not hard to memorize, but decided to record it.

SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS  WHERE COLUMN_NAME LIKE '%DocType%'

 

List View In Accumatica

 

Here I want to describe how to create such simple page like this:

For reading this manual father you need to know how to add page to sitemap in accumatica. If you need me to describe this process let me know, I assume it is not challenging process.

For staff like this you need ListView template and two other classes.

The first class is used to represent single view item in grid and second class intended for navigating in the db. 

Accumatica manual recomends the following location of those two classes:

1. Create separated project ( for example IG )

2. Inside of it create Folder with the name of pages folder ( for example Investigation )

3. Add reference to the dll PX.Data

4. Create class CountryMaint:

namespace IG.Investigation
{
    public class CountryMaint : PXGraph<CountryMaint>
    {
    }
}

5. Build class library and add reference to newly created project.

I got something similar to this ( just without red rectangle ):

For now we have manager of records but without representation of records itself. Let's do it with tool called Data access class generator. Switch back to the file IG301000.aspx choose design mode and for the typename choose IG.Investigation.CountryMaint. 

Press at generate class and in the window that will appear type Country.

Here is what I seen:

Press at "Generate" button and you'll see that class which can represent single record was created exactly in DAC folder.

Now if will have desire to open developed web page you'll notice 

Error #96: View  doesn't exist.

which means that we need to add something, that is called view. What it can be? Add to the class following line

public PXSelect<Country> Countries;

and Visible="true" and then try to open page again:

Error #96: View  doesn't exist.

Why? I went nuts tring to figure out, untill I watched in manual, which sad the next phrase: 

In the Properties window, set the following property for the grid:

• DataMember:Countries

But why it speak about non-mentioned DataMember as View ? I have no idea, but if you have share it.

So, let's set it and execute. Are you ready to see result?