User_ZCWF3 Gold Medal

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

@JohnCirocco that isn't an option on the form sublist fields options. the request is to have it at the line item level so that the person creating the bill can ensure they've selected the correct PO's before saving it. often times we're creating one bill for line items from a bunch of different PO's from the vendor.

My understanding is that ATP cannot be greater than 180. That has been a serious problem for us.

Thank you both!