Does anyone know what flag gets undone to remove the receipt from Rec’d Not Invoiced?
As in what table should be updated.
Not sure I follow (your kind of asking about the reverse of what happens)
RcvDtl.Invoiced gets set when an AP invoice is applied against a PO Receipt.
So a receipt shows up on the Rvc’d Not invoiced when
RcvDtl.Received == TRUE AND RcvDtl.Invoiced == FALSE
Not sure if you can set the RcvDtl.Invoiced field w/o also setting .InvoiceNum and .InvoiceLine
Rcvdtl field is Invoiced.
Vinay Kamboj
RCVHead - uncheck save for invoicing to equal false. I just did this today
2 Likes
You can just uncheck in an updateable dashboard save for invoicing checkbox = false and it will remove it from the RNI report
Thank you. I tried the Invoiced first, because just seem logical. But Saved For Invoice it is.
FWIW - That field solves your problem but where did the receipt post or did it not create GL entries with COS/WIP? If it did and you use a clearing account your subsidiary ledger “Receive No Invoice” report will not balance the GL clearing account if it is not invoiced.
We bring in the inventory from SMI.
Debit Inventory
Credit AP Clearing
Then I created a Inv Adjustment Reason Code tied to GL 2010 AP Clearing.
SO when I do the adjustment and chose SMI Inv Adjustment, the following happens.
Credit Inventory
Debit AP Clearing.
Then I clear the checkbox for Saved for Invoicing.
Thank you for the explanation. This is good information to know for the future.
**Josh Owings **| JR Automation
ERP Applications Manager
O: +1
(864) 397-9193 | C: +1 (864) 884-6587