I wrote a BAQ /Dashboard for Accounting to pull info on AP Invoices. My BAQ works great and my dashboard does too BUT. The dashboard will not pull anything for the the month of April. It will pull March and May.
The dashboard is filtering on Posted Date. You can see that the BAQ has invoices posted in April.
My Dashboard filters
Dashboard results…
March worked…
April empty
thoughts anyone?? Why is data in BAQ but can’t pull it in Dashboard.
Hi Kimberley,
Are you sure you don’t have an error on your dashboard condition? In “March Worked…” screenshot IDK how you input a filter for >= 3/22/2019 but got records for post date 3/21, 3/12, 3/13 in there?! Something seems awry…
Nancy
That is because one I click on the dashboard that date shows. My result have the full month. I don’t know why it defaults to that one line.
Here’s my customization on data filter for PO order date; maybe you can compare to your field properties too?
I always just make a calculated field in the BAQ that holds a copy of the date I want to filter on. Then in the dashboard, I just use the Tracker View’s fields.
"Stat Date" >= GLJrnlDtl_PostedDate"End Date" <= Calculated_PostedDateCopyNo need to customize the Tracker view
i think we talked about this before. What does your calculated field look like?
In this example I want to only show RcvDtl with a ReceiptDate within in a user specified range.
The Summary only displays the RcvDtl_ReceiptDate column. I hide its copy - which is named Calculated_RcvDate2
The BAQ just has a calculated field:
So the data returned by the BAQ will always have the same values in:
RcvDtl.ReceiptDate and Calculated_RcvDate2
tried that still no results
Why did you say your BAQ returns records outside of the range - for when you think it is working?
And i really hope something is wrong with your BAQ, as that shows an invoices dated 2/3/2011 as not being posted until 3/22/2019
welcome to my world…yes they post them that late
I get no results for April when I filter 4/1 to 4/20
What do you get if you only set the start date? Leaving the other field blank.
And try 3/1/2019 and then 2/1/2019. Does the 2/1 start date include all the records you get with a 3/1 start date?
Over 8 years later?
agh…I see what you are saying
I am checking with accounting but I looked at on of the invoices posted in 3/19 for 2016. It was a misc charge.
Copy the query Phrase and post it here.
I just put the start date it in of 3/1/19 I get March, April and May post dates.
[APInvHed].[InvoiceDate] as [APInvHed_InvoiceDate],
[APInvHed].[GroupID] as [APInvHed_GroupID],
[APInvHed].[InvoiceNum] as [APInvHed_InvoiceNum],
[Vendor].[VendorID] as [Vendor_VendorID],
[Vendor].[Name] as [Vendor_Name],
[APInvHed].[DocInvoiceAmt] as [APInvHed_DocInvoiceAmt],
[GLJrnDtl].[PostedDate] as [GLJrnDtl_PostedDate],
(GLJrnDtl.PostedDate) as [Calculated_PostDate2]
from Erp.APInvHed as APInvHed
inner join Erp.Vendor as Vendor on
APInvHed.Company = Vendor.Company
and APInvHed.VendorNum = Vendor.VendorNum
inner join Erp.GLJrnDtl as GLJrnDtl on
GLJrnDtl.Company = APInvHed.Company
and GLJrnDtl.APInvoiceNum = APInvHed.InvoiceNum
and ( GLJrnDtl.CreditAmount <> 0 )Delete the tracker Object in the dashboard and then re-add it, with:
This is what I did for new Tracker view and still does not work for April only.
Odd; when I put in the dates for April it processes for a long time then no results
When I run it from March or May it returns in seconds.
What does the “Input Prompts Only” check box do? I don’t think I have ever used it before.
Normally, Trackers are a way to show data from one row of a dataset, and its updated as you select different rows.
By checking “Input prompts only”, It makes them inputs and not tied to the values from the dataset’s row.
With the Input prompts cleared, slect different rows in the summary, and those two fields on the tracker should change
