1 2 3 15 Previous Next

SAP Business One Application

222 Posts

SAP Business One 9.1 PL07, version for SAP HANA has been released and adopts HANA SPS08!


Details of this release can be found at the overview note: 2160655  - Overview Note for SAP Business One 9.1 PL07, version for SAP HANA



Important Notes


Access the SAP Business One  9.1 Clips on YouTube or the SAP Business One Academy to learn about the new release.


SAP Business One HANA pages in SDN


SAP Business One on SAP HANA solutions


SAP Business One HANA topics

SAP Business One, version for SAP HANA Extensibility topics

Mike Fielding

Starting Out IN B1 Sales

Posted by Mike Fielding Jun 29, 2015

Well here we go. 1st blog post and 1st time out in the big bad world of SAP Business One. Loads to learn and loads to get done. Hope to see you out in the thick of it.

From streamlining operations to managing inventory and cash flow, SAP Business One helps reduce the complexities of running your business so you can focus on reaching your business dreams.


Share your big dream for your business in our 'Small Business, Big Dreams' sweepstakes and you could win expert small business coaching to help grow your business and get you closer to your dreams!


More details to follow.  Stay tuned for updates on this blog!

I have been playing around with the surface pro 3 with business one. I find it is best to maximize the font size if using classic UI or when using the cockpit view it is best to maximize the icon be having a low pixel density. I find it useful to use the surface when walking through a warehouse.

Hi Experts, 




One issue I have a Data Archiving question that I have been troubled with recently :



I'm working with a demo DB when I Running definitely the application the Data Archive Parameters Form visualize the following Warning message :



"Warning: Not enough free space on specified drive for backup of read-only database"






I read the note 1486588 and I have considerations that are documented in it.



However, it is very strange because the free space on my C drive is 300GB and the database should be only 5 GB.  I do not know why I am having this problem.



So I have SB0 9.1 PL6



Thank you in advance for any suggestion




SAP Business One helps in creating different price lists for items.

The user can entering various price lists into SAP Business One.

SAP Business One provides ten predefined price lists.

Adding, changing, or deleting these prices enables you to map a pricing tactic in SAP Business One.


The following links helps in managing price lists.





The existing price lists can be viewed as follows:


Go to Inventory Module>> Price Lists>> Price List


The Price lists are listed.




Select the required Price List and Double click it.


A window is opened as follows:


Here the required parameters are entered, if required or left blank.


Click "OK" to view the required Price List.

In this example, I have selected "Regular Sales Price"

Using this feature you can modify/update the required price-lists.

I just new server to run SAP business one on. With the speed of SSDs it minimizes the need for raid. We only use raid for redundancy and not for speed boost like traditional SAS drives. I love the simplicity in architecture. Even though it is not a PCI express SSD the random read and random writes is quite fast. The time it takes from running an aging report went from 2 minutes to 5 seconds. With the speed of the SSD in case the index is not rebuilt on the SQL server it does not degrade performance as much. I am running traditional SAP and a lot has changed in hardware in the past few years.

This article will explain how to create vendor payments with a corporate credit card against A/P invoices.  Journal entries are part of the illustration.


There are 2 options in applying the payment; one is before the A/P invoice is added and the other is through the outgoing payments window.

  1. Payment will be applied before the invoice is added for point-of-sale and internet purchases.
  2. Payment will be made through the outgoing payments window for invoices with extended payment terms (e.g. net 30). These payments will be crediting the corporate Credit Card Payable instead of Cash.


If one does not exist, create a G/L Liability Account called Credit Card Payable


Online or POS purchases - payment is made before the A/P invoice is added

From the A/P invoice screen, click on the Payment Means button.  Select Credit Card tab.  ***Very important: Enter the G/L Account of Credit Card Payable.
Add the A/P invoice.  We will show example journal entries for a running total on 2 purchases.  Here's the first journal example for a $500 purchase:


Expense Inventory

     500  |


Credit Card Payable

             |  500


Invoices with Extended Terms - purchases that are paid after the invoice is received

Open the Outgoing Payments window and select the vendor and invoices being paid with the credit card.

Click on the Payment means button.  Select Credit card tab. *** Very important:  Enter the G/L Account of Credit Card Payable.

Example journal entry for a $750 purchase:




     750  |


Accounts Payable

             |   750



Accounts Payable

    750  |


Credit Card Payable

            |     500

            |     750


When the credit card statement arrives, all of the charges that were applied to A/P invoices will get coded as a debit to Credit Card Payable.  The sum of those items should total the balance in the credit card payable account.  Journal example:


Credit Card Payable

  1,250  |


Accounts Payable

             |   1,250


If there are other charges that did not already have an A/P invoice, those charges could go through the above process, or simply be coded directly to the appropriate expense account or inventory item.


Once the credit card statement is entered, the G/L liability account should reconcile to 0 unless there is a timing issue and charges for the next payment cycle have already hit.  If there are aged items in this account they need to be resolved.


About us:  Aether Consulting is a Gold SAP Business One reseller partner located in Michigan.

Basics in Financial Reporting

Double-entry bookkeeping system is used for recording financial transactions. 

Every entry to an account requires a corresponding and opposite entry to a different account. 

Recording of a debit amount to one or more accounts and an equal credit amount to one or more accounts results in total debits being equal to total credits for all accounts in the general ledger

First we need to know the types of accounts used in financial books

Types of accounts

Asset account

Liability account

Expense account

Income account

Asset account:

An item of property owned by a person or company having value and available to meet debts, commitments, or legacies. 

e.g.: Land, Vehicle, Cash, Bank, Debtors etc.

Liability account:

An obligation, responsibility, or debt owned by a person or company.

e.g.: Loans, Creditors etc.

Expense account:

   The cost incurred in or required for something; an amount of money spent by a person or company.

   e.g.: purchases, costs, expenses, overheads

Income account:

               Money received, especially on a regular basis, for work or through investments

               e.g.: sales, revenue

To understand the accounting, we need to just follow the rules

Rules of debit and credit

Assets Accounts: 

Debit increases in assets and Credit decreases in assets

Capital Account: 

Credit increases in capital and Debit decreases in capital

Liabilities Accounts: 

Credit increases in liabilities and Debit decreases in liabilities

Revenues or Incomes Accounts: 

Credit increases in incomes and gains, and Debit decreases in incomes and gains

Expenses or Losses Accounts: 

Debit increases in expenses and losses, and Credit decreases in expenses and losses


We will understand the entries with some examples:

Example 1

A cellphone is purchased for $1500 using cash.


An asset is increased: Cellphone is the asset.

Another asset is decreased: Cash is the asset.

So the entry would be:

Cellphone debit $ 1,500

Cash credit $ 1,500

Example 2

Cash is deposited to Bank 1 $100,000

An asset is increased: Bank1 is the asset.

Another asset is decreased: Cash is the asset.

So the entry would be:

Bank 1 debit $100,000

Cash credit $100,000

Example 3

A Television of $2000 is purchased from “ABC” Ltd as credit

An asset is increased: Television is the asset.

A Liability is increased: ABC is the liability

So the entry would be:

Television debit $2,000

ABC Ltd. Credit $2,000

I have been using business one for a few years now. One thing that shocked me was when our retail store customer required us to send invoices by EDI Business one does not have that as a feature. But I remember that most small business don't have the expertise to handle EDI in house so the consultant route is the best option. Me being a tech person manage to get a semi automatic process working with the EDI provider we used to have. But with the growing need to have all the documentation from being transmitted electronically the need for a fully integrated solution is needed. I found a provider and due to running a old machine it was not possible but with the new software and hardware it took only a few days and we got a solution that cut down on data entry and minimizes mistakes. Now in hindsight I should installed EDI with this flexible and stable platform years ago.

Lilian Kennedy

PCC - We're listening!

Posted by Lilian Kennedy Apr 28, 2015


Hi All


While accessing dashboard reports,we may get errors.

But the below specific error which irritates the consultant ,as they need to resinstall B1 integration again and again.Some time it might work and some it doesn't

error:Cannot connect to SAP Business One Integration Service. In the Microsoft "Services" window, ensure that this service has been started.

I found a work around which you can use it for benefits.

As soon as when you get error for your original user,log off sap application.


1. Log on SAP application with another user who have dashboards enabled.

2. you will get the same error but no worries.Log off from the system.

3. Login again with original user.Now it will get connected successfully.


Don't know the actual reason behind it but it might help you.


Share the other workarounds you have.

SAP Business One 9.0, version for SAP HANA PL16 has been released.


This release adopts HANA SPS08, check all details in the following note: 2117582  - Overview Note for SAP Business One 9.0 PL16, version for SAP HANA.            



Important Tips:


          2072868 - Backup service for SAP HANA best practices and known limitations



Important Notes

          Check this note to learn how to unzip the HANA SERVER provided as a set of 2 TAR files.

SAP Business One 9.1 PL06, version for SAP HANA has been released and adopts HANA SPS08!


Details of this release can be found at the overview note: 2138556  - Overview Note for SAP Business One 9.1 PL06, version for SAP HANA


Important Notes


Access the SAP Business One  9.1 Clips on YouTube or the SAP Business One Academy to learn about the new release.


SAP Business One HANA pages in SDN


SAP Business One on SAP HANA solutions


SAP Business One HANA topics

SAP Business One, version for SAP HANA Extensibility topics


  • To Generate Bank File in SAP Business One, First Open SAP Business One Client From our Desktop.
  • To Open Payment Wizard Use The Path
  1. Modules à Banking à Payment Wizard.
  • Click Next from the screen to start the bank file generation process .


  • STEP:1

In step1 we can select New Payment run (or) Load saved payment run.

Load saved payment run means we can use already executed payment run.

  • Click On Next Button in the bottom to go to Step2.
  • In Step2, we can select payment type and payment means.
  • After selecting the required fields we can click on next button to go to step3.


  • Step:3
  • In step 3, we can select the Business partner code range by entering details in from & to Boxes.
  • After Entering Business partner code we have to click on “Add to List” Button to add Business partner code to Table.
  • Also we can select specific Business partner by using check box in the first column of the table.
  • After Entering Proper Details, we can click next button to go to step4.
  • Step:4
  • In Step4, we have to enter Due date as mandatory, and also we can select specifications.
  • After entering details in step4, we have to Select Next button from bottom of the screen to go to step5.
  • Step : 5


  • In Step 5, we have to select the G/L Account for the bank from which we want to pay by using check box in the first column.
  • After selecting the account in the step 5, we have to click to go to step 6.
  • Step : 6
  • In Step 6, we can filter the business partner by using the check box in first column.
  • Also we can check the details of the payment by clicking “Expand All” button.
  • After checking all details, we have to click on the next button to go to step7.
  • Step:7
  • In Step 7, we have to select Specific process for save the file, by selecting the options in step 7.
  • After that we have to click on the next button to go to step 8.
  • After Clicking next one popup window will open, here we have to click “yes” to execute the payment wizard.
  • After clicking yes, another window will open like “Payment wizard has been executed successfully”, here click “ok” to generate the bank file.
  • STEP:8
  • To generate the bank file click on the Bank File button in the bottom.
  • After Clicking on bank file button, we will get “payment engine” Popup Window.


  • In this payment engine window we have to select the button called “Create Files” at the bottom to create payment bank file.
  • After run the payment engine it will generate bank file.
  • From Created Files tab in the payment engine we can know the path of the created file.
  • Bank file is created by using Payment Wizard.


Filter Blog

By author:
By date:
By tag: