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.​

   

Report Criteria

Enter report criteria below to get desired results, as per Fig. 02 below.
   

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. By Vendor: displays open RMAs for only the selected vendor(s). All Outlets: displays open RMAs for all outlets. By Outlet: displays open RMAs for only the selected outlet(s). All Created By: displays open RMAs made by all users. Selected Created By: displays open RMAs made by the chosen user(s). All Categories: displays open RMAs for products assigned to any category. Selected Categories: displays open RMAs that contain products for the chosen category(ies). All Requisitioners: displays open RMAs by all users who created the requisition for it.  Selected Requisitioners: displays open RMAs by the selected user(s) who created the requisition for it.
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.
   

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. Calculation: EXTENDED COST = COST x ORDERED If the RMA has been partially returned, then the extended cost will show the cost of the total amount remaining to be returned. Calculation: EXTENDED COST = COST x OPEN
Vendor	Displays the Adaco vendor number and name.
RMA Details	Displays various information of the RMA number, including: Delivery date / date of first receiving. Status (untransmitted, transmit pending, transmitted, partial). Adaco vendor number and name. Phone number. Fax number. Delivery date.
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. Calculation: ITEMS TOTAL / ORDER TOTALS = OPEN x COST Example: 1.2 x 24 x -2 = -57.60 x $37.50 = -$2,160.00
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. Calculation: NET TOTAL = ITEMS TOTAL + VENDOR RATES
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.