Open RMA Report
The Open RMA report is used to see the details of all RMAs which still are open, including ones which have been partially received.- To run the this report, go to Report Centre>Purchasing Reports>Open RMA.
- Double-click Open RMA report or select the report and click Run Report, to open the report criteria screen, as per Fig. 01.

Fig. 01 - Running the Open RMA report
Report Criteria
Enter report criteria below to get desired results, as per Fig. 02 below.
Fig. 02 - Report Criteria for Open RMA report
Fields | Description |
Include Comment Log | When enabled, any text that has been placed in the Comments Log on the RMA will appear on the report. |
Order Selection |
All RMAs: displays every RMA in the application which has not yet been received. Delivery Date: displays only the RMAs with a delivery date within the specified time frame. |
From and To | These fields become enabled when Delivery Date is selected in the Order Selection menu. |
Search Criteria |
All Vendors: displays open RMAs for every vendor.
|
Advanced Search | Disables when All Outlets or By Outlet is chosen for Search Criteria. All Outlets: displays open RMAs for all outlets. By Outlet: displays open RMAs for only the selected outlet(s). |
Detail Group By | Enabled when All Outlets or By Outlet is chosen for Search Criteria. Without grouping: displays the open RMAs in alphabetical order by outlet name and then by Purchase Order number. Category: displays the open RMAs by RMA number and then in numerical order by category number. |
Show PO Details | Enabled by default. When disabled, the product information on the RMAs will not be displayed and the Detail Group By field is disabled. |
Use ordered/received totals | When enabled, this will disable the Order Status field and will show the Ordered Totals, the Received Totals, and the Remaining Totals instead of the Items Total, Vendor Rates, and Net Total. |
Order Status |
(Select All): enabled by default, displays all open RMAs regardless of status. Untransmitted: displays all RMAs with an untransmitted status. Transmit Pending: displays all RMAs with a transmit pending status. Transmitted: displays all RMAs with a transmitted status. Partial: displays all RMAs with a partial status. |
Report Results
When the Open RMA report is generated, the result should look similar to Fig. 03.
Fig. 03 - Open RMA report results
Fields | Description |
Product | The Adaco product number. |
Description | The name of the product. |
Purchase Information | The text typed into the Purchase Info field on the Product Master. |
Par. Unit | An abbreviation of the Purchase Unit assigned to the product on the Product Master. |
Unit Description | The Pack Size information. |
Cost | The price of the product on the RMA. |
Quantity |
Ordered: the total amount of the product being returned. Received: the amount of the product that has been returned. Note: only applies to Multiple Receiving returns. Open: the amount that still needs to be returned. |
Retail Attributes | The attributes assigned to a product on the Product Master, located under Property>Products>Retail. |
Extended Cost | The cost of the total amount being returned on the RMA.
|
Vendor | Displays the Adaco vendor number and name. |
RMA Details | Displays various information of the RMA number, including:
|
Vendor RMA # | The vendor RMA number that is typed in by the user. |
Comment | Text that has been typed into the Comments Log on the RMA will appear here. |
Items Total / Order Totals | The total extended cost of the products on the RMA.
|
Vendor Rates / Received Totals | The total amount of the rates being applied to the RMA. |
Net Total / Remaining Totals | The total cost of the RMA.
|
Purchase Order Account Recap |
Account: the Adaco account number. Account Name: the name of the account. Account Reference: the account cross-reference number. Account Cost: the amount on the Purchase Order being charged to the account. Account Total: the total amount being charged to all the accounts for the specified Search Criteria. |
Accounts Grand Total |
Account: the Adaco account number. Account Name: the name of the account. Account Reference: the account cross-reference number. Account Cost: the total amount charged to the account for all the RMAs appearing on the report. Accounts Grand Total: the total amount charged to all accounts on the whole report. |
Comments
0 comments
Please sign in to leave a comment.