ERP Software Blog| SAP Blogs| SAP HANA Blogs| Microsoft Dynamics 365 Blogs

Tips And Tricks (Part 1)

By D1 Technologies, LLC

The Drag & Relate feature is an oldie but a goodie.  It’s something that’s been in SAP Business for as long as I’ve used it but many people don’t know or have forgotten that it exists.  Drag & Relate is a quick way of generating on the fly reports for master data or transactions that relate to or are refined by a specific piece of information.  Just this week I had two customers that wanted to be able to look something up and we were able to find their information quickly without writing a query.  In both cases the customers had been using Business One for several years but it didn’t cross their mind to use Drag & Relate.

Along the left side of the SAP Business One application you can find the Drag & Relate Tab, below the My Cockpit and Module tab.  By clicking on this Tab, users can access this feature to quickly lookup information by relating one specific piece of information to transactional or master date.

Tips_and_tricks_pic_1.jpg

 

 

 

 

 

 

 

In the first example they wanted to see a list of all Production Orders that contained a particular item as a component.  We opened the Item Master for that component item and selected the Drag and Relate Tab.  Then we selected the Item Code by clicking and holding on the field until it was highlighted with a black rectangle around the field.Tips_and_tricks_pic_2.jpg

Once the Item Code field is highlighted with the black rectangle drag and drop the rectangle onto the Production Order Details.Tips_and_tricks_pic_3.jpg

The returned results shows a list of all Production Orders that the component Item was part of, along with the Planned and Issued Quantities.  From the results you could drill into the individual Production Orders with the golden arrow.Tips_and_tricks_pic_4.jpg

In the second example they wanted to see a list of all Purchase Orders that had ever been created for a specific Vendor.  We opened the BP Master, selected the BP Code and dragged and dropped it on the Purchase Order on the Drag and Relate Tab.  The returned results show a list of all Purchase Orders ever created for that vendor.  The results could be additionally refined by using the Filter button in the bottom left corner and, as an example, excluding the Purchase Orders with a status of Cancelled.Tips_and_tricks_pic_5.jpg

Topics: SAP Business One

Recent Posts

How to Create Templates for Pick & Pack in SAP Business One!

Sep 19, 2018 10:27:02 AM

Payment Means Are One Click Away in SAP Business One!

Aug 27, 2018 3:33:26 PM

There Are New Options in User Groups Setup in SAP Business One!

Aug 20, 2018 11:09:30 AM

How to Show Zero Price for Inactive Price Lists in SAP Business One!

Aug 13, 2018 10:41:46 AM

How to Choose the Best ERP Software for Small Business

Aug 7, 2018 6:49:12 AM

Posts by Topic

see all