Purchase tracker report

Pradeep_Krishna

Hi Experts,

I have to create a vendor wise Purchase tracker report using rdlc layout. Could some one help me how to set dataitem link between the tables as follows.

Expanded Data Type Data Source Name Include Caption
1 DataItem Purch. Rcpt. Header <Purch. Rcpt. Header> No
0 Column "Purch. Rcpt. Header"."Buy-from Vendor No." VendorNo No
0 Column "Purch. Rcpt. Header"."No." GrnNo No
0 Column "Purch. Rcpt. Header"."Order No." PoNo No
0 Column "Purch. Rcpt. Header"."Order Date" PoDate No
1 DataItem Purchase Line <Purchase Line> No
0 Column "Purchase Line".Quantity PoQuantity No
0 Column "Purchase Line".Amount PoAmount No
0 Column "Purchase Line"."Quantity Received" QtyRcd No
0 Column "Purchase Line"."Quantity Invoiced" QtyInvoiced No
1 DataItem Purch. Inv. Header <Purch. Inv. Header> No
0 Column "Purch. Rcpt. Header"."No." InvoiceNo No
1 DataItem Purch. Inv. Line <Purch. Inv. Line> No
0 Column "Purch. Inv. Line".Amount InvoiceAmount No
1 DataItem Vendor Ledger Entry <Vendor Ledger Entry> No
0 Column "Vendor Ledger Entry".Amount VendorPaymentAmount No
0 Column "Vendor Ledger Entry"."Document No." DocumentNo No
0 Column "Vendor Ledger Entry"."Document Date" DocumnetDate No

Thanks in advance.

lubost

Purch. Inv. Header can be done by two basic ways: directly from purchase order or by importing receipt lines. So, it is not safe way to link receipts to invoices. Best way is: link receipts to invoices using Value Entry table. Remember that one receipt can be linked to several invoices and one invoice to several receipts.

Pradeep_Krishna

Thanks.But cant we connect purch inv line with purch rcp hdr?