Andrew, we have a similar situation. We created a new Custom Field along with a scheduled workflow. Each evening we use the scheduled workflow to post current open balance. If the Balance does not change, the system notes does not reflect the record was updated. If the balance has changed, it updates the field and our…

As long as the other color Item also has a base price set, when you edit the sales order and change the item, the new Base Price will populate

My first bet is that the customer has 4 items with specific pricing. Try adding a criteria line (this ensures the Pricing Item equals the Line Item: Formula Numeric case when {item} = {customer.pricingitem} then 1 else 0 end Equal to 1

Would you mind sharing screen shots of your search Criteria and Results?

Because of our ($%#&*) WMS, we needed to move to Premium because we needed additional SuiteCloud Plus licenses. Yes, we do see improved performance but we are not even close to any other metric that required a move to Premium (users/transaction count/storage) I also have a friend that is going through the same situation as…

My bet is that it is either not displayed on the default form for that record type OR the field is set to either Disabled or Inline

What I think you want on criteria is "Item on any line" = "PRP". That will return all invoices that have that item anywhere on the Invoice

I do not use SCA but in "normal" NetSuite, Consolidated Invoices do not show inter-mixed with normal invoices. I also doubt that Invoice Groups would show as it is really just a Custom Record that references 1 or more Invoices

Unfortunately, bundle 154385 "SuiteSolutions - Consolidated Invoicing" has functionally been replace by the new "Invoice Groups" (setup - company - enable features Under the Transactions tab, subtab Billing We use the consolidated invoicing and found that now when bugs/issues are found that we need to contact NetSuite…

I have seen this where a user changes the item on a single line invoice that has a same selling price. The item lines do not get recorded in the system notes.

To correct the formula use: You are just missing the CASE function and the associated END Your field name is on the assumption you are doing an Item Search Case When {name} = '12333' THEN '25' ELSE {locationquantityavailable} END

Mikko, Thanks. That did it.

Paul, On the definition of the Custom Record, under the Sublist tab, is there an entry there? I have 1 custom record that I did not define a sublist and it shows on the Custom tab like your screen shot. On another I do have a definition to a specific tab and it appears on that tab name

Sorry, For custom record, that is not needed. Sorry for the confusion.

Paul, Didn't see it listed above but did you create a new Sublist (Customization -> Forms -> Sublist)?

The videos under "https://netsuite.csod.com/ui/lms-learning-details/app/curriculum/a07a0486-683d-4e8c-b81c-f6cdd261055c"

We actually have a custom field on all records that is the formatted link to get back to the record. We use a workflow to set the value. An example, for Invoices, we use the formula: 'https://xxxxxxx.app.netsuite.com/app/accounting/transactions/custinvc.nl?id=' || {internalid} Then we can use the value in our dashboards,…

Martha, It only applies to the Non-Inventory/Other Charge type items.

Martha, based upon the form, it looks like this is an Assembly/Kit item? Can be Fulfilled/Received is not valid for Assemblies/Kits

When I was a consultant, I had a customer using Pacejet to do LTL rate shopping. I believe Shiphark also does but I have no experience with them

If you are going to create the ACH transfer outside of NetSuite, just create a new Payment Method (Setup - Accounting - Accounting Lists) and you can use that to reflect you used ACH

You have to be careful but here is how: 1) Go to Setup - Company - Auto Generated Numbers 2) On the Document Numbers tab, go down to Credit Memo and check the box for allow override. Click Save 3) Go generate the credit memo and you should see that the Document Number/Transaction ID field now allows you to enter your old…

I think if you change the formulas to be MAXIMUM in place of GROUPed you should reduce the duplicates

If you use a Formula (Text) with {incomeaccount.id} it will return the Internal ID of the income account

Finally came up with the right setting:

Yes, what ever sales order you feed should be processed regardless of which customers. I do it via workflow and "should" be the same. We use a workflow as we have fields we pass from the SO to the invoice based on formulas

Martha, Add Mainline=Yes and remove the grouping and you should be good. (Also, make sure the search has Public checked)

Possibly via complex scripting. We unfortunately have to do that on a daily basis

You would need to split the sales order lines. The first would have the quantity equal to the available and the Drop Ship/Special Order selector cleared. The second would be for the balance the customer needs and generate the PO just for that line

We only have serialized but our screen looks like this. You "should" have the line with just Inventory Item. That should be the hyper link to create a normal inventory item