Enable Disable Post Button In General Journals For selected User Group

                To Enable disable Post button In General Journal forms, We Have To follow following steps.

step 1; 

Navigate To \Classes\LedgerJournalFormTable\enableButtonsActive----> add ur code in this method

here have added a code to disable Post button for specific user group

                     while select userGroupList

                       where userGroupList.groupId =='Namedis'

                           && userGroupList.userId == curUserId()              

                         {

                              ctrlPostJournalMenu.enabled(false);   --------------------> MenuButton Group

                           }

 Note; LedgerJournalTable Clas is a helper class for Ledger Journal Table form 

Create Purchase Orders header and Lines by importing excel file using X++ in ax2012

Hi guys ,Today we see how to create  Purchase order header and Lines by Excel data in ax 2012 using X++.  

I write the code in job for testing purpose.i share that code to  you.Just write this code in job and test it.

Here vendor account and Delivery date value are hot coded so for that values i create a macro.

static void ReadExcelfile1(Args _args)

{

    #define.Vendor("US-105")

    #define.DeliveryDate("1/1/2014")

    SysExcelApplication         application;

    SysExcelWorkbooks           workbooks;

    SysExcelWorkbook            workbook;

    SysExcelWorksheets          worksheets;

    SysExcelWorksheet           worksheet;

    SysExcelCells               cells;

    Filename                    filename;

    COMVariantType              type;

    int                         rowNo;

    PurchTable      purchTable;

    PurchLine       purchLine;

    InventDim       inventDim;

    str _itemid;

    real                   comvariant2real;

    

    str COMVariant2Str(COMVariant _cv, int _decimals = 0, int _characters = 0, int _separator1 = 0, int _separator2 = 0)

    {

        switch (_cv.variantType())

        {

            case (COMVariantType::VT_BSTR):

            return _cv.bStr();

            case (COMVariantType::VT_R4):

            return num2str(_cv.float(),_characters,_decimals,_separator1,_separator2);

            case (COMVariantType::VT_R8):

            return num2str(_cv.double(),_characters,_decimals,_separator1,_separator2);

            case (COMVariantType::VT_DECIMAL):

            return num2str(_cv.decimal(),_characters,_decimals,_separator1,_separator2);

            case (COMVariantType::VT_DATE):

            return date2str(_cv.date(),123,2,1,2,1,4);

            case (COMVariantType::VT_INT):

            return num2str( _cv.int(),_characters,_decimals,_separator1,_separator2);

            case (COMVariantType::VT_EMPTY):

            return "";

            default: throw error(strfmt("@SYS26908", _cv.variantType())); } return "";

    }

    rowNo   = 1;//If the excel file NOt having header.

    //rowNo   =2;//If the excel file having header.

    application = SysExcelApplication::construct();

    workbooks = application.workbooks();

    filename = @"C:\Users\harika.m\Documents";//Excel file path.

    try

    {

        workbooks.open(filename);

    }

    catch (Exception::Error)

    {

        throw error("File cannot be opened.");

    }

    workbook = workbooks.item(1);

    worksheets = workbook.worksheets();

    worksheet = worksheets.itemFromNum(1);//which shows excel sheet number.

    cells = worksheet.cells();

    type = cells.item(rowNo, 1).value().variantType();

    while (type != COMVariantType::VT_EMPTY)//loop through given excel column.

    {

        type = cells.item(rowNo+1, 1).value().variantType();//It will find variant type of column from given Excel sheet(ReadIntegerFile.xlsx) tiil it get empty.

         ttsbegin;

        //Order header

        purchTable.clear();

        purchTable.initValue(PurchaseType::Purch);

        purchTable.PurchId = NumberSeq::newGetNum(PurchParameters::numRefPurchId()).num();

        purchTable.DeliveryDate = str2Date(#DeliveryDate, 213);

        purchTable.initFromVendTable(VendTable::find(#Vendor));

        if (purchTable.validateWrite())

        {

            purchTable.insert();

        //Order line

            inventDim.clear();

            inventDim.InventSiteId = COMVariant2Str(cells.item(rowNo, 4).value());

            inventDim.InventLocationId = COMVariant2Str(cells.item(rowNo,5).value());

            _itemid = COMVariant2Str(cells.item(rowNo, 1).value());

            purchLine.clear();

            purchLine.initValue(purchTable.PurchaseType);

            purchLine.initFromPurchTable(purchTable);

            purchLine.initFromInventTable(InventTable::find(_itemid));

            purchLine.InventDimId = InventDim::findOrCreate(inventDim).inventDimId;

            purchLine.PurchQty = str2int(cells.item(rowNo, 2).value().bStr());

            purchLine.RemainPurchPhysical = purchLine.PurchQty;

            purchLine.PurchUnit = COMVariant2Str(cells.item(rowNo, 3).value());

            purchLine.QtyOrdered = purchLine.calcQtyOrdered();

            purchLine.RemainInventPhysical = purchLine.QtyOrdered;

            purchLine.setPriceDisc(InventDim::find(purchLine.InventDimId));

            if (purchLine.validateWrite())

            {

                purchLine.insert();

            }

            else

                throw error("Order line");

        }

        else

            throw error("Order header");

        ttscommit;

       info(strFmt("ItemID %1", purchLine.ItemId));

        rowNo++;//To get next column number in the loop.

    }

    

}

Introduction To The Microsoft Dynamics Ax2012

Introduction to Microsoft Dynamics Ax2012

          Hi guys, today we are going to learn some of the basic definations in Ax2012.

What is an ERP System?

        The idea behind an ERP system is that there should be one central point which integrates all of the core essential business processes. To understand an ERP system, one needs to have a knowledge of those processes.That means Integration of All departments in an organization To know the financial statements.

What is Dynamics AX?

Microsoft Dynamics AX is A Software which maintain the ERP for an organization.The main advantages of microsoft dynamics ax is it offer users to their different types of business scenarios with pricing differences.

What are the modules Present in Ax2012 ?

Accounts Payable

This module helps you to manage vendor invoices. You can create and track outgoing invoices, enter the invoice number electronically or manually, or have the vendor enter the invoices through a vendor portal. Other tasks you can do include reviewing, flagging, approving and paying the vendor invoices.

Accounts Receivable

In this module, you can manage your customer invoices and incoming payments. Other tasks you can do include creating customer invoices, receiving payments through different payment types, creating non-sales related invoices, settling invoices among others.

Budgeting

The budgeting module enables you to set up, create and view budgets. You can create budget register entries for the original budget, monitor the funds available for planned programs, revise or transfer the budget, view budget status and history, create budget reports, among other activities.

Cash and Bank Management

The cash and bank management module enables you to maintain your organization’s bank accounts and financial instruments such as promissory notes, bills of exchange, checks, and deposit slips. The module is integrated with different modules including General Ledger, Accounts Receivables, and Accounts Payable.

Fixed Assets

This module helps you to manage your organization’s fixed assets such as equipment, land, vehicles and buildings. You can set up acquisition information about the assets and then depreciate them based on set capitalization. You can also calculate the adjustments on the fixed assets to know the optimum time to dispose them.

Human Resources

This module gives you a clear overview of the performance of your workers, enabling you to identify areas that they can improve efficiency and reduce cost at the same time. Examples of tasks you can accomplish under this module include maintain comprehensive worker information, administer organizations structures, control absenteeism, review worker performance and so on.

Inventory and Warehouse Management

This module helps you to control inbound and outbound activities related to inventory. For example, you an keep track of expected inventory, set up quality inspection and automate quality associations, process shipments to complete orders and so on The module can be integrated with various Microsoft products including Product Information Management, Microsoft Excel, SQL Server Analysis and Sql  Report Services.

Procurement and Sourcing

Procurement and sourcing can be time consuming and a financial fatality in case of erroneous entries. With MX Dynamics Procurement and Sourcing module, you can create purchasing policies to Control the purchasing process, hence speeding up related processes. Other tasks you can manage here include creating agreements with vendors, ordering items and services, maintaining vendor information, identifying suppliers and so on.

Project Management and Accounting

This module enables you to manage and complete different projects. You can set up customer-focused projects based on fixed prices or times and materials and manage the cost of investment or internal projects. Some tasks in the module can be integrated with Microsoft Project Server, making the project planning flexible.

Travel and Expense

If your employees incur expenses for your business during travel, you can manage the expenses through this module. Here, you can define expense policies and automate reimbursement of travel. Other important tasks you can do include create expense reports, create cash advance and travel requisition pages, among others.

          Here the common User Interface of Microsoft Dynamics Ax2012.

       

Happpy Daxing....!