JohanvL

Hi User_HXWQS, The link points to cashsale.nl ... so you may be right about "Enter Cash Sale".. (Whoever had set it up may have renamed it a long time ago to "Enter Receipt"....so thank you)

in Soap Receipt example? Comment by JohanvL Apr 25, 2022 10:06PM

Hi User_HXWQS, No, I do not want the Item Fulfillment record, nor do I have a Sales Order. I want to directly create a Receipt (without an SO linked to it), add item(s) to that (including the Inventory Detail - Serial/Lot Number), shipping method, etc. Just like when in the UI you go Transactions > Sales > Enter Receipts…

in Soap Receipt example? Comment by JohanvL Apr 25, 2022 9:05PM

Thank you @Mikko De La Fuente-Oracle .. that was very insightful. Glad it's just 1 line that replaces the creditcard line. I just tested it and works like a charm! Thanks, Johan

in Soap - pay Sales Order with cash instead of creditcard Comment by JohanvL Apr 18, 2022 9:24PM

Thank you @Mikko De La Fuente-Oracle . Now I can set this transaction date to a future date, but will this prevent Item Fulfillment from shipping this order until it reaches the transaction date? Or is there something else for that? (I know it's a different question, but it affects this issue) Thanks, Johan

in Is there a way to post a date to a Sales Order using SOAP? Comment by JohanvL Apr 15, 2022 7:39PM

Hi @Leonard Mallare-Oracle , Thank you for getting back with me. I just now refreshed the JS and template files. Result is that ALL countries are available for BOTH billing AND shipping.. which we don't want either... Best regards, Johan

in Reference Cart Country Question Comment by JohanvL Apr 12, 2022 4:22PM

@Leonard Mallare-Oracle , No, that didn't work. It was already set up like that and it doesn't fix the issue. I took a look at SuiteAnswer 43108, hoping that that would work, but that doesn't work either.. it didn't do a thing. (It then also refers to SuiteAnswer 30778, but that doesn't even exist)... Not sure if I'm…

in Reference Cart Country Question Comment by JohanvL Apr 6, 2022 8:46PM

Hi @Joahnna Given Uy-Oracle, It's a CAMPAIGN record. The custom field is a currency field. I tried to fill it through Workflow, but that only picks a few currency fields from the Item record, and not one from one of the pricelevels... So unless I create a hidden field first on the Item record that would fill itself with a…

in Custom CRM field with default value from an Item record Comment by JohanvL Mar 31, 2022 9:08PM

Hi @Leonard Mallare-Oracle , I'm sorry, other items got in the way, so it took a few days for me to respond. To answer your question: This is done through our sitebuilder (Reference Cart) webstore. Thanks, Johan

in Reference Cart Country Question Comment by JohanvL Mar 30, 2022 4:28PM

Hi @Erick Dela Rosa-Oracle , Excellent, thank you! I took your code, and changed it to what I needed it for and it worked perfectly! Thank you again! Best regards, Johan

in Fill a custom field in SalesOrder through SOAP Comment by JohanvL Mar 23, 2022 5:29PM

Thank you, @Joy Noreen Magoling-Oracle , that report is exactly what I'm looking for! I was able to duplicate the behavior from the other report AND add the kits to it as well. Thank you so much! Have a great day! -Johan

in Qty sold by week - Kits Comment by JohanvL Feb 22, 2022 5:38PM

Hi Joy, Thank you for your elaborate response! Yes, I noticed that the kits aren't able to be picked from the record. Is there another record though that would show me how many kits (not the items in the kits themselves) have been sold by week/month? Thanks, Johan

in Qty sold by week - Kits Comment by JohanvL Feb 17, 2022 10:24PM

Hi Joy, I believe it's taken from a standard one, although I don't know/remember which one that was. I've included some screenshots for information that may be of use.. Thanks, JohanvL

in Qty sold by week - Kits Comment by JohanvL Feb 15, 2022 3:30PM

Thank you, @Ivy Lopez-Oracle ! Not sure why I didn't see that before. (I have in the past, but it had been a while, so thank you for pointing out the comment on that field!)

in FedEx integration - customer cost vs shipping cost Comment by JohanvL Dec 22, 2021 6:33PM

Hm.. yes, we are being charged the List Rates from what we can see. Do you happen to have a direct link to that documentation?

in FedEx integration - customer cost vs shipping cost Comment by JohanvL Dec 22, 2021 6:13PM

Hi @Ivy Lopez-Oracle , Yes, I saw that and that's set up correctly. It DOES pick the "List Rate" for the customer.. but it also picks that when creating the label (and therefore charging us the same). I want the "negotiated rate" when it comes to printing the label, if you know what I mean.

in FedEx integration - customer cost vs shipping cost Comment by JohanvL Dec 21, 2021 6:41PM

Thank you. I added a line to my question to make it a little more clear (I hope). It's probably a simple setting, but I can't find it atm...

in FedEx integration - customer cost vs shipping cost Comment by JohanvL Dec 21, 2021 3:11PM

Hi Ivy Lopez, THANK YOU! Yes, I finally was able to put this to the text next to my old solution and it worked perfectly. It now only shows the customers with billed orders! Best regards, Johan

in Saved Search > Customers with All Billed Sales Orders Comment by JohanvL Dec 6, 2021 7:58PM

Hi Dominica, Thank you for your response. I've tried it out and it's not giving me what I would want. With your solution, I would say see a customer with billed, closed and cancelled. However, the customer currently has Pending Approval, Pending Billing and Pending Fulfillment orders. So those are different. What I want is…

in Saved Search > Customers with All Billed Sales Orders Comment by JohanvL Nov 8, 2021 6:21PM

Hi Joy, Thank you for letting me know.. I'll vote there (not sure what it'll do, but better than nothing). Surprisingly, the client was ok with the space in the field, so.. I guess it's ok for now. Thanks, Johan

in How do I remove -none- from a Saved Search grouped results field Comment by JohanvL Oct 29, 2021 2:45PM

Hi Joy, so.. how do I return a null value? I've tried: (Field) - (Summary Type) - (Formula) Formula(Text) - Group - NVL({serialnumbers},'') => this returns "-none-" Formula(Text) - Group - NVL({serialnumbers},0) => this returns "0" Formula(Text) - Group - NVL({serialnumbers},' ') => this returns " " (so.. it's a character…

in How do I remove -none- from a Saved Search grouped results field Comment by JohanvL Oct 27, 2021 3:52PM

I'm glad I'm not the only one with this question! Thank you Jack Daryl O Espiel-Oracle for the csv import part. I had thought of that already for the customer record. I'm with Kastnerd on this one, in that it only takes care of the Customer record. Any related records (Sales Order, Invoice, Item Fulfillment) still have…

in California Consumer Privacy Act CCPA delete user data Comment by JohanvL Dec 29, 2020 9:20PM

What fields in what tables did you update? (what field contains the "Guest Shopper"?) I believe we use the autonumber, so I guess we only need to update the customer name... but I was under the impression that "Guest Shopper" gets filled in somewhere else... not sure though.

in Replace Guest Shopper with Billing First and Last Name Comment by JohanvL Nov 25, 2015 11:37AM

Setup>Website>Setup Website - External TAB Look for "Shopping cart page Continue Shopping link URL". See what this goes to.. and make sure it goes back to your external site.

in add to cart via hyperlink versus a button Comment by JohanvL Feb 17, 2014 3:05PM

Thank you khultquist. I tried something 'similar' (at least, I assume it's similar), by adding another item to the order (incl. nlapiCommitLineItem and after that removing it again). It had the same results: no change in price...

in User event Script doesnt recalculate Comment by JohanvL Feb 18, 2014 4:36PM

Do you use nlapiCommitLineItem(type) after all changes? Also there are some client script functions that address 'firefieldchange' maybe that would work... I know this is a user event but you might consider testing as a client script. Can you post the whole script or the portion of the function that is in question. I…

in User event Script doesnt recalculate Comment by JohanvL Feb 17, 2014 10:56AM

Anyone...?

in How can I change the promocode through a script? Comment by JohanvL Feb 28, 2014 4:30PM

Not sure if this will help, but it's recommended to have an email width of 600px, so I would suggest not to exceed that with the width of your banner. Example of this recommendation: http://www.campaignmonitor.com/blog/post/3478/poll-maximum-width-html-email/

in Banner Size in Email Comment by JohanvL Feb 6, 2014 9:44AM

For anyone else struggling with this, I did find a solution: 1. create a global variable in the tracking module file, before you define the module: var globApplication; 2. remove the call to load script from Mount to app section 3. assign the application ojbect to your global variable during the mount to app method:…

in Reference checkout 2.03.0 - delaying the load sript command for conversion trackers Comment by JohanvL Jan 10, 2017 1:21PM

Not sure if you can know what these pages are if you work with the theme itself and put a javascript in there that checks for the audience and if it's a certain value (or not), it would show a popup...? Just a thought.

in display message if not logged in Comment by JohanvL Mar 5, 2014 4:14PM

Or just use javascript to hide the elements... then you can have it depend on whatever you want (say you only want to hide it for non-registered customers)... To give a hint: Put this in a javascript section: $("#kReferralCode").parent().parent().parent().parent().parent().parent().parent().parent().hide(); (and make sure…

in Hide Promotion code option at webstore checkout page Comment by JohanvL Feb 17, 2014 3:16PM

MFA for Oracle Community

JohanvL Blue Ribbon

Comments