User_V5KBL Blue Ribbon

@Tigran Shahnazaryan thanks, will try and let you know.

@Tigran Shahnazaryan thank you. No, I didn't try to hard code a dummy Customer/Project Name. Did you script with Custom GL plug-in or without custom gl plug-in?

@Angelica Mae Segador-Oracle never mind, I was able to figure it out. Changed the source code to use assign and formula.

@Angelica Mae Segador-Oracle I used ${apply.customfieldid} where customfieldid is the ID of the custom field holding the balance value.

@MTL_MIA thank you!

@Patrick Fresnosa-Oracle I want to calculate for example total sales from last week, not last rolling seven days. I should get the same number for last week irrespective of the day of the week (during this week) that I run the report. @User_ZCWF3 KPI wouldn't work as this is a saved search with multiple columns including…

@Robert Nedelkow-Oracle thanks for the sample expressions above. How about an expression for last week (not last rolling seven days)? The user group link is no longer valid. Thanks.

No, it is not yet fixed.

@SweetBiller did you ever find a workaround different from "creating multiple "weight" units of measure" you described above? Would appreciate comments/suggestions from anyone else especially those in the steel/manufacturing industry. Thanks.

@Jeremy Guimaras -Oracle Yes, I am in Review Documents Awaiting Approval page. Yes, I am experiencing the issue after clicking Apply Filters. To reproduce, create a Vendor Bill and cancel or Reject it. Go to this page, select the Approver, select Pending Approval in Approval Status and click Apply Filters. The Canceled or…

@Jeremy Guimaras -Oracle thank you for your response. SuiteApprovals | Records for Approval portlet only shows what is pending in my queue or where I am the approver. SuiteApprovals | Pending and Rejected Records contain all records with an approval status filter. The Approval Status filter is not working. When you select…

@Jervin Nicholas Teopengco-Oracle Yes, just to remove the "/" OR replace with it with "1" or "-". It is a custom EFT template with xml output.

@EN_HCMC not sure if this is still an issue but consider SuiteAnswers article ID 62029 and adapt it for your file. <#list transHash[payment.internalid] as transaction>Reference Number: ${transaction.tranid}</#list>

@Elychelle Gulen-Oracle we don't use in transit and we did not enable it. Must it be enabled for this work? System says once enabled, you cannot disable it.

@Elychelle Gulen-Oracle my saved search matches your screenshot and preview is returning values, yet I am still getting the "Bank Account Template Error EP_00004 : There are missing or incorrect filters in this saved search" error.

@Patrick Fresnosa-Oracle we need to export Bill Payments along with other transactions via API to an external environment.

@Elychelle Gulen-Oracle is it possible to set a permanent value in cc or bcc of the Payment File Administration email Payment notification page ? I tried different combinations in a workflow but no luck. This is strictly for payments only.

@Angelica Mae Segador-Oracle the above did not fix the issue. <#list payments as payment> <#list transHash[payment.internalid] as transaction> Transaction ID: ${‌transaction.tranid} The above code is listing all invoices in the payment file even though "payment.internalid" is used. How do I get NetSuite to list just the…

@Angelica Mae Segador-Oracle thank you. I used this and it is listing and repeating all the reference numbers for all vendors in each vendor payment instead of only reference numbers that belong to the Vendor. I followed the steps in this article but it returned an error - Displaying all Transaction IDs per Payment -…

@Jervin Nicholas Teopengco-Oracle already tried many combinations of System Notes but it didn't return any value.

@Angelica Mae Segador-Oracle the issue has been resolved. One of the workflows was not released. Thank you!

@Patrick Fresnosa-Oracle Yes, we customized the workflow using saved searches for different departments. Everything was done using out of box features.

@Michelle Jabanes-Oracle we are trying to compare Probability Field in Opportunity transaction to Total (team Total) field in Quota. See screenshot below. If the transaction saved search is based on Quota, Applying Transaction... is not available. If the search is based on Opportunity, Quota is not available. Same with…

@Michelle Jabanes-Oracle no, I am referring to Quota for Sales Rep. Go to Transactions - Quota/Forecast - Establish Quotas.

Thanks @Michelle Jabanes-Oracle Opportunity is not selected in Transaction Types to Exclude from Forecast Reports but I am not able to add a field from Opportunity to the Forecast vs Quota report. The fields are not available and we need the Probability field from Opportunity. The goal is to compare Probability (from…

@carl.billings can you expatiate? How did you bring in Quota?

@Richard James Uri-Oracle I will check and get back to you. Thanks.

@Patrick Fresnosa-Oracle no, I am not. I am asking if the data in the files in Payment File Administration can be accessed via SuiteAnalytics Connect or ODBC. There is an ACH EP Migration Record type (Records Catalog).…

@Angelica Mae Segador-Oracle I was waiting for the outcome of the "internal coordination" with your SuiteBuilder team.

@Patrick Fresnosa-Oracle We were missing the debit side on the original JE for I/C Customer