PurchaseInvoice Report

Purchase Invoice Report:

 Contract Class:

 [ DataContractAttribute]
public class INC_PurchaseInvoiceContract
{
    VendInvoiceId           vendinvoiceId;
}
-------------------------
[DataMemberAttribute("VendInvocieId")]
public VendInvoiceId parmVendInvoiceId(VendInvoiceId _vendinvoiceId = vendinvoiceId)
{
    vendinvoiceId = _vendinvoiceId;

    return vendinvoiceId;
}
---------------------------------

RDP Class:

 [SRSReportParameterAttribute(classstr(INC_PurchaseInvoiceContract))]
public class INC_PurchaseInvoiceDP extends SrsReportDataProviderPreProcessTempDB
{
    INC_PurchaseInvoiceContract         contract;
    INC_PurchaseInvoiceHeaderTmp        header;
    INC_PurchaseInvoiceLineTmp          lines;
    VendInvoiceId                       vendinvoiceid;
    VendInvoiceJour                     vendinvoicejour;
    VendInvoiceTrans                    vendinvoicetrans;

}
------------------------------
[SRSReportDataSetAttribute('INC_PurchaseInvoiceHeaderTmp')]
public INC_PurchaseInvoiceHeaderTmp getINC_PurchaseInvoiceHeaderTmp()
{
    select  header;
    return  header;
}

[SRSReportDataSetAttribute('INC_PurchaseInvoiceLineTmp')]
public INC_PurchaseInvoiceLineTmp getINC_PurchaseInvoiceLineTmp()
{
    select  lines;
    return  lines;
}
------------------------------------------
public void processReport()
{
    contract        = this.parmDataContract();
    vendinvoiceid   = contract.parmVendInvoiceId();

    this.setHeader(vendinvoiceid);
    this.setLine(vendinvoiceid);
}
------------------------------------------
public void setHeader(VendInvoiceId _invoiceid)
{
    UserInfo            userInfo;
    VendInvoiceTrans    vendinvoicetranslocal;
    select firstOnly userInfo where userInfo.id ==  curUserId();
    select vendinvoicejour
            where vendinvoicejour.InvoiceId == _invoiceid;
    select vendinvoicetranslocal where vendinvoicetranslocal.InvoiceId == vendinvoicejour.InvoiceId;
    header.VendorCode           =   vendinvoicejour.OrderAccount;
    header.VendorName           =   vendinvoicejour.vendName();
    header.VendorDoc            =   vendinvoicejour.InvoiceId;
    header.InvoiceDate          =   vendinvoicejour.InvoiceDate;
    header.PO                   =   vendinvoicejour.PurchId;
    header.PrintedBy            =   UserInfo.name;
    header.Prepared             =   PurchTable::find(vendinvoicejour.PurchId).createdBy;
    header.PostedBy             =   vendinvoicejour.createdBy;
    header.PostedDate           =   DateTimeUtil::date(DateTimeUtil::applyTimeZoneOffset(vendinvoicejour.createdDateTime, DateTimeUtil::getUserPreferredTimeZone()));
    header.Approved             =   '';
    header.CompanyImage         =   FormLetter::companyLogo();
    header.Invoiceid            =   vendinvoicejour.InternalInvoiceId;
    header.GRN                  =   VendPackingSlipTrans::findInventTransId_RU(vendinvoicetranslocal.InventTransId).PackingSlipId;
    header.insert();
}
-----------------------------------
public void setLine(VendInvoiceId   _invoiceid)
{
    while select vendinvoicetrans
                 where vendinvoicetrans.InvoiceId == _invoiceid
    {
        lines.ItemId                = vendinvoicetrans.ItemId;
        lines.ItemDescription       = vendinvoicetrans.Name;
        lines.Qty                   = vendinvoicetrans.Qty;
        lines.PurchPrice            = vendinvoicetrans.PurchPrice;
        lines.LineTotal             = vendinvoicetrans.lineAmountInclTax();
        lines.Tax                   = VendInvoiceJour::findFromVendInvoiceTrans(vendinvoicetrans.PurchID,vendinvoicetrans.InvoiceId,vendinvoicetrans.InvoiceDate,vendinvoicetrans.numberSequenceGroup,vendinvoicetrans.InternalInvoiceId).SumTax;
        lines.insert();
    }
}
------------------------------------

Controller Class:

 public class INC_PurchaseInvoiceController extends SrsReportRunController
{

}
----------------------------
public static void main(Args _args)
{
    INC_PurchaseInvoiceController      controller = new INC_PurchaseInvoiceController();
    VendInvoiceJour                    vendInvoiceJour;

    vendInvoiceJour = _args.record() as VendInvoiceJour;

    controller.parmArgs(_args);
    controller.parmReportName(ssrsReportStr(INC_PurchaseInvoice, INC_PurchaseInvoiceReport));
    controller.parmShowDialog(false);
    controller.startOperation();
}
-------------------------------
protected void prePromptModifyContract()
{
    VendInvoiceJour                 vendInvoiceJour;
    INC_PurchaseInvoiceContract        contract;

    if (this.parmArgs() && this.parmArgs().record())
    {
      contract              =   this.parmReportContract().parmRdpContract() as INC_PurchaseInvoiceContract;
      vendInvoiceJour       =   this.parmArgs().record();

      contract.parmVendInvoiceId(vendInvoiceJour.InvoiceId);
    }
}
-----------------------------------

Comments

Post a Comment

Popular posts from this blog

We will follow the following steps in the AX development.

We will follow the following steps in the AX development. 1. Follow the naming convention: - All new objects will start with a prefix ‘INC_ModuleNameofObject’ - Adding a new field to an existing table should be prefixed with ‘INC_ModuleNameofObject’ - Created Extended Data Types for any new fields you create. - Follow the rest of the standard processes for methods, relations, indexes, delete actions. 2. Label file: - Create a new label file or use an existing for your customization. - Label file will have the 1st 3 digits of the Customer Name (Functional consultant can help         to identify the names.) 3. Please maintain a XPO for the customization, we will use it for the deployment.         Please maintain a backup and forward it to me end of the day. 4. The customization will be done on the test environment. It will be tested by the functional consultant         and then by the end user. ...
Read more

Need to provide “ItemId lookup” based on "ItemType" field, which selected while creating SalesOrder

In SalesTable form – Need to provide “ItemId lookup” based on "ItemType" field,  which selected while creating SalesOrder In SalesTable Form -> Datasource -> Salesines -> Fields -> ItemID -> Lookup( )     SysTableLookup          sysTableLookup = SysTableLookup::newParameters(tableNum(InventTable),_formControl);     Query                   query = new Query();     QueryBuildDataSource    queryBuildDataSource = query.addDataSource(tableNum(InventTable));         queryBuildDataSource.addRange(fieldNum(InventTable, ItemType)).value(queryValue(salesTable.ItemType));     sysTableLookup.addLookupfield(fieldNum(InventTable,ItemId));     sysTableLookup.addLookupMethod(tableMethodStr(InventTable,defaultProductName));     sysTableLookup.addLookupMethod(tableMethodStr(InventTable,itemGroupId));   ...
Read more

How to retrieve multiple selected records from Grid using X++

Image
How to retrieve multiple selected records from Grid using X++: In this post, we discuss how we can retrieve all selected(marked) records of a datasource or retrieve marked records form Grid. For this purpose follow the steps listed below. Create a new table named " Student " that contains two string fields i.e. Name & ID. Create a new form and add the newly created "Student" table in the datasource node. Next create a new button on the form, set its multiselect property to " Yes " . Now override the clicked method of the button and add the following code. Code snippet     int             recordsCount;     Student     studentLocal;     super();          recordsCount = student_ds.recordsMarked().lastIndex();  // Total number of marked records.     studentLocal = student_ds.getFirst(1);          while (studentLocal)     {   ...
Read more