I have had very good success with SPS Commerce when I was a consultant.

Yes, it is unfortunate (unlike searches) but I just use more formula fields with Absolute Value.

I know David Smith (he of the Chrome Extensions) has build a script to use a saved search to select the records and then processed by a script to delete them.

Same here. Ours was caused specifically by using the Inventory Location field in the criteria. We got around if by using a formula and using the Internal ID of the joined version of the Inventory Location.

Also to your point about the warning that all data will be lost, if you change the Custom Field definition (ie: Pointing to the new Record) you will still lose your data. If all you are doing is taking the existing list referenced by the custom field you should be OK. I would still create a new custom field to store the…

We have many kits also. We use Fulfillments when trying to report how many of an item are "sold".

Like your question on assembly builds, by chance is the check box "inactive" checked? That would account for no items being displayed here or in the assembly build issue you posted.

Unfortunately this is not possible. I have a customer that as moving to SCA and needed all their items "converted" to Matrix. We ended up exporting all the item attributes and re-importing as Matrix Child records. We renamed all the old items first before importing. We also added a new Custom field on the items for report…

I have a customer that uses at least 90% including SCIS and SCA and then have some that barely use 50% at present but they just went live April 1. The balance of them are also in the 75% range.

If you add directly to an item fulfillment, it is just a "value" going to a Landed Cost category

We have custom fields on our items for Case Quantity which we then populate on the sales order line. We do the math in another Custom Field via workflow to divide the quantity by the case quantity to store the number of cases.

This sounds exactly how NetSuite Item groups would function. If the PTO kit component is marked as a drop ship item, NS will generate a separate drop ship PO for each item in your example.

you could try Case when {custrecord_cd_usage_actual}-{custrecord_cd_usage_included} > 0 then {custrecord_cd_usage_actual}-{custrecord_cd_usage_included} else 0 end

We had the "As of Date" the same and the period was closed when it was initially run. I even ran a search to see any transactions created in April with a date On or Before 3/31/19 with zero results... Odd...

Yes, easiest way is to create another custom field (as stored) and a scheduled workflow (which can read unstored fields) and populate the Stored version of the field.

It's handled exclusively within PayPal like any of their other user options (like PayPal balance, credit card within PayPal. Bad news is, they do not give you metrics on what the customer selected. You have to infer from your sales metrics whether you think it is generating additional sales.

Instead of Country, you should have Shipping Country.

Also, FYI, I believe you could have included the customer name in the results and used the tab Recipients from Results. That way they would only get the segment needed for them?

Anybody? Bump...

Well, One important issue is that you can only setup DKIM email signing for one domain.

Sorry for the false alarm. In all my years dealing with Customers, I have never had one with the Marketing Preference checked to have new entity records default to Soft Opt-Out. Once I realized that and flipped the setting on the contacts, they all showed. The warning (incorrectly showing) that I did not have that feature…

We have the DKIM setup. I know most of these are invalid addresses as my custom imported a ton of contacts from a "list" they purchased. I just want the repeated entries going to the bounced email list. I look at my stats and do not see any additional emails going out and since they are Opted OUT, NetSuite should not be…

This one is great (at least it was for me...) https://netsuite.custhelp.com/app/answers/detail/a_id/21517/kw/Lead%20Nurture

You must be using ODBC. Try doing the initial search using a saved search. Not sure if ODBC might be different.

I am doing a 3rd party integration between CData & Netsuite. I am trying to access data from SalesOrder_ItemList (a CData table). This generates: Your formula contains a reference to a field for which you do not have a permission. I am wondering what permissions I need to add to role I am using. I have added every sales…

I am assuming it is a custom record? So under Custom Record under permissions, you can add that table.

That is why I added the "Assuming the Invoice is created the same day as the fulfillment..." part... As long as what has been shipped is also invoiced it will give you the gross profit of that partial shipment. If you only want to see completed orders, you can add the Criteria CreatedFrom.Status = Sales Order-Billed

I was only making an assumption that it was a custom record. I do NOT know CData or how it stores the data.

I have been able to convince my customers to do the profitability by sales order (assuming the Invoice is created the same day as the fulfillment which we do via workflow) Search would be transaction search type = Item Fulfillments, Invoices, Cash Sales Posting is True add a date range if needed Results Created From…

They should be in the normal transactions table. If you go to Transactions, Purchases, Receive Orders, List. Bring up a receipt and note its Internal ID. (?id= in the URL) Create a Transaction Search and have one Criteria: Internal ID (Number) and set it to the internal ID of the receipt noted above. Click preview. Does…