RSS

Ledger Journal Import

26 Jul

static void GL_GJImport(Args _args)

{

    textBuffer tb = new textBuffer();

    int cnt;

    int numLines;

    int c;

    container inLine;

    boolean first = true;

    Dimension finDim;

    amount amount;

    LedgerJournalACType LedgerJournalACType;

    ledgerJournalName ledgerJournalName;

    journalID JournalID;

    axLedgerJournalTable axLedgerJournalTable;

    axledgerJournalTrans axLedgerJournalTrans;

    LedgerJournalType JournalType = ledgerJournalType::Daily;

    ;

    tb.fromFile(‘C:\\sampleGLImport.csv’);  //File name  with Path …

    numLines = tb.numLines();

    if(numLines)

    {

        ttsBegin;

        for(cnt = 0; cnt < numLines; ++cnt)

        {

            inLine = str2Con(tb.nextToken(true));

            if(conpeek(inLine, 1) && !first)  //first field don’t do anything if blank

            {

                if(!JournalID) //Create Journal Haader

                {

                    select firstonly ledgerJournalName

                        where ledgerJournalName.JournalType == JournalType;

                    axLedgerJournalTable = new axLedgerJournalTable();

                    axLedgerJournalTable.parmJournalName(ledgerJournalName.JournalName);

                    axLedgerJournalTable.parmJournalType(JournalType);

                    axLedgerJournalTable.parmName(“Journal Description”);

                    axLedgerJournalTable.save();

                    JournalID = axLedgerJournalTable.parmJournalNum();

                }

                //Create Trans …

                axLedgerJournalTrans = new axLedgerJournalTrans();

                axLedgerJournalTrans.parmJournalNum(JournalID);

                axLedgerJournalTrans.parmAccountType(  str2Enum(LedgerJournalACType, conPeek(inLine,    1)));

                axLedgerJournalTrans.parmAccountNum(conpeek(inLine, 2));

                axLedgerJournalTrans.parmOffsetAccountType(  str2Enum(LedgerJournalACType,  conpeek(inLine, 3)));

                axLedgerJournalTrans.parmOffsetAccount(conpeek(inLine, 4));

                finDim[1] = conPeek(inLine, 6);

                finDim[2] = conPeek(inLine, 7);

                axLedgerJournalTrans.parmDimension(finDim);

                amount = conpeek(inLine, 5);

                axLedgerJournalTrans.parmAmountCurCredit((amount > 0 ? abs(amount) : 0));

                axLedgerJournalTrans.parmAmountCurDebit((amount < 0 ? abs(amount) : 0));

                axLedgerJournalTrans.save();

                ++c;

            }

            first = false;

        }

        ttsCommit;

        info(strFmt(‘Imported %1 Items’, c));

    }

}

// Job End <–

Acct Type Acct Offset Type OffSet Acct Amount Department CostCenter
Bank USA Oper Ledger

300160

500

1201

Ledger

300160

Bank USA Oper

-250

1102

Advertisements
 
Leave a comment

Posted by on July 26, 2011 in X++

 

Tags:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
All About Dynamics 365

Dynamics 365, D365, Implementor

syedrafayali

This blog contains information about Functional techniques and guidelines in Microsoft Dynamics AX, including tips, tricks, tutorials, tools and upcoming news enhancement in Microsoft Dynamics Ax

Philippsen's Blog

Everyday findings in my world of .net and related stuff

Microsoft Dynamics AX

A great WordPress.com site

Finite Minds

Adventures in IoT

Dynamics Ax

Technical Knowledge

timsaxblog

A blog about implementing Microsoft Dynamics AX and Dynamics 365 for Operations

Microsoft Dynamics 365 Blog

All Things Dynamics 365 - Enterprise Edition, A Blog by Sandeep Chaudhury

DEVSerra - Dynamics AX development blog

Your official Microsoft Dynamics AX blog.

OrganicAX

Discovering Dynamics

AX

A blog by Hai Nguyen

Learn Dynamics Ax with Johnkrish

Live as if you were to die tomorrow. Learn as if you were to live forever - Mahatma Gandhi ****** The more I learn, the less I know - Albert Einstein

Twisted Untwirled

Just another WordPress.com site

ramdynamicsax

Just another WordPress.com site

guyterry's Dynamics AX blog

Just another Dynamics AX blog

Chaitanya kumar

Happy DAXing...!!! :)

%d bloggers like this: