|
Reports A list of all transactions posted to
a cost object for selected fiscal periods, called the Transaction
Listing, is on top of the Detail Transaction Report. A
list of all open commitments called the Commitment Listing
is on the bottom of the report. Reading
the Transaction Listing Lists the cost object number, fiscal
dates covered in the report, company, and MIT supervisor.
Double-click on the yellow cost object number to display Master
Data information. Report
Columns (these headings run horizontally
across the report) Shows individual transactions by cost
element. The DTR is first sorted by cost element,
following the structure of the cost elements in the Summary
Statement, then by vendor. The WE and EI transactions
are sorted a third time by tracking number (confirmation number
from NECX and Partners). How to Find
Out More About a Charge 1. Click on an item listed under the following columns on
the Detail Transaction Report to see the SAP source document
screen for a transaction: After you click on the items under the Type, Document
Number, and Transaction Date columns, the "Document
Header" screen appears first. Click the Enter button
Reading the Commitment Listing On the bottom of the transaction listing for each cost object
is the Commitment Listing section which displays all open
commitments for the cost object. It also indicates the total
amount of blanket orders, if selected on the report entry
screen, and what remains on the purchase order. Manual reservations
and LDS (Labor Distribution System) commitments are also included
on this list.
Note
You
can suppress the Commitment Listing on the DTR
by checking Exclude Commitments on the entry screen. The following table shows how the Ordered, Invoiced,
and Remaining amounts (last three columns) are calculated. Column Calculation Ordered Total amount of all line items originally ordered.
Invoiced Total amount invoiced, including shipping charges and
discounts. (This reflects the amount actually paid to
the vendor by MIT.) Remaining Original order price times the quantity of items
not yet invoiced. The Remaining column does NOT always equal the Ordered
column (original amount plus change orders) minus the
Invoiced column (amount invoiced). This is due to differences
in ordered price and the invoiced price. The Remaining
column reflects the order price times the quantity
of items not yet invoiced. Discounts and freight costs also
may cause the ordered amount to differ from the invoiced amount. How to Find Out More About a Charge
on the Commitment Listing Click on an item listed under any column to see the "Display
Purchase Req," the "Display Purchase Order,"
or the "Display Funds Commt" screen. See the Detail
Transaction Report: Source Document Level for more information. After you execute the DTR, you can
use these buttons to sort the report again, change the column
layout, or download the contents into a spreadsheet format.
Button Change
Sort Order Sorts the Transaction Listing columns, but not the
Commitment Listing. 1. Click on the Change Sort Order button. The following
dialogue box is displayed. 2. Click on one of the white fields under the Sort
Field and then on the Matchcode button Result: A list of fields available for sorting
is displayed. 3. Scroll down to see all the fields. 4. Double-click on a field to select it. Result: The field is copied into the Sort
Field on the Sort Order screen. 5. Click on the radio button under A or D
to sort the field in either ascending or descending
order. 7. (optional) Repeat Steps 2 - 6 for the other
two fields if you wish to sort on additional fields. 8. (optional) To sort on only one or two fields,
leave the other fields or field blank. Delete the letters
using the Delete key or the space bar on the Mac. Use
the Backspace key on the PC. 9. Click the Enter button Result: The report is rerun and sorted according
to your criteria. You can change the order of columns on the Transaction
Listing on the DTR, but not on the Commitment Listing.
1. Click on the Change Layout button. The following
dialogue box is displayed. 2. Type over the numbers under Column in the
order that you want columns to appear on the report.
You can also display Company Code and Fiscal
Year on the report by typing a number beside them.
The default for these fields is blank. (Make sure these
fields are not subtotaled or they will not appear on
the report.)
3. To hide the columns, delete the number with the
Backspace key, Delete key, space bar, or by entering
0 (zero). 4. Click the Enter button Result: The report is rerun and the columns
arranged according to your criteria. At the bottom of the Change Layout dialogue box are
buttons that you can use to change or reset your default
column layout. Column
Layout Description
Clears out the column numbers. Click on the
Get Default Layout button Download Downloads the report to a spreadsheet. For instructions,
see Downloading the Report.
1. Click the Download button. 2. Use the Matchcode button 3. Type in a name in the Name or the Field
Name field. 4. Click the Save button. Result: A message that your file was downloaded appears
on the bottom left of your screen. 5. Open your file in the spreadsheet application. 1. Click on the Print button Result: The "Print Options"
dialogue box is displayed. 2. Select Landscape (11 x 8
1/2) or Portrait (8 1/2 x 11). 3. Choose between Simplex (single-sided
printing), Duplex (double-sided printing), or Printer
default.
Note
You can only
print double-sided on a duplex printer. 4. Click the Enter button Result: The "Print:" screen is displayed.
For further instructions on printing
see Reports: Reporting
Fundamentals: Printing Reports: How to Enter the Print Screen. >>Go
to Detail Transaction Report (DTR): Source Document Level
|
to see the "Display Document: Overview" screen.
See the 
(PC: 
)
to the right.
to subtotal the sorted field. (If you subtotal on a
field it will not appear as one of the columns on the
report; it will appear as a horizontal line under the
category you sorted on.)
.
