Finance | Project Operations, Human Resources, ...

GRNI Product Receipt - Mass Write Off

(0) Share

Report

Posted on by Community Member

Hi All,

Could anyone advise how to process mass write offs of old/aged GRNI balances through the purchase ledger?

We have tried searching for the answer on this but even a basic GRNI clear down process doesn't seem to be obvious within D365 F&O?

Thanks!

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

André Arnaud de Cal... 300,904 Super User 2025 Season 2 on at

Like (0)

Report

Hi Dom,

I do assume GRNI stands for 'Goods received, not invoiced'?

In Dynamics 365, the invoice needs to be posted. This can be done with a zero invoice per vendor where you select open receipts. There is no automation that this can be done for all vendors at once.

Setting a zero invoice, will have impact on the inventory cost value. Depending on your requirements, you can have the original PO price used; where in a new line, you can clear the invoice amount with a negative value on e.g. a category or service item.

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

There is not automatic way of cancelling this either you have to Invoice all PO's or cancel Product receipts and then cancel PO's.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Dom Bell,

Can you elaborate on the question please?

I wonder why you want to 'write off' those balances.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Olivia C 64 on at

Like (1)

Report

Hi, I am currently facing this issue at the moment.

For example, if we have a PO which has been raised for £1000 and the invoice comes in for £990 and is matched, this leaves £10 remaining on the PO which is affecting our GRNI.

The reality could be that the £10 will never actually be invoiced, is there an easier way to resolve this to fix the GRNI rather than the PO orderer correcting their receipt within the product receipt journal?

Is there a function within the Purchase Ledger module where they can 'round off/write off' a purchase order if it is likely another invoice is not going to come in? Something that perhaps allows a tolerance, say if less than 10% of the PO is left, there is the option to round off the remainder at this point?

Or is the answer like what Saurabh says below where there isnt an automatic way of cancelling this and either you have to invoice the full PO amount or cancel/correct the product receipt and deliver the remainder of the PO? This just seems very administrative.

Thank you all

Was this reply helpful? Yes No
LucianoM 15 on at

Like (0)

Report

Hi Olivia,

Did you get any response on this? I am also looking for the best way to clear out these "orphan receipt balances" on my GRNI.

In addition to your scenario above.. I have a scenario where the business user fully receipted a bulk PO by mistake and that receipt was subsequently manually matched to a partial invoice by AP. Subsequently, they now have a massive GRNI accrual sitting in the account that cannot be invoiced as the original receipt was matched already. How can they write off/clear this over accrual?

Many thanks in advance.

Was this reply helpful? Yes No
Olivia C 64 on at

Like (0)

Report

Hi Luciano,

I think in answer to your query of clearing the balances of your GRNI it would be using the 'correct' function within the product receipt journal.

The user who has receipted/created the PO can amend their receipt amount if they have receipted a bulk PO in full as opposed to partially to match the invoice value. They can only reduce the amount of their receipt rather than increasing this.

I have found this page here which details the process quite well, please see the 'Correct/Modify Product Receipt' section, I hope this helps.

oakhallgroup.zendesk.com/.../360053353414-Reverse-Cancel-or-Correct-a-Product-Receipt

Thank you

Olivia

Was this reply helpful? Yes No
LucianoM 15 on at

Like (0)

Report

Hi Olivia,

Thank you for prompt response.

If the original over product receipt has already been used in invoice matching - would I still be able to correct that Product receipt if the invoice has been matched and posted already?.. just looking at the note in the guide you shared:

TEST EXTRACT - STEP# 6 - (NOTE: Material must still be available in the location to reverse! If you have issued/distributed the material or allocated it, you cannot do this step.)

would the invoice need to be reversed out first before the receipt can be corrected? Hope that makes sense :-)

Was this reply helpful? Yes No
Olivia C 64 on at

Like (1)

Report

Hi Luciano,

Apologies I didnt make that clear. Even if there is an invoice thats been matched and settled against a line you have receipted and are wishing to correct, providing you are reducing the receipt amount you will still be able to do this.

So yes you can use the product receipt function despite of a matched invoice and wont have to credit the supplier invoice.

Thank you

Olivia

Was this reply helpful? Yes No
Suggested answer

LucianoM 15 on at

Like (0)

Report

Thank you Olivia

Was this reply helpful? Yes No