RobertBongers

Hi Angelica, Sorry for the late reply. 1.Custom Labels Not Showing in WMS Print I have the label setup under WMS > Printing > Templates The labels are Active (inactive is not ticked) I've refreshed and even relogged from the environment I've also created the Report Types where I've connected the Label templates Steps I go…

in WMS Advanced PDF Template Configuration questions Comment by RobertBongers Sep 9, 2025 6:29AM

Hi @Shorin Rio Daa-Oracle Thanks for the reply. I'm I then correct to state that the provided barcode string could be incorrect then? Name: Standard WMS WO Pallet Label with Lot or Serial Advanced PDF Template Bundle: 554701 Record Type: CUSTOMRECORD_WMS_RULE_EVALUATN_AUTOPRINT String:…

in SCM Mobile - WMS - GS1 code scanning Comment by RobertBongers Jun 10, 2025 6:23AM

This is the Return Authorization. The Language is set to Dutch. As you can see the field WMS Reason for Return is in English The Custom List which is in use for the WMS Reason for Return. As you can see this is a locked list since it came in an Oracle Bundle. I don't think it's something we can change ourselves, but how…

in WMS Reason for Return - Translation Comment by RobertBongers Apr 3, 2025 9:14AM

Hi @Alex Joves -Oracle, Thanks for the reply! The settings seem to be correct, but it still prints the Advanced PDF template differently. I'm now thinking; could it be possible to have these buttons behaviours changed through scripting? To get a bit more in depth i've added the exact steps below. Settings: My Preference =…

in Transaction Print button / Print in Customer Locale Comment by RobertBongers Jan 20, 2025 7:18AM

@Angelica Mae Segador-Oracle, Thanks for the reply. The problem is that I can't set both 'width' and 'height' values, because every image we have is different. Some are more portrait, some are more landscape. So when setting both width and height with hard values the images will get skewed/stretched. At the moment we're…

in Advanced PDF Image Aspect Ratio Comment by RobertBongers Apr 11, 2024 6:57AM

I can confirm this worked for me. It now shows correctly on the Invoice PDF who created the Invoice.

in how to get "createby" field from advanced PDF/HTML template Comment by RobertBongers Feb 13, 2024 10:52AM

Hi, The content comes from 'Lists --> Relationships --> Groups'. But yes, The tab on the Customer 'Customer Group' is a Custom sublist.

in How to show a Static Customer Group name result in a transaction saved search? Comment by RobertBongers Oct 25, 2023 6:09AM

Yes, ofcourse. Here it is!

in How to add custom fields on the Statement PDF templates Comment by RobertBongers Aug 14, 2023 9:35AM

Hi @Angelica Mae Segador-Oracle , Ofcourse. Below is the code. The record has been placed just below ${statement.billaddress} on line 188. <?xml version="1.0"?><!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd"><pdfset><#if statements?has_content><#list statements as statement> <pdf> <head> <link…

in How to add custom fields on the Statement PDF templates Comment by RobertBongers Aug 8, 2023 6:14AM

Hi @Angelica Mae Segador-Oracle, Thanks for the reply! I've unchecked the store value box. But once I do that the Print on Statement checkbox greys out. After trying to save the Statement PDF/HTML template I get the same error

in How to add custom fields on the Statement PDF templates Comment by RobertBongers Aug 3, 2023 6:10AM

I've just figured out that the field ${statement.trandate} gives me the correct value. I just didn't refresh the page good enough last time. So i'm leaving this as an answer for everyone here. If you need the Statement Date you can use ${statement.trandate}

in How to show statement_date on Multi-Currency Statement Advanced PDF/HTML template? Comment by RobertBongers Jul 31, 2023 1:03PM

Hi @Angelica Mae Segador-Oracle Below are the screenshots. The same error occurs with all the different ways of trying to get the field in the PDF template.

in How to add custom fields on the Statement PDF templates Comment by RobertBongers Jul 31, 2023 7:30AM

Hi @Kristoffer Viray-Oracle , Thanks for your time! Not really sure why it's not working on my end, but in the end we've settled with calling the fields individually.

in Address form: Address template reorder fields + Advanced PDF Templates Comment by RobertBongers May 10, 2023 12:09PM

Hi @Kristoffer Viray-Oracle, Thanks for the reply! It might be that I'm not explaining it correctly. In that area it shows the right information as well. My issue is that when you print the Advanced PDF template and you use the ${record.billaddress} to show the Address, it doesn't use the custom ordering from the Address…

in Address form: Address template reorder fields + Advanced PDF Templates Comment by RobertBongers May 9, 2023 9:45AM

@GauravAgrawal Yes, calling the fields individually works. But i'm wondering why the Address Template of the Address forms has no influence on that record. What's the use of the Address Template then?

in Address form: Address template reorder fields + Advanced PDF Templates Comment by RobertBongers May 8, 2023 11:30AM

Hi, Just a quick follow-up question :-). I've tried to recreate the WMS Inventory Report by checking SuiteAnswer #72220. Step 2 of this solution states to Create Inventory. We don't have this option in our Searches. We're running Oracle NetSuite WMS 2022.2. Do we need a different version?

in How to Customize WMS Inventory Report Results? Comment by RobertBongers Dec 9, 2022 12:06PM

Hi @Patrick Fresnosa-Oracle, Thanks for the reply. The checkbox is unchecked. (i can't enable it because we're running SuiteTax). I just saw that I didn't include the settings of the Custom Transaction field. Just to have everything shown, i've included it below. Maybe we need to use a workflow to get the contents of the…

in How Populate Custom field from Time Tracking to Invoice? Comment by RobertBongers Dec 5, 2022 7:58AM

@Dominica Sevilla-Oracle , Thanks for the reply! Is there a way that I can follow the progress of that Defect? I tried looking for it, but couldn't find it.

in Why is the amount of Report Builder rounding off on the exported Excel? Comment by RobertBongers Nov 14, 2022 7:53AM

Thanks for the patience and responses @Joy Noreen Magoling-Oracle , I've reproduced the problem through the UI of NetSuite, and I've replicated it today again with a new invoice, with a different Lot Numbered Assembly item (0111.02.0080.330). I got the exact same results (first it's 79,23 until the Invoice, then it's…

in How Could 'Item rate' on Sales Order Differ from Item Rate on Invoice? Comment by RobertBongers Nov 10, 2022 12:29PM

Hi @Joy Noreen Magoling-Oracle, I've checked this immediatly, and thought that might be the case. But the price is just a custom label for the recod 'Rate' I've also checked if there are some workflows who might be interfering, but couldn't find any which did something with the rate/price

in How Could 'Item rate' on Sales Order Differ from Item Rate on Invoice? Comment by RobertBongers Nov 9, 2022 8:49AM

Hi, Yes, rows with the same items should be added together. quantity / total pricing included. So in above example it would be:

in How to Combine Orderlines in Invoice (with SuiteTax enabled)? Comment by RobertBongers Nov 2, 2022 7:27AM

Hi @Dominica Sevilla-Oracle, That is correct. That's exactly what i'm looking for ☺️

in How to Combine Orderlines in Invoice (with SuiteTax enabled)? Comment by RobertBongers Nov 1, 2022 7:24AM

Hi @Joy Noreen Magoling-Oracle, Here is a screenshot of the product. I see it's a Lot Numbered Assembly item. The steps that I make to reproduce are as followed: I'm creating a new Sales Order, and enter the item. I'm putting in a fractional quantity of 71,6. As you can see the Rate here equals 79,23. Then I approve the…

in How Could 'Item rate' on Sales Order Differ from Item Rate on Invoice? Comment by RobertBongers Oct 31, 2022 11:04AM

Hi @Dominica Sevilla-Oracle Here are screenshots of an Invoice. As you can see there is the same product on page 1 and page 2. The orderline on page 2 is the one that coincides with the second bullet. The Customer orders 20 cartons of the product, but for the production process it's easier to create 20,6 cartons instead of…

in How to Combine Orderlines in Invoice (with SuiteTax enabled)? Comment by RobertBongers Oct 31, 2022 8:31AM

Hi @Joy Noreen Magoling-Oracle, We have no Contract Renewals Module in the account. I've just checked the workflows but there isn't any that would change one of these fields. Regards, Robert

in How Could 'Item rate' on Sales Order Differ from Item Rate on Invoice? Comment by RobertBongers Oct 27, 2022 10:10AM

@Joy Noreen Magoling-Oracle , Thank you! That was it! Everything is working in order now.

in Saved Search - Production Quantity Variance Register Comment by RobertBongers Sep 29, 2022 10:03AM

Hi @Joy Noreen Magoling-Oracle, Thanks for the clarification! I see now that i am getting the right amounts, but I have different account names, which is weird. I'm guessing there are more variables in play in our situation than that I know of. Saved search Example Production Variance Example As you can see the amounts are…

in Saved Search - Production Quantity Variance Register Comment by RobertBongers Sep 29, 2022 8:15AM

Hi @Joy Noreen Magoling-Oracle, Thanks for the reply. Yes, i've tried those, but they weren't giving me the expected results. The results didn't match the 'increase' & 'decrease' fields from the Production Quantity Variance Register

in Saved Search - Production Quantity Variance Register Comment by RobertBongers Sep 20, 2022 8:42AM

@Kristoffer Viray-Oracle, Last friday & today everything seems to be working again. We didn't change anything on our end, but are happy that it's working again. I'll be filing the support case soon. Thanks for all the help!

in Advanced Printing Error - com.netledger.common.exceptions.NLUserError Comment by RobertBongers Sep 12, 2022 6:34AM

HI @Kristoffer Viray-Oracle, In this case it's a custom invoice template. There are quite a few User Events Scripts that are running on the Invoice records with before load. The ones that aren't from a bundle have been inactivated but to no avail.

in Advanced Printing Error - com.netledger.common.exceptions.NLUserError Comment by RobertBongers Sep 8, 2022 12:45PM

RobertBongers Red Ribbon

Comments