Drag & Relate Tool (Purchase-A/P Return) (6)

In case of any Purchase returns, SAP Business One provides return documents such as Goods Return Request, Goods Return, and A/P Credit Memo. In this blog we are going to discuss how Goods Return Request and Goods Return Request Detail tabs under Drag & Relate Tool help the user in generating ad hoc reports. 

• Goods Return Request: -  You can generate a list of Goods Return Requests available in the system using this tab, with the selection criteria of your choice. This is done by dragging and dropping the highlighted selection field onto the Goods Return Request  tab. Some of the available selection criteria on the basis of which you can create an ad hoc report are as follows: - 

• Business Partners

• Business Partner Groups 

• Items

• Item Groups 

• Contact Person

• Warehouses 

• Manufacturers 

You also have the option to  filter the report further by dragging and dropping the desired header field onto the filter symbol present in the bottom right corner of the report. 

• Goods Return Request Details: - This tab is an extension of the Goods Return Request business process information Tab, using this tab the user can generate reports which contain row level details on an individual Goods Return Request document as opposed to the previous report which only lists out the total number of Goods Return Requests available in the system. The details this report contain are: - 

• Item No.

• Item/Service Description

• Quantity

• Unit Price

• Price Currency

• Row Total

You also have the option to  filter the report further by dragging and dropping the desired header field onto the filter symbol present in the bottom right corner of the report.