This Space has blogs on various topics in the field of SAP. These blogs point out solutions to various technical and functional issues that consultants face during implementation or support of SAP Projects. Readers/followers are welcome to contribute to this space by emailing your content at bohra.mohammadi@gmail.com. You will be rewarded according to the topic/number of words/complexity of the topic/issue which are you addressing in your blog.
Showing posts with label SAP Business one. Show all posts
Showing posts with label SAP Business one. Show all posts
Monday, December 19
Case study for SAP business one
This topic describes the case study for SAP business one . At the end of this topic you will be able to understand all of the tasks required to complete the case study . You will also be able to implement the light and music business one company all by yourself .
You will need to set up the item master records for light and music items . Firstly you will need to set up the item groups . Secondly you will need to set up the individual items and cells and assign them to an item group . Finally you will need to set up a bill of materials for the multi screen items . In the next demonstration we will view how to set this up .
We are now going to see how to set up the billing materials in business one . Select inventory and then item master data . Now select the add mode . Fill in the item number and a short description of the item. Now add this item to the multi screen group . Remember to mark it as an inventory and sales item and then click on add . Now click on production and define billing materials . Select the add mode . Tab across to see a selection of products . Select the multi screen here and click on choose . The billing materials type will need to be set to production . Here we need to add one PC and nine LCD screens for the billing materials . Once you have changed the quantities , click on add to add the billing materials .
For this area you will need to set up the customer and vendor master records pertaining any special requirements . Firstly you will need to create the customer and vendor groups . Secondly you will need to create the individual customer and vendor master records and assign these to a group , thirdly you will need to set up the special payment terms and discounts that are required , fourthly you need to put each customer into a purchasing membership group . finally you will need to produce the reports relating to the purchasing memberships . There are three reports required here . In the next demo , we will see how to create one of these .
Select the reports and then select query wizards . Now click on next . Select the required tables , in this case OCRD , and CRD 1 and then click on next . Now you select the field you want to be on the report . We need the business partner name , the business partner code and the purchasing level . This is the user defined field we use to refer the customer level of purchasing membership . Now change the sort order to one on this line so that data is sorted correctly . Now we select the field we want to pay from the business field business partner address table – street , city and zip code . Now click on next . Next we specify the conditions for the report . We add anyone to say gold and silver members , so we select all records for the purchasing membership not equal to bronze . When this is done , click on next . Now we can execute out reports , giving us our results . Finally we can save the reports .
For this are you need to set up the accounting module of business one according to light and music requirements . Firstly you need to set up the standard charts of accounts and you need to rename accounts or add new accounts when necessary . Secondly you need to be able to demonstrate how projects operate in business one . Thirdly you need to know how to manage the advance payments in business one . Finally you need to be able to demonstrate how cash flow forecasting is handled in business one . In the next demonstration we shall see how to manage advance payments in business one .
Light and music want to post their yearly cost of their stock insurances account into the advance payment account . They then want to post their monthly cost of their stock insurances account every month by debiting the advance payments account and crediting the stock insurances account . To effect this transaction in business one we use the recurring postings function . Click on financials and then click on recurring postings .Firstly we enter unique code for the recurring posting . In this case we enter RT0001 . Next we put up a short description of the transaction . In this case , stock insurance prepaid. Below we put the datas of the accounting entry we require . We want to credit advance payments of one thousand pounds each month and debit the stock insurances account with the same figure . Finally we specify when we want the transaction to occur . We want it to occur monthly on the last day of every month .
For this area , you will need to set up light and music warehouses arrangement in business one . Firstly you will need to create the sale and rental warehouses . Secondly you will need to configure business one so that the items can be managed by the serial numbers . Thirdly you will need to demonstrate how to import excel price lists into business one . We will see how to do this in the next demonstration . Finally you will need to define a method to printing of the storage location onto a pick list or a stock transfer document .
One of the light and music vendors has sent a surprise list in a Microsoft excel file . We need to import this into business one . Click on inventory and then click on item master data . Firstly we are trying to find the item master record of the item I0001. If we scroll down to the sound systems limited process we can see that there was no process information held . Now we click on administration , then data import , then import from excel . We choose the data tab to import . In this case items . The data we are going to import is the item number , the price list code , the price and the price list currency . We can import more if required by simply selecting additional fields . The first tick box allows us to update the existing item master records . By checking the second tick box we can also update the G/L account dissemination . In this case it is not needed . Click ok to select the file that you wish to import . We can see that the two requests were imported . Now we are going to check the item master record to see if has been updated with the new price . Click on inventory , then item master data and enquire again on item I0001 . If we scroll down to the sound systems limited price list we would see that it has been updated with the new price .
For this are you will need to fulfill light and music sales and purchasing requirements using business one. Firstly you will need to set up alternative item links so that similar items can be proposed if the required item is not available in stock , secondly you will need to set up alerts so that the manager will be notified if a sales order or purchase order is raised that has a value above a certain level . Thirdly a report has to be created as to how much commission a sales person earned over a month and lastly one think each customer requires is a purchase has to be handled using a consignment processing . In the next demonstration we will see how to set up alerts in business one .
Michael Smith , the MD of light and music would want to make sure that no purchase order over a value of fifty thousand pounds is raised without his approval . First we click on administration , then approval procedures , then define approval stage .We need to say that a stage requires the approval of Michael Smith . We shall call this stage as Michael Smith . In the user field we tab across and select Michael Smith . We now add the approval stage . Next we click on define approval templates . We need to add an approval template , specify our terms and we give this template a name and a description , here we give it as high value purchase order . Then we need to add the originator – the document required for approval . We tab in the user field and select all users except Michael Smith and manager , using control to get multiple selections . Now we select the documents tab and select the purchase orders . Then we go to the stages and add the approval stage we previously defined . We then specify when we want the approval to be done by clicking on the terms tab . We wanted to apply when the total document value is greater than fifty thousand pounds . Click on add to add the approval templates . To test if the set up is correct , we then log out and then log in as another user . Now we try and raise the purchase order value with more than fifty thousand pounds . The system will inform us that the document requires approval .We can add a comment . Now the document will be saved as a draft and Michael Smith will be sent a request for approval .
Light and music will be producing multi screens in a number of stock components . You will need to demonstrate how this production process will be handled in business one .
For this area of rental , you will need to configure business one to handle light and music’s rental business . Light and music requires a printed rental agreement to be sent out every time an item is rented . This we need to create according to their specifications using the print layout designer . Management also requires at least two report to assist the maximizing of revenues from the rental business .
In this area of services , you will need to set up business one to be able to manage warranty and service codes . Light and music provides service of maintenance contracts for technical presentation equipments . This needs to be represented in business one . Light and music also provide a limited warranty for the purchased items which also needs to be represented . In the next demonstration , we will see how to set up the service contracts in business one .
We will now see how to set up and configure business contracts in business one . First we click on service , then service contract . We select add mode . We are now going to set up for the ‘MS’ hotel , we select this in the customer name field . We want the contract to last one year . So we specify end date of 12 months from now . We then give the contract a short description , in this case let it be standard hotline service . Next we specify the service type – regular . We then specify the contract type customer as such based on all the customers and not just specific items or groups . We then set a response time of two hours and a resolution time of 48 hours . We click on the coverage tab to specify the hours when this contract will apply . Here we would like to apply the coverage between 9 am to 10 pm , Monday to Sunday . The contract does not include parts , labor or travel costs . So we leave these three tick boxes unchecked . We also want to provide coverage in holiday times , so tick the check box for it . Finally clicking on add to complete the exercise .
You have now completed the topic on the SAP business one case study . You are now able to attempt to complete the case study on your own
You will need to set up the item master records for light and music items . Firstly you will need to set up the item groups . Secondly you will need to set up the individual items and cells and assign them to an item group . Finally you will need to set up a bill of materials for the multi screen items . In the next demonstration we will view how to set this up .
We are now going to see how to set up the billing materials in business one . Select inventory and then item master data . Now select the add mode . Fill in the item number and a short description of the item. Now add this item to the multi screen group . Remember to mark it as an inventory and sales item and then click on add . Now click on production and define billing materials . Select the add mode . Tab across to see a selection of products . Select the multi screen here and click on choose . The billing materials type will need to be set to production . Here we need to add one PC and nine LCD screens for the billing materials . Once you have changed the quantities , click on add to add the billing materials .
For this area you will need to set up the customer and vendor master records pertaining any special requirements . Firstly you will need to create the customer and vendor groups . Secondly you will need to create the individual customer and vendor master records and assign these to a group , thirdly you will need to set up the special payment terms and discounts that are required , fourthly you need to put each customer into a purchasing membership group . finally you will need to produce the reports relating to the purchasing memberships . There are three reports required here . In the next demo , we will see how to create one of these .
Select the reports and then select query wizards . Now click on next . Select the required tables , in this case OCRD , and CRD 1 and then click on next . Now you select the field you want to be on the report . We need the business partner name , the business partner code and the purchasing level . This is the user defined field we use to refer the customer level of purchasing membership . Now change the sort order to one on this line so that data is sorted correctly . Now we select the field we want to pay from the business field business partner address table – street , city and zip code . Now click on next . Next we specify the conditions for the report . We add anyone to say gold and silver members , so we select all records for the purchasing membership not equal to bronze . When this is done , click on next . Now we can execute out reports , giving us our results . Finally we can save the reports .
For this are you need to set up the accounting module of business one according to light and music requirements . Firstly you need to set up the standard charts of accounts and you need to rename accounts or add new accounts when necessary . Secondly you need to be able to demonstrate how projects operate in business one . Thirdly you need to know how to manage the advance payments in business one . Finally you need to be able to demonstrate how cash flow forecasting is handled in business one . In the next demonstration we shall see how to manage advance payments in business one .
Light and music want to post their yearly cost of their stock insurances account into the advance payment account . They then want to post their monthly cost of their stock insurances account every month by debiting the advance payments account and crediting the stock insurances account . To effect this transaction in business one we use the recurring postings function . Click on financials and then click on recurring postings .Firstly we enter unique code for the recurring posting . In this case we enter RT0001 . Next we put up a short description of the transaction . In this case , stock insurance prepaid. Below we put the datas of the accounting entry we require . We want to credit advance payments of one thousand pounds each month and debit the stock insurances account with the same figure . Finally we specify when we want the transaction to occur . We want it to occur monthly on the last day of every month .
For this area , you will need to set up light and music warehouses arrangement in business one . Firstly you will need to create the sale and rental warehouses . Secondly you will need to configure business one so that the items can be managed by the serial numbers . Thirdly you will need to demonstrate how to import excel price lists into business one . We will see how to do this in the next demonstration . Finally you will need to define a method to printing of the storage location onto a pick list or a stock transfer document .
One of the light and music vendors has sent a surprise list in a Microsoft excel file . We need to import this into business one . Click on inventory and then click on item master data . Firstly we are trying to find the item master record of the item I0001. If we scroll down to the sound systems limited process we can see that there was no process information held . Now we click on administration , then data import , then import from excel . We choose the data tab to import . In this case items . The data we are going to import is the item number , the price list code , the price and the price list currency . We can import more if required by simply selecting additional fields . The first tick box allows us to update the existing item master records . By checking the second tick box we can also update the G/L account dissemination . In this case it is not needed . Click ok to select the file that you wish to import . We can see that the two requests were imported . Now we are going to check the item master record to see if has been updated with the new price . Click on inventory , then item master data and enquire again on item I0001 . If we scroll down to the sound systems limited price list we would see that it has been updated with the new price .
For this are you will need to fulfill light and music sales and purchasing requirements using business one. Firstly you will need to set up alternative item links so that similar items can be proposed if the required item is not available in stock , secondly you will need to set up alerts so that the manager will be notified if a sales order or purchase order is raised that has a value above a certain level . Thirdly a report has to be created as to how much commission a sales person earned over a month and lastly one think each customer requires is a purchase has to be handled using a consignment processing . In the next demonstration we will see how to set up alerts in business one .
Michael Smith , the MD of light and music would want to make sure that no purchase order over a value of fifty thousand pounds is raised without his approval . First we click on administration , then approval procedures , then define approval stage .We need to say that a stage requires the approval of Michael Smith . We shall call this stage as Michael Smith . In the user field we tab across and select Michael Smith . We now add the approval stage . Next we click on define approval templates . We need to add an approval template , specify our terms and we give this template a name and a description , here we give it as high value purchase order . Then we need to add the originator – the document required for approval . We tab in the user field and select all users except Michael Smith and manager , using control to get multiple selections . Now we select the documents tab and select the purchase orders . Then we go to the stages and add the approval stage we previously defined . We then specify when we want the approval to be done by clicking on the terms tab . We wanted to apply when the total document value is greater than fifty thousand pounds . Click on add to add the approval templates . To test if the set up is correct , we then log out and then log in as another user . Now we try and raise the purchase order value with more than fifty thousand pounds . The system will inform us that the document requires approval .We can add a comment . Now the document will be saved as a draft and Michael Smith will be sent a request for approval .
Light and music will be producing multi screens in a number of stock components . You will need to demonstrate how this production process will be handled in business one .
For this area of rental , you will need to configure business one to handle light and music’s rental business . Light and music requires a printed rental agreement to be sent out every time an item is rented . This we need to create according to their specifications using the print layout designer . Management also requires at least two report to assist the maximizing of revenues from the rental business .
In this area of services , you will need to set up business one to be able to manage warranty and service codes . Light and music provides service of maintenance contracts for technical presentation equipments . This needs to be represented in business one . Light and music also provide a limited warranty for the purchased items which also needs to be represented . In the next demonstration , we will see how to set up the service contracts in business one .
We will now see how to set up and configure business contracts in business one . First we click on service , then service contract . We select add mode . We are now going to set up for the ‘MS’ hotel , we select this in the customer name field . We want the contract to last one year . So we specify end date of 12 months from now . We then give the contract a short description , in this case let it be standard hotline service . Next we specify the service type – regular . We then specify the contract type customer as such based on all the customers and not just specific items or groups . We then set a response time of two hours and a resolution time of 48 hours . We click on the coverage tab to specify the hours when this contract will apply . Here we would like to apply the coverage between 9 am to 10 pm , Monday to Sunday . The contract does not include parts , labor or travel costs . So we leave these three tick boxes unchecked . We also want to provide coverage in holiday times , so tick the check box for it . Finally clicking on add to complete the exercise .
You have now completed the topic on the SAP business one case study . You are now able to attempt to complete the case study on your own
Labels:
billing materials,
case study for SAP business one,
customer and vendor master records,
SAP Business one
Sunday, November 13
FIFO costing method and Effect of additional expenses on the stock value
At the conclusion of this topic you will be able to describe the standard costing method, describe the FIFO costing method, describe the effect of additional expenses on the stock value, update the costing methods, and use the material revaluation functionality.
The standard price costing method: SAP business one allows you to work with a standard price method for calculating your stock value. A standard or fixed price should be entered in each item, thus influencing every stock posting as described in the next few lines. A stock receipt entered with the different price than the standard price set for the item will debit the stock account according to the standard price. In addition the difference between the standard price and the actual receipt price will be recorded in a variance or a price difference account. For example when the receipt price is higher, than the standard price then the following journal entry will be created. As you will be able to see, the vendor or the allocation account is debited, the stock account is debited with the value according to the standard price and the variance account is debited with the difference between the actual price of the document and of the standard price defined for the item. Stock releases will be recorded according to the standard price only.
Setting standard prices: when you work with a single price in all your warehouses, you should set the standard price via the item master data window. Under the inventory tab there , in the field cost price, type the standard price of your item . when you click on the tab key, the system message- update price for all warehouses is displayed. Click yes to display this price to all your warehouses. It is possible to change the cost prices of each one of the items in the warehouses manually before inventory postings have been created. After these were created you can use the material revaluation window which will be explained later. You can see that in the field costing method, the option standard is selected. Lets see few examples of journal entries created when working with the continuous stock with the standard costing method. Lets first start with the goods receipts PO. Our preliminary assumptions are that the business partners are sales tax exempted and that the item has sufficient stock quantities and is managed by the standard costing methods. You should know that no journal entry would be created by a document containing items with no standard price. This means that if you add a document with an item which does not have the cost price here, no journal entry for the inventory value will be created. The following example will tell a case where the items price as recorded in the goods receipts PO, that is from the standard from as set in the item master data window. Lets type one hundred and fifty in the goods receipt PO. We conceive that the item master data , the cost price of the data in item number one is one hundred. Lets add the document. Lets browse back and take a look at the journal entry. You can see that the allocation account is credited by one hundred and fifty dollars which is the items price in the goods receipts PO. The stock account Is debited by one hundred dollars which is the items standard price. And the variance account is debited by fifty dollars which is the difference between the price in the documents and the standard price of the item in the warehouse. Remember that the allocation account functions as a temporary alternative for the vendors account which will be cleared only after you create a corresponding A/P invoice. Note again that whenever the variance account is recorded in the journal entry, you can conclude the items quantity in stock is positive. If the quantity in stock is zero or negative, the price difference G/L account will be reflected in the difference between the price in the document and the standard price recorded for the document. In this case the variance account will not appear here and instead the price difference account would be recorded. If a document changes the quantity of stock from positive to negative the price difference account will be recorded in the journal entry. If a document changes quantity in stock from negative to positive, then the variance account will be recorded in the journal entry. Lets base an A/P invoice on the goods receipts PO we have just added. When basing an invoice in the goods receipt PO, the allocation account is debited counter to the vendor account which is credited. Lets add the A/P invoice and see the journal entry. You can see that the vendor is credited by one hundred and fifty dollars and the allocation account is debited by one hundred and fifty dollars. Note again that the allocation account functions as a clearing account, it is debited by the amount with which it was credited in the goods received PO. Lets see some stock release documents. Lets open an A/R invoice an see the journal entry created by a standard price item. Again lets set the price here to one hundred and fifty dollars. Remember that the release document do not affect the stock valuation price. This A/R invoice is not based on any document. Let add the document, browse back and take a look at the linked journal entry. You can see that this journal entry includes the deliveries, the inventory transaction and the invoices of accounting transaction. You can see that the value of the inventory transactions is calculated by the item standard price and the amount in the accounting transactions is calculated by the price recorded in the A/R invoice. Lets see an example of an inventory document. Lets take for an example a goods receipt. Select the item again here and you can see that the price is one hundred and fifty. In this example we display a case where the items price here varies from the item standard price set. You can see that the items standard price is one hundred, and the price actually recorded is one hundred and fifty. Lets add this document. Browse back and you can see that the increase account is credited by one hundred and fifty dollars, the stock account is debited by one hundred dollars which is the standard price of the item and the variance account is debited by a difference, between the price in the document (one hundred and fifty ) and the standard price of the document which is hundred dollars. In general if the price in the stock receipt documents is lower than the standard price of the item then the variance account will be credited.
Working with negative stock in the standard method. In a situation where the item quantity in the stock is negative or will be negative after the transaction is created, in most cases the price difference account will be recorded in the journal entry instead of the variance account.
The FIFO costing method: this option calculates the stock value by the FIFO method( first in first out) . each inventory receipt transaction creates a layer of quantities, costs( purchase price) and dates. Each inventory release transaction uses quantities and their corresponding costs from the first open layer or layers. A layer closes when its entire quantity is released. When several inventory receipt transactions are recorded on the same date, SAP business one identifies the first layer, second layer and so on according to their entrance time. Note: no cost price will be displayed in the item master data.
Layers of quantities and prices: lets see how the FIFO costing method works in SAP business one. First and inventory receipt transaction is recorded. It might be a purchasing document or another stock receipt document in this example the inventory receipt transaction was recorded with a quantity of two at a price of one hundred and on the date January first 2004. This inventory receipt transaction created the first layer which is layer number one. On February second an additional inventory receipt transaction was recorded for this item. However, this time although the quantity was two, and the price was two hundred. This created the second layer number two. On march third, one of your customers purchased this item. An inventory release transaction was recorded. Three pieces of this item were purchased. As a result three units of this item were releases from the warehouse. As a result layer number one was closed since a quantity of two was released from this layer and layer number two remained open with a quantity of one at a price of two hundred since only one of the two pieces was released.
Lets see some example for journal entries created by the FIFO costing method. First you can see from the items master data that the selected costing method is FIFO. Notice that there is no cost price field here. This is because the FIFO prices are calculated dynamically according to the receipt and the stock postings. Lets start with the goods receipt PO. Again our prerequisites are that the business partner is tax exempted and that the item is managed by the FIFO costing method. Lets receive two items. Lets receive a quantity of two at a price of one hundred to warehouse number one. Lets add this document and browse back to see the journal entry. You could see that it’s a regular inventory valuation transaction. Now lets add another goods receipt PO. For this tome the quantity will be two and the price will be two hundred to warehouse number one. You can see that the journal entry is normal. Now lets go to the delivery which is the release document. Select the FIFO item and select a quantity of three. Lets add the document, browse back and take a look at the journal entry. You can see that the amount is four hundred. In the delivery there is a quantity of three and a price of one hundred. Remember that the prices in release document do not count for the calculation of the journal entries. So what they did for the calculation for the debited and credited amounts? If you remember, the first layer contains two items with a price of one hundred and the second layer contains two items with a price of two hundred. When the delivery document released a quantity of three, two items which were in the first layer were multiplied by one hundred and this layer was closed. The third item was calculated with a price of two hundred. This account two four hundred( 2 multiplied by one hundred plus one multiplied by two hundred. Lets demonstrate the FIFO transactions using a query we have defined earlier. This query uses a table which represents the WH journal. Here you can see the query sentence and you can see the items transactions. Under the column transaction type you can see the code of the documents. Number 20 represents the goods receipt PO and the number 15 represents a delivery document. In the first record you can see a transaction created by the goods received PO , with a receipt quantity of two at a price of one hundred. In the second record you can see a second transaction created by the goods receipt PO with a received quantity of two at a price of two hundred dollars each. Now lets see the release transactions. If you remember, earlier we had created one delivery document releasing a quantity of three. However you can see that in this query two separate transactions were created. The first transaction record an issued quantity of two at a price of one hundred. This transaction closes the layer created with the closed good receipt PO. The second record shows an issued quantity of one at a price of two hundred. Since the first layer was closed this quantity and price are now taken from the second goods receipt PO transaction and therefore the price changes accordingly.
Working with negative stock in FIFO method: when the stock is negative or zero after addition of a new FIFO layer , all FIFO layers of this item will be closed. The price of the released items will be taken from the last purchase price. When the stock becomes positive as a result of the addition of a new receipt transaction, two FIFO layers will be created for this item. The first layer will record the quantity required in order to bring the stock balance to zero. This layer will be closed. The second layer will record the remaining quantity of the receipt transaction and will function as the first open layer for future FIFO transactions.
Example: an items stock balance is (-4). A quantity of ten was recorded as a stock receipt transaction . results: the first layer for quantity of four, required to bring the stock balance to zero is closed. The second layer for the remaining quantity of six will function as the first open layer of this item.
Additional expenses: additional expenses maybe insurance, shipment or other fees which apply to your goods. If you are working with the continuous stock system, you can add the value of the additional expenses recorded in the row level of your purchasing documents to the inventory value of your goods. Additional expenses may also update the cost price of the items. Further information on additional expenses is provided later on. The influence of additional expenses on the inventory value will be explained further according to the moving average method.
If you are working on the additional expenses on a continuous stock system, you first need to verify that you have defined a certain G/L account under administration ,then definitions, then financials, then G/L accounts determination. Under the purchase tab page, at the bottom of this window, under the title expense account, you can see the variance account field. If you choose the affect the stock with additional expenses you need to specify a variance clearance account to clear journal entries created by the A/P journal memos based on A/P invoices or by the goods return based on the goods receipt POs withy which the additional expenses amount is changed. After you define this G/L account you can add sales and purchasing documents which include additional expenses. Lets see an example as to how the additional expenses affect the valuation when they are recorded in purchasing documents. Lets take for example a goods receipt PO. Lets select an item which is managed by a moving average costing method. The cost price of this item is one hundred in warehouse number one. Lets receive this item with a quantity of one. Select additional expenses. Lets say insurance in the amount of ten dollars. Under the column expenses one stock, you can choose either yes or no. if you choose yes, the additional expenses amount will influence the stock valuation. Lets add this document and browse back to see the journal entry. You can see that the allocation account is credited by one hundred dollars, which is the moving average price of the item. The additional expenses clearing account is credited by ten dollars which is the additional expenses amount and the stock account is debited by the total amount of these two G/L accounts. Note that the additional expenses amount recorded in the journal entry is the global amount for the additional expenses for the entire quantity. The expenses clearing Is the clearing account recorded for the stock account. Now lets place an A/P invoice in this goods receipts PO. You can see that the row that we have recorded in the goods receipt PO is now copied to the A/P invoice , including then additional expenses amount. Lets add the document, browse back and take a look at the journal entry. You can see that the vendor is credited by one hundred and ten dollars which is the total amount of document. The additional expenses clearing account is debited by ten dollars. This is to clear the amount credited in the goods receipt PO. The allocation account is credited by one hundred dollars which is the moving average price for the item. This is to clear the amount debited in the goods receipt PO. Now lets see an example of an independent A/P invoice. Lets select the vendor again, the item and type the date. Now again lets select an additional expense and type an amount. Select yes to affect the stock valuation with the amount of additional expenses lets select add. Browse back and take a look at the journal entry. Note that the expenses clearing account is not recorded in this journal entry since the stock account reflects the item price including additional expenses. As mentioned earlier, the expenses clearing is a clearing account and this journal entry records the final values affecting the inventory valuation. Therefore no intermediate accounts are recorded here. Only the vendor account and the stock account are seen.
Update costing method: starting in version 2004, it is possible to change the costing method of an item, however in case it is not linked to any open documents and its on hand stock is zero. Use the update stock valuation method report to update the costing method of your items.
Lets take a look at the update stock method window. Go to inventory. Click on item management and select update stock method. Approve the selection for the window that opens and open the update stock valuation report. Use this window to update the costing method of your items. Note that only items with a zero on hand stock and have no open documents are displayed ion this window. We can take a look at any item and see that it has no on hand stock. There is no quantity in this field. You can also see that the costing method is set to standard. In the current method column you can see the costing method of the items. In the new method column you can select the relevant costing method which you would like to use from now on for this item. In the approved column, check the boxes of all the items you would like to update. Lets select one of the items with a costing method of moving average method. When you click on update the window closes and you can see that the current method is changed from standard to moving average method.
Material revaluation: starting in 2004, It is possible to change the costing price for your items manually. This window allows you to revaluate material values by changing the moving average or the standard price of an item and calculating the total value of all the stock. There are two options for revaluating the stock: 1.the item price changes when the whole stock is affected.
2. the inventory value( credit or debit) changes with the reference to a certain quantity of the item.
Lets take a look at the material revaluation functionality. Go to inventory, then inventory transaction, then click on material revaluation. In this window you have two methods of revaluation- price change and inventory debit / credit. First lets see the price change revaluation type. In the table, select the items. Let this items current price be one hundred and two point five dollars. Lets say this resulted from the stick and that you would like the price to be one hundred dollars. Simply type new price in this column. Note that the increase and decrease G/L accounts are those defined in the selected warehouse. Click on add to select and perform the action. Go back to browse the linked journal entry. You can see that the corresponding journal entry created for stock valuation involves the stock account of warehouse number one and the decrease account specified in the corresponding field in the material evaluation window. The decrease G/L account is recorded on the journal entry due to the fact that we reduce the price from one hundred and two point five to one hundred. Lets take a look at the item .you can see now that the item whose price was changed from one hundred and two point five to one hundred. Lets take a look at the second method. Inventory debit / credit. This method allows you to record a change in the inventory value which relates to a certain quantity of the item. For example if you know that a price mistake was made in a certain receipt document, yet the inventory value of the entire quantity will be updated regardless of the quantity specified in here. Again lets select this item and now type the quantity. Note that the quantity is informative only . type a positive amount to debit the stock account and a negative amount to credit it. Note that the negative and positive amounts are dependant on the definitions made in the field displayed credit balance with a negative sign. Click on add. Lets browse back to see the journal entry. You can see that one hundred and ten dollars are recorded in the journal entry. Lets take a look at the item and you can see that the cost price was updated accordingly.
You will now be able to describe the standard costing method, describe the FIFO costing method, describe the effect of additional expenses on the stock value, update the costing methods, and use the material revaluation functionality.
The standard price costing method: SAP business one allows you to work with a standard price method for calculating your stock value. A standard or fixed price should be entered in each item, thus influencing every stock posting as described in the next few lines. A stock receipt entered with the different price than the standard price set for the item will debit the stock account according to the standard price. In addition the difference between the standard price and the actual receipt price will be recorded in a variance or a price difference account. For example when the receipt price is higher, than the standard price then the following journal entry will be created. As you will be able to see, the vendor or the allocation account is debited, the stock account is debited with the value according to the standard price and the variance account is debited with the difference between the actual price of the document and of the standard price defined for the item. Stock releases will be recorded according to the standard price only.
Setting standard prices: when you work with a single price in all your warehouses, you should set the standard price via the item master data window. Under the inventory tab there , in the field cost price, type the standard price of your item . when you click on the tab key, the system message- update price for all warehouses is displayed. Click yes to display this price to all your warehouses. It is possible to change the cost prices of each one of the items in the warehouses manually before inventory postings have been created. After these were created you can use the material revaluation window which will be explained later. You can see that in the field costing method, the option standard is selected. Lets see few examples of journal entries created when working with the continuous stock with the standard costing method. Lets first start with the goods receipts PO. Our preliminary assumptions are that the business partners are sales tax exempted and that the item has sufficient stock quantities and is managed by the standard costing methods. You should know that no journal entry would be created by a document containing items with no standard price. This means that if you add a document with an item which does not have the cost price here, no journal entry for the inventory value will be created. The following example will tell a case where the items price as recorded in the goods receipts PO, that is from the standard from as set in the item master data window. Lets type one hundred and fifty in the goods receipt PO. We conceive that the item master data , the cost price of the data in item number one is one hundred. Lets add the document. Lets browse back and take a look at the journal entry. You can see that the allocation account is credited by one hundred and fifty dollars which is the items price in the goods receipts PO. The stock account Is debited by one hundred dollars which is the items standard price. And the variance account is debited by fifty dollars which is the difference between the price in the documents and the standard price of the item in the warehouse. Remember that the allocation account functions as a temporary alternative for the vendors account which will be cleared only after you create a corresponding A/P invoice. Note again that whenever the variance account is recorded in the journal entry, you can conclude the items quantity in stock is positive. If the quantity in stock is zero or negative, the price difference G/L account will be reflected in the difference between the price in the document and the standard price recorded for the document. In this case the variance account will not appear here and instead the price difference account would be recorded. If a document changes the quantity of stock from positive to negative the price difference account will be recorded in the journal entry. If a document changes quantity in stock from negative to positive, then the variance account will be recorded in the journal entry. Lets base an A/P invoice on the goods receipts PO we have just added. When basing an invoice in the goods receipt PO, the allocation account is debited counter to the vendor account which is credited. Lets add the A/P invoice and see the journal entry. You can see that the vendor is credited by one hundred and fifty dollars and the allocation account is debited by one hundred and fifty dollars. Note again that the allocation account functions as a clearing account, it is debited by the amount with which it was credited in the goods received PO. Lets see some stock release documents. Lets open an A/R invoice an see the journal entry created by a standard price item. Again lets set the price here to one hundred and fifty dollars. Remember that the release document do not affect the stock valuation price. This A/R invoice is not based on any document. Let add the document, browse back and take a look at the linked journal entry. You can see that this journal entry includes the deliveries, the inventory transaction and the invoices of accounting transaction. You can see that the value of the inventory transactions is calculated by the item standard price and the amount in the accounting transactions is calculated by the price recorded in the A/R invoice. Lets see an example of an inventory document. Lets take for an example a goods receipt. Select the item again here and you can see that the price is one hundred and fifty. In this example we display a case where the items price here varies from the item standard price set. You can see that the items standard price is one hundred, and the price actually recorded is one hundred and fifty. Lets add this document. Browse back and you can see that the increase account is credited by one hundred and fifty dollars, the stock account is debited by one hundred dollars which is the standard price of the item and the variance account is debited by a difference, between the price in the document (one hundred and fifty ) and the standard price of the document which is hundred dollars. In general if the price in the stock receipt documents is lower than the standard price of the item then the variance account will be credited.
Working with negative stock in the standard method. In a situation where the item quantity in the stock is negative or will be negative after the transaction is created, in most cases the price difference account will be recorded in the journal entry instead of the variance account.
The FIFO costing method: this option calculates the stock value by the FIFO method( first in first out) . each inventory receipt transaction creates a layer of quantities, costs( purchase price) and dates. Each inventory release transaction uses quantities and their corresponding costs from the first open layer or layers. A layer closes when its entire quantity is released. When several inventory receipt transactions are recorded on the same date, SAP business one identifies the first layer, second layer and so on according to their entrance time. Note: no cost price will be displayed in the item master data.
Layers of quantities and prices: lets see how the FIFO costing method works in SAP business one. First and inventory receipt transaction is recorded. It might be a purchasing document or another stock receipt document in this example the inventory receipt transaction was recorded with a quantity of two at a price of one hundred and on the date January first 2004. This inventory receipt transaction created the first layer which is layer number one. On February second an additional inventory receipt transaction was recorded for this item. However, this time although the quantity was two, and the price was two hundred. This created the second layer number two. On march third, one of your customers purchased this item. An inventory release transaction was recorded. Three pieces of this item were purchased. As a result three units of this item were releases from the warehouse. As a result layer number one was closed since a quantity of two was released from this layer and layer number two remained open with a quantity of one at a price of two hundred since only one of the two pieces was released.
Lets see some example for journal entries created by the FIFO costing method. First you can see from the items master data that the selected costing method is FIFO. Notice that there is no cost price field here. This is because the FIFO prices are calculated dynamically according to the receipt and the stock postings. Lets start with the goods receipt PO. Again our prerequisites are that the business partner is tax exempted and that the item is managed by the FIFO costing method. Lets receive two items. Lets receive a quantity of two at a price of one hundred to warehouse number one. Lets add this document and browse back to see the journal entry. You could see that it’s a regular inventory valuation transaction. Now lets add another goods receipt PO. For this tome the quantity will be two and the price will be two hundred to warehouse number one. You can see that the journal entry is normal. Now lets go to the delivery which is the release document. Select the FIFO item and select a quantity of three. Lets add the document, browse back and take a look at the journal entry. You can see that the amount is four hundred. In the delivery there is a quantity of three and a price of one hundred. Remember that the prices in release document do not count for the calculation of the journal entries. So what they did for the calculation for the debited and credited amounts? If you remember, the first layer contains two items with a price of one hundred and the second layer contains two items with a price of two hundred. When the delivery document released a quantity of three, two items which were in the first layer were multiplied by one hundred and this layer was closed. The third item was calculated with a price of two hundred. This account two four hundred( 2 multiplied by one hundred plus one multiplied by two hundred. Lets demonstrate the FIFO transactions using a query we have defined earlier. This query uses a table which represents the WH journal. Here you can see the query sentence and you can see the items transactions. Under the column transaction type you can see the code of the documents. Number 20 represents the goods receipt PO and the number 15 represents a delivery document. In the first record you can see a transaction created by the goods received PO , with a receipt quantity of two at a price of one hundred. In the second record you can see a second transaction created by the goods receipt PO with a received quantity of two at a price of two hundred dollars each. Now lets see the release transactions. If you remember, earlier we had created one delivery document releasing a quantity of three. However you can see that in this query two separate transactions were created. The first transaction record an issued quantity of two at a price of one hundred. This transaction closes the layer created with the closed good receipt PO. The second record shows an issued quantity of one at a price of two hundred. Since the first layer was closed this quantity and price are now taken from the second goods receipt PO transaction and therefore the price changes accordingly.
Working with negative stock in FIFO method: when the stock is negative or zero after addition of a new FIFO layer , all FIFO layers of this item will be closed. The price of the released items will be taken from the last purchase price. When the stock becomes positive as a result of the addition of a new receipt transaction, two FIFO layers will be created for this item. The first layer will record the quantity required in order to bring the stock balance to zero. This layer will be closed. The second layer will record the remaining quantity of the receipt transaction and will function as the first open layer for future FIFO transactions.
Example: an items stock balance is (-4). A quantity of ten was recorded as a stock receipt transaction . results: the first layer for quantity of four, required to bring the stock balance to zero is closed. The second layer for the remaining quantity of six will function as the first open layer of this item.
Additional expenses: additional expenses maybe insurance, shipment or other fees which apply to your goods. If you are working with the continuous stock system, you can add the value of the additional expenses recorded in the row level of your purchasing documents to the inventory value of your goods. Additional expenses may also update the cost price of the items. Further information on additional expenses is provided later on. The influence of additional expenses on the inventory value will be explained further according to the moving average method.
If you are working on the additional expenses on a continuous stock system, you first need to verify that you have defined a certain G/L account under administration ,then definitions, then financials, then G/L accounts determination. Under the purchase tab page, at the bottom of this window, under the title expense account, you can see the variance account field. If you choose the affect the stock with additional expenses you need to specify a variance clearance account to clear journal entries created by the A/P journal memos based on A/P invoices or by the goods return based on the goods receipt POs withy which the additional expenses amount is changed. After you define this G/L account you can add sales and purchasing documents which include additional expenses. Lets see an example as to how the additional expenses affect the valuation when they are recorded in purchasing documents. Lets take for example a goods receipt PO. Lets select an item which is managed by a moving average costing method. The cost price of this item is one hundred in warehouse number one. Lets receive this item with a quantity of one. Select additional expenses. Lets say insurance in the amount of ten dollars. Under the column expenses one stock, you can choose either yes or no. if you choose yes, the additional expenses amount will influence the stock valuation. Lets add this document and browse back to see the journal entry. You can see that the allocation account is credited by one hundred dollars, which is the moving average price of the item. The additional expenses clearing account is credited by ten dollars which is the additional expenses amount and the stock account is debited by the total amount of these two G/L accounts. Note that the additional expenses amount recorded in the journal entry is the global amount for the additional expenses for the entire quantity. The expenses clearing Is the clearing account recorded for the stock account. Now lets place an A/P invoice in this goods receipts PO. You can see that the row that we have recorded in the goods receipt PO is now copied to the A/P invoice , including then additional expenses amount. Lets add the document, browse back and take a look at the journal entry. You can see that the vendor is credited by one hundred and ten dollars which is the total amount of document. The additional expenses clearing account is debited by ten dollars. This is to clear the amount credited in the goods receipt PO. The allocation account is credited by one hundred dollars which is the moving average price for the item. This is to clear the amount debited in the goods receipt PO. Now lets see an example of an independent A/P invoice. Lets select the vendor again, the item and type the date. Now again lets select an additional expense and type an amount. Select yes to affect the stock valuation with the amount of additional expenses lets select add. Browse back and take a look at the journal entry. Note that the expenses clearing account is not recorded in this journal entry since the stock account reflects the item price including additional expenses. As mentioned earlier, the expenses clearing is a clearing account and this journal entry records the final values affecting the inventory valuation. Therefore no intermediate accounts are recorded here. Only the vendor account and the stock account are seen.
Update costing method: starting in version 2004, it is possible to change the costing method of an item, however in case it is not linked to any open documents and its on hand stock is zero. Use the update stock valuation method report to update the costing method of your items.
Lets take a look at the update stock method window. Go to inventory. Click on item management and select update stock method. Approve the selection for the window that opens and open the update stock valuation report. Use this window to update the costing method of your items. Note that only items with a zero on hand stock and have no open documents are displayed ion this window. We can take a look at any item and see that it has no on hand stock. There is no quantity in this field. You can also see that the costing method is set to standard. In the current method column you can see the costing method of the items. In the new method column you can select the relevant costing method which you would like to use from now on for this item. In the approved column, check the boxes of all the items you would like to update. Lets select one of the items with a costing method of moving average method. When you click on update the window closes and you can see that the current method is changed from standard to moving average method.
Material revaluation: starting in 2004, It is possible to change the costing price for your items manually. This window allows you to revaluate material values by changing the moving average or the standard price of an item and calculating the total value of all the stock. There are two options for revaluating the stock: 1.the item price changes when the whole stock is affected.
2. the inventory value( credit or debit) changes with the reference to a certain quantity of the item.
Lets take a look at the material revaluation functionality. Go to inventory, then inventory transaction, then click on material revaluation. In this window you have two methods of revaluation- price change and inventory debit / credit. First lets see the price change revaluation type. In the table, select the items. Let this items current price be one hundred and two point five dollars. Lets say this resulted from the stick and that you would like the price to be one hundred dollars. Simply type new price in this column. Note that the increase and decrease G/L accounts are those defined in the selected warehouse. Click on add to select and perform the action. Go back to browse the linked journal entry. You can see that the corresponding journal entry created for stock valuation involves the stock account of warehouse number one and the decrease account specified in the corresponding field in the material evaluation window. The decrease G/L account is recorded on the journal entry due to the fact that we reduce the price from one hundred and two point five to one hundred. Lets take a look at the item .you can see now that the item whose price was changed from one hundred and two point five to one hundred. Lets take a look at the second method. Inventory debit / credit. This method allows you to record a change in the inventory value which relates to a certain quantity of the item. For example if you know that a price mistake was made in a certain receipt document, yet the inventory value of the entire quantity will be updated regardless of the quantity specified in here. Again lets select this item and now type the quantity. Note that the quantity is informative only . type a positive amount to debit the stock account and a negative amount to credit it. Note that the negative and positive amounts are dependant on the definitions made in the field displayed credit balance with a negative sign. Click on add. Lets browse back to see the journal entry. You can see that one hundred and ten dollars are recorded in the journal entry. Lets take a look at the item and you can see that the cost price was updated accordingly.
You will now be able to describe the standard costing method, describe the FIFO costing method, describe the effect of additional expenses on the stock value, update the costing methods, and use the material revaluation functionality.
Continuous Stock System in SAP business one
This topic describes the continuous stock system in SAP business one. At the conclusion of the topic you will be able to describe the continuous stock system, describe the three possible costing methods, initialize the continuous stock system in your company, and describe the moving average costing method.
A continuous stock system reflects the value of stock postings by means of monetary transactions in terms of the accounting system. These monetary transactions are carried out only when the items defined as WH items are received or released from the stock. A continuous stock system should be determined during basic initialization before any transactions have been posted. The stock account reflects the stock final value and recorded in most of the stock transactions in SAP business one.
A warehouse item is linked to a stock account. As you purchase this item by the purchasing documents, the balance of the stock account increases. When you sell this item using sales document, the balance of the stock account decreases.
There are three possible costing methods used for calculating the inventory. First one is moving average. This option calculates the inventory value by the item’s cost price. Next is the standard. This option calculates the inventory value by a fixed price. The items standard price should be fixed before starting to work your the company. The last one is FIFO. This option calculates the inventory value by the FIFO method( first in first out). Each inventory receipt transaction creates a layer or quantity related to costs; each inventory release transactions will use quantities and their corresponding costs from the first open layer or layers.
Check the box ‘inventory valuation by’ to initialize the stock system. Define primary G/L accounts to be selected as default in new warehouses, item groups and item master data. Set G/L accounts in the item master data window.
Initializing the continuous stock system: under administration, system initialization, then company details with the basic initialization tab page. First check the box ‘inventory valuation by’, in order to initialize a continuous stock system. As a result the following fields will be displayed. In the inventory valuation by, chose from the drop down menu one of the three options- moving average, standard or FIFO. Starting from version 2004 it is possible to change this method in any time. The default costing method for the new items is taken from the linked item groups, and the costing method of new item groups is then selected in this field. A new company is created with the moving average inventory valuation method as a default. The next is ‘handle price system from the warehouse’ check this box to manage separately the cost of each of the items in the warehouse. Use purchase account posting system. This box is available in only certain localizations. Check this box if you want to document your inventory transactions on the expenses side, and as well as conducting a continuous stock system. Each journal entry would have additional rows reflecting the companies expenses. Additional documentation is provided. Next area is ‘ allow stock release without cost price’ . check this box to allow stock release transaction with zero value. Thus the inventory valuation will not be affected. Note that the box ‘inventory valuation by’ cannot be checked after stock costing have been recorded. Moreover you cannot clear this box after the creation of an automatic stock posting. For example, delivery, goods received,etc.
Detailed information about the stock G/L account is attached later. The stock account reflects the stock final value, and is recorded in most of the stock transactions in SAP business one. Cost of goods sold is used in good delivery, invoices and to the returning account used in the AR returns and AR credit memos. Next is the allocation account. This account is used as an offsetting account in the goods, CPOs and AP credit memos. The balance of this G/L account reflects the total amount of open goods receive PL and good returns. Then comes the variance account. This account is used only in the standard price inventory system. In certain scenario, in case there are differences between the standard price and the actual price in the purchasing document, these differences would be recorded in the variance account. Examples are provided later. Then its sales returns. This is an offsetting account to the cost of goods sold account used in the AR returns and AR credit memos. Goods clearing account is an offsetting account to the allocation costs used when enclosing goods received POs or goods returns. In this case, no inventory entry is registered, however a journal entry is created including this G/ L account. Next is the expenses clearing account. If you choose to additional start with expenses you need to specify an offsetting G/L account to the stock account for clearing the journal entries created by AP invoices and goods received POs. note that this G/L account is involved with the journal entries whenever the allocation account is also involved. The stock account balance plus the sales returns account balance reflect the the total stock value.
Setting of G/L accounts in the item master data: select administration. Under it system initialization, then general settings, and finally the inventory tab page. Under the default warehouse, choose from the dropdown menu the default warehouse that is being used by your company. Set G/L account by. Use the dropdown menu to select the required method by which you would like to set the G/L accounts connected to your items. First is WH. Initially you need to find the warehouse window. Locate it under administration, definitions, inventory , warehouses an finally accounting tab page. Next is item group. In G/L account in order to find it you need to find the item groups window. Locate it under administration, definitions, inventory , item group. Define an accounting tab page. Next is the item level. So in this method in order to define G/L accounts for each item manually, via inventory, item master data, inventory tab page. Auto – add all the new items to the warehouse. Check this box that you wish SAP business one to add all the existing warehouses to every new item and every new added warehouse to all the existing items.
General remarks: it is generally recommended to define a separate warehouse for fixed asset items. In all three costing methods, the price calculated for the items is in the local currency. Starting in version 2004, it is possible to whether the row level additional expenses will affect the inventory valuation in purchasing documents.
When managing a continuous stock system by moving average, a stock receipt will debit the stock account of each warehouse, according to the price entered in the document. You can see that the vendor or the allocation account is credited and the stock account is debited according to the value of the cost price. This price will also update the item’s cost price according to a calculation formula relevant to the moving average system.
The moving average costing method: a stock release posting will credit the stock or sales returns account according to the items cost price. Stock release documents do not affect the cost price of your items. Note that the item prices recorded in the A/R credit memes and returns do not influence the cost price and are not considered to the calculation of the journal entries reflecting the inventory value , which these documents create.
The following demonstration shows the influence of release and receipt documents on the stock accounts and on the items cost pricing. This will not include all the possible journal entries created by release and receipt documents.
First take a look at the items managed by the moving average costing method. Under the inventory data tab page in the field costing method, you can see that the selected costing method is moving average. It is also possible to change the costing method into standard or FIFO. These will be discussed later. The default costing method for an item is taken from the linked item group. the costing method selected in group is the method selected in covering detail in basic initialization tab page, in the field inventory valuation by. Starting in version 2004, it is possible to change the costing method of an item. However, only if it is not linked to any open documents and its on hand stock is zero. If the box handle price system through warehouses is checked under system initialization in basic initialization tab page., the cost price will be ,managed and calculated separately, for each item in each warehouse and will be displayed in the warehouse row in the table. Here you can see that each of the displayed items are displayed along with the corresponding cost price. The moving average price which is the cost price will be displayed here after the inventory transactions will be carried out in SAP business one. You can see that every warehouse in the table is linked to G/L accounts according to the field set G/L accounts by. You can see the stock G/L account which is the main account, in which the inventory valuation is recorded. Lets see examples of journal entries created in working of a continuous stock system by the moving average costing method. Lets start with the goods receipt PO. Lets select a business partner and an item. first some prerequisites. Make sure that the business partner is tax exempted and that the item is not tax liable and is defined with the moving average costing method. Note that the warehouse specified under the item number one is the warehouse number one. Lets add this document. Lets browse back and display its journal entry. The debit and credit amounts are calculated by multiplying the quantity of the item in the document by the prices specified in the goods received. You can see that one multiplied by one hundred equals one hundred and this is the amount displayed in the journal entry. Let take a look at the item master data under the inventory data tab page and you can see that the cost price is calculated as one hundred. Lets open the journal entry again. You can see that the stock account recorded in the journal entry is stock one which is linked to warehouse number one as specified in the item master data. You can see that the stock account is debited. Therefore the items inventory valuation increases. You can see the allocation account here. Remember that a this allocation account functions as a temporary alternative to the vendors account which will be cleared only after you create a corresponding A/P invoice or goods return document. Lets copy this goods received PO to an A/P invoice. Lets select the vendor. Click on goods receipt PO and select the goods receipt PO and just create it. Lets add the document. Browse back to create it again and click this link arrow to display its related journal entry. When you base an A/P invoice in a goods received PO, the allocation account is debited. Counter to it is the vendors account which is credited. Note that the allocation account serves as a clearing account here. It is debited in the account in which it was credited in the goods received PO created earlier. Lets take a look at the item. You can see that the cost price is still one hundred since we did not change its receipt price. Now lets add an independent A/P invoice. This is an invoice that is not based on any other document. Select a vendor and now type a price of one hundred and twenty US dollars. Lets add the document. Browse back and display the journal entry. You can see that the debit and credit amounts are now one hundred and twenty and not one hundred. This is since the price form the document is taken and multiplied by the quantity. Note that now the stock account is recorded in the journal entry and not the allocation account. Lets take a look at the item master data. You can see that the cost price of the item is changed to one hundred and ten. This is because the first item received in the stock was received for one hundred dollars and the second item received was for one hundred and twenty dollars. The moving average of the two items with these two prices results in one hundred and ten. Now let us take a look at some release documents. Lets begin with delivery. Select a business partner and assign them. Lets deliver this item with a quantity of one and a price of one hundred. Lets take a look at the items cost price and consider that it is one hundred and ten. Lets add the document and browse back to display its related journal entry. You can see that although the price in the delivery document was one hundred dollars, the journal entry created here reports one hundred and ten both in the debit and credit sides. These are the amounts calculated by multiplying the quantity by each one of the items in the delivery document by their cost price. The cost of goods sold account functions as on offsetting account to the stock account and the stock account is credited. Thus the item inventory valuation is decreased. Now lets base an A/R invoice on this delivery. Again you can see here that the price is one hundred. Lets add the document and browse back to display the journal entry. When you base an A/R invoice on a delivery, no stock posting is created. Thus only a regular journal entry is created in the accounting system. You can see that there are no stock accounts here. Only the customer and the revenues account. Now lets add an independent A/R invoice. Again lets select a customer and an item. Lets add the document and browse back and look at its linked journal entry. This journal entry includes both the deliveries and inventory transaction represented by these two rows and the invoices accounting transaction represented by these two rows. Now lets see an inventory document. Lets ho to inventory and select inventory transaction and then select stock transfer. Lets transfer one unit of this item from warehouse number one to warehouse number two. Lets add the document and get back to see its linked journal entry. If you specify different stock accounts for your different warehouses, the stock transferred transaction will credit the stock transaction to the release warehouse. In this case the warehouse number one. And debit the stock account of the received warehouse. In this case the warehouse number two. The release and the receipt prices are set by the moving average price of the item in the release warehouse. You could see that one hundred and ten is displayed for warehouse number one.
Moving average in the production process: in a production order for a bill of materials item the parent item price will be calculated according to the moving average prices of its child items. You cannot change its price. There are two methods for issuing items in production orders. Additional information is provided in a separate lesson. One method is manual. In this method, you document the parent items receipt and the child items release in two separate steps. Second is the backflush. In this method, the parent items receipt and the child item release are recorded simultaneously. If your company is upgraded from a version before 2004, the old production method also will be available.
Lets take a look at the influence of the production process on the continuous stock system. First take a look at the define of bill materials window. Here you can see the parent product which is going to be received in warehouse number two. The parent product is comprised of this child item with a quantity of two which is going to be released from warehouse number one. Both the parent and child items are defined with moving average as their costing method. The child items cost price is one hundred in warehouse number one. Lets open a production order. Select the parent item .in the production order, the parent items price will be calculated according to the moving average prices of its child items. It is not possible to change this price. There are two methods for issuing items in production order which are manual and the backflush. Additional information is provided in a separate document. Manual: In this method, you document the parent items receipt and the child items release in two separate steps. First lets add this production order in a planned status. Browse back and change the status to release. Update the window, right click the mouse and select the issue components. This action will release the child items from the warehouse number one. Lets add the document. Browse back and take a look at the journal entry. You can see that the stock account at the child release in warehouse is credited and the work in progress account is debited. The credit and debit account amounts are calculated according to the moving average prices of the child item. You can see that the child items moving average price is one hundred in warehouse number one, multiplied by two gives you two hundred. Now lets receive the parent account into the warehouse number two. Select report completion and click on add. Browse back and take a look at the journal entry. You can see that the work in process account is credited and the stock account of warehouse number two is debited. Lets go back to the production order window. If we had selected the issue method as backflush when the production order was completed, the stock account of the parent item warehouse will be debited and the stock account of the child item warehouses would be credited. Again the release and the receipt prices are set by the moving average prices of the child items. However in the backflush method there is no issue for production but the two journal entries shown to you are just created simultaneously . when the issue method is set to manual, there might be a situation where the cost price of the item changes during the production process. For example this items cost price used to be one hundred dollars. An issue component took place , but then before the report completion was added the moving average price of the item was changed to one hundred and ten dollars instead of one hundred dollars. In this case under the summary tab page you can see the following data. The actual components value is two hundred ,however the actual products value is two hundred and twenty. Therefore there is a variance of twenty dollars. This variance would be reported as you close the production order. You can see that the work in process materials and the work in process variance are debited and credited respectively.
Working with negative stock: in a situation in the item quantity when the stock is zero or negative, the creation of the stock receipt document changes the cost price of the item to be entered in that receipt document.
You are now able to describe the continuous stock system, describe the three possible costing methods, initialize the continuous stock system in your computer and also be able to describe the moving average costing method.
A continuous stock system reflects the value of stock postings by means of monetary transactions in terms of the accounting system. These monetary transactions are carried out only when the items defined as WH items are received or released from the stock. A continuous stock system should be determined during basic initialization before any transactions have been posted. The stock account reflects the stock final value and recorded in most of the stock transactions in SAP business one.
A warehouse item is linked to a stock account. As you purchase this item by the purchasing documents, the balance of the stock account increases. When you sell this item using sales document, the balance of the stock account decreases.
There are three possible costing methods used for calculating the inventory. First one is moving average. This option calculates the inventory value by the item’s cost price. Next is the standard. This option calculates the inventory value by a fixed price. The items standard price should be fixed before starting to work your the company. The last one is FIFO. This option calculates the inventory value by the FIFO method( first in first out). Each inventory receipt transaction creates a layer or quantity related to costs; each inventory release transactions will use quantities and their corresponding costs from the first open layer or layers.
Check the box ‘inventory valuation by’ to initialize the stock system. Define primary G/L accounts to be selected as default in new warehouses, item groups and item master data. Set G/L accounts in the item master data window.
Initializing the continuous stock system: under administration, system initialization, then company details with the basic initialization tab page. First check the box ‘inventory valuation by’, in order to initialize a continuous stock system. As a result the following fields will be displayed. In the inventory valuation by, chose from the drop down menu one of the three options- moving average, standard or FIFO. Starting from version 2004 it is possible to change this method in any time. The default costing method for the new items is taken from the linked item groups, and the costing method of new item groups is then selected in this field. A new company is created with the moving average inventory valuation method as a default. The next is ‘handle price system from the warehouse’ check this box to manage separately the cost of each of the items in the warehouse. Use purchase account posting system. This box is available in only certain localizations. Check this box if you want to document your inventory transactions on the expenses side, and as well as conducting a continuous stock system. Each journal entry would have additional rows reflecting the companies expenses. Additional documentation is provided. Next area is ‘ allow stock release without cost price’ . check this box to allow stock release transaction with zero value. Thus the inventory valuation will not be affected. Note that the box ‘inventory valuation by’ cannot be checked after stock costing have been recorded. Moreover you cannot clear this box after the creation of an automatic stock posting. For example, delivery, goods received,etc.
Detailed information about the stock G/L account is attached later. The stock account reflects the stock final value, and is recorded in most of the stock transactions in SAP business one. Cost of goods sold is used in good delivery, invoices and to the returning account used in the AR returns and AR credit memos. Next is the allocation account. This account is used as an offsetting account in the goods, CPOs and AP credit memos. The balance of this G/L account reflects the total amount of open goods receive PL and good returns. Then comes the variance account. This account is used only in the standard price inventory system. In certain scenario, in case there are differences between the standard price and the actual price in the purchasing document, these differences would be recorded in the variance account. Examples are provided later. Then its sales returns. This is an offsetting account to the cost of goods sold account used in the AR returns and AR credit memos. Goods clearing account is an offsetting account to the allocation costs used when enclosing goods received POs or goods returns. In this case, no inventory entry is registered, however a journal entry is created including this G/ L account. Next is the expenses clearing account. If you choose to additional start with expenses you need to specify an offsetting G/L account to the stock account for clearing the journal entries created by AP invoices and goods received POs. note that this G/L account is involved with the journal entries whenever the allocation account is also involved. The stock account balance plus the sales returns account balance reflect the the total stock value.
Setting of G/L accounts in the item master data: select administration. Under it system initialization, then general settings, and finally the inventory tab page. Under the default warehouse, choose from the dropdown menu the default warehouse that is being used by your company. Set G/L account by. Use the dropdown menu to select the required method by which you would like to set the G/L accounts connected to your items. First is WH. Initially you need to find the warehouse window. Locate it under administration, definitions, inventory , warehouses an finally accounting tab page. Next is item group. In G/L account in order to find it you need to find the item groups window. Locate it under administration, definitions, inventory , item group. Define an accounting tab page. Next is the item level. So in this method in order to define G/L accounts for each item manually, via inventory, item master data, inventory tab page. Auto – add all the new items to the warehouse. Check this box that you wish SAP business one to add all the existing warehouses to every new item and every new added warehouse to all the existing items.
General remarks: it is generally recommended to define a separate warehouse for fixed asset items. In all three costing methods, the price calculated for the items is in the local currency. Starting in version 2004, it is possible to whether the row level additional expenses will affect the inventory valuation in purchasing documents.
When managing a continuous stock system by moving average, a stock receipt will debit the stock account of each warehouse, according to the price entered in the document. You can see that the vendor or the allocation account is credited and the stock account is debited according to the value of the cost price. This price will also update the item’s cost price according to a calculation formula relevant to the moving average system.
The moving average costing method: a stock release posting will credit the stock or sales returns account according to the items cost price. Stock release documents do not affect the cost price of your items. Note that the item prices recorded in the A/R credit memes and returns do not influence the cost price and are not considered to the calculation of the journal entries reflecting the inventory value , which these documents create.
The following demonstration shows the influence of release and receipt documents on the stock accounts and on the items cost pricing. This will not include all the possible journal entries created by release and receipt documents.
First take a look at the items managed by the moving average costing method. Under the inventory data tab page in the field costing method, you can see that the selected costing method is moving average. It is also possible to change the costing method into standard or FIFO. These will be discussed later. The default costing method for an item is taken from the linked item group. the costing method selected in group is the method selected in covering detail in basic initialization tab page, in the field inventory valuation by. Starting in version 2004, it is possible to change the costing method of an item. However, only if it is not linked to any open documents and its on hand stock is zero. If the box handle price system through warehouses is checked under system initialization in basic initialization tab page., the cost price will be ,managed and calculated separately, for each item in each warehouse and will be displayed in the warehouse row in the table. Here you can see that each of the displayed items are displayed along with the corresponding cost price. The moving average price which is the cost price will be displayed here after the inventory transactions will be carried out in SAP business one. You can see that every warehouse in the table is linked to G/L accounts according to the field set G/L accounts by. You can see the stock G/L account which is the main account, in which the inventory valuation is recorded. Lets see examples of journal entries created in working of a continuous stock system by the moving average costing method. Lets start with the goods receipt PO. Lets select a business partner and an item. first some prerequisites. Make sure that the business partner is tax exempted and that the item is not tax liable and is defined with the moving average costing method. Note that the warehouse specified under the item number one is the warehouse number one. Lets add this document. Lets browse back and display its journal entry. The debit and credit amounts are calculated by multiplying the quantity of the item in the document by the prices specified in the goods received. You can see that one multiplied by one hundred equals one hundred and this is the amount displayed in the journal entry. Let take a look at the item master data under the inventory data tab page and you can see that the cost price is calculated as one hundred. Lets open the journal entry again. You can see that the stock account recorded in the journal entry is stock one which is linked to warehouse number one as specified in the item master data. You can see that the stock account is debited. Therefore the items inventory valuation increases. You can see the allocation account here. Remember that a this allocation account functions as a temporary alternative to the vendors account which will be cleared only after you create a corresponding A/P invoice or goods return document. Lets copy this goods received PO to an A/P invoice. Lets select the vendor. Click on goods receipt PO and select the goods receipt PO and just create it. Lets add the document. Browse back to create it again and click this link arrow to display its related journal entry. When you base an A/P invoice in a goods received PO, the allocation account is debited. Counter to it is the vendors account which is credited. Note that the allocation account serves as a clearing account here. It is debited in the account in which it was credited in the goods received PO created earlier. Lets take a look at the item. You can see that the cost price is still one hundred since we did not change its receipt price. Now lets add an independent A/P invoice. This is an invoice that is not based on any other document. Select a vendor and now type a price of one hundred and twenty US dollars. Lets add the document. Browse back and display the journal entry. You can see that the debit and credit amounts are now one hundred and twenty and not one hundred. This is since the price form the document is taken and multiplied by the quantity. Note that now the stock account is recorded in the journal entry and not the allocation account. Lets take a look at the item master data. You can see that the cost price of the item is changed to one hundred and ten. This is because the first item received in the stock was received for one hundred dollars and the second item received was for one hundred and twenty dollars. The moving average of the two items with these two prices results in one hundred and ten. Now let us take a look at some release documents. Lets begin with delivery. Select a business partner and assign them. Lets deliver this item with a quantity of one and a price of one hundred. Lets take a look at the items cost price and consider that it is one hundred and ten. Lets add the document and browse back to display its related journal entry. You can see that although the price in the delivery document was one hundred dollars, the journal entry created here reports one hundred and ten both in the debit and credit sides. These are the amounts calculated by multiplying the quantity by each one of the items in the delivery document by their cost price. The cost of goods sold account functions as on offsetting account to the stock account and the stock account is credited. Thus the item inventory valuation is decreased. Now lets base an A/R invoice on this delivery. Again you can see here that the price is one hundred. Lets add the document and browse back to display the journal entry. When you base an A/R invoice on a delivery, no stock posting is created. Thus only a regular journal entry is created in the accounting system. You can see that there are no stock accounts here. Only the customer and the revenues account. Now lets add an independent A/R invoice. Again lets select a customer and an item. Lets add the document and browse back and look at its linked journal entry. This journal entry includes both the deliveries and inventory transaction represented by these two rows and the invoices accounting transaction represented by these two rows. Now lets see an inventory document. Lets ho to inventory and select inventory transaction and then select stock transfer. Lets transfer one unit of this item from warehouse number one to warehouse number two. Lets add the document and get back to see its linked journal entry. If you specify different stock accounts for your different warehouses, the stock transferred transaction will credit the stock transaction to the release warehouse. In this case the warehouse number one. And debit the stock account of the received warehouse. In this case the warehouse number two. The release and the receipt prices are set by the moving average price of the item in the release warehouse. You could see that one hundred and ten is displayed for warehouse number one.
Moving average in the production process: in a production order for a bill of materials item the parent item price will be calculated according to the moving average prices of its child items. You cannot change its price. There are two methods for issuing items in production orders. Additional information is provided in a separate lesson. One method is manual. In this method, you document the parent items receipt and the child items release in two separate steps. Second is the backflush. In this method, the parent items receipt and the child item release are recorded simultaneously. If your company is upgraded from a version before 2004, the old production method also will be available.
Lets take a look at the influence of the production process on the continuous stock system. First take a look at the define of bill materials window. Here you can see the parent product which is going to be received in warehouse number two. The parent product is comprised of this child item with a quantity of two which is going to be released from warehouse number one. Both the parent and child items are defined with moving average as their costing method. The child items cost price is one hundred in warehouse number one. Lets open a production order. Select the parent item .in the production order, the parent items price will be calculated according to the moving average prices of its child items. It is not possible to change this price. There are two methods for issuing items in production order which are manual and the backflush. Additional information is provided in a separate document. Manual: In this method, you document the parent items receipt and the child items release in two separate steps. First lets add this production order in a planned status. Browse back and change the status to release. Update the window, right click the mouse and select the issue components. This action will release the child items from the warehouse number one. Lets add the document. Browse back and take a look at the journal entry. You can see that the stock account at the child release in warehouse is credited and the work in progress account is debited. The credit and debit account amounts are calculated according to the moving average prices of the child item. You can see that the child items moving average price is one hundred in warehouse number one, multiplied by two gives you two hundred. Now lets receive the parent account into the warehouse number two. Select report completion and click on add. Browse back and take a look at the journal entry. You can see that the work in process account is credited and the stock account of warehouse number two is debited. Lets go back to the production order window. If we had selected the issue method as backflush when the production order was completed, the stock account of the parent item warehouse will be debited and the stock account of the child item warehouses would be credited. Again the release and the receipt prices are set by the moving average prices of the child items. However in the backflush method there is no issue for production but the two journal entries shown to you are just created simultaneously . when the issue method is set to manual, there might be a situation where the cost price of the item changes during the production process. For example this items cost price used to be one hundred dollars. An issue component took place , but then before the report completion was added the moving average price of the item was changed to one hundred and ten dollars instead of one hundred dollars. In this case under the summary tab page you can see the following data. The actual components value is two hundred ,however the actual products value is two hundred and twenty. Therefore there is a variance of twenty dollars. This variance would be reported as you close the production order. You can see that the work in process materials and the work in process variance are debited and credited respectively.
Working with negative stock: in a situation in the item quantity when the stock is zero or negative, the creation of the stock receipt document changes the cost price of the item to be entered in that receipt document.
You are now able to describe the continuous stock system, describe the three possible costing methods, initialize the continuous stock system in your computer and also be able to describe the moving average costing method.
Friday, November 11
Business Partners in SAP Business One
After Reading this post, you will be able to outline the three types of business partners that exist in SAP business one. You will also be able to describe how the business partners records are structured, including how to activate and deactivate a partner record.
There are three types of business partners in SAP business one. These are vendors , customers and leads. They are used in the following cases. A vendor master record is used to handle all the purchasing transactions. When the balances are integrated with the general ledger or accounting system, through one or more accounts. A customer master record id used to handle all sales transactions. Customer balances are also integrated to the general ledger through one or more control accounts. A lead can be used to handle sales opportunities, orders and quotations. However they cannot affect the accounting side of the system. If you want to post an invoice against the lead you must first convey them to a customer. It is also important to note that the business partner code must be unique for customers, vendors and leads , as well as general ledger account codes. If you want a customer to also be a vendor, you must create a separate business partner record.
The business partner master record contains of large amount of useful data, ranging from the addresses of the business partner , the currency that they trade in, their account balances, the contacts for the business partner, the sales employee assigned to the partner, and a group against which you can report about the business partner. We will discuss these throughout the topic.
The business partner master record contains the various balances for a customer. These balances are displayed depending upon the currency of the business partner. The balances shown are the account balance, the delivery balance , the order balance and the opportunities. The account balance is a combination of open invoices that have not been paid. Open deliveries list those deliveries that have not yet been invoiced. The order balance list the open orders that have not been delivered. And the opportunities aree opportunities that are not yet been closed or turned into an order. In SAP business one it is possible to create a report from these balances showing the data. This is often a useful overview of the business partners activity. It is also possible to view this report in a graph format.
Lets see a demo of the possible type of business partners as well as checking the balance of the business partners account balance and seeing a breakdown of a balance within a report. In the screen showing the general layout of the master record, there are three different types of business partners in the dropdown list. If we open a business partner, we can see that the field is populated . here we choose a customer from the system. And we see that the business partner type is set to customer. We also notice the currency of the business partner which is set to british pounds. And this system is said to be on the national or local currency . on the right hand side of the screen we can notice the balances that we discussed earlier with graph icons next to the balances.
In SAP business one it is possible to create relationships between business partners of the same type. For example one customer might be the parent of another customer. The parent customer may pay for the invoices raised against its subsidiaries or it might accept invoices raised against the leverage to the subsidiaries. These two types of relationships are possible with SAP business one.
In SAP business one it is also possible to categorize the business partners into groups. These groups can range from the size of the partner, for example the big partner groups, the small partner groups or the very important partners. Or it could be related to the products they sell or purchase such as sports equipment or clothing. Groups can be further broken down by the type of business partner. You can have a customer group and a vendor group. They are an extremely useful way of breaking down of the business partners for reporting and analysis. Let us see how to create a new group in the next demonstration.
In SAP business one there are 64 different properties that you can assign to any individual business partner. These properties can be used in numerous ways. The most common use of the property is to indicate the location of the business partner. The default setting in the business one for the top eight properties is to set a location. However all of these locations can be edited by the user. The locations might range from north to south or from continent to continent. Business partners can be grouped by property for further analysis.
In this demonstration we will learn how to add a new property and a group to a business partner. And then view a source analysis report using the group and property name. we first have to open a business partner data record.
In SAP business one it is possible to assign multiple contact persons for each business partner. A tab is available for this information in the business partner master data. The tab includes general details such as contact numbers and name, as well as remark fields. It is also possible in business one to select a contact as a default contact and have this person as the first port of call on any source or a document.
In SAP business one, there is a possibility of having both the billing for shipping and the delivery addresses . this is important as the company does not always want to ship to the same location as warehouse or store every time. A company may also have multiple offices and depending on the amount of the amount of invoice they may want to bill a different location. Now we shall she how to enter a ship- to address.
In this demonstration we are going to create a new default contact person for a business partner. We will also create a shipping or a delivery address for goods to be sent to. For creating a new contact, we click on the contacts tab. We then select define new and begin to fill the data fields on the right hand side of the screen. We are going to create a source contact and we are going to update the email address, the telephone number. You can see the other settings there. Also important is the remarks field where we can store information and about a particular contact, their interests, their likes and dislikes. We should just finish completing that. Once we have entered all the information we should just click update to update the customers record. To make the contact the default, you will see a button at the bottom of the screen which we can use to set the contact person as the default. When they are the default their name appears in board. To add a ship- to address click on the addresses tab ,and click on the arrow next to ship-to. This then opens up and gives us the option of defining it. You click on this and then begin filling the data on the right hand side of the screen. Let us set us an address in London for example. Then we click update. We once again make this the default address by selecting it and then setting it as default.
There are many situations where a customer may want to block transactions to a particular supplier or customer or business partner. In SAP business one it is possible to set a customer or supplier as active or inactive. Business one gives you the option of placing a partner on hold so that no transactions can be made until it has been unfrozen. It also gives you the option to making it inactive for a set period of time. This could be used for some promotions.
In SAP business one, it is sometimes necessary to deactivate a business partner record. They may be for example having a number of invoices and you do not want to take any more orders until these invoices have been paid. We do this by making the customer inactive or on hold. Here we open the transport master record and we tick the on hold button and update the business partner master record. This shows top transactions being made against trandsports. To check this we open the sales order. Now we select trandsports as our business partner. As we select this on the board, we receive a warning that the customer is frozen. We can overwrite this by selecting yes. We now add an item to the order, the delivery dates and click add. When we confirm the act, we receive the error telling that the customer is frozen. Hence we are unable to make any transactions against this customer because it is on hold. To activate this partner again we untick the on- hold box. In the business partner master record.
You have now completed the topic in business partners in SAP business one. After this session, now you will be able to outline the three types of business partners available, and the transactions that are possible against each of the type. You will also be able to describe how the business partner records are structured ,including the process of making a business partner active.
There are three types of business partners in SAP business one. These are vendors , customers and leads. They are used in the following cases. A vendor master record is used to handle all the purchasing transactions. When the balances are integrated with the general ledger or accounting system, through one or more accounts. A customer master record id used to handle all sales transactions. Customer balances are also integrated to the general ledger through one or more control accounts. A lead can be used to handle sales opportunities, orders and quotations. However they cannot affect the accounting side of the system. If you want to post an invoice against the lead you must first convey them to a customer. It is also important to note that the business partner code must be unique for customers, vendors and leads , as well as general ledger account codes. If you want a customer to also be a vendor, you must create a separate business partner record.
The business partner master record contains of large amount of useful data, ranging from the addresses of the business partner , the currency that they trade in, their account balances, the contacts for the business partner, the sales employee assigned to the partner, and a group against which you can report about the business partner. We will discuss these throughout the topic.
The business partner master record contains the various balances for a customer. These balances are displayed depending upon the currency of the business partner. The balances shown are the account balance, the delivery balance , the order balance and the opportunities. The account balance is a combination of open invoices that have not been paid. Open deliveries list those deliveries that have not yet been invoiced. The order balance list the open orders that have not been delivered. And the opportunities aree opportunities that are not yet been closed or turned into an order. In SAP business one it is possible to create a report from these balances showing the data. This is often a useful overview of the business partners activity. It is also possible to view this report in a graph format.
Lets see a demo of the possible type of business partners as well as checking the balance of the business partners account balance and seeing a breakdown of a balance within a report. In the screen showing the general layout of the master record, there are three different types of business partners in the dropdown list. If we open a business partner, we can see that the field is populated . here we choose a customer from the system. And we see that the business partner type is set to customer. We also notice the currency of the business partner which is set to british pounds. And this system is said to be on the national or local currency . on the right hand side of the screen we can notice the balances that we discussed earlier with graph icons next to the balances.
In SAP business one it is possible to create relationships between business partners of the same type. For example one customer might be the parent of another customer. The parent customer may pay for the invoices raised against its subsidiaries or it might accept invoices raised against the leverage to the subsidiaries. These two types of relationships are possible with SAP business one.
In SAP business one it is also possible to categorize the business partners into groups. These groups can range from the size of the partner, for example the big partner groups, the small partner groups or the very important partners. Or it could be related to the products they sell or purchase such as sports equipment or clothing. Groups can be further broken down by the type of business partner. You can have a customer group and a vendor group. They are an extremely useful way of breaking down of the business partners for reporting and analysis. Let us see how to create a new group in the next demonstration.
In SAP business one there are 64 different properties that you can assign to any individual business partner. These properties can be used in numerous ways. The most common use of the property is to indicate the location of the business partner. The default setting in the business one for the top eight properties is to set a location. However all of these locations can be edited by the user. The locations might range from north to south or from continent to continent. Business partners can be grouped by property for further analysis.
In this demonstration we will learn how to add a new property and a group to a business partner. And then view a source analysis report using the group and property name. we first have to open a business partner data record.
In SAP business one it is possible to assign multiple contact persons for each business partner. A tab is available for this information in the business partner master data. The tab includes general details such as contact numbers and name, as well as remark fields. It is also possible in business one to select a contact as a default contact and have this person as the first port of call on any source or a document.
In SAP business one, there is a possibility of having both the billing for shipping and the delivery addresses . this is important as the company does not always want to ship to the same location as warehouse or store every time. A company may also have multiple offices and depending on the amount of the amount of invoice they may want to bill a different location. Now we shall she how to enter a ship- to address.
In this demonstration we are going to create a new default contact person for a business partner. We will also create a shipping or a delivery address for goods to be sent to. For creating a new contact, we click on the contacts tab. We then select define new and begin to fill the data fields on the right hand side of the screen. We are going to create a source contact and we are going to update the email address, the telephone number. You can see the other settings there. Also important is the remarks field where we can store information and about a particular contact, their interests, their likes and dislikes. We should just finish completing that. Once we have entered all the information we should just click update to update the customers record. To make the contact the default, you will see a button at the bottom of the screen which we can use to set the contact person as the default. When they are the default their name appears in board. To add a ship- to address click on the addresses tab ,and click on the arrow next to ship-to. This then opens up and gives us the option of defining it. You click on this and then begin filling the data on the right hand side of the screen. Let us set us an address in London for example. Then we click update. We once again make this the default address by selecting it and then setting it as default.
There are many situations where a customer may want to block transactions to a particular supplier or customer or business partner. In SAP business one it is possible to set a customer or supplier as active or inactive. Business one gives you the option of placing a partner on hold so that no transactions can be made until it has been unfrozen. It also gives you the option to making it inactive for a set period of time. This could be used for some promotions.
In SAP business one, it is sometimes necessary to deactivate a business partner record. They may be for example having a number of invoices and you do not want to take any more orders until these invoices have been paid. We do this by making the customer inactive or on hold. Here we open the transport master record and we tick the on hold button and update the business partner master record. This shows top transactions being made against trandsports. To check this we open the sales order. Now we select trandsports as our business partner. As we select this on the board, we receive a warning that the customer is frozen. We can overwrite this by selecting yes. We now add an item to the order, the delivery dates and click add. When we confirm the act, we receive the error telling that the customer is frozen. Hence we are unable to make any transactions against this customer because it is on hold. To activate this partner again we untick the on- hold box. In the business partner master record.
You have now completed the topic in business partners in SAP business one. After this session, now you will be able to outline the three types of business partners available, and the transactions that are possible against each of the type. You will also be able to describe how the business partner records are structured ,including the process of making a business partner active.
Tuesday, October 18
SMB Portal and its Functionality
This topics tell you about the SMB portal and its functionality. By the end of this topic you will be able to list out and explain the various user types for the SMB portal. You will also be able to describe how to obtain a user for the SMB portal and access the SMB portal as well as navigating through it.
The SMB portal is the main support platform for all SAP products including SAP business one. It offers a broad range of functionalities to SAP partners and customers alike. These functions inckude product documentation and service information; support communication with SAP where there is an option to create and track problem related messages ; the ability to access the knowledge database and access SAP notes ; online training and downloading capabilities for upgrade and patches.
When an SAP partner has agreed to sign an agreement , SAP manually enters the partners master data. The partner is being given a partner number, installation number and an email domain. After which the partner then specifies a central contact person at their company. SAP then creates a user with the administration authorization for the central contact person. The central contact person has the authorization to create messages, request licenses, search for notes, request and maintain other users within the company, for accessing the SMB portal. They can also book training. The conformation for this authorization is sent to the central contact person by mail. Once the contact person receives this authorization, they can then use the partner number provided by the SAP to access the SMB portal and hold the authorization of an administrator.
There are three core address links used to access the SMB portal. The first link is SMB. This is the main entry address. It will take you to the home page of the SMB portal. In addition to the SMB quick link there is also a user-admin. This is the address to maintain personal information, add and maintain user authorizations . the third quick link is tcs. This address link is used to create a passport so that the entry into the SMB portal can be made more efficiently. Or that this access can only take place in the work station on which it has been set up. To access any of these quick links, a user id and password is required.
When you enter the SMB portal using any of the above address links, SAP will distinguish between three different authorization levels or user types. These are the info user, the support user and the administrator. The info user has the display authorization on the SMB portal only. They can use the SMB portal to get the latest information about SAP business one. In addition to the display authorization, the support user is also authorized to use the support functions on the SMB portal, such as requesting licenses and creating new messages. Finally in addition to the authorizations of a support user, users with an administrators authorization can also request new users and maintain their data, manage authorizations , reset password and maintain email domains. Furthermore all three users can maintain their own personal data, display their own authorizations and change their own password. Now lets see how to log in and navigate in the SMB portal.
Now we will know how to log in and navigate in the SMB portal by this demonstration. In the address field of the browser, we enter www.service.sap.com/smb. immediately a log in box appears. Here we enter our eight digit S user number and the associated password. Then we click ok. Now we are taken in to the home page of SMB portal. In the centre of the page we have featured news items. Below that we have the latest events. To the right of this screen is your opportunity for feedback. You can request new content that can be available, or just feedback on the general usability of the application.and if you wish to subscribe to new letters, you can do that. To maintain passwords go to the my profile. And in the inbox you will receive all of the SAP messages, support and other product related enquiries. On the left we see all one click services. Here we can order SAP, download upgrades and patches, or we could request license keys. If we now go across the tabs on the top, we can get to our solutions button. This gives us a detailed information about all of our products, including installation and upgrade information. If we now go to the tab solution development, we can find information about the APIs. For business one, we can look in the software development kit. And here is the information which comes on the two APIs. On the marketing and sales, we can see that we have a media link for ordering business one. We also can download the latest sales information and also use the opportunity management and the resource tools. Under education we have access to a whole series of online and classroom training material. If you click on the online training material button, we see a link through to the online learning products. Will cover these later in more detail. Under the classroom training link we see a list of all the classroom training. Here we can download the classroom content. We could also go to the training catalogue and book on to a course. One of the most important links is the services and support. Here we can search the notes database , create new messages, and download patches and upgrades. Finally the partnering with SAP will take us through the general partner contracts and information. We also have some country specific links and quick links described at the top of the screen.
You have now completed the topic on the SMB portal. You are now able to list and explain the various user types of SMB portal. You are also able to explain how to get a user for the SMB portal, access the portal and navigate within it.
The SMB portal is the main support platform for all SAP products including SAP business one. It offers a broad range of functionalities to SAP partners and customers alike. These functions inckude product documentation and service information; support communication with SAP where there is an option to create and track problem related messages ; the ability to access the knowledge database and access SAP notes ; online training and downloading capabilities for upgrade and patches.
When an SAP partner has agreed to sign an agreement , SAP manually enters the partners master data. The partner is being given a partner number, installation number and an email domain. After which the partner then specifies a central contact person at their company. SAP then creates a user with the administration authorization for the central contact person. The central contact person has the authorization to create messages, request licenses, search for notes, request and maintain other users within the company, for accessing the SMB portal. They can also book training. The conformation for this authorization is sent to the central contact person by mail. Once the contact person receives this authorization, they can then use the partner number provided by the SAP to access the SMB portal and hold the authorization of an administrator.
There are three core address links used to access the SMB portal. The first link is SMB. This is the main entry address. It will take you to the home page of the SMB portal. In addition to the SMB quick link there is also a user-admin. This is the address to maintain personal information, add and maintain user authorizations . the third quick link is tcs. This address link is used to create a passport so that the entry into the SMB portal can be made more efficiently. Or that this access can only take place in the work station on which it has been set up. To access any of these quick links, a user id and password is required.
When you enter the SMB portal using any of the above address links, SAP will distinguish between three different authorization levels or user types. These are the info user, the support user and the administrator. The info user has the display authorization on the SMB portal only. They can use the SMB portal to get the latest information about SAP business one. In addition to the display authorization, the support user is also authorized to use the support functions on the SMB portal, such as requesting licenses and creating new messages. Finally in addition to the authorizations of a support user, users with an administrators authorization can also request new users and maintain their data, manage authorizations , reset password and maintain email domains. Furthermore all three users can maintain their own personal data, display their own authorizations and change their own password. Now lets see how to log in and navigate in the SMB portal.
Now we will know how to log in and navigate in the SMB portal by this demonstration. In the address field of the browser, we enter www.service.sap.com/smb. immediately a log in box appears. Here we enter our eight digit S user number and the associated password. Then we click ok. Now we are taken in to the home page of SMB portal. In the centre of the page we have featured news items. Below that we have the latest events. To the right of this screen is your opportunity for feedback. You can request new content that can be available, or just feedback on the general usability of the application.and if you wish to subscribe to new letters, you can do that. To maintain passwords go to the my profile. And in the inbox you will receive all of the SAP messages, support and other product related enquiries. On the left we see all one click services. Here we can order SAP, download upgrades and patches, or we could request license keys. If we now go across the tabs on the top, we can get to our solutions button. This gives us a detailed information about all of our products, including installation and upgrade information. If we now go to the tab solution development, we can find information about the APIs. For business one, we can look in the software development kit. And here is the information which comes on the two APIs. On the marketing and sales, we can see that we have a media link for ordering business one. We also can download the latest sales information and also use the opportunity management and the resource tools. Under education we have access to a whole series of online and classroom training material. If you click on the online training material button, we see a link through to the online learning products. Will cover these later in more detail. Under the classroom training link we see a list of all the classroom training. Here we can download the classroom content. We could also go to the training catalogue and book on to a course. One of the most important links is the services and support. Here we can search the notes database , create new messages, and download patches and upgrades. Finally the partnering with SAP will take us through the general partner contracts and information. We also have some country specific links and quick links described at the top of the screen.
You have now completed the topic on the SMB portal. You are now able to list and explain the various user types of SMB portal. You are also able to explain how to get a user for the SMB portal, access the portal and navigate within it.
Navigation in SAP Business One
This Post describes navigation through the SAP business one. At the end of this topic you will be able to log in to an SAP business one company. You will be able to choose how data is displayed throughout the system. You will be able to navigate successfully around the system and you will be able to create user defined short cuts.
In SAP business one there is a possibility of having more than one company running on a server. These companies can have multiple users and each user if given information can have access to each company. To gain access into business one a user must have a user name and password for that company. When in business one, it is possible to view all the companies that are available on the local server. Once you have selected the company it is possible to navigate around the system using such features such as the command centre, the message bar and the menu bar. We would discuss and view them in more detail in the following passages.
To log in to the SAP business one, click the icon on the desktop. After a short while you will be prompted to enter a user name and password.
The SAP business one menu bar is displayed at the top of the screen. The menu bar contains the windows standard menu- file , edit, window and help as well as some generic SAP business one functions. The tool bar is displayed onto the menu bar. The tool bar is a collection of icon buttons that grant to easier access to the commonly used functions such as- add or find. There are 6 main explore functions in business one and these are shown in the tool bar. You can print, send email, send sms, send a fax, export to MS word and excel. The functions represented by the buttons are also available in the menu bar. Active functions are shown in colour and inactive functions are greyed out. You would know that this would change depending on where you are in business one and what documents you have opened. We would now look at how to export some data using the menu bar.
Lets assume we are going to export the data using a tool bar. for example we may open a sales order. We want to export this data to a spreadsheet. To do this we click the export to excel icon in the tool bar. we then follow the screen prompts to save and to enable macros until excel automatically loads.
In SAP business one there are various data input tools available in documents. The four main input tools that you are likely to come across are the selection list, the dropdown list, the navigation arrow and the tabulator key. While choosing the selection list a window appears with a list of possible entries for that field. While selecting the dropdown list a field of possible entries appears. While selecting the navigation arrow you will be taken to another window, of connected information. And by selecting the tabulator key a list of possible entries will be shown. These keys importance is to speed up the process of creating documents in SAP business one. If the user has authorization they can change the field label by simply pressing control+ double- click. This is extremely useful for the system customization and familiarity. These some terms seem unclear and not descriptive enough the user can simply change them.
Let us take an example where the document open is a sales order. To bring in a customer we press the tab button in the customer field. This selects the customer. We can also select the customer by right clicking the selection list box on the right of the customer field. Once we select the customer a navigation arrow appears next to the code. If we click here it takes us to the business partner screen showing us more details about the customer. There is a pool downlist next to the contact on the order screen. If there were more than one contact assigned to this customer, we would say that by clicking on the arrow. We now want to rename a field. To do so we control and double click on the field phone and replace the text. We can also make it bold by selecting the tick box.
To increase the efficiency and navigation around SAP business one, it is possible to create user specific menus and shortcut keys. With user menus you can create your own list of documents that are frequently opened and group them together. With the shortcut keys you can assign the special function keys such as F1 or F2 to certain documents. They are access with considerably decent efficiency. Now let us look at the creation of the user menu and the shortcut keys.
To create the user menu, you must first open up the document that you want in the user menu. Let us take an example where are going to place an A/R invoice into the user menu. Once opened, we go to the user menu bar and select user menu. This opens a new window giving us the option of where to place the document. We want to place A/R invoice in the forms. So we click on the forms and press add. Close the sales order tab, then go to the user menu tab on the command centre. If we click on the forms, we could see the A/R invoice appear underneath. Next we are going to create the shortcut key for the A/R quotation. To do this we go to the menu bar and select tools, and then user shortcuts and then customize. This will open a new window. Lets assume we want the shortcut key to be F3. So we select the pool –down list in F3. We then select the module the document is in- sales A/R, highlighted on the side is sales quotation and press allocate. To test this we now press F3 and the sales quotation shall appear.
In SAP user is given an option as to which language the user would like to view the system in. the user can be using the same company as somebody else and still read the system in a different language. A system has a diverse array of languages to choose from. Another feature in the display settings is the ability to alter the desktop by adding a picture. This could be for example your company logo. There are other values in the display parameters that we would look at later on.
To change any of the display settings of the system, we must first select administration on the command centre , then system initialization and general settings. This opens a window with many tabs and options. Select the display tab. In this tab we have the general display settings of business one ranging from the decimal numbers to the date format. On the left hand side of the screen we have some obvious functionality. The most important one is the language which is located at the top. If you click on the pulldown list you can see the availability of the various languages. If I select german and click on update then yes to confirm, you would notice the system has changed its display parameters and the system language has become german. To change the language back we go through the same procedure. To alter the background display on the desktop, we select the background tab. we can then select browse to search to select a picture. Click on update and now you can see the picture on the desktop.
The function known as drag and relate is used in linking two business objects to create an adhoc report. The possibility exists to compare almost any two objects in SAP business one. For example we could compare the customer code with the invoice objects and get a list of all invoices for a particular customer. By simply dragging a data object onto the field under the drag and relate tab, you can gain an excellent overview of the companies performance in certain areas. We shall now look at how to perform the drag and relate function.
To perform a drag and relate function we must first have some data to drag. Lets assume that We have opened up the stock item master data and selected the product s1001, which is a mountain bike. We now select the drag and relate tab on the command centre. Select sales and then drag the item code across and place it on top of A/R invoice. A report is produced showing every invoice ever created against that product. Now lets say we only want to view open invoices. To achieve this we drag the open field down to the icon at the bottom of the window and then click okay. A report of open invoices is then shown.
You have now completed the topic on SAP business one navigation process. You are able to log in to an SAP business one company and choose how data is displayed throughout the system. You can also navigate around the system using the appropriate tools, icons and create shortcuts for efficiency
In SAP business one there is a possibility of having more than one company running on a server. These companies can have multiple users and each user if given information can have access to each company. To gain access into business one a user must have a user name and password for that company. When in business one, it is possible to view all the companies that are available on the local server. Once you have selected the company it is possible to navigate around the system using such features such as the command centre, the message bar and the menu bar. We would discuss and view them in more detail in the following passages.
To log in to the SAP business one, click the icon on the desktop. After a short while you will be prompted to enter a user name and password.
The SAP business one menu bar is displayed at the top of the screen. The menu bar contains the windows standard menu- file , edit, window and help as well as some generic SAP business one functions. The tool bar is displayed onto the menu bar. The tool bar is a collection of icon buttons that grant to easier access to the commonly used functions such as- add or find. There are 6 main explore functions in business one and these are shown in the tool bar. You can print, send email, send sms, send a fax, export to MS word and excel. The functions represented by the buttons are also available in the menu bar. Active functions are shown in colour and inactive functions are greyed out. You would know that this would change depending on where you are in business one and what documents you have opened. We would now look at how to export some data using the menu bar.
Lets assume we are going to export the data using a tool bar. for example we may open a sales order. We want to export this data to a spreadsheet. To do this we click the export to excel icon in the tool bar. we then follow the screen prompts to save and to enable macros until excel automatically loads.
In SAP business one there are various data input tools available in documents. The four main input tools that you are likely to come across are the selection list, the dropdown list, the navigation arrow and the tabulator key. While choosing the selection list a window appears with a list of possible entries for that field. While selecting the dropdown list a field of possible entries appears. While selecting the navigation arrow you will be taken to another window, of connected information. And by selecting the tabulator key a list of possible entries will be shown. These keys importance is to speed up the process of creating documents in SAP business one. If the user has authorization they can change the field label by simply pressing control+ double- click. This is extremely useful for the system customization and familiarity. These some terms seem unclear and not descriptive enough the user can simply change them.
Let us take an example where the document open is a sales order. To bring in a customer we press the tab button in the customer field. This selects the customer. We can also select the customer by right clicking the selection list box on the right of the customer field. Once we select the customer a navigation arrow appears next to the code. If we click here it takes us to the business partner screen showing us more details about the customer. There is a pool downlist next to the contact on the order screen. If there were more than one contact assigned to this customer, we would say that by clicking on the arrow. We now want to rename a field. To do so we control and double click on the field phone and replace the text. We can also make it bold by selecting the tick box.
To increase the efficiency and navigation around SAP business one, it is possible to create user specific menus and shortcut keys. With user menus you can create your own list of documents that are frequently opened and group them together. With the shortcut keys you can assign the special function keys such as F1 or F2 to certain documents. They are access with considerably decent efficiency. Now let us look at the creation of the user menu and the shortcut keys.
To create the user menu, you must first open up the document that you want in the user menu. Let us take an example where are going to place an A/R invoice into the user menu. Once opened, we go to the user menu bar and select user menu. This opens a new window giving us the option of where to place the document. We want to place A/R invoice in the forms. So we click on the forms and press add. Close the sales order tab, then go to the user menu tab on the command centre. If we click on the forms, we could see the A/R invoice appear underneath. Next we are going to create the shortcut key for the A/R quotation. To do this we go to the menu bar and select tools, and then user shortcuts and then customize. This will open a new window. Lets assume we want the shortcut key to be F3. So we select the pool –down list in F3. We then select the module the document is in- sales A/R, highlighted on the side is sales quotation and press allocate. To test this we now press F3 and the sales quotation shall appear.
In SAP user is given an option as to which language the user would like to view the system in. the user can be using the same company as somebody else and still read the system in a different language. A system has a diverse array of languages to choose from. Another feature in the display settings is the ability to alter the desktop by adding a picture. This could be for example your company logo. There are other values in the display parameters that we would look at later on.
To change any of the display settings of the system, we must first select administration on the command centre , then system initialization and general settings. This opens a window with many tabs and options. Select the display tab. In this tab we have the general display settings of business one ranging from the decimal numbers to the date format. On the left hand side of the screen we have some obvious functionality. The most important one is the language which is located at the top. If you click on the pulldown list you can see the availability of the various languages. If I select german and click on update then yes to confirm, you would notice the system has changed its display parameters and the system language has become german. To change the language back we go through the same procedure. To alter the background display on the desktop, we select the background tab. we can then select browse to search to select a picture. Click on update and now you can see the picture on the desktop.
The function known as drag and relate is used in linking two business objects to create an adhoc report. The possibility exists to compare almost any two objects in SAP business one. For example we could compare the customer code with the invoice objects and get a list of all invoices for a particular customer. By simply dragging a data object onto the field under the drag and relate tab, you can gain an excellent overview of the companies performance in certain areas. We shall now look at how to perform the drag and relate function.
To perform a drag and relate function we must first have some data to drag. Lets assume that We have opened up the stock item master data and selected the product s1001, which is a mountain bike. We now select the drag and relate tab on the command centre. Select sales and then drag the item code across and place it on top of A/R invoice. A report is produced showing every invoice ever created against that product. Now lets say we only want to view open invoices. To achieve this we drag the open field down to the icon at the bottom of the window and then click okay. A report of open invoices is then shown.
You have now completed the topic on SAP business one navigation process. You are able to log in to an SAP business one company and choose how data is displayed throughout the system. You can also navigate around the system using the appropriate tools, icons and create shortcuts for efficiency
Labels:
data input tools,
SAP Business one,
SAP Navigation
Architecture of SAP Business One Application
The business one application is based on a client server architecture. The server runs either on Microsoft SQL server 2000 or IBM DB2 or as a central data repository. Most of the applications relies on the client. This is what is called a fat client. This mean the processing is carried out locally and largely independent of the server performance. SAP offers a software development kit for SAP business one. You can use this kit to add your own functions in visual basic, C, C ++ and java. The SDK runs either on the server or the client depending on its purpose. An integration toolkit provided the interface to convert data from SAP business one to XML based on the SOAP 1.1 protocol. Data can be read from the database using the standard ODBC interface of the sequel server. SAP business one is shaped with the business manager and two services, one for the sending of emails , faxes and sms and one for backing up of the SAP database. SAP business one also provides innovative customization options which means it can be easily tailored, using of tables and formatted searches. Country versions are separately being developed for the specific country specific requirements and many of these are already available. The usual interface is already being translated into major languages and users can switch between the languages they need.
To enhance the SAP business one functionality SAP provides the software development kit. This consists of the following interfaces, the data interface application programming interface and the user interface application programming interface. These provide direct Read and write access to SAP business one related objects Independent of the SAP business one client. The data interface API allows you to integrate to non-SAP systems. In this case the user interface of the external system is not integrated into the business one client. Never the less , the external system still accesses the same database as business one and executes the same application logic. This ensures that the data remains consistent. The data interface API provides a library of component object module. This means that the programming language must support comp. SAP supports visual basic, C and C++ .however you can also use the data interface API for the JAVA applications. The user interface API provides access to the screen elements of the business one client so that you can develop additional functions and integrate them fully into SAP business one’s user interface. Events on the user interface trigger the processing of the screen data for the additional functions.
The SAP add-ons for the SAP business one are add-on applications that SAP have developed by themselves to enhance the functionality of the core SAP business one product. The SAP add-ons with business one are delivered on a separate CD and must be stored separately from the main application. You can choose which add-on you want to use and only install the necessary ones. The SAP add-ons for business one are based on the SDK. Most of the SAP add-ons for business one are relevant globally, but there are also some that are targeted for special countries or special reasons. The SAP add-ons are – data tarasfer workbench, support tools( earlywatch alert, support desk), fixed assets, MS outlook integration, business configuration sets, payement engine, advance layout designer , intercompany transactions and intrastate( europian union).
SAP business one is ideal for small subsidiaries of global companies or trading partners of global companies who run SAP business suite, where the global company may use the SAP business suite and the trading companies or subsidiaries maybe too small for using an SAP business suite installation or client. With the many country versions of the SAP business one , the global company can use it with all smaller subsidiaries around the world. Thus avoiding separate IT decisions and boarding of different IT knowledge in every country . Furthermore the global company can use the integration between SAP business one and the SAP business suite. The level of integration between business one and business suite essentially depends on the requirements of the corporate group. Potential scenarios range form simple data integration to entire business process integration which can even include business partners. To enable consolidated reporting of the data of all the companies , ERP systems, including business one systems. You upload directly the required data into an SAP business information warehouse. To get a better view of the whole data in the operating systems or the subsidiaries using business one ,you can use an SAP enterprise portal which directly links to the subsidiary systems, to enable data exchange between ERP systems including business one and to build business processes across enterprise boundaries, you can use the SAP netweaver infrastructure. These three levels of integration is all compatible with the SAP business suite.
Your best source of information regarding SAP business one is the SMB portal. You need to be an SMB partner or customer or employee of SAP to access the SMB portal. Use the quicklink- smb to go to the SMB portal. From here you can navigate to different areas that provide information about solutions, solutions development , service support, education, partnering with SAP, marketing and sales. The SAP service market place or the SMB portal is discussed in more detail in later articles.
To enhance the SAP business one functionality SAP provides the software development kit. This consists of the following interfaces, the data interface application programming interface and the user interface application programming interface. These provide direct Read and write access to SAP business one related objects Independent of the SAP business one client. The data interface API allows you to integrate to non-SAP systems. In this case the user interface of the external system is not integrated into the business one client. Never the less , the external system still accesses the same database as business one and executes the same application logic. This ensures that the data remains consistent. The data interface API provides a library of component object module. This means that the programming language must support comp. SAP supports visual basic, C and C++ .however you can also use the data interface API for the JAVA applications. The user interface API provides access to the screen elements of the business one client so that you can develop additional functions and integrate them fully into SAP business one’s user interface. Events on the user interface trigger the processing of the screen data for the additional functions.
The SAP add-ons for the SAP business one are add-on applications that SAP have developed by themselves to enhance the functionality of the core SAP business one product. The SAP add-ons with business one are delivered on a separate CD and must be stored separately from the main application. You can choose which add-on you want to use and only install the necessary ones. The SAP add-ons for business one are based on the SDK. Most of the SAP add-ons for business one are relevant globally, but there are also some that are targeted for special countries or special reasons. The SAP add-ons are – data tarasfer workbench, support tools( earlywatch alert, support desk), fixed assets, MS outlook integration, business configuration sets, payement engine, advance layout designer , intercompany transactions and intrastate( europian union).
SAP business one is ideal for small subsidiaries of global companies or trading partners of global companies who run SAP business suite, where the global company may use the SAP business suite and the trading companies or subsidiaries maybe too small for using an SAP business suite installation or client. With the many country versions of the SAP business one , the global company can use it with all smaller subsidiaries around the world. Thus avoiding separate IT decisions and boarding of different IT knowledge in every country . Furthermore the global company can use the integration between SAP business one and the SAP business suite. The level of integration between business one and business suite essentially depends on the requirements of the corporate group. Potential scenarios range form simple data integration to entire business process integration which can even include business partners. To enable consolidated reporting of the data of all the companies , ERP systems, including business one systems. You upload directly the required data into an SAP business information warehouse. To get a better view of the whole data in the operating systems or the subsidiaries using business one ,you can use an SAP enterprise portal which directly links to the subsidiary systems, to enable data exchange between ERP systems including business one and to build business processes across enterprise boundaries, you can use the SAP netweaver infrastructure. These three levels of integration is all compatible with the SAP business suite.
Your best source of information regarding SAP business one is the SMB portal. You need to be an SMB partner or customer or employee of SAP to access the SMB portal. Use the quicklink- smb to go to the SMB portal. From here you can navigate to different areas that provide information about solutions, solutions development , service support, education, partnering with SAP, marketing and sales. The SAP service market place or the SMB portal is discussed in more detail in later articles.
Sunday, October 16
Interview with a SAP Employee
Question : SAP in the comparative market- how has it fared so far and how is going to be in future:
SAP : What is important for us is that we gain share in market in q1. We compare ourselves with our peer group which is Microsoft on a yearly base because we have a different seasonality. Upto now in the last four years we are gaining share against them. So ask me again at the end of the year.
Question : Safe passage program which is recently added to the company and about how many customers you have added :
I think we added roughly 60 again .we have more than 500 now.
Question : How the competitive landscape may have impacted the deals you have not won ?
SAP : Yes its true, as you know we made some adjustment at the end of last year. Some technical adjustments just came in terms of deals. They were not too prominent. Hence we couldn’t close the deals at the end of last year. So I would say what we did in the first quarter is really business people brought in, in the first quarter.
Question : SAP Is known as a large enterprise company. Now you are focusing on the mid market. Now is this an area which you can continue to focus on and if so, what are you committed to spend.
Ya, roughly 10-20 million. It is really important know because if you put this into figures in terms of its operating margin increased and improved. We had an operating margin which was flat, which was established business which was half a percent to one percent.
Question : A1S and planning of ramping up of A1S
SAP : First of all we should know that our established business will continue to grow double digit. So what we try is a new product which will add additional revenue to our profitability. And we do it in a different way because we want this product to be entirely hosted. Once the product is ready we select the customers. We get very good feedback. But its not only about the product, but its also about the operation which has a lot of innovation in it. So I expect we will be ready for volume business in the first quarter of 2008 and then you will see first of all, is the revenue is coming slower in. that’s known because the subscription. But over a time the revenue will increase more and more. And I expect that our margin in 2010 will be higher than the margin we have earned today as an established business.
Question : Are you concerned about the reduction in spending that some experts are suggesting in the agent markets:
SAP : Im not worried. We are doing good business in china and india and japan. I have so far honestly no indications , india particularly the large enterprises which are traditionally our clients. From my point what I see is im confident on this agent market.
Question : What about the business options in the US, are you still seeing growth in the future:
SAP : The united states business was very strong ,which is more than 20% which I see is really strong. We are improving in our position in the US. You know that’s since many quarters we are the number one in the US and we continue to gain share there.
Question : ORACLE law suite filed against one of your subsidiaries tomorrow now:
Tomorrow now has a very precise business model. This business model is known, it follows the guidelines and rules and policies. So I see they are claims which I don’t understand . our lawyers are behind it. We will officially answer in the next weeks.
SAP : What is important for us is that we gain share in market in q1. We compare ourselves with our peer group which is Microsoft on a yearly base because we have a different seasonality. Upto now in the last four years we are gaining share against them. So ask me again at the end of the year.
Question : Safe passage program which is recently added to the company and about how many customers you have added :
I think we added roughly 60 again .we have more than 500 now.
Question : How the competitive landscape may have impacted the deals you have not won ?
SAP : Yes its true, as you know we made some adjustment at the end of last year. Some technical adjustments just came in terms of deals. They were not too prominent. Hence we couldn’t close the deals at the end of last year. So I would say what we did in the first quarter is really business people brought in, in the first quarter.
Question : SAP Is known as a large enterprise company. Now you are focusing on the mid market. Now is this an area which you can continue to focus on and if so, what are you committed to spend.
Ya, roughly 10-20 million. It is really important know because if you put this into figures in terms of its operating margin increased and improved. We had an operating margin which was flat, which was established business which was half a percent to one percent.
Question : A1S and planning of ramping up of A1S
SAP : First of all we should know that our established business will continue to grow double digit. So what we try is a new product which will add additional revenue to our profitability. And we do it in a different way because we want this product to be entirely hosted. Once the product is ready we select the customers. We get very good feedback. But its not only about the product, but its also about the operation which has a lot of innovation in it. So I expect we will be ready for volume business in the first quarter of 2008 and then you will see first of all, is the revenue is coming slower in. that’s known because the subscription. But over a time the revenue will increase more and more. And I expect that our margin in 2010 will be higher than the margin we have earned today as an established business.
Question : Are you concerned about the reduction in spending that some experts are suggesting in the agent markets:
SAP : Im not worried. We are doing good business in china and india and japan. I have so far honestly no indications , india particularly the large enterprises which are traditionally our clients. From my point what I see is im confident on this agent market.
Question : What about the business options in the US, are you still seeing growth in the future:
SAP : The united states business was very strong ,which is more than 20% which I see is really strong. We are improving in our position in the US. You know that’s since many quarters we are the number one in the US and we continue to gain share there.
Question : ORACLE law suite filed against one of your subsidiaries tomorrow now:
Tomorrow now has a very precise business model. This business model is known, it follows the guidelines and rules and policies. So I see they are claims which I don’t understand . our lawyers are behind it. We will officially answer in the next weeks.
Labels:
SAP Business one,
sap interview,
sap professional
Thursday, October 13
SAP and Their Produstcs - SMB Customer - SAP Business One
As you finish reading this article, you will be able to describe SAP and their products particularly the SMB customers. You will be able to explain SAP’s business one product functionality and the architecture. And you will be able to list the add-on components and integration with other SAP products. The market in smaller or mid size businesses or the SMB is very fragmented. This means its almost impossible to speak of one uniform SMB market. The companies that make up the SMB market differ considerably in terms of se ize, complexity of IT systems, the industry and their locations. SAP divides the SMB market as described in the following paragraph
Small companies that don’t prepare balance sheet generally don’t have specific needs when it comes to business softwares. In most cases they use MS office applications. Advanced SMBs on the other hand need to be able to model and control the business processes using a software system. SAP has developed SAP business one specifically for those customers. Since the system that is easy to implement their broad range of business functionality. SAP has developed the ‘my SAP all-in-one solutions’ for these companies. Large enterprises represent SAPs traditional customers and many have already used the ‘my SAP business suite’. Lets take a look at these application in more detail.
SAP has a solution for companies of any size. ‘my SAP business suite’ offers a comprehensive family of business solutions, providing a full range of functionalities for all business processes. ‘my SAP all-in -one’ gives the benefits of services to small and mid size business or sophisticated SMBs in a package specially tailored to their needs. ‘my SAP all-in-one solutions’ as designed by SAP planners as pre-considered and industry specific system based on a simplified landscape with low maintenance cost. ‘SAP business one’ contains all the functionalities required by the small companies who want SMBs. It offers a broad range of innovative functions at minimum maintenance and operating costs.
The SAP business one application has been designed as an integrated business system with a powerful customer relationship management capability, targeted at the small to medium business. With one central database , the user can access all transactions, activities and documents relating to a specific customer, supplier or even a product. Business one supports standard core financial functions such as journal entry and bank reconciliation. It also includes management functions like logistics, and from sales to purchases. The application includes functionality to managing entry levels, create production items and maintain ongoing services support relationship with the customers. In addition to the functionality the system provides unique ‘drag and relate’ reporting for creating ad-hoc reports and in integrating contact and activity management system finally the workflow management through alerts and approval procedures is very important to really control their business. I shall write about the Architecture of the business one application in My next post.
Small companies that don’t prepare balance sheet generally don’t have specific needs when it comes to business softwares. In most cases they use MS office applications. Advanced SMBs on the other hand need to be able to model and control the business processes using a software system. SAP has developed SAP business one specifically for those customers. Since the system that is easy to implement their broad range of business functionality. SAP has developed the ‘my SAP all-in-one solutions’ for these companies. Large enterprises represent SAPs traditional customers and many have already used the ‘my SAP business suite’. Lets take a look at these application in more detail.
SAP has a solution for companies of any size. ‘my SAP business suite’ offers a comprehensive family of business solutions, providing a full range of functionalities for all business processes. ‘my SAP all-in -one’ gives the benefits of services to small and mid size business or sophisticated SMBs in a package specially tailored to their needs. ‘my SAP all-in-one solutions’ as designed by SAP planners as pre-considered and industry specific system based on a simplified landscape with low maintenance cost. ‘SAP business one’ contains all the functionalities required by the small companies who want SMBs. It offers a broad range of innovative functions at minimum maintenance and operating costs.
The SAP business one application has been designed as an integrated business system with a powerful customer relationship management capability, targeted at the small to medium business. With one central database , the user can access all transactions, activities and documents relating to a specific customer, supplier or even a product. Business one supports standard core financial functions such as journal entry and bank reconciliation. It also includes management functions like logistics, and from sales to purchases. The application includes functionality to managing entry levels, create production items and maintain ongoing services support relationship with the customers. In addition to the functionality the system provides unique ‘drag and relate’ reporting for creating ad-hoc reports and in integrating contact and activity management system finally the workflow management through alerts and approval procedures is very important to really control their business. I shall write about the Architecture of the business one application in My next post.
Labels:
Architechture of the business one application,
SAP Business one,
SAP Products,
Small and Midsize Business
Subscribe to:
Posts (Atom)