Skip to main content
Question

GRNI write off


Forum|alt.badge.img+5
  • Sidekick (Customer)
  • 17 replies

Hi,

Can anybody advise how to write of non-inventory and inventory amounts from the GRNI report?

Items are from previous year.  Cannot write off the part number as stock take for year end was completed. 

The reason for write off are

FOC from supplier so invoice will not be raised but the Purchase order line has value to it.

PO Closed - unable to write off.

Line posted as tolerance / variance

Thank you,

Lisa

10 replies

Forum|alt.badge.img+13
  • Hero (Employee)
  • 150 replies
  • June 19, 2023

Hi @LisaT,

You can create supplier invoice with zero value and matched these items by changing price as zero in PO matching dialog box. then GRNI will clear, and value will go to price variance account via M19 & M20 posting type.

BR/Narmada

 

 


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 17 replies
  • June 19, 2023

Thank you Narmada,

How do we make sure that this does not pick up the inventory part number as we do not want it to affect the stock.  Just want to remove it from the GRNI / GL balance?

 

Lisa


cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • 439 replies
  • June 19, 2023

The AP process only matches invoices with receipts.  It will not impact the inventory transactions.


Forum|alt.badge.img+6
  • Hero (Partner)
  • 39 replies
  • June 19, 2023

Invoice matching can affect stock, depending on the purchase part setting.

I think to close receipt (indicate that no further invoice is expected) you need to set “Closed date” on receipt.

 


Forum|alt.badge.img+6
  • Hero (Partner)
  • 39 replies
  • June 19, 2023

One more thing - after setting the Clsoed Date manually, GRNI balance in GL must be cleared by manual voucher.

 


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 17 replies
  • June 22, 2023

Hi Adam,

Thank you for your response.

Can you please show an example of a GRNI voucher to clear the GRNI balance?

Thank you,

Lisa


Forum|alt.badge.img+16
  • Hero (Customer)
  • 675 replies
  • June 22, 2023

Hello, Lisa, 
it depends on your setup, but in principle, you should close GL balance created by receipt (posted by M10 posting rule). The other side of the posting is profit - usually a revenue account (goods received free of charge).

If account used for M10 posting type is defined as ledger account, your voucher should be Q one, otherwise you can use regual manual M voucher. 


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 17 replies
  • June 22, 2023

ok, thank you again for this.  Really appreciate it 🙂


Forum|alt.badge.img+16
  • Hero (Customer)
  • 675 replies
  • June 22, 2023

Alternatively, you can come back to the solution proposed by @Narmada and Christy (@cperdue).

You can create zero-value invoice and match it to outstanding receipt. If invoiced value declared is equal to receipt value - there will be no impact on stock (be careful with foreign currency orders, because in such case you need to apply the same currency rate to invoice and receipt).
Invoice matching must be then completed/balanced by manual posting line (to the profit account mentioned).


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 17 replies
  • June 22, 2023

Thank you again Adam.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings