Will removing numbers from a customer number range have affect on VAT reporting

[Former Member]

Hi

I have a customer number range ( external ) e.g 1000 to 2999 and assigned to customer group XYZ. I have created some 30 customer ( 2201 to 2230 ) and also posted transactions. Now I want to change the number range From /To to 1000 to 1999.

QUESTION : In XDN1 ,it allows to change. I am worried about the already created invoice in the customers ( 2201 to 2230 ) as it is not in the new number range From /To. What is the affect of this. Will it affect VAT reporting and other parts like data flow to BW.

Please help to know on this.

[former_member183501]

No it should not be a problem.

But, for more visibility it would be good to set deletion flag as suggested by Jelena.

As per your number range it seems that business won't have that much of customers for this particular account group and users would be known about it.Hence, it could work without creating new ones also.

[Jelena]

Since there are only 30 records created in another range it might be a good idea to mark those customers for deletion and create new master records for them. The reason for that is the users most likely will get used to the idea that 100... numbers represent Sold-to (or whichever customer type this is) and will use that in the reports. It'd be very difficult to keep explaining to everyone that there are 30 "odd" customers in another range.

Other than that, there should be no effect on BW, unless some assumptions about the number range were used in the extractions or reports there. But we can't possibly know about this, you'd need to contact someone locally to confirm.

[JL23]

I actually doubt that this example is a real business case since the new number range can only take 999 numbers and as the standard buffer is set to 10 the range might already be exhausted with much earlier.

Deleting and recreating customers is also not always a desired plan since you then have 2 customer masters with identical names which both show up in standard search helps. You would need to tweak the search helps and add the deletion indicator to only get undeleted customers right away when searching. Further, as there is already business volume you also might to look for a while at 2 customer to get the total.

[Jelena]

You're right. I thought OP just skipped the trailing zeroes as literally 1000 to 1999 is not an adequate range.

This is, unfortunately, "damn if we do, damn if we don't" situation when the records in another number range already exist. Either way, there are some negatives that OP's organization will need to evaluate. With the option I proposed it might be inconvenient for a while but then eventually the records will get old and can be deleted.

[Lakshmipathi]

The best way to get answer to such type of queries is to test in your system by yourself, before posting here. Immediately, you will come to know the impact rather posting here and waiting for members' feedback

[Former Member]

Dear Lakshmipathi,

I have tested on existing customers and it has posted and coming as open item in FBL1N. I will test on VAT and know.

For BW test, I do not have access to the system and I am in support. So posted the question.

Sorry if it has caused inconvenience.

Thanks

kamala

[Jelena]

Please use "Comment on this answer" when replying to an existing answer. If you post another answer then the person replied to will not get notified. Also it's not an answer, isn't it?

[Lakshmipathi]

As rightly pointed out by Jelena Perfiljeva whenever you add any information as asked by the members, please do so under Comment and not under Answer, as you were not answering. I have converted your above post from Answer to Comment.

[JL23]

A number range is used to pick numbers from when creating new customers.

As the customers already exist and their number does not change at all, how could a number range change then effect the VAT reporting on existing invoices?

[Lakshmipathi]

I have tested on existing customers and it has posted and coming as open item in FBL1N

Is it FBL1N or FBL5N? I presume, this was a typographical error. Also, please let me know whether you were able to look two codes for the same customer in FBL5N.

For BW part, you can add one more secondary tag. You can learn more about tags at https://www.sap.com/community/about/using-tags.html and browse all existing tags here: https://www.sap.com/community/topic.html

For general information and tips about asking questions in the community, please visit this page: http://www.sap.com/community/about/questions-and-answers.html

[Gustavo_Vazquez]

Hi Kamala,

I suggest to change number range for your existing Customer Group and create a new Customer group with a new range.

There is no relationship between Customer <-> Number range but there is Customer <-> Customer Group.

You can't change customer number once documents are posted

Kind regards

[Former Member]

You should first be aware on how the process works now in order to evaluate the impact of this change. From a SAP standard view I'm with Jürgen.