Just got this resolved: I had left the last depreciation field blank on the asset record thinking it was not needed since it was on the depreciation history record Once this was populated and I toggled the 'depreciation active' field from true to false and true again (to trigger the 'reset asset value' process), the…

Hi @Jack Daryl Espiel-Oracle Would the client script be on page init? Or would it be after field sourcing?

Hi @Jack Daryl Espiel-Oracle If I were to use a script, would it be a user event, before record load?

Thanks @Katerina Winklerova-Oracle I have found that a setting in customer payments screen that lets you adjust the number of visible rows So it looks like it might be record by record type based?

Hi @Elychelle Gulen-Oracle I have responded to the email. I have found this issue in yet another account. So in total, there are 3 accounts where I have encountered this issue: 2 demo and one sandbox.

Hi @Kristoffer Viray-Oracle Thanks for looking into this. A colleague suggested the following field (appliedtotransaction.rate) and that seems to work to source the SO rate on an IF search. The tips you have given are still useful though for future use :)

More suggestions of workarounds for items that are currently enhancement requests.

Thanks @Kristoffer Viray-Oracle That worked!

Hi @Kristoffer Viray-Oracle Thanks for your suggestion. I tried this right now though it is treating all lines as being on back order even though they aren't actually on back order: This is the workflow action

Hi @Jack Daryl Espiel-Oracle I haven't had a chance to test sorry. It's Saturday here so I will test and post my findings when I can. Thanks

Thanks. That is a good suggestion Currently, I am working on a workflow that automatically closes the line if the quantity available is 0 or if the item is already on backorder. Will post the results here once I am done

Thanks for the suggestion @Entartes I just tested it now and it doesn't seem to prevent back orders From what I gather, isn't negative inventory different to back orders? (with this app being geared towards negative inventory and not back orders?)

Hi @Dominica Sevilla-Oracle Are there any updates on this? thanks

Hi @Dominica Sevilla-Oracle The item in question is added automatically via promotion Apologies for that, I should I have clarified earlier. The settings: The allow uncommitted setting is needed since other items can be on back order. It is this one item (the complimentary item added via promotion) that shouldn't be back…

To add to this: is there a way to have a workflow triggered by changes in the support case record, created by the system? For example, in a support case, I have the above mentioned changes. I want this to be a trigger for a workflow Is that possible?

Hi @Kristoffer Viray-Oracle Thanks. That seems to populate the rate. However, I was needing this field in a saved search and it doesn't show a value since the 'store value' is unchecked. If I try to tick 'store value' and try to set the field value using a workflow and the same formula of {itemunitprice}, I still get a…

Hi @Elychelle Gulen-Oracle Yes, I checked the bill to address. They were all using the same value (custom) from the drop down in the bill to

For quantity, I am thinking of the ones on the item line. so a quantity pricing breaks essentially

@Mikko De La Fuente-Oracle With the client script post sourcing idea, how would I look up a combination of the price level and quantity for an item?

Hi @Elychelle Gulen-Oracle The images are for a fictitious company in a demo account. None of the data is real. (it was just the default fake data on a Suitesuccess demo account). With the billing address, the invoice records were copied using the "make copy" function from the original invoice under the actions menu from…

Hi @Elychelle Gulen-Oracle The PO numbers are exactly the same. I had copied one invoice record and created the others and didn't enter this on any of the invoices The billing addresses are also the same The attached images were removed.

Thanks @Niks Blando-Oracle I had a related question (sorry if I need to start another thread?) Is the invoice grouping functionality scriptable?

@Mikko De La Fuente-Oracle The record is in edit mode How would I use a saved search if the record hasn't been saved yet? What kind of script would be needed for this?

The record was in edit mode. It still wasn't sourcing a value and returning an error though Is this custom field supposed to work? Or can this only be scripted?

@Mikko De La Fuente-Oracle i have tested this as follows: The item's record:

Hi @Mikko De La Fuente-Oracle The price level will be from the item record. I have tried setting up a custom field that sources the price level directly However, the price level I am interested in isn't available I can only have this field auto populate with the base price In this example, the rate charged for the item is…

Re-tried it (I must have had a quote or comma in the wrong place) and it now works In the source view: <#--FM:BEGIN--><a href=&quot;${record.custbody_if_invoice?replace('<[^>]+>','','r')}">${transaction.tranid}</a><#--FM:END--> Thanks Jack!

Found how to create the saved search on here:https://suiteanswers.custhelp.com/app/answers/detail/a_id/90124/~/create-a-custom-field-that-links-an-item-fulfillment-to-an-invoice

Hi @Jack Daryl Espiel-Oracle Apologies for the delay in responding. I have just got around to testing this. I have ended up moving the hyperlink to an email instead of the PDF. Should the same solution work in a scriptable template seeing as that also uses freemarker? I have tried the following though am getting an…

Hi @Mikko De La Fuente-Oracle I can't see how to create a saved search to reference the item fulfilment from an invoice. There are "2 degrees of separation" in the sense that the IF record is connected to the sales order and not the invoice record. In that scenario, how would I query the item fulfilment transaction…