What is SAP Business One ??

What is SAP business One? If you look at to SAP Official website (www.sap.com), The SAP Business One application integrates all core business functions across your entire company – including financials, sales, customer relationship management, inventory, and operations. Unlike many other small business solutions on the market today, SAP Business One is a single application, eliminating the need for separate installations and complex integration of multiple modules.  if you search on Wikipedia.org, SAP Business One is an integrated enterprise resource planning (ERP) software that targets business software requirements of small and medium sized enterprises (SMEs) from SAP AG based at Walldorf, Germany. 

My version as nubie, SAP Business One is an application that integrates all of business functions so the information moves in real time. 

SAP Business One contains 15 core modules:

• Administration Module, where configuration is performed
• Financials Module, where various accounting and financial activities are conducted
• Sales Opportunities Module, where existing customers and potential accounts are structured tracking
• Sales Module, where orders are entered, shipped and invoiced
• Purchasing Module, where purchase orders are issued and goods received into inventory
• Business Partners Module, where Business Partners (customers, vendors, and leads) are contacted and maintained
• Banking Module, where cash is received and paid out
• Inventory Module, where Inventory is valued and managed
• Production Module, where bill of materials is defined and manufacturing is tracked
• MRP Module, where purchase and production planning takes place
• Service Module, where after-service products are managed
• Human Resources Module, where employee information is kept
• Reports Module, where system-default and user-defined reports are generated (as on-screen tables, printouts or Excel files: Print Layout Designer, Advanced Layout Designer (To be Discontinued in 2009 due to purchase of Business Objects), XL Reporter and Crystal Reports 2008 Basic(One Free License per customer))
• E-commerce, allowing customers to buy and sell online to consumers or other businesses.
• WebCRM. Allows employees to manage customer support cases, salespeople to manage prospects, and customers to submit cases all via a web browser client.

source: wikipedia.ord and SAP.com

How to setup Witholding Tax

How to Set up Vendor Withholding Tax

SAP Business One lets you to manage what kind of tax that wants you use. So you can add tax group based on your company needs and set to your vendors. Below I will share step by step to add tax group and attached to vendor.

Adding Withholding Tax Group

Go to Administration à Setup à Financial à Tax à Withholding Tax

To add new Withholding Tax group, write on table based on your company needs then click OK to Saved into database.

Table name of tax Group: OWHT

Setup Tax to Vendor

Go to Business Partner à Business Partner Master Data

Click on Accounting Tab à Tax Tab

Give mark on check box Subject to Withholding Tax

And to setup what kind tax that allowed for vendor just click button “…” next to wTax Code Allowed.

Listing tax group will appear and you just select tax group that allowed to selected vendor

Click OK to saved setup tax of vendor into database

Click Update to saved change Business partner master data into database

Table name of Business Partner: OCRD

How to hide unnecessary column in SAP B1

Yes, of course we can set by own what information that we want to show.

For example, when you on screen A/P Invoice, you want to hide discount column, coz currently your company not have discount rules.

Here are the steps:

1. Make sure you already on A/P invoice Screen
2. Right click On grid/table
3. Popup Menu will show and click on form setting
4. Click Table format and find discount title. After found, just delete mark in visible column
5. Click OK then you will see discount column already hide.

To restore or show again, just follow the steps and make sure you already mark visibility of discount column.

How to Create A/P Invoice SAP B1 using SDK

What is an A/P Invoice?

A/P Invoice is abbreviations from Account Payable Invoice. Its account or the bill must be paid to vendor based on the goods we buy. Many vendor allowing to pay after product or service already been received.

To generate document A/P Invoice in SAP B1 is using oPurchaseInvoice object.

Here is the code:

Dim oAPInvoice As sapbobscom.Documents

Set oAPInvoice = oCompany.GetBusinessObject(sapbobscom.BoObjectTypes.oPurchaseInvoices)

With oAPInvoice

‘Header area

.CardCode = your vendor code

.NumAtCard = your reference no

.DocDate = your posting date

.TaxDate = your document date

.DocType = sapbobscom.BoDocumentTypes.dDocument_Items

.Comments = your remarks

‘Detail area

.Lines.SetCurrentLine (detail rows)

.Lines.itemCode = your item code

.Lines.WarehouseCode = your warehouse code

.Lines.Quantity = your qty

.Lines.VatGroup = "ZI"

.Lines.UnitPrice = F_Price

.Lines.LineTotal = F_Amount

LngErr = .Add()

If LngErr <> 0 Then

oCompany.GetLastError(LngErr, sErrMsg)

Msgbox SErrMsg

Else

MsgBox “Create A/P Invoice Data Success”

End with

Note: If your vendor use Tax amount, you can setup first on Business partner master - allowed tax

How to know a field name in SAP B1

SAP B1 developer absolutely must to know what a fieldname that used to insert data or used as parameter.

I will share this beginner function below.

Example, you active screen is Item Master Data and you want to know fields name of Purchase Item classification.

Below are the steps:

1. Move your mouse to Menu Bar View and give mark on System information
2. Bring your cursor on text “Purchase Item” and watch your bottom bar, you will see a description of that field, table name and field name

Result:

First row: Purchase Item [Yes/No]

Second row: Y[Form =xx Item =xx Pane =0 Variable = x OITM,prchseItem]

Explanation:

Table name: OITM

Field name: prchseItem

It is so easy and enjoys. J