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.