Posts

Top 3 Questions on Printing Checks for Payment in SAP Business One

Image
  SAP Business One provides some special functions for Check for Payment, ranging from the definition of a House Bank Account to printing a batch of Checks for Payment. These are the Top 3 Questions we see in SAP Business One Support about printing Checks for Payment. Question 1: How do you print Checks for Payment if the checking account is locked? SAP Business One will not allow you to print a check when another user is accessing the checking account. The Check Printing will be locked at that time. Sometimes the lock is not released, and if you try to print the Check for Payment, you will see the message ‘You cannot print checks while another user is accessing this checking account’. To release the lock, complete the following step: Under   Administration   →   Setup   →   Banking   →   House Bank Accounts , deselect   Lock Checks Printing   for the relevant bank accounts. Question 2: How can you set default print layout for your Checks for Payment? When you open the Check for Paymen
Post a Comment
Read more

How to Import Fixed Assets Legacy Data into SAP Business One from Excel

  If you are implementing SAP Business One Fixed Assets solution and you are confused how to import the legacy data, this article will help you. A simple example will show you how to import opening balance from Excel. Business Scenario: Your company owns a car. It was acquired in September 2016 with price 600000 EUR and it is expected to be used for 10 years. This car started depreciation since September 2016 and 20000 EUR has been depreciated in year 2016. Now you would like to implement the Fixed Assets solution since year 2017 and import the value of this car into SAP Business One. What need to be done? Steps: Enable Fixed Assets solution Go to Administration -> System Initialization -> Company Details -> Basic Initialization, tick the checkbox ‘Enable Fixed Assets 2.  Define the basic parameters for Fixed Assets management Account Determination: Administration -> Setup ->Financials ->Fixed Assets -> Account Determination        Example: FA Motors (Motor Ve
Post a Comment
Read more

Why we get Variances during production Process - SAP business One

 Why does production variance (total variance) occur? What happens to the total variance when you close the production order? If there is a difference between the value of the issued components and the received products, this results in production variance, which is referred as total variance in the application. Production variance often occurs because of the following: 1. Component overconsumption: The quantity of components consumed in production was greater than planned, which causes a negative variance. 2. Component savings: The quantity of components consumed in production was less than planned, which causes positive variance. 3. "Receipt before issue" scenario: The receipt from production is added before the issue for production. In this scenario, the product cost is based on the product cost estimation, which is derived from: a) The current production order structure (in other words, the list of production order components along with their planned quantities). b) The c
Post a Comment
Read more

Fixed Asset Master Data Import Fails - SAP b1

Image
Symptom   Fixed Asset Master Data Import does not import all of the fixed assets, or fails to import Solution  If not all of the fixed assets are imported by the Fixed Assets Master Data Import, you can check the log file for more information. The log file is located in a subdirectory called "SAP Business One Log" that can be found in the temp directory. To access the temp directory, open Windows Explorer and enter "%temp%" in the Address field.  You may find one or more lines beginning with, for example: [date time] BA ER CBAMasterDataTransfer::CBAMasterDataTransfer. The error message and the incorrect data are then added to this initial string. To find out what is wrong in the log file, the following is a diagnosis of the problem from system messages: a) "Import End; Number of imported asset: 0; Number of processed assets: 0; Error:             1". Reason: It is usually due to format error. b) "Import End; Number of imported assets: 0; Number of pro
Post a Comment
Read more

Transaction Notification examples -

 When creating TNs you must note that documents can be saved as drafts and that is why we create a Tn for Drafts and the document.  Examples of TNs 1. When a purchase quotation must have a base document  - see below TN - this TN can be followed up with the respective documents i.e NO purchase order without Purchase quotation. No GRPO without PO . NO AP Invoice without GRPO down to the credit note. It also applies to the Sales Process its only a matter of changing the Tables and object types.  PURCHASE QUOTATION MUST HAVE A BASE DOCUMENT -- ---DRAFT  IF (:transaction_type = ('A') OR :transaction_type = ('U')) AND :object_type = '112' THEN cnt := 0; select count(*) into cnt FROM "ODRF" T0 INNER JOIN  "DRF1" T1  on T1."DocEntry"=T0."DocEntry" WHERE T0."ObjType"=540000006 and  T1."BaseType" NOT IN ('1470000113')  AND T0."DocEntry" = :list_of_cols_val_tab_del; IF :
Post a Comment
Read more