Skip to main content

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

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

 

 


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


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


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.

 


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

 


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


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. 


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


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).


Thank you again Adam.


Reply