custom Purchase Order Confirmation report (header)

(0) Share

Report

Posted on by Husna Yusuf

1,094

Hi all,

i have read some posts about custom Purchase Order report. mostly they informed me how to custom the lines of Purchase order. for my case i need to custom the header information because i need to put Term of Payment and Unlading address(from CompanyInfo table) on my header PO. which is not provided in PurchPurchaseOrderHeader table.

i have add two fields in PurchPurchaseOrderHeader,

put some lines codes in PurcPurchaseorderDP.processReport

and add new two textbox to return Term of Payment and Unlading address value in Design report( i still use PurcPurchaseOrder.report SSRS).

The custom is working, in Pro forma Purchase Order mainly.

But its not working on Purchase order Confirmation.

i guess, both Proforma PO and Confirmation PO are the same Report,PurchPurchaseOrder, aren't they?

or is there any another tables that i have to modify?

need some advice, Thank you.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Husna Yusuf 1,094 on at

Like (0)

Report

after got stuck in this issue,

i found another tips.

custome Header PO report.

1. update the PurchPurchaseOrderheader with ur additional fields.

2. update method PurchPurchaseOrderHeader.initfrom**** .. for my case i nedd Term of Payment value(description).

assume you already add your addtional field. "this.Paymenttermdescription = PaymTerm::find(PurchTable::find(this.PurchId).Payment).Description".

3. update class PurcPurchaseorderDP.processReport(), in order to get value Term of Payment.

4. update PurchPurchaseOrder.report.

5. CLEAR Chace (must do).

Was this reply helpful? Yes No