Rick Cobb_2 Red Ribbon

I think I found an acceptable field: vendor.duplicate that I can use to identify all vendors that are currently flagged as dupes. Next step is to configure a saved search that will send those results in real time when new vendors are imported that may have dupes.

Found the Cleared field which is what we want; not sure why there's an enhancement request:

Thanks.

Joy, That doesn't help me. I need something that is identifiable on the transaction line in the Results subtab to call out shipping lines. Here's a search: the second and fourth lines are shipping lines. the Item Designation New column is a joined field to the item table. I want to report in that column when the line is a…

Joy, What if Shipping Line is not showing as an exposed field on my transaction saved search?

Mikko, No need for further assistance. Rick

Mikko, That's what we're doing: creating a custom transaction body field on AR invoices and populating it with the latest user notes memo field contents via after submit script. Thanks for your help! Rick

Mikko, Here's a screen shot of a sample note: None of the fields of interest (Title, Memo, Date) are exposed. What is the possible reason that the fields that contain the most information are not exposed to querying????

Mikko, What if the client essentially wants to do a left outer join of ALL invoice records with selected fields and one or more fields from the related user notes on the transaction if there is in fact a user note attached to the invoice? Thanks.

some more info: if there are multiple user notes attached/related to an invoice, they'd like to see only the latest user note.

Patrick, Assuming the prior period is closed (not locked), the client specifically wants to void the invoice because that would re-open the sales order (which are tied to projects) from which the invoice was created. Creating a credit memo or reversing journal entry doesn't have that effect. Are we able to void the invoice…

Patrick, Let me check whether the periods are closed or locked. Either way, are you implying that voiding the transaction in a prior period can control the date of the reversing GL impact? Via the JE you describe?