P/C Crew Advances/Activity Report

Top  Previous  Next

The P/C Crew Advances/Activity Report [pcar] displays posted Petty Cash transaction amounts broken down by Amounts Advanced, Accounted for Amounts (receipts) and the amount of the Advance Outstanding (the difference between the Amounts Advanced and the Accounted for Amounts).

 

 

Open:

 

To access the P/C Crew Advances/Activity Report [pcar], click the 'P/C' module from the menu tree (see following screen shot).

 

The P/C Crew Advances/Activity Report [pcar] is also located in the 'Report' folder under the 'Petty Cash' sub-folder titled P/C Activity Report [pcar].

 

You can also access this report by typing the screen or acronym name in the blue prompt bar located above the 'Setup' menu.  Then, press Enter.

 

 

 

The screen then appears.

 

 

 

To select criteria, press the F2 Key or right click in most fields to make your selection.  You can also simply type in the criteria in the allotted fields. If you wish to include all criteria information, leave all fields blank.

 

 

Vendor Range:

 

Starting and Ending - Vendors to include in the report.  To restrict the report to only include information for a single vendor, input the same Vendor Number in both the Starting and Ending fields. To select all vendors, leave both fields blank.

 

 

Transaction Selection:

 

Press the F2 Key or right click in any of these fields (Production, Company, Bank and Currency) to choose the necessary codes if they don't already default. To choose multiple codes for a particular field, press the F2 Key or right click in that field and hold down the Control Key while simultaneously using your mouse to select.  By making a selection, this isolates the report to only display items based on the code(s) selected.

 

 

Date Range:

 

Starting and Ending - Transaction Effective Dates to include in the report as PSL3 is date-driven. To restrict the report to only include information for a single date, input the same date in both the Starting and Ending fields. To select all dates from inception to future, leave both fields blank.  Press the F2 Key or right click in either date field for the calendar selection to appear.

 

 

 

 

Envelope Information:

 

Number - User-defined code or number identifying each P/C envelope.

 

 

P/C Cash Account Range:

 

Starting and Ending - Account numbers to include in the report. To restrict the report to only include information for a single account number, input the same account in both the Starting and Ending fields. To select all account numbers, leave both fields blank. Please note these fields only become accessible when you select 'Include A/P Transactions' and/or 'Include J/E Transactions' in the Report Selection area.

 

 

Report Selection:

 

Show Detail - Check mark to include detail distribution data for each transaction.

 

Include P/C Transactions - Check mark to include transactions that were entered in P/C Entry [pcent].

 

Include A/P Transactions - Check mark to include transactions that were entered in A/P Entry [apte].

 

Include J/E Transactions - Check mark to include transactions that were entered in Journal Entry [jete].

 

 

J/E Transactions:

 

J/E Number - User-defined code or number also known as the User Source Code to track your company's different classifications of Journal Entries.  Please note this field only becomes available when you select 'Include J/E Transactions' in the Report Selection area.

 

 

Print/Preview the Report: Located in the top right hand corner of the screen, you can choose the following options to generate the report:

 

Print - Opens the Print Dialogue box and sends the report directly to the printer.

 

Preview - Generates a PDF format report and appears instantly on your screen.  You are still able to print from the PDF format.

 

Spreadsheet - Generates an Excel format report and appears instantly on your screen.  You are still able to print from the Excel format.  Please note if you select this option, you are able to have additional sorting options within Excel.