HoJo Red Ribbon

Jervin, Yes this is ONLY on bills that were created from the integration or bills that might have been copied from those bills created from the integration. Thank you!

Thank you, Jervin. Can a script or workflow be created via a integration? That is the only access the AP Automation service had. And any other script or workflow would have to be authored or authorized by me and I never did. I have searched the scripts and workflows and don't see anything that looks like this.

Angelica, I appreciate the response but the formatting of this formula is probably more involved than I have done in the past and that is why I am reaching out to this forum for a more concrete direction. Knowing how these If statements work, I can't invision how I can use this to calculate a commissionable total in the…

Thank you, Clarisa. The next time I have this issue, I will post a sample scenario. My sales people in the region were asking to change the Netsuite name for Turkey and I was surprised this country name had special characters knowing that I had problems with special characters in the past. I will be sure to post the…

That is interesting. I have had problems many times with imports where ANY fields have special characters and I have to delete the fields from my imports. These are addresses with many special characters. I have never tried ONLY importing that country. Maybe it is allowed for that field/value only?

Why does NetSuite have this spelling of Türkiye as the default country in NetSuite and then not allow special characters in imports. That doesn't make sense and causes a lot of issues for companies working internationally in many countries, including Turkey. I have had employees ask if this default country can be changed…

Thanks for the confirmation @Clarisa De Torres-Oracle The Ready for Tag field is on the body and the Tag Required is on the line. I only want to search SO where the Ready for Tag is checked, but I only want it to return SOs where there are no checked boxes on ANY line for Tag Required. I think I have to use the formula…

Community, I have checked this manually and the formula works with either Sum or Max. The key is that when I had the name and ship date in the formula, it was not working. I am not super knowledgeable about how these summary criteria work but it looks like it was summing by the minimum groupings these two results (name and…

Another possible solution: Edited the summary to Max but kept the formula the same. Removed the name and ship date from the group results. I now have only three returned SOs and I checked them all and none have the box checked. Could this be the ticket?

No Cigar! I have been testing this and it did not work. My search is still returning Sales Orders where the box is checked on one or more lines. I would appreciate any help you can give!!

Ha! I just noticed that the edit to add ' ' around my T did not take the first time. I updated the criteria and now my results are completely blank….which may be correct! I will create some items that can test this and follow up. Please wait to respond. I don't want to waste anyone's time. :-)

I was looking back at my discussions and saw that this one was not resolved. We did implement this through the Electronic Bank Payments , which didn't cost extra for us as the license was included in our package. I followed the instructions in the Help Center to set everything up. The trouble came when the file was not…

Thanks for the additional information. That is too bad. Hopefully NetSuite will offer some updates here but with the workaround, it may not be a priority.

Thanks guys, these are all good suggestions. However, I still have that open question about the status on the Item Receipt. Item Receipts do not have a "status" that I can see and that is the piece I am missing. I need the PO status but also the item receipt status. Because a PO can have multiple receipts and some can be…

Of course! The results have so many fields but the fields in question are: The second to the last line shows the bill on an item receipt. The last line was meant to show Billed or Open based on the two criteria but it isn't working.

I found half the solution. This formula worked for me to only list applying transactions that were actually Item Receipts: CASE WHEN {applyingtransaction.type} = 'Item Receipt' THEN {applyingtransaction.number} ELSE Null END However, I still get multiple lines where an item has both an item receipt and a bill as applying…

I would appreciate if anyone can help with this. I need to show a report that has all open POs, listing the items and on the same row, the item receipt for those items and the status of the receipt (billed or open). I didn't think this would be as difficult as it is. I basically need to remove applying transactions that…

OMG! I had tried that in my variations but maybe I had something else incorrect at the time so it didn't recognize it as a valid formula. One thing I always mix up is whether it is 2 apostrophes or 1. With NetSuite formulas using text is it always 'text' whether you are searching text OR inserting text. Thanks in advance…

I didn't realize this question was still open so I am giving an update. We found a workaround back then but it is NOT ideal. It becomes such a mess to figure out what POs result in the open balance under Inventory Received Not Billed when using the post variances option, we never have variances anymore. We have searches…

Jervin, Thank you for this response! Do you think that a person could do testing while the auto numbering is not enabled and then enable it? Or would the impact be the same. Thanks for the suggestions. We will work around this with overrides since we have to match sticker numbers anyway.

Jervin, Thanks for your suggestion. When I have done this before, I used the same formula as would be used to pull the information in a search. In a search, if I want to pull this data from a Sales Order or Quote, I would use {customermain.custentity_sa_ship_instructions} or even just…

Vote for enhancement 62271 in NetSuite that requests to be able to pay a single vendor for each invoice.

There is an enhancement in NetSuite that you can vote on requesting to pay each vendor invoice with a separate check, but in my case, I would like a separate payment transaction (like with credit cards). See enhancement 62271.

Clarisa De Torres, Thank you for this workaround. This is just what I was looking for!

I have never been able to get the bill and the PO to appear on the same line when there is a standalone bill. However I have created a few workarounds that may or may not make others want to puke. They will take some time to detail out but I will try to do that soon.

Thanks, Joy! So if I understand correct, the components to an assembly can be using any costing method (including lot numbered?) but the assembly that is being made using the WIP process must use average costs? Thanks, Holly

Thank you! I think I was testing this on the wrong item this morning and that is why it wasn't working. I have retested it and it works!!!

@Jack Daryl Espiel-Oracle, Is it possible within this workflow or another to have this also set upon copy of an item so we don't have to recreate items from scratch on items where this field wasn't set originally? Thanks in advance!!

This is answered in the post "Workflow to set costing Method"

Jack, Thank you so much!!! I don't know what I missed different than what you have here but your solution was much more elegant than what I had. I tested it and it works. Thanks so much!! Holly