Purchase Order Report

Forum Forums SI 2016 Genreal Purchase Order Report

This topic contains 1 reply, has 2 voices, and was last updated by  Narayana Karthik 1 year ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #12311 Reply

    mdudziec
    Participant

    Hi, I’m looking to add a field to the Purchase Order report (the one under Order Reports section), to add a field that states the Project Name. Any clues how I add this in Report Designer?
    Thanks

    #12326 Reply

    Narayana Karthik

    Hi,

    Purchase order may contains items from different projects, so project name is not available as part of purchase order field but Project Name is available as part of purchase order item field and its part of “Sub purchase order item” report.

    If you want to display project name for each item or group items by project name then you have to customize the “Sub Purchase Order Item” report there ProjectName is available as part of Data Explorer tab.
    Or if you want to display the ProjectName in Main “Purchase Order” report considering all items are from same project. Then You have to use following script code to get the ProjectName and assign it to a Textbox.

    Following is the sample script code to get project name and assigned it to a textbox –
    =================================================================
    If ReportUtilities.PurchaseOrder Isnot Nothing AndAlso ReportUtilities.PurchaseOrder.Projects Isnot Nothing Then

    Dim projName as string = ReportUtilities.PurchaseOrder.Projects.OfType(Of ProjectInfo2).Select(Function(pi) pi.Name).FirstOrDefault()

    ReportUtilities.SetTextBoxValue(rpt, “grpPOInfo”, “txtProjName”, projName)
    End If

    ==============================================================

    Hope it helps.

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: Purchase Order Report
Your information:





<a href="" title="" rel="" target=""> <blockquote cite=""> <code> <pre> <em> <strong> <del datetime=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width="">