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.