User_ZCWF3 Gold Medal

@kathryn123 - not sure if this would apply to your situation, but some of our auto-emails were getting flagged as spam.

@Jack Daryl Espiel-Oracle , Sorry - I have another question if you're able to help me again. Is there a way for me to set this up so that I don't create an Ad Hoc Queue Request record if there is a Quality Context with a certain name associated with the item?

Hi @Joy Noreen Magoling-Oracle , Thank you so much for the information. We are using Serialized/Lot Numbered Items and Bins are turned on (T) for them. Thanks again!

Hi @Joy Noreen Magoling-Oracle Thanks for the update. Appreciate your help very much!

@Jack Daryl Espiel-Oracle You are the BEST! Thank you for the instructions - they worked perfectly! THANK YOU!!!!

Hi @Jack Daryl Espiel-Oracle , That's a really great point... All of the line items would need to get an Ad Hoc record created. Is this possible? Thank you SO much for your feedback - I really appreciate it

Hi @Jack Daryl Espiel-Oracle , Gotcha - sorry! I was confused by your screenshot and thought I needed to make a custom record. I don't see a way to get the Item and the Quantity from the Item Fulfillment. Can you show me how I would get those fields pulled? Thank you so much!

@Jack Daryl Espiel-Oracle Why wouldn't the record type be Ad Hoc Queue Creation Request?

Hi @Jack Daryl Espiel-Oracle , That's correct. Thanks!

Hi Dominica, I have 3 different PO's open for 3 different components: PO#1 - 200 pcs of component A; 100 pcs ETA 11/15/2022, 100 pcs ETA 12/15/2022 PO #2 - 100 pcs of component B; 100 pcs ETA 2/15/2023 PO #3 - 500 pcs of component C; 250 pcs ETA 1/30/2023; 250 pcs ETA 4/15/2023 These components can be used to build…

 @User_Y9BMT- we had wanted this too and we could not find a way to show the invoices by PAID date...and what happens if an invoice is partially paid? Ultimately, I took the transactions that went into the A/R account (Deposit Applications, Credit Memos, Payment, etc).

Hi @Joy Noreen Magoling-Oracle, I think it would be helpful to clarify what is considered a system vs manual reallocation. Thanks

Hi @Joy Noreen Magoling-Oracle , I figured it out, but thanks for responding!

I found the Ad Hoc Queue Creation Request page, but the available qty field always show 0 even though I have stock in that location. Any ideas on what I'm missing? Thanks!

Thanks, @Niks Blando-Oracle - that seemed to resolve it.

Hi @Mat O2F , what was your solution to the multiple IF's to one SO? Thanks!

Hi @Dominica Sevilla-Oracle , I believe that works! Thank you so much!

Hi @Dominica Sevilla-Oracle , I have the formula set up as you requested and see how the bill to results on the sales order are different than the customer record default bill-to, however, that's not what I'm looking for. I'm specifically looking for sales orders where the bill-to address is "Custom" and not saved in the…

Hi @Dominica Sevilla-Oracle , I updated the formula per above and that doesn't work either. My results include records where the bill-to address is not 'Custom'

Hi @Dominica Sevilla-Oracle , That doesn't work.

Hi @Tafara Yes - I tried it with {customer.address}. It did not work for me. Thanks for your input!

Hi @Dominica Sevilla-Oracle , @Tafara - sorry I missed the msg for the criteria. It's below. I have tried with Main Line True and no Shipping or Tax Lines as well without success.

Hi @Tafara , Thank you for the suggestion. That didn't work for me :(

Hi @Dominica Sevilla-Oracle, From what I can tell, it's not possible. I was hoping that there would be a way to know which specific parts (location, date code, etc) were committed to orders that have not shipped yet. When the parts are allocated from a PO, you can see which specific PO, but when PO parts are received in,…

@Joy Noreen Magoling-Oracle thanks. How did you know this information? Is there a list that says what fields are/are not available for inline editing?

Hi @Joahnna Given Uy-Oracle - thanks again for your time on this. Here is the item portion of the sales order. I've also attached the template source code.

Hi @Joahnna Given Uy-Oracle, That's what I have in my PDF template and it's not working for me. This is what I want reflected: And this is what shows up with that code:

@Joahnna Given Uy-Oracle - I really appreciate your help. It's a standard field introduced in the 2021.1 release. This article goes into a bit of detail on it: https://tvarana.com/netsuite-deposits-and-prepayments/

@Joahnna Given Uy-Oracle any ideas?

@Joahnna Given Uy-Oracle I'm using Advanced PDF