JP-112

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

in FORMULA (TEXT) GROUP Comment by JP-112 Feb 6, 2020 4:14AM

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

in Search to identify bills that have changed in value after they are paid in full Comment by JP-112 Jan 30, 2020 10:42AM

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!

in Validate Line Function Script Comment by JP-112 Jan 30, 2020 9:10AM

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 =…

in Validate Line Function Script Comment by JP-112 Jan 14, 2020 8:36AM

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

in Validate Line Function Script Comment by JP-112 Dec 20, 2019 4:30AM

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;…

in Validate Line Function Script Comment by JP-112 Dec 19, 2019 8:15AM

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.

in Credit Notes/Memos associated with a customer payment Comment by JP-112 Feb 5, 2019 11:49AM

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

in Credit Notes/Memos associated with a customer payment Comment by JP-112 Feb 6, 2019 11:22AM

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…

in Compare two fields Comment by JP-112 Jan 30, 2019 9:57AM

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

in Vendor Payment CSV Import error Comment by JP-112 Mar 20, 2019 4:38AM

Are you including Line ID?

in CSV Import to update existing custom fields Comment by JP-112 Mar 20, 2019 10:07AM

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

in Workflow Saved Search Condition Comment by JP-112 Feb 28, 2019 10:58AM

JP-112 Red Ribbon

Comments