Scenario for GRPO

[Former Member]

Hi All,

I am facing a problem here while handling a scenario in GRPO. Any suggestions would be greatly appreciated.

Scenario :

GRPO is copied from Purchase order. PO can have upto 200 line items. If the qty of any item is recieved less than the qty in the po, then we have following udf's in the GRPO at row level to update the qty;"Accepted qty, Short/Excess qty, Rejected Qty". The problem arises when accepted qty is zero, coz if the qty field of GRPO is 10 and accepeted is zero, the system still counts 10 in stock as it is system behaviour. NOw we want the stock to be updated by the accepted qty. How can this be handled??

I thought of using dropship whse in case where item is not received, but the problem arises as this can still be copied to A/P Invoice. It solves the issue at inventory level but the accounting gets affected as the material is not recieved physically.How can we handle this scenario???

Thanks in advance,

Joseph

[Former Member]

Hi!

What u mean by accepted qty in GRPO.

i belive, the Quantity field in GRPO is the Accepted Qty then there is no need of a spreate UDF.

[Former Member]

Hi Thanga Raj,

We have created a UDF at Row Level 'Accepted Qty', as the Accepeted Qty may differ from the billed Qty. The billed qty i.e. the qty in PO comes in the qty field of GRPO. Now the accepted Qty may be zero in some cases where as the qty which is updated in the QTy field of GRPO updates the stock. Is there any possible work around for the above mentioned scenario???

Thanks,

Joseph

[Former Member]

Hi Thanga Raj,

Also to clear this scenario a bit more, I'll try to explain it again in brief; Billed Qty of Purchase Order would be the Qty in GRPO. Now the following cases arise;

a. The qty in the GRPO i.e. the receieved qty can be zero, meanin the item didnt arrive in the consignment.

b. The qty in GRPO can be recieved partially.

c. The clients wants to capture the details of "Accepted Qty, Short/Excess qty, Rejected Qty" on PLD and also the stock should be updated accordingly.

Any suggestions??

Thanks,

Joseph

[Former Member]

Hi

You can have the following UDF's in the GRPO screen.

You may use the existing 'Qty' field in the GRPO to record the accepted Qty.

U_POQty - To record the PO Qty

U_RejectedQty - To record the rejected Quantity

If the 'Accepted Qty' is 0, then there will not be a need to enter a GRPO.

[Former Member]

Hi!

Also create a UDF as Billed Qty in GRPO rows and bring the PO qty there through a FMS. Use Default Quantity field in GRPO as Accepted Qty.

[Former Member]

Hi Thanga Raj,

I was tryin to do the same but the problem arises when the accepted qty has to be zero.

Thanks,

Joseph

[Former Member]

Hi Thanga Raj,

I tried to do the same but the problem arises when the accepted qty is zero.

Thanks,

Joseph

[Former Member]

Hi Thanga Raj,

I tried to do the same but the problem arises when the accepted qty is zero.

Thanks,

Joseph

[Former Member]

Hi!

If Accepted Qty is zero then why do u booking a GRPO for that item ?

[Former Member]

Hi Thanga RAj,

Booking of GRPO is required as the vendor sends an invoice after paying the excise duty. So, we need to raise a debit note for the same with the details of the GRPO as how much qty was billed, what was the accepted qty and so on.

Thanks,

Joseph

[Former Member]

Hi Thanga RAj,

Booking of GRPO is required as the vendor sends an invoice after paying the excise duty. So, we need to raise a debit note for the same with the details of the GRPO as how much qty was billed, what was the accepted qty and so on.

Thanks,

Joseph

[Former Member]

Hi!

Then tell me will this works in your case .

1. Book PO

2. Book GRPO, record the accepted Qty there as 0.

3. Book Excise Invoice for all items

4. Book a Goods Return for the items which has 0 Accepted qty.

[Former Member]

Hi Thanga Raj,

Wont the system ask me to generate an outgoing excise invoice for the same??? Or can i avoid it by changing the tax code there??

Thanks,

Joseph

[Former Member]

Hi!

No, system will allow you to post a Goods Return without a Outgoing Excise.

[Former Member]

Thanks Thanga Raj,

Will see if the user agrees for this workaround. Thanks fr all your inputs.

Best Regards,

Joseph

[Former Member]

Hi Joseph.......

If you are receiving zero qty against a perticular PO so there is no need to raise GRPO and close that perticular row in PO. There is no necessity to maintain separate UDF. Or else if in future suppose your supplier will send you the qty against the zero accepted qty item then you should put the row status of that row in PO Open. Latre you can accept also.

Regards,

[Former Member]

Hi Rahul,

I have suggested the same to the users, but they want a detail of accepted, rejected qty for any item as well and that is the reason why I had to create these UDF's on the document. If at all you have any other workaround in your mind, do let me know.

Thanks,

Joseph