Comission car return in SAP DBM Russia

Hello All! Hopes today is a good day again for you! Today I would like to tolk to you about my last activities in SAP regarding Comission vehicle and how we can return or sell it to customer. But before we should take it from him. So it it such process, when we take from customer vehicle on our stock, without paying  him money for this vehicle until it will be sold. Only after this we will pay him money for vehicle and take from him some sommission fees, that we done all those activities on salling and advetising and storage his vehicle on our stock ..etc. Here represented a local design made for russia and very popular here.

So look. we create normal used vehicle in SAP DBM, but in Vehicle prices tab we should make a tick that this vehicle comission .This tick will influence on our account determanation, so it is very important for us. Then we should input all the prices for vehicle, both purchase and sales price should be equal, because we don't have a MARGIN from this vehicle, we just sell it on customer price.

Look at picture at the left. It is our vehicle prices tab.

So after this we can do all the activities to purchase vehicle.They will be the same as purchase new vehicle, you can see in my messages earlier. But we must do 2 activities only:-). Creta purchase order on Storage location - Comission stock and Goods reciept, we can't do activity cretae incoming invoice, due to we will pay customer when we will sell this vehicle. 

So in the day when Slaes order will be created we can do activitie create incoming invoice to sell vehicle.

Then complite all the requried fields in Order and press Save, then press Create billing and Goods movement.

And in this case we should create debit memo for taking comission from customer.

In case we sell the vehicle during a long period of time, but still can't do it and customer desided to take vehicle back, we should create return order. BUT it will looks the same like sales order in  our design, only Flag Comission car return should be YES. In this case all accounting data will change to make return.

Sales order header will lokks like on picture left. 

After Sales header complited you should press Create billing and create goods movement. Then go to FI document and check postings. See the picture below.

Debit memo will have also such flug in Header. You should choose Yes.  And input the comission value with VAT.

Then go to items tab and choose "Comission sale", input 1 job and amount of comission without VAT. Double input of VAT influeced SAP rounding system, because russian cents are still important in handrieds after point , and here always SAP makes wrong rounding. Look item tab in picture below. 

After this you should billing this order and we can look on Fi postings.

So that is all for today! Hopes, you were happy to read this postings. Sayy to all "Have a good day! Good luck!"

Today is a good day!

How say my Manager at the mornings: "Today is a good  day!" Yes! it is really true, because io want to givwe you a link for SAP DBM 7.00 manual.

Here it is: SAP DBM 7.00

Look!It is really good link for begginers and "old gyes in DBM"!

How sales in SAP DBM looks in FI.

Hello All! Do you remember what we do before? ...O yes of course we just purchased for you very good new Ferrari! Oh. I think it was a very good deal! And you?

Well by the way what happends in that time in background? I mean what happends in FI whicle we so easy press create billing and goods movement and than get new keys from vehicle?

Well lets start. we will return to our DBM vehicle with  /DBM/vsearch transaction. Then press order and we will see line of our order. Press twice and go in.

Then press Goto - Document Flow.  On the picture in the best way you will see picture like below. 

Press Accounting document and you will enter FB03 transaction. You will plus on vehicle amount to Trade receivables(221100) so customer dept appeared and mines from Base Vehicle Revenue(610000) and Tax account(431010).  THis happends after you create billing.

what do you think happend after Goods movement? Yes..it should be debit from Stock account. Lets click the button Goods movement and look into Document Flow. We can see new line in reservation document - Goods Movement.

If you go in you will see standart MIGO transaction. If you press FI doccument button and choose Accounting documents. You will see that + on Vehichle Stock(213100 rus 41010100 Stock account) amount and - from Vehicle Base account( 710000 rus 90020101 Vehicle base cost). 

How to sell vehicle in SAP DBM.

So before we discussed how to purchase vehicle on stock. It is easy now just to sell this vehicle. Lets' go in by transaction /DBM/VSEARCH/  and type in internal number. O! We still don't have a vin number. What is the vehicle without VIN number? Let do it.

Go to Actions Change VIN in vehicle record and complete vin number, press Save. Look! It is very easy:-)

Now lets try to sell this vehicle. Of course first of all you should find a customer...No no sales manager should fined a real customer and create customer record in a system!You should find just customer record and assign it to this vehicle to notice that this vehicle is not for selling now it is resevred by those customer.

Again go to vehicle Action , choose Assign Customer, search for customer record, input Sales organisation and Division - New vehicle. You should customize it before you will do it:-) This Sales org. and Division will appeare on General data screen of vehicle record.

Then you should determine Sector. It is important in future to dermine profit center. Choose sector New vehicle, it depends on you customization settings.

Then you could start to Sell vehicle! Yahoo! Ok...relax and deep brithing....let's start.

Press the button Order in vehicle record and see. At the left some types of orders described. It is also depends on you customization settings. Well, which order do we need? No..no..not debit or credit memo....Somebody else?...Or right we should shoose Sales Order. In our exmple it is coded ZV01!  Press twice!

And what you can see? yes..it is normal Sales order. But it could be reached by transaction /DBM/order01 - to create sales order. Well here you can see Header with all the usuall data. You should complete date of postings, date of  invoice and Sales office and cust.Adviser(responsible person for this sale or sales executive). After this just go to Items tab and check if it is all correct. We will not discuss all the fields of SDBM ales Order like they are the same to Standart Sales Order. Press save to check all the date and Create invoice button will appeared.

Then press create billing for Creating posting to FI and print Invoice. Billing document will go to printer or you can print it using Print button.How mention something unusuall for standart Sales process???....Nobody?...Ok..what is always first Delivery documents or billing? Yes...in Standart SAP delivery process always prelimary, only then billing. In SAP BDM it could other way. 

Only after correct billing, when it is planned with customer we make in delivery on preventionalyy negotiated date. At the date of delivery we press the button Goods movement and print out all deliveris notes and other handover pack to issue it to the customer.

And that is all!!! Yahoo!!! NOw you can take your new just byed RED FERRARI and go....!!!

How consigment process look thought SAP FI?

Two post below I described how to make a consignment process. Now will look what happend in FI background.

First action Create consignement purchase order and Create consigment goods reciept  or Create consigment vehicle.  To check FI postings you should go to vehicle record to DBM vehicle history tab, where all documents linked. You can see normal Z* Vehicle Purchase order created vie ME23N transaction. There you can see all the Organization data you inpunt in action Create consigment purchase order. 

Then in history you can find action Create consigment goods reciept. If you go in, you will find normal goods reciept vie MIGO transaction.  In Head data оn Genaral overwiev screen you will find all the dates you input on goods reciept(date of document and date of postings). On Vendor screen you will see vendor you input in action. Also on items line you will fine you vehicle description with Quantity 1. On tab where you will find plant recieved goods and storage location.

On Purchase order data you can find Purchase order number and come in to look. At the Batch tab you will see internal vehicle number instead of standart Batch number.

If you want to see FI document you should go to Doc.Info tab in Header tab and press FI documents. You will enter into standart FB03 transaction, where you can see FI postings. Vehicle value where added to consigment stock account 21* and  mines on 41* reposting account ( In Russian accounting 15* account).

Action New vehicle phisical doesn't form any FI postings. It is only set up Location and Keys number.

Action Create consignment stock transfer will lead you to standart MIGO goods movement transaction. In Detail data , tab transfer posting you can see that vehicle was moved from Consigmend stock to New vehicle stock. If you go to Header Doc.info tab and press FI documents you can see  FB03 transaction with FI postings. Consigment stock account closed (mines from 213210 account and plus re-posting account 411150 = russian 15* account) and vehicle stock value where added to New vehicle stock account (213110) and mines re-posting account 411100 (russian 15*).  

And the most important activity - Create incoming invoice. If you go in you will get MIR4 SAP standart transaction. On the Header Basic data you can see all the detail you inputed in action: posting and document date, reference, amount, tax amount and tax code. Press on Folow-on document and you will see FI postings via Sap standert transsaction FB03. We have mines from Vendor account -Trade paybels (411000) and plus on re-posting account 411100 with tax account 431020.

Consignment process in SAP DBM in other way

In previous post I told how to make consignment process in SAP DBM. There are the other way to do this in case whether the business wants a PO to be raised first and then GR when the vehicle is consigned.

In that case instead action New vehicle consigment, we should do Create consigment purchase order in vehicle record in SAP DBM. When we just make an order for vehicle.  Where we input planned date of delivery.

Once vehicle arrived on site we could create Create Consignment Goods Receipt in vehicle record in SAP DBM. On this screen we should complete date of document = date of consigment. In Audi it is day of vehicle delivery on stock. So it should be current day. And the same like Posting date.

Then you continue with action described below in vehicle record in SAP DBM:

New Vehicle Physical

Create Consignment New Stock transfer

Create/Print incoming invoice

Consigment process in dealer site Audi

Today I have task to make a gap analysis and compare what we have in SAP DBM and in business about consignment process. So will go workshop through all consignment process step.

Consignment process is when OEM (manufacturer or importer) sell as vehicles and allow not to pay for it during some period. Sometimes for this day we have a small percentage, sometimes not. All this described in consignment or dealer contract.

In Audi  dealer should pay some money for every day  since that moment vehicle arrived on site. This % grows up every 30 days till 90 days. You must purchase vehicle before 90 days will off.

So Logistic person make stock order in OEM system for vehicle. When vehicle is produces, custom cleared and ready to be delivered to Dealer, OEM send via e-mail consignment conditions, where describe %.

At the day of arriving vehicle on stock, counting of consignment days starts. Logistic person should input this date into OEM system and should make action "New Vehicle Consignment" in SAP DBM, where she or he should input Delivery Date, Date of consignment started and Posting date(current). In best case all this date should be current date.  Vehicle record in SAP DBM will have Primary status zp27 Vehicle Received in Consignment stock .

Next activity in SAP DBM Logistic person should do is New Vehicle Physical. It means she should complete Storage location for this vehicle.  There she or he need to input date of arrival and Storage location.  Date of arrival should be current day and in Audi we have only one storage location.

In Russian market this vehicle will be like "Out of accounting balance".

Once customer wants to buy this vehicle or days of consignment goes to end, or base on management design, account chief decided to purchase vehicle from OEM.

For this Account person, who is responsible for vehicle accounting, should make payment to OEM in before 12 am that money could come to account of OEM in the same day.  Date of this day will be invoice date of OEM. So account could make an action Create consignment stock transfer in SAP DBM to move vehicle from "Out of accounting balance" to Stock Account.  Here she or he should input stock - receiver and date of invoice = date of payment and should be equal current day.  And posting date is current date. 

Account department on this day doesn't have any documents from OEM(like incoming invoice and delivery note). OEM sends them twice a month, when a big pack of document formed.

So account person can't input number of delivery note or billing number, they can do it later through standard SAP function vf03.

After this, when incoming invoice will arrive we could make an action Create/Print incoming invoice in SAP DBM, where we should input amount (the same like on invoice) and number of incoming invoice. In case  we urgently need to sell this vehicle, we could make this action before documents will be delivered, but without numbers of invoice. Numbers we will maintain later.

On this consigment process should be completed. If you have a question about it, you can leave you comments here or contact me via e-mail in my profile.

Also more information you could get in books about SAP:SAP's books
on Amozon

So, now I am employer of Inchcape company. For this I have got a long rtip starting from moving to Pskov region, were I took year off for my personal life and be in touch with nature. I was progressing in Sales and was a Sales manager for some projects. I train a lot of people to sell and promote their products. Then I was married and moved to St.Petersburg, where I continue like a Sales Manager for IT company. THis helps me to go throught Worlds Economic crisis. Only in 2009 I join one of the fierst unfrozen SAP project like a Trainier for Sales and SD. But then  my responsobilities were expanded to SAP consultant. THis projects give me a lot of opportunities to release my skills and talants. I deliver trainings in Sales in SD, I was trained, I took part in design of marketing materials with my painting and design skills, I met a lot of good friend, and most of them come to Russian all over the world. I visited for bussines trip UK and can wolk on London streets and run at the mornings in Hyde park!!! So here I am now and we continue to develop and make better or SAP DBM, showroom system. In next messages I will describe some simple task I had and hove I solve them...Hopes it will be helpfull for all DBM starters.

So at 17 my University ears started! It was really greate. First two yeares I was impressed students life! For me it was easy lessons : programming, Mathematical analisys, high mathematic, because i already was good prepared in school for it. So I have  o lot of time for theater,where i took part like an actor and a lot of other students activities. I have got a lot of organization skills and etc. All my marks always was excellent. At the third year of university I some gyes from SurgutGazprom comes to us and said: "We started SAP implementation project.. We need good specialist in it. We will exam you and then pay for you study and then will offer you job may be.!!!" Ok great, I thought. I and 10 students of my ages took part in this long studing program. We were studied to be SAP consultant, we study all from consultan image to smart network systems. And we have got payble practice in Surgut gazprom. Every summer! There I have got my first practice of SAP SD. I work close to two developers and wrote instruction for users and made testing. It was interesting because it was real productive life conjugate with oil sale. That is really impressive and every man had big responsobility on this project. Next year I have got practice in SAP HR department. My friend was my Lead! It was great and it happend by chance..but who beilive in chance? There I started get knowledges about SAP HR. thank you very much tp my friend who help me;-)
At the end of University that gye fro SurgutGazprom forget about as and didn't offer to work. Of course this situation wasn't trash me. I took all my document and wrote a letter to lead of IT department ..I waited answer.But no answer came to me...one week, one month...I found job at city Administration to maintance Oracle DB...but it was just a small island to have a rest in way to SAP and Surgut Gazprom.
One day I was fliyng to Moscow sity. I set and found that man in next place looked at PC and words "SAP" at his presentation were founded by my eyes. "Yes!I can't loose this chance.I should ask some documentation!" I thought at that time. I know if you want something...The Universe will help you and send you an opportunity, you just need to take it. I said to that man : "Hello! I study SAP. I saw you have some information about it?Could you please give it to me?" He was wonder and ask for my flash. I said in root you can find my CV. He copied it to his PC. ...read and then when we landed he said.
"I WILL CALL YOU SONE"
I belive he will do it. after some month He called to me. He said that maibe I will usfeull for him, but he don't know now where. He advice me to find way where i could be usefull..
Month later, my friend from Gazprom, who was my practice lead, send my a message by ICQ: "Anna we search for consultant for HR support and training. We will take in from autsource company" I understand...that man I met in fly, was CIO of that autsource company. I called him...some weeks later I join new project!...and that is other story...

The books I read: (Unfortunately those book have only english language).

Mastering HR Management with SAP ERP HCM

The SAP Consultant Handbook

Next year, when I was 16, I again visited Summer School of Informatic and Programming in Novosibirsk. I wrote a program that use Data Bases( SQL) with Delphi application. It was economic game, where 6 people can take part by network. The idea of program was known. Two teams, every use lake for catching fish. But lake is resourse and it is limeted by ecology. So every team need to have a good fisch income and also don't destroy the ecological system -lake, that fish could allways reprodact itself. So it was really difficult and long project for me. But at  the end I was granted for excelent programming! I was 16, but already known SQL  selects:-)
Then aughtum came, it was last year in Full Middel School. I again took part in Youth Scientific Conference and have good 1 place in my city and then in region. University of Surgut City invated me to study there without exams. It was a long good work done to be prepared for new university life!...

The books I read:
Russian SQL, Data Base and Delphi
English SQL Bible , Beginning Database Design: From Novice to Professional

HTML, Delphi, and modeling...

When I was 15, in sumer , I again was visiting Summer Informatic and Programming School in Novosibirsk State University. It was so funtastic, I met a lot of new friends and study new way of  programming Applications for Windows with Delphi 3.0. it was big progress for me! Now I can do programms in time with World! First programm was about modeling Electro Statistic Electric Fields. One electron was moving accoding formulas and forces of attraction between some of static electrons. That electrons user could set up manually, where he wants. It was really interesting.
For this programm I was granted with Diploma of excelent programming skills.
In that summer I met a lot of people, who delighted me. Most of then became scientifics in future or very good and high paid programmers.
At winter I use this program for participance in Youth Scientific Seminar and also get Second place in my region.
That winter I coded my first HTML site. HTML only appeared at that time. I was writing some web sites with HTML and SCripts. PHP or flash , framework was unknown at that time.  It was also funtastic to make web-sites. I could share information with all world about something I know. I made some HTML sites and  one of them was tested in Pereslavl-zalesskii Programming center and I have got 2nd place in all-russian competiton between HTML-coders.
Great!So thank you very much my teacher, who help me to study HTML, write programmss on Delphi, my friends, who support me at that time!

The book i read: 

 Russian  Delphi with CD , HTML

 English  Delphi 2009 Handbook, HTML & XHTML: The Definitive Guide (6th Edition)

Steps...into future

Next school year I was fall in love with my own educational programm, which was coded on Pascal. My idea was to help students understand biological processes of celling deviding into two new cells. It is about how our body grow up and how all happends on a micro - level. I made beautifull programm with Picture of celling and description of all parts of cells. I use Assembler module for using mouse. So users can pick -up parts of cell with mouse coursor and read the description what is it about. And also I make moving model : how deviding process happend...still remember it consist of 4 steps from core of cell to litle pieces. It was wonder! I gave this programm to my biological teacher to use it for lessons. Hopes ot was good input into her work. She is still work with Youth in that school.  Then I took part in Youth Scientific Conference, where presented my Cell programm. There I first time met my new teacher in IT. He said me not so my word, but leave a reccomends letter. He said that "She is very creative girk. She should have a big future!" Thank you very much for him! It was very important words in my life.

Books of my teacher Iliay Trub
C++ object -oriented programming

DBMS Cache


The book I read:
Russian Biology, Cell Biology
English Student Study Guide for Biology , Molecular Biology of the Cell

Next 2 years till 15 I was studing Pascal. After my first success in programming I have got like a wings. I start t obelive that I found idea of my life. I could write a programs!!!Not so much people can do it in 13...except Bill Geits of course. But In that time I start from Dos, then Windows 3.11 appeared and only then real OS windows 95! In 13 I have got new opportunity from my school to visit Pereyaslavl- Zalesskii IT school (branch of Moscow Internation University). It was autumn, we lived in beautifull place in head of Russia. It was very old city, where I have got first knowleges about Windows 95, Word etc... That time was great I have got new friends, new teahcers...Thank you very much to all people who were there. Now I still have friendsship with some of them! When I come back to my Siberian city, I found a new PC on my table! It was great: my parents made for me this gift!It was really very important! Thank you Mam and Dad for this...hope you know that I grateful.

The book I have read at that time:
Russian Windows 95, BIOS.
English Turbo PASCAL , BIOS

School days

First to yeares I was studied for Pascal and Turbo Pascal programming. We created fuuny programs with different way of calculation and 2d drawing.
I was very good student and myy teacher allowed me to visit Summer Informatic and Technology School at Novosibirsk State University. It school with long story, about 30 years old.
There I met a lot of good teacher and professors in IT. And there I wrote my first big programm - Game "Old Castel" for DOS. It was very pictural screen with funny "Army" who tried to attacht you castel wall. Ay the top of wall you should throw bricks on them. And really it was difficul to be a winner in this Game! For this programm wroted in 13 years I was Grandet Excelent Diploma. It was really me first achivment in programming.

Books I read in that period was : Turbo Pascal 7.0 , Pascal for Students(Including Turbo Pascal)

I was a young girl when first day I have seen PC. It was throught the window of special Informatic School for Youth. After some years when I was 10, I tried to enter this school, but feiled. Next year I tried again and don't know why teacher who sets opposite to me, desided to take me. May be it was due to incomplence of group for programmer. So Thank you very much to Her, after some year she was just Mam of  my friend!
But that day I still remember. My father said: Anna! It was so easy to solve those task..why are you thinking so long? I answered: I afraid that my fast answer arouses suspicion that I stolen the soloving of excersises. It was funny. But still my positive intentions makes people thing that I don't know something.
Well. First day of my programmer lesons were difficult. There were about 5 students with 2 girls only. Which some of them we were friends till end of school! Teacher tried to explain us what doest it mean Algorithm with example of Teaport and how to make a tea. Now this theacher is my good friend...she not only study me computing , she study how to prepare soup:-) and etc:-). Thank you very much for her. She made a big input into all my life and not only professional. She is now Director of that Youth Computing School. Her Name is Sedova Ludmila Ivanovna. 
So at that time we were studied on monochromic PC with easy program which allow to write algorithm for drawing 2d figures.(Trees, circles and etc.). This way my first year of school comes to end.

Today - 1st day!

Hello All! Today is first day of life for my blog! Here I just want to told about the way I come to SAP. May be it will be usefull for just starting Sap consultants or may be for old SAP professional, who wan't to add their story and how the life was changed after SAP came into treir life!

I want to speack about my fist real project and impact I personally have done for bussines, where SAP was implemented and impact to my implementation team.

Also I want to discuss all my development which happends now and what new I have got from books or other expirence, may be for someone it will be very known and easy thing, but may be for some one it will be usefull to get something new about SAP. So ...hopes it will be a good joney into SAP life!

And I promise to write every day some words about my SAP life!