Thank you. Your suggestion gave me an idea. Because there are numerous open PO's on one customer, I thought to create a new record type for customer PO's, parent on it is = customer. However, I am having difficulties matching the quantity entered in it against invoices. Did I do something wrong?

Great idea, but I need this for just one customer out of the entire file. The rest can be partially invoiced.

The rate pulled in the amount invoiced but I was able to drill down into item cost. Thanks again!

No one knows?

I wanted to create a search to see the invoice amount and item fulfillment amount by item sold. The issue I am having is that it is not pulling the 'amount' from the item fulfillment. I get the IF transaction, the date but not the amount. Below is my Criteria and results. Any ideas? Thanks in advance.

did that and it still didn't work

On the action? It isn't an option. Only on the workflow.

That did not work either. It let me add an item from the search and save. Below is the workflow again and what the search looks like.

Thank you

Another note. I was able to get the item, however, I want the pop up work work on inventory item but it is not part of the subgroup. How can I include the item along with assembly and kit?

Thank you for your help! Case can be closed

Great thank you! I believe that I missed one criteria that you have listed. One other question, is there a way to say, exclude a date along with the above?

Please disregard. I figured out what was wrong. Thank you all. Consider the case closed

Thank you for your reply. I wanted to use workflow so it runs automatically each month. The initial persons reply did help to a point but it is not picking up all parent/child. If I can get it to populate, it should work. Any further thoughts? Thanks!

Or does anyone know what would stop one from displaying in the search? I was looking at our customers and noticed that not all of them are populating on here. Yet when I go to the parent there is a consolidated balance and a listing of subcustomers. Any idea what might cause this?

Thank you. Is there a way to pick one customer or not select one?

Thank you Jam.

Thank you all. That explains it.

Just to be clearer, I want to display the new address field I created as a column header in the customer record under the address tab.

Its above please click on it. Nothing to compare because I cannot add.

I just did thank you. However in my search it will only pull the one line of the entry that I do not need. Maybe something with the script. The below returns nothing. If I use the offset account it pulls that line. I will continue to go down this path. Thank you Ayie.

I could only get one JE to update and it added 2 more lines even though I chose update. There are no descriptions on the JE line and I only want the credit reflected on the customer account not the debit and credit. So still not working. Further thoughts?

True

Thank you all. My issue has been solved

Thank you. However, I am not able to pull up 186610 like 280911. Can you provide what it says? Yes I am using advanced taxes. Thank you

Turns out it is a flaw in NetSuite. So there isn't an answer with it. Thanks all! Consider this closed.

One other question, is there a way to add all item weight on a sales order for a total and not just by line? So the total weight on here is 60 with both items. Thanks again!

Thank you all it worked!

Thank you.

Please review origin based sales (so our sales tax always needs to be our warehouse sales tax for inside Illinois) and the implication of shipping to out of state Nexus. If I use the tax item under financial (IL), everyone, even out of state gets charged our sales tax for our corporate office. If I remove the tax item, in…