Block material for stock removal until goods receipt

[Former Member]

Hi,

This is our current GR process

ASN -> inbound delivery -> TO creation (when goods physically arrive) -> TO confirmation -> customs declaration (outside SAP) -> GR

Goods are received in physical warehouse A with storage types Z01 to Z05.

Physical warehouse B is near to the KANBAN production line and has storage types Y01 to Y05. It is located 40km away from A

All Y and Z storage types are part of SAP warehouse REC.

We have following situation:

- every 2 hours a batch runs that replenishes the Y fixed bin storage types of warehouse B with the materials from the Z FIFO storage types of warehouse A.

- replenishment takes into account all WM stock in Z storage types

Requirement:

- replenishment should not take into account quantities that have been received in warehouse A without GR in MM/IM

- reason is that these quantities should not leave the premises of WH A as long as customs declaration is not ok

Possible solutions:

- GR before TO: not an option for business

- Move quantities on physical GR to another storage location than foreseen in the PO and move back when customs ok: business does not want to maintain additional storage location

- Other custo settings?

- User exit during replenishment (MWMRP002 - Replenishment control: TR quantity allocation)?

- Other?

Thank you for your valuable insights!

Geert

[Former Member · Accepted solution]

Finally we could convince the business to receipt the goods under customs in a separate MM storage location.

Since we are within a HU-managed environment the solution with storage location control in the warehouse does not work so we could not automatically move between storage locations via posting changes.

The process we came up with is the following:

- receipt of goods in new MM sor loc linked to same warehouse

- confirmation of TO which places goods in final destination bin

- automatic GR based on TO confirmations which allows Finance to already do the necessary. From a stock / MRP point of view all is correct

- use HUMO to select all HUs linked with the inbound delivery and to do transfer between storage locations once go from customs is received

In this last part we had to intervene because HUMO inbound delivery number search only returns results for HUs with object type 03. Since after GR HUs get status 12 but still have the inbound delivery number as object number, we allowed object type 12 in the inbound delivery number search for HUMO.

Thanks again for all valuable inputs.

[Former Member]

Dear Geert,

As mentioned by you, below is the document flow

ASN -> inbound delivery -> TO creation (when goods physically arrive) -> TO confirmation -> customs declaration (outside SAP) -> GR

Is it necessary for you to confirm transfer order on TO creation? if not then you can keep TO open and after custom clearance, on GR, TO can be confirmed. You can put logic in GR exist for checking TOs for inbound delivery and confirm them on PGR. But you need check, whether how destination bin is treated as which is fetched in TO for next TO.

Another solution could be, you can set up batchjob to block and unblock quant. So on TO creation you can block quant there itself and unblock it on PGR or unblock it by settting up batchjob.

BR

Kamlakar

[MANIS]

ASN -> inbound delivery -> TO creation (when goods physically arrive) -> TO confirmation -> customs declaration (outside SAP) -> GR

Do you update any flag in system as a result of Custom declaration, How the SAP operator get trigger that Custom declaration has been completed and PGR can be done for the Inbound delivery. Might be that will give some idea how to handle this situation

[Former Member]

Hi Manish,

You are correct I should have mentioned that there is no automatic trigger or switch of flag coming from another system that sets or allows PGR.

Currently we prevent the automatic GR (after all TOs are confirmed) by manually adding a line item "CUSTOMS" in the delivery with a quantity = 1. Once customs declaration is finished, this quantity is manually set = 0 and PGR is done.

Hope this gives you a better insight in our process.

Thanks for your reply!

Best regards

Geert

[MANIS]

This is very interesting scenario

Using standard it is not possible,  you need to write the code in exit to achieve the same

During replenishment run system takes the stock detail from LQUA to internal table. Once that is done ask the developer to write a small utility to transfer the detail to custom table and check LQUA-VBLEN field pick the entry from that and extract the detail from VBUK table where VBUK-VBLEN= LQUA-VBLEN once you get all the detail then check VBUK-WBSTK if that is other then C then delete all those entry from internal table and return back the line item to standard for processing.

Now there might be a scenario where LQUA-VBLEN will be blank as these record exist due to internal movement so you need to ask your developer to retain those as those are valid Quant

here VBUK-WBSTK = C means Total goods recipt has been posted

Hope this will  help

[Former Member]

Thanks Jacob and Manish,

I will discuss this with our developer and come back to you.

Cheers

Geert

[Former Member]

Sorry Manish to get back to you so late.

Our focus have been off the problem because of an internal project and change in priority for this issue.

Now we are back on track again and I was wondering if you were referring to user exit MWMRP002 - Replenishment control: TR quantity allocation to get this part coded.

Or did you had another suer exit in mind?

Thanks in advance!

Best regards

Geert

[prabakaran_gurusamy2]

Hi Geert,

Another way is you can control it through batch characteristics. Add or create usage decision ( released, blocked, ..etc) as one of characteristics in classification. we can check feasibility of considering only batch which has  released status( = custom clearance) for replenishment.

Thanks and Regards,

Prabakaran Gurusamy

[Former Member]

Hi

Have you considered a "Goods In" storage type in Whs A that all materials are initially receipted into. These would not be available for replen and could be moved into Z FIFO (LT10) once the customs part is completed ?

Cheers

A

[Former Member]

Hi,

Thanks for your suggestion which would indeed serve our purpose.

In fact we considered this as well, but again the business refused this solution as they want to move the goods directly to their final destination in the receiving warehouse A.

I should have mentioned it in the possible solutions part.

Best regards

Geert

[Former Member]

Hi

Have you considered setting the stock type in the PO to 'S-Blocked Stock'. The stock would then be receipted into the final destination as required, but as blocked stock. You could then use LQ02 to unblock the stock when the customs part is completed thus making the new stock available for replen ??

Cheers

A

[Former Member]

Hi,

Didn't look at it from that side.

This could be a valid solution if we could trigger the posting change to set the category from S to Unr. based on the PGR.

If not, then we risk that goods stay in blocked stock in MM and are disregarded by MRP.

Any FM / BADI / user exit that could help in attaining this solution?

Cheers

Geert

[Former Member]

Hi

Not sure if there is a BADI/FM to cover this. I used a similar solution but had the developer write a small piece of coding.

Manish looks to have provided some guidance on possible coding.

Cheers

A

[Former Member]

You could block the WM inventory on BIN, Quant, or SU level to avoid replenishment until customs clearance is complete. Your TR will not be converted to TO until you remove the block.

BIN - LS02N - click stock removal block until customs clearance is complete.

Quant - LS22 - removal block

SU - LS32 - removal block

Guessing quant level would work best in case you have multiple materials in the BIN or on SU.

[Former Member]

Hi Jacob,

Thanks for your idea!

Do you have any suggestion on how you could incorporate this in our GR process in an automatic way?

I believe then we would need a way to block the quant or SU automatically after TO confirmation, but how will we differentiate between materials having and materials not having to pass customs?

Next to this we would also have to find a way to automatically unblock the quant / SU after PGR.

Are there any FM, BAPI or user exits that can be used?

Best regards

Geert