Friday, August 7, 2020

Drag & Relate Tool (Business Partner Groups)

The Business Partners Module in the Drag & Relate tool is very versatile in terms of functionality. The second business process information tab under this module is the Business Partner Group tab. As the name suggests, when you double click on this tab the user gets the entire list of all business partners Groups(Customer & Vendor Groups) created in the system. In addition, the user can further drill down into the report using the filter option present in the bottom right corner.  The fields that are available as standard in the report are: - 

  • BP Group Name

  • Customer/Vendor


The BP Group Name field can be further used to create reports of numerous permutations and combinations. The user must drag and drop the selected group name onto any other desired business process information tab under the drag and relate tool to create an ad hoc report. For example, if you would like to get the list of all sales orders created for a particular customer group, what you should do is select the desired customer group from the list of business partner Groups, click on the Group name till the field is highlighted and then drag and drop the field onto the Sales Order tab under the same Drag & Relate tool to generate the desired report. Similarly, the user can create dozens of other ad hoc reports by simply dragging and dropping. Some of the other business process tabs that can be used to generate ad hoc reports using BP Group Name as a selection criteria are: -

  • All Tabs Under Sales Module (under Drag & Relate Tool)

  • All Tabs Under Purchase Module (under Drag & Relate Tool)

Thursday, August 6, 2020

Drag & Relate Tool (Business Partners)


The Business Partners Module in the Drag & Relate tool is very versatile in terms of functionality. The first business process information tab under this module is Business Partners itself. As the name suggests, when you double click on this tab the user gets the entire list of all business partners(Customers, Leads & Vendors) created in the system. In addition, the user can further drill down into the report using the filter option present in the bottom right corner.  The fields that are available as standard in the report are: - 

  • BP Code

  • BP Name

  • Telephone 1

  • Fax Number 

  • Contact Number

  • Sales Employee Code 

  • Mobile Phone 


The BP code and The BP name fields can be further used to create reports of numerous permutations and combinations. The user must drag and drop the selected code or name onto any other desired business process information tab under the drag and relate tool to create an ad hoc report. For example, if you would like to get the list of all sales orders created for a Customer, what you should do is select the Customer from the list of business partners, click on the customer name till the field is highlighted and then drag and drop the field onto Sales Order tab under the same Drag & Relate tool to generate the desired report. Similarly, the user can create dozens of other ad hoc reports by simply dragging and dropping. Some of the other business process tabs that can be used to generate ad hoc reports using  BP code and BP name as selection criteria are: -

  • All Tabs Under Sales Module (under Drag & Relate Tool)

  • All Tabs Under Purchase Module (under Drag & Relate Tool)

  • All Tabs Under Production Module (under Drag & Relate Tool)

  • All Tabs Under Service Module (under Drag & Relate Tool)

  • Journal Entry Tab & Journal Entry Details Tab (under Drag & Relate Tool)

  • All Tabs Under Business Partners Module (under Drag & Relate Tool)

Wednesday, August 5, 2020

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


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 A/P Credit Memo tab and A/P Credit Memo Details tab under Drag & Relate Tool help the user in generating ad hoc reports. 


  • A/P Credit Memo: -  You can generate a list of A/P Credit Memo documents 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 A/P Credit Memo 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. 

  • A/P Credit Memo Details: - This tab is an extension of the A/P Credit Memo business process information Tab, using this tab the user can generate reports which contain row level details on an individual A/P Credit Memo document as opposed to the previous report which only lists out the total number of A/P Credit Memos 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. 


Tuesday, August 4, 2020

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


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 and Goods Return Detail tabs under Drag & Relate Tool help the user in generating ad hoc reports. 


  • Goods Return: -  You can generate a list of Goods Return documents 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  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 Details: - This tab is an extension of the Goods Return business process information Tab, using this tab the user can generate reports which contain row level details on an individual Goods Return document as opposed to the previous report which only lists out the total number of Goods Returns 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. 


Monday, August 3, 2020

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. 


Sunday, August 2, 2020

Drag & Relate Tool (Purchase-A/P) (5)


In this blog we discuss the A/P Invoice and A/P Invoice Details business processes information tabs which are available under the Purchasing module within the Drag & Relate Tool. Their functions are as follows: - 



  • A/P Invoice: -  You can generate a list of A/P Invoices 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 A/P Invoice 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. 

  • A/P Invoice Details: - This tab is an extension of the A/P Invoice business process information Tab, using this tab the user can generate reports which contain row level details on an individual A/P Invoice document as opposed to the previous report which only lists out the total number of A/P Invoices available in the system. The row level 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. 


Saturday, August 1, 2020

Drag & Relate Tool (Purchase-A/P) (4)


In this blog we discuss the Purchase Request and Purchase Request Details business processes information tabs which are available under the Purchasing module within the Drag & Relate Tool. Their functions are as follows: - 



  • Purchase Request: -  You can generate a list of Purchase Request 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 Purchase 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. 

  • Purchase Request Details: - This tab is an extension of the Purchase Request business process information Tab, using this tab the user can generate reports which contain row level details on an individual Purchase Request document as opposed to the previous report which only lists out the total number of Purchase 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.