Angela Bayliss · Senior Solution Architect · Gold Crown

This can be done using a script. You would need to create an item for royalties, and whenever a customer has an invoice that qualifies, a journal would be created. The formula for the amount of the accrual would be the royalty amount defined on the customer record*Item royalty amount*line amount. To create the JE, the…

WHen you import the addresses, are you importing them using 'override' = true? This is the only way I was able to populate the address in the box without adding the state into the state field on the address. There are some settings that may be applying that could be interfering: Setup>Company>Preferences>General…

Happy to help if you answer my questions. 😉

Thank you for the screenshots. If possible, can you log in using the custom role, and take some screenshots of the record being available to edit for us? IE- log in to that role, take a screenshot of the custom record in view mode, then a second screenshot of the custom record in edit mode? That will help a lot.

Hello there! Let me run some tests and I'll get back to you shortly.

There are a number of reasons why this might occur. Question - do you have the 'bill po in advance of receiving' enabled? Is the PO for items, or expenses? Here is how I would troubleshoot: View the PO - system notes subtab. Look to see if the PO was billed. If it wasn't, then the 2 transactions were never linked. If that…

https://community.oracle.com/netsuite/english/discussion/comment/16877530#Comment_16877530 The resolution of this issue is relative to your costing method. If you're using average costing, the cost of all the components will be calculated into the total amount you build. Which is clearly not accurate. This issue is a major…

https://community.oracle.com/netsuite/english/discussion/4502122/lock-users-from-editing-custom-record-rights-for-custom-roles Can you provide a screenshot of your custom record if you are still having issues?

https://community.oracle.com/netsuite/english/discussion/comment/16878284#Comment_16878284 When you enable A/R, a customer deposit account will be auto generated. So you should already have a customer deposit account within your COA (If the features are enabled). Navigate to Lists-accounting-accounts. Sort by account type.…

https://community.oracle.com/netsuite/english/discussion/4502032/customer-deposit-account You cannot have a separate account for each customer deposit. However, it is pretty simple to look at the default customer deposit account and see which customers have deposits made. It's also recommended that you create the customer…

https://community.oracle.com/netsuite/english/discussion/comment/16878178#Comment_16878178 In the search results, use ID as one column, and Name as the second. What is strange is that these 2 columns are the first 2 default columns when using the 'default' view….

https://community.oracle.com/netsuite/english/discussion/comment/16878094#Comment_16878094 Here is the easiest solution, Suiteapprovals is a free bundle that allows you to create approval rules. This way you're not having to edit workflows, or scripts. If you aren't using suiteapprovals, I suggest that you consider it.

This is a very old thread, closing it out.

The issue I was running into is people accidently minimizing portlets, then calling me asking how to undo the minimize. It's not possible. Good to know. Another training item

Consolidated Payments

https://community.oracle.com/netsuite/english/discussion/comment/16878039#Comment_16878039 And you chose your own response as the best answer. At least I tried.

Create your search - Main Line=false Group the results by Type & item Sum the Quantity and amount columns. Let me know what else you need?

I went back and reviewed this entire post. Question - why not customize the Current Inventory Snapshot report to only show your consignment warehouses? THat report will give you a lot more information about the consignment warehouse inventory….

You should try to make the search results smaller to run the search. Add a date filter, and see if you can get partial results. If you can, expand the filter in small increments - I've had to break search criteria up by Quarter, then consolidate the results to capture a full year. It's not fun, but if the results are…

The next approver could be set multiple ways: If you're using Suiteapprovals, it's set via the approval rule If you're using a workflow, it's set via the workflow actions. If you're using roles to approve the JE's, it won't be set automatically. In order to help you, we need to know what process you're using for the…

Are your items set up with UOM? If you receive pallets, but stock in eaches, you should be able to put the items away into multiple bins.

You can do this with a script, but otherwise, I don't believe this is possible.

https://community.oracle.com/netsuite/english/discussion/comment/16877807#Comment_16877807 https://community.oracle.com/netsuite/english/discussion/comment/16877807#Comment_16877807 Schedule it to run in the background. You can then export the results once it has completed.

True

You can search for free bundles for Mass Delete. RSM has a great one based on saved searches. You create a search of records to delete. Add the search to the script deployment. Save and execute the deployment. It's an AMAZING time saver. Good Luck!

In your workflow, did you set all triggers to be active?

Answer is C

https://community.oracle.com/netsuite/english/discussion/comment/16875293#Comment_16875293 Once the transactions exist, they will not update automatically when another record is updated.

We were able to create a process and script where we allowed 1 line with a single receipt that would match. So if a po has 20 lines, it can have 20 receipts - 1 receipt per line - and we were able to get the 3 way match to work. For my client, this process worked.

https://community.oracle.com/netsuite/english/discussion/comment/16875054#Comment_16875054 Ah! Weird question - don't the users need to populate the fields in the header?