Payment GL by Item Report

This report allows the user to pull a payment report based on Item GL Code. Results are listed by order.

Pull the Report

1. Select the display fields from the drop down list.
2. Select search criteria.
3. Select up to three level of sorting.
4. Select the output format.

Display Fields

• Payment ID – The unique identifier in the system for this payment.
• Order Id – The unique identifier for the order the payment was made against.
• Order Amount Paid – The amount of money that was paid against this order item.
• Invoice ID – The unique identifier for the invoice this payment and order are associated.
• GL Code – The code associated with this item in financial set up.
• Item – Name of the item as it appears in financial set up.
• Co ID – The unique identifier in the system for the company.
• Company – The name of the company as it appears on the company info tab of the company record.
• Amount – The portion of the total payment that was applied to this order.
• Operator – The login id of the user that created the payment. Note – Self registered is the id associated with exhibitors/companies that have logged in on the event site.
• Payment Mode – Method of payment (ex. Online Credit Card, Check, etc.).
• Item Type – Name of the item type this item is associated.
• Event – Name of the event this payment is associated.
• Tracking No – The tracking number recorded when the payment was entered.
• Payment Date – The date the payment was entered.
• Payment Details – Any details entered at the time the payment was entered.
• Date Modified – The date the payment was modified. Note- Online Credit Card and System Transfer payment methods cannot be modified.
• Operator Full Name – If available, the full name associated with this login id.

Search For

• Event – Select the event from the drop down.
• Item Type – If desired, select an item type from the drop down to narrow the search results to items associated with one item type.
• GL Code – Enter a GL Code to narrow the search results to only payments associated with this GL Code.
• Payment Date – Select a start and end date to narrow the search results to only payments made during this time period.

Sort By – choose up to three levels of sorting from the drop downs. The fields are the same as the display fields

Output Format

• HTML – the system will display the results in the same browser window.
• ASCII - the system will prompt the user to open or save a text file.
• Excel - the system will prompt the user to open or save an Excel file.
• PDF – the system will prompt the user to open or save a PDF file.
• XML - the system will open a new browser window or tab, and display the results.