From July 9th till 13th we will be at #MSInspire. See you there!

HOW TO CREATE PURCHASE ORDER IN MICROSOFT DYNAMICS AX 2012

HOW TO CREATE PURCHASE ORDER IN MICROSOFT DYNAMICS AX 2012
13 Oct 2014

Hi Guys,

In this post I’ll show you how to create purchase order in Microsoft Dynamics AX 2012 using X++ code (for those of you who aren’t familiar with it).

First off lets create the job that will accomplish the Create Purchase Order in Microsoft Dynamics AX 2012 task.

static void CreatePurchaseOrder(Args _args) {
NumberSeq numberSeq;
Purchtable tbl_purchtable;
PurchLine tbl_purchLine;
PurchFormLetter purchFormLetter;
;

ttsbegin;

// Now let’s create the number sequence object that will generate the purchase order id

numberSeq = NumberSeq::newGetNumFromCode(purchParameters::numRefPurchaseOrderId().NumberSequence, true);

// Next we’ll create the Purchase Order values

tbl_purchtable.initValue();
tbl_purchtable.PurchId = numberSeq.num();
tbl_purchtable.OrderAccount = ‘4000’;
tbl_purchtable.initFromVendTable();

if (!tbl_purchtable.validateWrite()) {
throw Exception::Error;
}
tbl_urchtable.insert();

// And the Purchase Order line items

tbl_purchLine.PurchId = tbl_purchtable.PurchId;
tbl_purchLine.ItemId = ‘LW24GG’;
tbl_purchLine.createLine(true, true, true, true, true, false);
ttscommit;

// Now let’s post the Purchase Order

// If you want to post the packing slip, then change the DocumentStatus to “PackingSlip”

purchFormLetter = purchFormLetter::construct(DocumentStatus::Invoice);

// Next we’ll update the method parameters in sequence i.e.
// Purchase record Buffer
// Invoice Number
// Transaction date

purchFormLetter.update(tbl_purchtable,”Inv_” + tbl_purchTable.PurchId, systemdateget());

// As I mentioned before, if you want to post packing slip, change the DocumentStatus to “PackingSlip”

if (tbl_purchTable::find(tbl_purchTable.PurchId).DocumentStatus == DocumentStatus::Invoice) {
info(strfmt(“Invoiced journal for purchase order %1”, tbl_purchTable.PurchId));
}
}

And that’s it!

About Folio3 Dynamics Services

FDS (Folio3 Dynamics Services) is a dedicated division of Folio3 that specializes in Microsoft Dynamics AX, Dynamics CRM, Dynamics NAV and Dynamics GP based development, customization and integration services. Our main focus is on Enterprise Mobility. We firmly believe that opening up Microsoft Dynamics AX and other products to iOS Android, Windows 8 and Windows Phone users will have a huge impact on organizational agility and productivity.

If you have a Dynamics AX based development project you’d like to discuss or would like to know more about our Dynamics AX development services, please get in touch with us.

Share

saboorawan

Latest From Our Blog
7 Ways Dynamics 365 Finance and Operations Boos...
dynamics 365 finance
November 9, 2018
Introduction Launched by Microsoft, Dynamics 365 ERP is one of the most effective for businesses today. It is perfect to save the time, effort and ...
Read more
The Ultimate Guide to Dynamics 365 HR Payroll P...
dynamics hr payroll
October 30, 2018
For any business, irrespective of its size, payroll processing is one of the most important functions. Payroll processing is a method through which...
Read more
An Ultimate Guide to Dynamics 365 Business Cent...
business-central-2
September 24, 2018
Microsoft Dynamics Business Central can capably support all your financial processes, whereby enabling smooth integration with supply chain, operat...
Read more
Contact Form