Create Sales Order through code

I found few good sample code for creating sales order in a book and I was able to compile a code for posting sales order invoice. I thought I should share on my blog. It might be useful for some one.

Code for creating Sales order

SalesTableType and SalesLinetype. Insert() should be called for creating the sales order. Example is as follows. I am currently looking for code that can contains example code of creating invoice from scratch. I will send you the code in an hour.

static void createSalesTable(CustAccount _custAccount)

{

SalesTable salesTable;

NumberSeq NumberSeq;

;

NumberSeq =

NumberSeq::newGetNumFromCode(SalesParameters::numRefSalesId

().numberSequence);

salesTable.SalesId = NumberSeq.num();

salesTable.initValue();

salesTable.CustAccount = _custAccount;

salesTable.initFromCustTable();

salesTable.insert();

}

Example: Create a Sales Line

static void createSalesLine(SalesId _salesId, ItemId _itemId)

{

SalesLine salesLine;

;

salesLine.clear();

salesLine.SalesId = _salesId;

salesLine.ItemId = _itemId;

salesLine.createLine(NoYes::Yes, // Validate

NoYes::Yes, // initFromSalesTable

NoYes::Yes, // initFromInventTable

NoYes::Yes, // calcInventQty

NoYes::Yes, // searchMarkup

NoYes::Yes); // searchPrice

}

Code for posting Sales order Invoice

static void createSalesOrder(Args _args)

{

SalesFormLetter formLetterObj;

formLetterObj = SalesFormLetter::construct(DocumentStatus::Invoice);

formLetterObj.update(SalesTable::find(“SO-101248”));

}

Confirm Sales Order through code

Hi,

Today i am going to show you how to conform sales order through code

static void confirmSalesOrder (Args _args)
{
        SalesTable salesTable;
        SalesFormLetter salesFormLetter ;
     
        SalesTable = SalesTable::find('SO-ASC0001');

        salesFormLetter = SalesFormLetter::construct(DocumentStatus::Confirmation);

        salesFormLetter.update(salesTable);

}

now run this code,

Post/Create Sales order Packing slip x++

Hi Folks,

Today i am going to show you code how to create and post Packing slip through x++;

static void createPostSalesPackingSlip(Args _args)
{
    SalesTable salesTable;
    SalesFormLetter salesFormLetter;

    salesTable = SalesTable::find('SO-ASC001');
      //Posting Sales Order 
    salesFormLetter=SalesFormLetter::construct(DocumentStatus::PackingSlip);
    salesFormLetter.update(SalesTable::find(sid));
       salesFormLetter.update(salesTable,systemDateGet(),SalesUpdate::All,AccountOrder::Non e, NoYes::No,NoYes::Yes);
    info("Sales Order Status is Delivered");
}

run this job.

Create Sales Order in x++

Hi,

Today i am going to show you code how to create sales order in x++.

static void CreateSalesOrder(Args _args)

{

//declaring variables

SalesTable salesTable;

SalesLine salesLine;

NumberSeq numberSeq;

ttsBegin;

//creating sales order header

//getting sales order id from number sequence

numberSeq = NumberSeq::newGetNum(SalesParameters::numRefSalesId());

numberSeq.used();

salesTable.SalesId = numberSeq.num();

salesTable.initValue();

salesTable.CustAccount = ‘Demo-001′;

salesTable.initFromCustTable();

//validate

if (!salesTable.validateWrite()) {

throw Exception::Error;

}

salesTable.insert();

//creating sales order line

salesLine.SalesId = salesTable.SalesId;

salesLine.ItemId = ‘DM0012′;

salesLine.SalesQty = 2;

salesLine.LinePercent = 1;

salesLine.createLine(true, // Validate

true, // initFromSalesTable

true, // initFromInventTable

true, // calcInventQty

true, // searchMarkup

true  // searchPrice

);

ttsCommit;

//displaying sales order id

info(salesTable.SalesId);

}

And THEN run this job