Dynamics Community Forum Thread Details

purchase tracker Report

Hi experts,

I have to create a report based on the vendor no. I have added several fields in my report. from various data item . Such as

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
0 Column "Purch. Rcpt. Header"."Document Date" GrnDate No
1 DataItem Purch. Rcpt. Line <Purch. Rcpt. Line> No
0 Column "Purch. Rcpt. Line".Quantity PoQuantity No
0 Column "Purch. Rcpt. Line"."Direct Unit Cost" * "Purch. Rcpt. Line".Quantity Amount No
0 Column "Purch. Rcpt. Line"."Quantity Invoiced" QtyInv No
1 DataItem Purch. Inv. Header <Purch. Inv. Header> No
0 Column "Purch. Inv. Header"."No." InvoiceNo No
0 Column "Purch. Inv. Header".Amount InvoiceAmount No
1 DataItem G/L Entry <G/L Entry> No
0 Column "G/L Entry".Amount PaymentAmount No
0 Column "G/L Entry"."Posting Date" PaymentDate No
0 Column "G/L Entry"."Document No." paymentDocNo No
1 DataItem Purch. Inv. Line <Purch. Inv. Line> No

I have linked the data item as follows

for Purch. Rcpt. Line

Property Value
DataItemTable Purch. Rcpt. Line
DataItemTableView <Undefined>
DataItemLinkReference <Purch. Rcpt. Header>
DataItemLink Document No.=FIELD(No.)

for purchase inv header

Property Value
DataItemTable Purch. Inv. Header
DataItemTableView <Undefined>
DataItemLinkReference <Purch. Rcpt. Line>
DataItemLink Order No.=FIELD(Order No.)

for GL entry

Expanded Data Type Data Source Name Include Caption
1 DataItem G/L Entry <G/L Entry> No
0 Column "G/L Entry".Amount PaymentAmount No
0 Column "G/L Entry"."Posting Date" PaymentDate No
0 Column "G/L Entry"."Document No." paymentDocNo No

for purchase inv line

Property Value
DataItemTable Purch. Inv. Line
DataItemTableView <Undefined>
DataItemLinkReference <G/L Entry>
DataItemLink Document No.=FIELD(Document No.)

this shows the correct information about the vendor wise purchase details. whenever i receive and invoice in the pur order page of nav its giving the correct answer for single reciept line. but not for the entire doc No.

could some one help me how to get purchase details for reciept lines when i recieve and invoice seperately using get reciept lines

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS