Alpha Numeric Number Ranges for Material Documents

[venkat_uppula]

Hello All,

Could you please let me know how to fulfill the below mentioned requirement.

I want to create material documents in MIGO for warehouse for quantity mismatches. Here it comes the scenario.

If a user uploads the initial balances with 561 Mvt. Type, then the same is updated in the WM with respective Bins. But the problem here is, the actual balances are 30 days old. Now customer used some of the existing materials and also procured other materials.

For Ex: CASE 1:

Exact balance as on 05-JAN-2020 for Material X is 50 EA

Now the business has consumed 5 EA of Material X

CASE 2:

Exact balance as on 05-JAN-2020 for Material X is 50 EA

Now the business has procured 50 EA of Material X

Now how can I do manually / or any other way to adjust this.

My customer asking to create a material document number ranges in the below format for this kind of adjustments.

XXX2002001 to XXX2002999

Where, XXX stands for company name,

20 stands for Year

02 stands for Month

001 to 999 is the number range. (this format is for FEB month of year 2020) in the same way, for March, it will be like this.

XXX2003001 to XXX2003999, for April it will be like this: XXX2004001 to XXX2004999

Please advise me on this.

BR,

[Abinathsiva]

Hi Ram,

Material document Number is client level configuration, Think this requirement for Material document number is not possible.

[DominikTylczyn]

Hi Ram, what you are trying to achieve is technically not possible. Material document number ranges are not defined on company code level. There is no way around here.

However you could use Goods Receipt/Issue Slips number to implement company code specific numbering. The Goods Receipt/Issue Slips number is not material document number though. It's just one more number that is going to be issued during material document posting. The setting is in SPRO: Materials Management -> Inventory Management and Physical Inventory -> Number Assignment -> Define Number Assignment for Goods Receipt/Issue Slips -> ...

Although the functionality has been designed for countries like Italy for legal reason, you may give it a try.

Dominik Tylczynski

[venkat_uppula]

Hi Dominik,

Thanks for your quick reply. If I configure the same as you said Goods Receipt/Issue Slips, will I be able to create a TO in this case?.

The actual balances are 30 days old as I said earlier. Now with 561 Mvt. type, the initial balances are uploaded at Storage Location Level. Out the list of the materials, I found 60 plus materials quantity is not matching with the initial balance quantity.

Here are the possible cases.

CASE1:

Initial Balance was uploaded as 50 EA, but physically 45 EA are available at Bin Level (5 EA is consumed)

CASE2:

Initial Balance was uploaded as 50 EA, but physically 55 EA are available at Bin Level (10 EA procured)

In the both cases, how can I match this. Both transactions were not made in SAP system.

BR

[DominikTylczyn]

Hi Ram, Goods Receipt/Issue Slips functionality has nothing to do with WM. It's just another number in a material document. Thus it has no influence on WM and TO creation.