Hi Guys,
I am working on a complex report where my goal is to run a saved search for Bills with the condition of showing Bills which Bill Credit HAS NOT BEEN created for. On the same note, I do not want to see in the search any Bills which have additional applying transaction, Bill Payment & Currency Revaluation.
Basically my main goal, is to create a report for Finance team which show a queue of all the Bills which have yet to be credited and need to be credit.
Quick background, in Israel, we have a SOP that requires companies to send a Proforma Bill to vendor without side of the PO and then once the vendor sends over the Invoice itself, we need to credit the Bill and then create a Bill from the PO.
I have tried to create this search in different variables but with no luck. One of the things that came to mind, was that I am missing additional info to exclude Bill which have been Credited. The idea which came to mind is to check if NS has an Out of The Box Line Item column, same as for: Quantity/Received/Billed but Credited. If so, this could solve the issue. Is this something we have in NS (I was not able to find). If not, is this something which can be created by a custom transaction line field + WF?
Thank you.