Purchase tracker report

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.

Answers

  • lubostlubost Member Posts: 611
    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_KrishnaPradeep_Krishna Member Posts: 8
    Thanks.But cant we connect purch inv line with purch rcp hdr?
Sign In or Register to comment.