26 March 2012

filter in form by using query

public class FormRun extends ObjectRun
{
str emplid;
QueryBuildRange qbr;
}
------
public void executeQuery()
{
qbr = this.query().dataSourceNo(1).addRange(fieldnum(EmplTable,Emplid));
qbr.value(strfmt("%1",emplid));
super();
}

23 March 2012

14 March 2012

sales order create with X++

static void SalesOrderCreateAndInvoice(Args _args)

{

SalesTable salesTable;

SalesLine salesLine;

NumberSeq NumberSeq;

CustAccount CustAccount = “32323?;

ItemId itemId = “0100000007?;

SalesFormLetter salesFormLetter;

SalesFormLetter_Invoice invoice;

;

// Order header (salesTable)

// New order number from number range produce

NumberSeq = NumberSeq::newGetNumFromCode(SalesParameters::numRefSalesId().numberSequence,true);

salesTable.SalesId = NumberSeq.num();



// Initialize the order header

salesTable.initValue();

salesTable.CustAccount = CustAccount;



// Initialization of the supplier-specific ordering data

salesTable.initFromCustTable();



// Create order header

salesTable.insert();



// Order position (PurchLine)

salesLine.clear();



// Assign order number and item number

salesLine.SalesId = salesTable.SalesId ;

salesLine.ItemId = itemId;

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

NoYes::Yes, // initFromSalesTable

NoYes::Yes, // initFromInventTable

NoYes::Yes, // calcInventQty

NoYes::Yes, // searchMarkup

NoYes::Yes); // searchPrice



// Create a new object of the SalesFormLetter_Invoice

// by using the construct-method in SalesFormLetter

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

// Post the invoice

invoice.update(salesTable, SystemDateGet(), SalesUpdate::All, AccountOrder::None, false,true);

// Set to true to print the invoice

}

13 March 2012

Get the query value in report

1. This is to get report query range value
Declare a variable in classdeclaration
CustGroup custGroup;

Prompt()

custGroup = this.query().dataSourceTable(tablenum(CustInvoiceJour)).range(1).value();

Write a display method in headder or body
Abd return the value

In query we will get from to range also
Ex: 1001 .. 1010

_______________________
2. Write following code in prolog/ headder or init() method.

public void ExecuteSection()
{
SysReportRun sysReportRun;
;
super();
sysReportRun = element;
sysReportRun.printRanges(true);
sysReportRun::executePrintSection(element);
}

Trial balance export to Azure Blob Storage

The file will be automatically generated from D365 using a batch job. The trial balance file should include all dimensions. (Main-Dept-Cost ...