Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • 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.

  • Get RSS Feed

6 Answers

  • Dec 11, 2017 at 02:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2017 at 02:51 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2017 at 03:23 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Dec 12, 2017 at 08:33 AM
    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2017 at 03:00 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2017 at 03:23 PM

    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

    Add comment
    10|10000 characters needed characters exceeded