Hi

Can anyone guide me in designing the query for the below mentioned requirement from one of my client.

1. Regular GRPO

2. Subcontracting ( Receipt from production)

3. Inhouse production (Receipt from production)

4. Finished goods ( Receipt from production)

5. Return components( in Receipt from production)

Note: Apart from regular GRPO & Return Components, the remaining will be distinguished by having an “UDF” where user will select the respective option

ex.. SC, INHOUSE, FG

We need to coincide all the above into one query.

Can anyone help me on getting the required output for the above mentioned query.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply