Friday, November 20, 2009

USING THE AR INVOICE IN SAP BUSINESS ONE

I will be posting some job aids designed by me on some scenarios in SAP Business One, I want to start with the AR Invoice.

The AR invoice is the primary and mandatory sales document in the sales process. AR invoice proves that sales has been made to a customer, but not prove that money as been received from the customer. Until incoming payment is done for the customer, the invoice remains open.
The AR invoice is reversed or cancelled with the AR credit memo.

There are two scenarios , when the AR invoice is based on existing document (eg delivery, or sales order) or when it has no base document


Scenario 1: Invoice has no base document




Monday, September 8, 2008

SAP Business One Certification Questions (FINANCIALS)

It is my desire to assit potential SAP Business One candidates on preparation for the certifications exam. I will post insightful questions on SAP Business One on this blog at regular intervals. I will start with the introductory chapters in the TB1100 (financials) manual. Some of the questions have more than one answers. The answers are at the end of the question
Your opinions and suggestions or inquires about SAP BUsiness One are welcomed.
1.There are 3 types of balance sheets accounts, which is not among the balance sheets a/c
a. Assets a/c
b. Liability a/c
c. Revenue a/c
d. Equity a/c

2. At the end of the fiscal year, the balances of asset a/c will be displayed on the active side, while liability will be on the passive side of the balance sheet….True or False

3. There are 2 types of income statement a/c, they are
a. Revenue and capital a/c
b. contingency and capital a/c
c. assets and liability a/c
d. Revenue and expense a/c

4. At the end of fiscal year balances of the revenue a/c will be subtracted from the balances of the expense account to get the profit or loss
.…True or False

5. In the Chart of accounts (COA), which level consist of several a/c groups for accounts of different types
a. Level 1
b. Level 2
d. Level 5
e. all of the above

6. How many levels are there in the chart of accounts
a. 7
b. 5
c. 4
d. 3

7. Level 2-4 consist of active or titles accounts…True or False



8. Which level contains active accounts only
a. Level 1
b. Level 2
d. Level 5
e. all of the above

9. The system displays the group cabinets a/c, i.e. Level 1 in
a. black with grey background
b. blue
c. black with blue background
d. blue with black background

10. The system displays level 2-4 in
a. black with grey background
b. blue
c. black with blue background
d. blue with black background

11. The system displays level 5 in
a. black
b. blue
c. green
d. grey

12. Accounts that you have entered in G/L a/c determination (primary a/c) are displayed in
a. black with grey background
b. blue
c. green
d. grey

13. If you wish to create your own chart of account instead of using the system you select User Defined in the Basic Initialization tab
….True or False

14. A control a/c links business partner to the general ledger…True or False


15. The system displays the total account balance in business partner record. The line item displays
a. debit balance in red and credit in black with parentheses
b. debit balance in black and credit in green with parentheses
c. debit balance in blue and credit in green with parenthesesd. debit balance in black and credit in green with parentheses
ANSWERS
1. REVENUE A/C 2. TRUE 3. D 4. TRUE 5. A, LEVEL 1
6. B, 5 LEVELS 7. TRUE 8. D, LEVEL 5 9. C, BLACK WITH BLUE 10. B, BLUE 11. A, BLACK 12. C, GREEN 13. TRUE 14. TRUE 15. B

MY CHALLENGES OF SAP BUSINESS ONE CERTIFICATION

In retrospect to my failing the SAP Business One Solution Consultant Certification examination C_TB1200_05, I have decided to write about the challenges experienced and what I suspect where responsible for my failing the certification exam on my first attempt. I will list them under these subtitles
- Structure of SAP Business One certification questions
- Types of Multiple Choice questions
- Inadequate SAP Business One Implementation or support experience

Structure of SAP Business One certification questions: Prior to writing
the certification exam, Like any candidate I was curious about the structure of exam and therefore did my research on what to expect from the examiners. I went to the official site of SAP Business and got the usual information about the number of question which is 80 the duration of the exam 180minutes, and various area of concentrations in greater than or less than format of the different modules to be tested.
For instance Customization 11-20% Human resources <10%
Master data <10% Designing print layout <10%
Accounting >20% Logistics >20%
The information provided is true, but in more specific terms, out of the 80 questions the accounting and logistics module are the bulk of the questions.
Customization 9 questions Human resources 1questions
Master data 5 questions Designing print layout 4questions
Accounting 25questions Logistics 25questions
This initially came as a surprise to me, despite my research. Scoring low percentages in either accounting or logistics will lead to failure while getting a zero percentage in human resources or designer print layout can still guarantee success in the examination. Therefore this will aid your area of concentration during preparation for the certification. Note this information is subject to change by the examiners.

Types of Multiple Choice questions: There are 3 types of multi choice questions in the C_TB1200_05, which you will be introduced to at the beginning of the certification and they carry varying marks. I will call them Simple, Medium and Hard.
The Simple questions are the ones only one answer is right from the available options .i.e. you are only required to select one answer.
For example (Simple questions):
In SAP Business One, payment refund is based on?

a) Due date
b) Payment Means
c) Documents
d) Due date
You just select the correct answer from the available option.
The Medium questions are just slight variation from the Hard questions, there is more than one correct answer from the available option.
For example (Medium questions):
Document Generation Wizard supports the following row types?
a) Subtotal
b) Gross total
c) Alternative
d) Text
In this option, more than one answer is correct; they could be two or three correct answers in the available option.

In the Hard questions, you have to select True or False in each of the available option. Let’s use the Medium question
Example (Hard questions):
Document Generation Wizard supports the following row types?
a) True Subtotal
False
b) True Gross total
False
c) True Alternative
False d) True Text False
In these questions you have to give an opinion in each of the options. This I found most difficult especially if the options are in form of statements, you have to verify each by selecting true or false.



Inadequate SAP Business One Implementation or support experience.
Working in an SAP environment, specifically business One will be an additional advantage for any candidate that wants to write the certification.
Some topics such as XL reporter or Designing the print layout, can only be better understood if you have worked with it.
A background knowledge of the rudiments of accounting will also be helpful, and
the SQL database comes handy in the TB1200 module, and general implementation of SAP Business One

Copyright warning
This article belongs to www.lanraytalks.com (coming soon)
and cannot be shared in part or full, without the knowledge of the author

Lanre Awojoodu works at Hammond financial services, Lagos as a software consultant.
He is a certified SAP Business One solution consultant and instructor