Archives

 

I have a site (https://anchoredmarriage.com) that uses RouteData for the articles. I want to add a dynamics canonical link to the pages and still handle the route data. 

In other words, most pages would have

<link href="https://anchoredmarriage.com/Default.aspx" rel="canonical">

But the pages with RouteData would look like this

<link href="https://anchoredmarriage.com/article/Wedding_Decorations" rel="canonical">

 

I recently wrote a direct deposit report, designed to copy the one from GP. This is obviously sensitive data so I removed the numbers; but you can see the format. In order to copy the GP format I used sub reports (not my favorite), the queries below power each of the sub reports. 

 

I need a report for an employee to show which DD bank accounts were used and the amounts that went to that bank account. This employee has more than one DD bank account setup.  I also need it to span a 2-year period.  I looked at the DD30101 table, which looks like it will work, and I can restrict on the employee ID, but not the check dates.  I tried adding the check date field from the DD30301, but not sure this will return multiple lines of records.

I'd like to create it as a view to use with SmartList.

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3