"Applied To" would be from the Item Fulfillment perspective

An IF is Applied To an SO

though I think in this case, that would be the Created From field

The Apply joins are usually for payments or credits

Sales Orders with no Fulfillments should just be in the "Pending Fulfillment" status

If there is any fulfillment at all, it will move to "Partially Fulfilled"

hello! does anyone know if there is a child table (odbc) to the Transactions table (odbc) that contains an "order status" field?

Although you could still have an SO that is pending fulfillment with a fulfillment created if pick pack ship was enabled and it was picked/packed @erictgrubaugh

@erictgrubaugh @Matt Yes. I'm looking for Sales Orders with -NO- item fulfillment activity/record at all. In our case this might signal that a pick ticket was lost, or was never given to a picker

So, I have a sales order search where the "Printed Pick Ticket" flag is set to "T", and now I need to know which of those have no Item Fulfillment as a related record.

Searching for the absence of something is always tricky in NS; not sure yet if you can do this with a single search

@User uploaded a file:

@Matt @Shawn @erictgrubaugh Somebody posted this a while ago. I think everybody should have it saved.

Perfect; @Shawn just like @Matt said, it looks like you should be able to use the "Applying Transaction..." join to build your search

It’s probably going to need a criteria formula numeric field that says something like "case when applying transaction is item fulfillment then 1 else 0” and then have the criteria set at value is 0. That way it would take out any orders with a transaction.

where can i locate the statement that is used on a customer record? customer > actions > generate statement

Customization -> Forms -> Transaction Forms

under Type = Statement

thanks @al3xicon

know the main difference between Statement PDF/HTML Template & Multi-currency Statement Template?

having pointed the statement towards the Advanced printing type - I get a message: Multi currency customer setting was detected. Please use Multi Currency Advanced Printing Template

i guess i can just use the Multi Currency Advanced Printing Template

@zackb @erictgrubaugh We accomplished the search. We ended up using the RF-SMART picked status as a criteria to filter out items that haven't been picked or partially picked.

Does anyone know of a way to import historical data into NS that doesn’t require the system to reopen and process all transactions as if they occurred at that moment? Working with a client that’s asking if they can import historical orders, etc. that reference items, customers, and accounts that aren’t active anymore, but I’m not sure if that’s possible.

@x97256 maybe as custom records

@michoel can you elaborate?

@x97256 you can create a new custom record type in Netsuite that has no impact on GL, or restrictions of closes periods, inactive items / customers etc.. and store whatever data you want there

@keith: new Chrome release 57.0.2987.110 might resolve sales order line issue

@mattb thanks!!!

did you hear that from NS or is that out? I am at the mercy of an outside firm for browser updates