Monday, July 20, 2020

Drag & Relate Tool (Financials)

Drag & Relate is a very useful tool that can add a lot of value to your organization.There is not an abundance in documentation on how to maneuver around the tool properly. Hence I decided to create a series of blogs to uncover some of its functions for each of the modules this tool can be used. I would like to begin with the ad hoc reports that can be created for the financial module. The business process informations that are available in under financial module of the tool are: -


  • Accounts: - Simply by double clicking the Accounts business process information tab you will get a list of all the accounts that you have defined in the system and if you are looking for a particular account and all its relevant details, all you have to do is simply click and hold in the desired header and drag and drop onto the filter symbol present in bottom right corner of the report. Then you have the option of  filtering  the header information according to the parameters of your choice.

  • Journal Entry: - The major purpose of this business process information tab is to create ad hoc reports containing details about journal entries related to any business partner of your choice. For example, you have the list of business partners opened, all you have to do is drag the highlighted business partner information onto the Journal Entry business process information tab and all you will be able to view the report containing details of all the journal entries related to that particular business partner. Further level of filtering is also possible using the filter symbol present in the bottom right corner of the report. 

  • Journal Entry Details: - To get the details such as credit amount, debit amount, and the remaining particulars regarding existing journal entries you can make use of this business process information tab. Say you have a list of journal entries opened in front of you, to get the transactional level information on a particular journal entry you will have to click and hold the desired journal entry number field until it highlights and then drag and drop it onto the Journal Entry Details business process information tab. By doing so you can create a report containing transactions level details of that particular journal entry. 

Sunday, July 19, 2020

Purchase Quotation Generation Wizard

The purchase quotation generation wizard enables you to create a batch of purchase quotations automatically. The wizard guides you step by step through the definition of parameters required to generate the documents.The steps to follow to create a purchase quotation through this wizard are: - 


  1. Step 1: - To generate target documents based on a newly defined parameter set, choose "New Parameter Set". To load predefined parameters, choose "Existing Parameter Set".

  2. Step 2: - Next step is to base your purchase quotations on items or purchase requests, and set the relevant selection criteria.

  3. Step 3: - Select the items for which you want your vendors to provide quotations. In addition, specify the required quantity and delivery date.

  4. Step 4: - In this step the preferred vendors associated with the selected items are listed below. If required, change the vendor or specify a vendor for items without a preferred vendor.

  5. Step 5: - In this step the preview of the desired purchase quotation is available to the user.

  6. Step 6: - While running the wizard, this is the step where the user  generates the purchase quotation. To save your predefined parameters for future use, choose one of the save options. 

  7. Step 7: - In this final step the user can view the summary of results generated by running the wizard. 

Saturday, July 18, 2020

Express Configuration Wizard

To equip SAP Business One for day to day company use, one must configure various settings, such as accounting, inventory, business partners, sales, and purchasing. Express configuration assists you in configuring company databases by providing a wizard that guides you through the essential settings for each area. In addition, you can compare previous configuration settings so that you can detect changes to a configuration, which may cause errors in the application.


You can use express configuration to:


  • Create a new company database using the express configuration wizard

  • Configure an existing company database using the express configuration wizard

  • Save configuration settings

  • Compare configuration settings

  • Display and print configuration reports


The Steps involved in configuring new companies are: - 


  1. Log on to SAP Business One and choose the Change Company button.

  2. In the Choose Company window, from the New dropdown list, choose New Using Wizard. 

  3. In the Site User window, specify the site user ID and password. The Express Configuration Wizard appears.

  4. In the Welcome window, choose Next.

  5. In the Creating a New Company window, make the required settings and choose Next. For more information, see Express Configuration: Creating a New Company SAP Business One creates a new company with the company details you specified.

  6. When prompted, enter a password for the new company.

  7. In the SAP Business One End-User License Agreement window, specify the relevant data and choose I Accept.

  8. The express configuration wizard appears. You can continue configuring the company database by going through the wizard step-by-step. 

Friday, July 17, 2020

Campaign Generation Wizard

Use the Campaign Generation Wizard to create promotional campaigns for your target demographics. This wizard guides you step-by-step through the definition of parameters required to generate campaigns. The steps that you need to follow to successfully run the wizard are: -


  • Step 1: - The first step is to create a new campaign according to a new parameter set, select Create New Campaign. To create a new campaign based on the parameter set of an existing campaign, select Create Campaign Based on Existing Campaign.

  • Step 2: -  Second Step is to specify all the necessary information for the campaign.

  • Step 3: - This table displays all business partners of the Target Group you specified in step 2. You can add or delete business partners, or change business partner information, if necessary.

  • Step 4: - Select one of the following options: 

    • To save the campaign without executing it, select Save Campaign and Exit.

    • To save the campaign and execute it, select Save Campaign and Execute and then select an execution method.

  • Step 5: - The report displays summarized information of the campaign you generated, as well as errors and warning messages.

Thursday, July 16, 2020

Procurement Confirmation Wizard

Procurement confirmation Wizard assists users in automatically creating one or more procurement documents, such as purchase quotations, purchase orders, or production orders directly from one or more sales orders. You can include a part or all of the items from the sales order in the newly created procurement document. Steps involved in running a procurement confirmation wizard are: -


  • Step 1: -  The first step is to choose all the base documents that you need to convert into procurement documents using this wizard. The Sales orders and Sales quotations are your only two options. 

  • Step 2: - Next step is to select the individual documents that you desire to copy onto a procurement document . i.e. Select the list of sales orders that you wish to copy onto a procurement document. 

  • Step 3: - In this step the user selects the target document that he/she intends to create. 

  • Step 4: - You have the option to consolidate the selected data from your sales orders into one procurement document in this step. Otherwise you can create a separate procurement document for each base document.

  • Step 5: - In this step you get to preview the results of running the wizard. This gives an idea of what is going to happen if the user chooses to run the wizard. 

  • Step 6: - The final step is to review the results and close the wizard. 

Wednesday, July 15, 2020

Production Cost Recalculation Wizard

The wizard enables you to recalculate production costs based on current values. It helps you to eliminate cost inconsistencies by recalculating the production cost of all the items managed by batch or serial at production. These items could be sent to production before their final cost is calculated. The wizard allows you to run simulation of cost changes and provides valuable recommendations. Steps involved in running the wizard are: - 


  • Step 1: -  The first step is to specify whether you want to run Production Cost Recalculation Simulation, Start Production Cost Recalculation Run, or Load Saved Production Cost Recalculation Run.

  • Step 2: -  In this step you specify the  parameters to run the wizard. The parameters that you select will determine the range of receipts from production to which the Production Cost Recalculation Wizard will be applied.

  • Step 3: - This is the part where the user will be able to view the recommendations the wizard puts forth. You can then select the document in which the production cost needs to be adjusted.

  • Step 4: - This is the step where you view and reevaluate all the documents and its connected materials to show its actual production cost. 

  • Step 5: - This is the final step where you can view the summary of the changes made in the production cost by the wizard.  

Tuesday, July 14, 2020

Payment Wizard

The payment wizard enables you to generate incoming and outgoing payments in batches as bank transfers, checks, and/or bills of exchange, according to the selected open A/R and A/P  transactions and the selected payment methods. Steps involved in running the Payment Wizard are: - 


  • Step 1 - Payment Run Selection

  • Step 2 - General Parameters

  • Step 3 - Business Partner - Selection Criteria

  • Step 4 - Document Parameters

  • Step 5 - Payment Method - Selection Criteria

  • Step 6 - Recommendation Report

  • Step 7 - Save Options

  • Step 8 - Payment Run Summary and Printing


The results of running the payment wizard are: - 


  • The relevant incoming payment and/or outgoing payments are created. 

  • The fully paid A/R and/or A/P transactions are closed and the Applied Amount field is updated accordingly.

  • The partially paid A/R and/or A/P transactions are still open and the Applied Amount field is updated accordingly.