User_V5KBL

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

in GL Impact Lines in Work Order Issue does not include Name or Project Comment by User_V5KBL Jul 8, 2025 5:25PM

@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?

in GL Impact Lines in Work Order Issue does not include Name or Project Comment by User_V5KBL Jul 8, 2025 4:45PM

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

in Print Vendor Bill Balance on Check Remittance Comment by User_V5KBL Feb 4, 2025 6:08PM

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

in Print Vendor Bill Balance on Check Remittance Comment by User_V5KBL Feb 4, 2025 3:09AM

@MTL_MIA thank you!

in Saved Search: Transaction Dates > Last Week Comment by User_V5KBL Oct 11, 2024 3:28PM

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

in Saved Search: Transaction Dates > Last Week Comment by User_V5KBL Oct 11, 2024 1:45PM

@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.

in Transaction Dates This Week vs Last Week Comment by User_V5KBL Oct 7, 2024 3:42PM

No, it is not yet fixed.

in Resolve Vendor Bills Posted on Locked Period Comment by User_V5KBL Oct 3, 2024 1:25PM

@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.

in Is it possible to have a consumption unit of measure that has a different Base Unit? Comment by User_V5KBL Sep 23, 2024 3:25PM

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

in SuiteApprovals Reminder > Pending Approval contains Rejected and Canceled Bills Comment by User_V5KBL Apr 17, 2024 2:17PM

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

in SuiteApprovals Reminder > Pending Approval contains Rejected and Canceled Bills Comment by User_V5KBL Apr 16, 2024 7:14PM

@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.

in Electronic Bank Payments - Custom EP API plugin Comment by User_V5KBL Mar 20, 2024 2:17PM

@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>

in How to add a line of code in bank payment file to display bill reference number Comment by User_V5KBL Mar 15, 2024 5:29PM

@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.

in Bank Account Template Error EP_00004 : There are missing or incorrect filters in this saved search. Comment by User_V5KBL Mar 14, 2024 6:37PM

@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.

in Bank Account Template Error EP_00004 : There are missing or incorrect filters in this saved search. Comment by User_V5KBL Mar 14, 2024 5:03PM

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

in Vendor Payment from Electronic Bank Payment - Undefined Status Comment by User_V5KBL Mar 5, 2024 10:31PM

@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.

in How to customize Drop Down Email Address in Payment Notification? Comment by User_V5KBL Jan 30, 2024 11:06PM

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

in Payment File - Reference Number and Date in EFT Bill Payments Comment by User_V5KBL Jan 26, 2024 5:47PM

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

in Payment File - Reference Number and Date in EFT Bill Payments Comment by User_V5KBL Jan 23, 2024 3:15PM

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

in How to know who is the Final Approver in SuiteApproval? Comment by User_V5KBL Jan 18, 2024 3:11PM

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

in Vendor Bill Created Using AP Automation Does Not Have Next Approver Populated for Suite Approvals Comment by User_V5KBL Jan 8, 2024 7:16PM

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

in Vendor Bill Created Using AP Automation Does Not Have Next Approver Populated for Suite Approvals Comment by User_V5KBL Dec 22, 2023 9:55PM

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

in Forecast vs Quota Report Customization Comment by User_V5KBL Dec 5, 2023 7:00PM

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

in Quota vs Forecast (Opportunity transaction fields) Comment by User_V5KBL Dec 4, 2023 5:35PM

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…

in Forecast vs Quota Report Customization Comment by User_V5KBL Dec 4, 2023 4:24PM

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

in Forecast vs Quota Report Customization Comment by User_V5KBL Dec 1, 2023 4:49PM

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

in Payment File Administration Database Table Comment by User_V5KBL Nov 14, 2023 4:02PM

@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).…

in Payment File Administration Database Table Comment by User_V5KBL Nov 10, 2023 9:39PM

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

in BAFF Payment File Format (Electronic Bank Payment) Comment by User_V5KBL Nov 10, 2023 5:59AM

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

in Clear Intercompany Open Receivables Comment by User_V5KBL Nov 10, 2023 5:57AM

User_V5KBL Blue Ribbon

Comments