Hi, It's a transaction saved search. Would like to group by Yes and No. Thanks!

Nevermind managed to resolve. If anyone wants to know, l can put up. Thanks!

Many thanks for your help! It appears that there was another recalc script that was causing an issue. I removed that script and now it works perfectly! Thanks for all your help, it really is invaluable!

Hi Shyam, I need to do this on a client script, I tried a variation of your sample above on a client script and still no good. Anyone else able to shed any light on this? Not sure why the original script I tried doesn't work: function updateTotalQuantity(type) { var totalQuantity = 0; var itemCount =…

Hi Mikko, Field: Also didn't work with validateLine function. Thanks!

Thanks Mikko, I have another question, i've got the following recalc function script, but again it does not seem to be working for some reason?? i.e custbody_qty doesn't get populated? function updateTotalQuantity(type) { var totalQuantity = 0; var itemCount = nlapiGetLineItemCount('item'); for (var i = 1; i <= itemCount;…

Thanks for this, but needed something that shows credit memos and their related customer payment. For example when accepting customer payments, credit memos can be assigned against invoices. However, can't see a way to show a search that shows the credit memo and related customer payment.

Ended up doing a search with the criteria of the customer payment internal id and result fields of paid transaction: paying transaction. Thanks!

My gut feeling would be that REGEXP_REPLACE LENGTH SUBSTR might be able to help you out here. Hopefully this might give you some ideas: <span style="font-family:'courier new'">CASE WHEN ((NVL(LENGTH(REGEXP_REPLACE(SUBSTR('AA111',1,2), 'D', '')),0) = NVL(LENGTH(REGEXP_REPLACE(SUBSTR('bb222',1,2), 'D', '')),0)) AND…

It appears you need to include the A/P Account in the field mapping! Seems to work now.

Are you including Line ID?

I was able to use it, just needed to include a criteria in the saved search. Thanks!