One time customer

[Former Member]

I would to like to know details about one time customer from an accounting perspective.

How much it is advisable to create one time customer. What would be its impacts from an accounting perspective. (some one told me clearing of accounts is an issue).

Inputs from someone who has already advised business to create onetime customer will be really helpful.

Help me understand what are the effects of it from financial side.

[former_member184080 · Accepted solution]

Dear Sayantan,

As already highlighted by others, its good if you provide us the reason or business scenario for having one time customer.

Evevry business or client will have their own specific scenarios and accordingly we will create the one time customers and account groups.

Check below thread, its well explained by members.

http://scn.sap.com/thread/1706878

Read the below Standard SAP on one time customers.

http://help.sap.com/saphelp_46c/helpdata/en/01/a9b324455711d182b40000e829fbfe/content.htm

http://help.sap.com/saphelp_40b/helpdata/en/dd/55f46c545a11d1a7020000e829fd11/content.htm

http://help.sap.com/saphelp_40b/helpdata/en/dd/55f45f545a11d1a7020000e829fd11/content.htm

http://help.sap.com/saphelp_46c/helpdata/en/53/c98650ca3711d2b494006094b9114a/content.htm

Regards, Sai Krishna.

[Former Member]

iHi Sayantan, 

Yes, you are right. Its is an external file from where we upload the sales orders from different customers.  this particular customer has 30 orders with different ship to parties. To group these orders of this particular customer I mannually group them out of say 100 different orders from the text file so that these are processed one after other as the system process the orders line by line. Furthermore its a one time customer

What solution / process to follow so that the system uploads eg  this customer's  orders together to sort prior to assigning the delivery number.

Regards,

Monica

[Former Member]

Hi,

Thanks for the reply,

Can you tell me what criteria you follow to sort group these customers now manually (i dont think that sold to party no is the only selection criteria).

Check every details in the file which comes in the text file. Normally you will find out an identifier which is common and unique for all the case (for that set of one time sold to party). Set a logic to group them based on that criteria. Place this logic in code before the uploading the file to ECC.

I don't see any standard solution in SAP, but a ABAP development.

Hope it helps.

regards,

Sayantan

[eduardo_hinojosa]

Hi

The main impact of one time customer on FI side is Special G/L transactions is not supported, as it is described in SAP Note 19638 - Special G/L transactions on one-time accounts. So, you can't run tcodes as F110 (payment program).

I hope this helps you

Regards

Eduardo

[moazzam_ali]

Hi Pal

First of all I would like to ask you your scenario. In which scenario you are thinking to use one time customer? We have used it in several scenarios. For normal sales process if your accounting guys face problem in clearing customer then you can use reference or assignment field for copying invoice number. A you know in normal customers accountants clear customer against customer numbers but in one time customer the customer account is same for every transaction so for differentiating purpose you can use Assignment field or reference field. I have done this before.

Let me know if you need more assistance.

Thank$

[Former Member]

In my case i am replicating a transaction which has already happened from a THP system to SAP. The THP system only sends me a EDI 810 (invoice) . I am converting this to an Order so that i can replicate the inventory changes and as well as the revenue changes happening from the LOC to SAP.

However here they are sending me only the SF, ST and BT nos . I got a confirmation that there will be a 1-1 mapping of STand SP.

Taking the negative impacts the customers LOC are sending are every time different (yes i agree that there are same customers as well). To do this i was thinking to use 1 time customer.

I hope i can give a small brief of my scenario MoazzaM.

N:B

THP: Third party system

SF:Ship from

ST: Ship to

BT: Bill to

SP: Sold to

LOC: LOC local operating company

[former_member184080]

Hi Sayantan,

If I understand your requirement correctly, you are creating order via EDI. In some cases, they are sending that data for which you don't have any customer master in SAP. So, to avoid any errors, you want to have a one time customer functionality so that you complete the order creations.

If my understanding is correct, then let me explain you how we are doing in our system.

We also getting order via EDI. In our case we have SP, SH,BP and PY are distributors. But, these distributors will have end customer (different partner functions) sometimes, the file contains the end customer who is not available in SAP ( reason for this is: distributor would have got the information about new end customer which the information yet to reach the client) In order to avoid any errors in order creation, we have created a dummy customer (say 99999) and a report also developed. Which will run as a background job and will send a mail to user if any dummy customer orders have created. This will they get intouch with distributor and creates the new customer.

Hope this may be helpful to you.

Regards, Sai Krishna.

[jpfriends079]

I agree with Sai's suggestion. As you mention, most your cases

THP: Third party system

would be common & constant,

which can represent

ST: Ship to 
BT: Bill to
SP: Sold to

in your system.

You would agree EDI partner is one critical factor to setup EDI transmission. And one time customer will not be feasible solution to handle this.

Thus, you can setup THP as a EDI partner

How to achieve that?

Please refer following SAP Help link for further explanation:

- Setting Up the EDI Partner

Thanks, JP

[moazzam_ali]

DEar

If you use one time customer, how you will handle and control this? Will you use same one time customer as SH, BP and PY or these partners will be the original ones?

Thank$

[Former Member]

JP,

In my case it is not constant, i agree something i need to make constant.

The basic reason for proposal of one time customer.

I will check with what ever details all of you have shared. Thanks to all of you. I will surely come up with the proposal and solution which i have thought of.

Lets see if it clicks.

[former_member182378]

Sai,

This will they get intouch with distributor and creates the new customer.

Could you please explain -

1. What is the flow of the "Selling of goods"?

Company > Dealer / distributor > End customers?

2. Why would customers be created, if "dummy customer" is assigned for those orders (for which end customers are not created in SAP)?

3. After end customer is created, what happens in the order, with customer as dummy customer?

(is dummy customer overwritten by a customer number, in the order?)

Thank you, in advance!

Added:

Sai,

Could you please answer / comment on the above?

Message was edited by: T W - added in blue color font, Typewriter

[former_member182378]

Sayantan,

How does the client want the postings of amounts to happen for One Time customers?

E.g.

All one time customers amounts (in billing document) should be posted to a separate G/L account? etc.

After you know how your client wants it; you can set it up with the help of Account Determination functionality.

Also have relevant fields Optional / Mandatory in respective customer account groups, in OBD2.

Added: As far as account determination or account posting for one time customers, there are problems or issues.

It could be very similar to posting of non-one time customers.

Message was edited by: T W - added in blue color font

[rahul_vishwakarma2]

Hi Friend,

One time Customer : Customers who only enter into a business transaction with you once are called one-time customers in the SAP R/3 System. It is not necessary to create a customer master record for these customers, since there remains no need for this master record after the business transaction has been carried out, and it would only require unnecessary storage space.

Example : Suppose one customer goes to shop and want some product, and that distributor knows that he is one time party i.e. he won't be coming again to buy product to our shop. so at that time that distributor will create a One time Party code for him and sold the product.

This will happen normal process.

For this there is a separate reconciliation is there.

For more information follow this link : http://help.sap.com/saphelp_46c/helpdata/en/01/a9b324455711d182b40000e829fbfe/content.htm

Regards,

Kundan

Message was edited by: Kundan Vishwakarma

[Former Member]

One time customer with several Ship to parties

From the text file to upload and group 30 orders of a one time customer having different  ship to parties out of 100 different customer orders to process in SAP SD. I have to manually choose and group these 30 orders at the bottom of the text file.

What solution / process to follow so that the system uploads eg  this customer's group orders together to sort prior to assigning the delivery number.

Thanks,

Monica

[Former Member]

hi monica,

To combine several orders or several line items into one delivery, certain criterias have to be same.For all the line items below mentioned data must be same, otherwise you can not combine them in one delivery even if the GI date, loading date etc are same.

1.Shipping point

2.Ship to party

3.Delivery due date

4.Route &

5.Incoterm

Apart from this you also a check box in customer master which you need to check to make orders combine.

There are few questions around your requirement.

To me it seems that you have a file from an external system which you are placing in the FTP folder and want to make an order combination. Clarify if i am correct.

If this is your requirement please check  the main identifiers which you are getting in the file.

There are 2 upload function modules as well i think which you you might be aware of.

1) SAP_GUIUPLOAD--- mainly used to upload from an excel file

2) ALSM_EXCEL_TO_INTERNAL_TABLE

what ever be the process normally it uses the BAPI (for an IDOC in SAP standard)

BAPI create sales order.

Hope this helps you to some extent. If not please clarify your requirement.

regards,

Sayantan

[former_member186385]

Hi,

ONE -TIME customer is the customer who does not place order frequently and it is unnecessary to create the master data for such customers in SAP

So SAP delivered the functionality of one time customer, where you will maintain only the General Data of the customer, there will be no COMPANY CODE data and Sales data maintained for such customers

During the FI transactions for such customer, you have to enter the Bank details and reconciliation account manually when posting the FI document

I could say, Apart from Manual entering the relevant Company code data there will be no other impact for FI

Maintaining the data manually at the transaction level can avoid maintaining the Master data and saving it at Table level

one time customer data is stored only at the document level, so it reduces the master data maintenance

regards,

santosh