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.

[VeselinaPeykova]

Probably I fail to understand the problem - if your stocks from system perspective differ from what you physically have in the warehouse - why not perform a physical inventory?

Is the company code live, by the way?

If some materials were procured and received in the warehouse (physically), normally you will have a PO and the vendor will expect an payment against the issued invoice. How was this posted in the system - do you have a PO, do you have a MIRO invoice, or was this considered in balances postings?

If you are not live yet - just perform physical inventory and adjust the open items (if this was not done already).

Even if you find a way to use alternative ranges for material documents (which I don't think that is possible, the idea that Dominik suggested is feasible, though), such solution will open a can of worms.

Users have to learn that they should post documents in the system in a timely manner.

If they do not do so - there is no point in having an integrated ERP system.

561 is meant to be used only for initial balances at go-live, not as a part of the standard process. Even from auditing perspective I would expect such stock adjustments to be a problem. After go-live the recommended approach is to use physical inventory for matching the stock in the system with the actual situation.

[venkat_uppula]

He Veselina,

Thanks for sharing your ideas. The user has uploaded all the Initial balances which are moved with 561 Mvt. Type. The user found there were some qty discrepancies for few materials. How to adjust these quantities against with respective materials. PI is done.

Please advice.

BR

[VeselinaPeykova]

venkat.uppula if physical inventory was performed correctly there won't be discrepancies between the physical stock and what is in the system, right?

The idea is that you initiate counting in the system, then you count what is physically available, you enter the count, then you post differences (if there are any).

I have faced a situation where the users made mistakes at entering the count results and I asked them to recount until they did it right.

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

[ankurch]

Hi Ram,

Use User Exit "USEREXIT_NUMBER_RANGE" in program SAPLMIGO.

Thanks,

[DominikTylczyn]

Can you share the details of your suggestion? I can't find "USEREXIT_NUMBER_RANGE" in program SAPLMIGO

Thanks

Dominik Tylczynski