Skip to Content
0
Former Member
Jun 12, 2009 at 02:57 PM

Reporting Asset Values by Tax jurisdiction

159 Views

My company has a reporting requirement to be able to report our asset values by Tax Jurisdiction (Town). I am trying to create an infoset using SQ02 and a query using SQ01 to create the report. I am trying to link table ANLA, ANLC, and ANLZ in the infoset linking the company code, asset main number and asset sub-number in each table from ANLA to ANLC and ANLA to ANLZ. The links to each table is a one-to-one link. I have tried a Left Outer Join link with the same result, no AMR asset

When I run the query, it does not pull in the AMR Assets to the report. I only get the CCNC, CWIP, and RMR Asset because we do not populate the tax jurisdiction for those assets.

Does anyone have any ideas on how I can accomplish this?

Any help on this would be greatly appreciated.

Wayne