Angela Bayliss · Senior Solution Architect · SuiteMaster

https://community.oracle.com/netsuite/english/discussion/comment/16856152#Comment_16856152 No. The last count date is set based upon the last inventory count transaction. It cannot be modified by scripts (and shouldn't be). This field is designed to report accurately for audit purposes. If it were editable, inventory…

Create the item with a -1 after it. Then go to items-list- open all filters & show inactives, and sort by item name. You should find the duplicate item in the list. If you don't, file a case with NetSuite. Everytime I have encountered this, it's due to an inactive item with the same name. Might try clearing your cache if…

https://community.oracle.com/netsuite/english/discussion/comment/16858981#Comment_16858981 You have an add on (Paid for) module that alllows you to do this. It's native, but not free. ~angela

https://community.oracle.com/netsuite/english/discussion/comment/16858606#Comment_16858606 It's checked by default, and should be unchecked if you want to see who creates records. And no, it won't work for existing transactions/records. ~angela

https://community.oracle.com/netsuite/english/discussion/4492832/powerbi-and-tables-in-netsuite WHen I last worked with Power BI (3 years ago), the biggest issue was that the Power BI team will set up all reports for you from NetSuite. If you want any report changes, only Power BI support can update them. So you may not be…

You cannot source a field when the fields are different types. Try this: Create a custom list of your 'territories'. Update the subsidiaries with the custom list valiue. Then set the sourcing field type to 'list - Territory' and you should be able to source from there. Also note - The subsidiaries are tied to the…

https://community.oracle.com/netsuite/english/discussion/comment/16858781#Comment_16858781 Don't feel like an idiot. All of us are learning different pieces and modules of NetSuite all the time. At least you have an easy fix! Have a great day. ~angela

Ah. In that case, it's more of an internal process than a NetSuite setting. For example, if your accounting department wants to run balance sheets by department, then users should ensure departments are set for all balance sheet accounts. NetSuite can support many different processes, but it cannot define the process for…

I'm not sure what you mean by 'account rules'. There are account types, they can be available to individual subsidiaries, or all of them, they can be restricted to departments or classes, etc. Customers and Vendors are tied to specific subsidiaries, unless you have multi sub customers/vendors enabled. Transactions for…

Go to Setup>Accounting>Accounting Preferences, and ensure that this box is checked: Dumb setting, and is not checked by default. ~angela

https://community.oracle.com/netsuite/english/discussion/4492762/change-customer-type-on-the-customer-record I'm not clear on your question? You can change a customer type to individual on the record itself, via CSV, etc. What is your actual question? ~angela

Oh wow. Another way you can do this is to create a saved search. Use the Suiteanswer # 72893, which has a table of 'applied to' & 'applying' transactions. Just a thought. ~angela Applied To Transaction Type Type Applying Transaction Type • Purchase Order • Item Receipt Bill • Bill Credit • Bill Payment • Vendor Return…

The only times you would expect that the system notes subtab is empty is if the box is checked, OR you're looking at transactions cloned into a sandbox environment. ~angela

https://community.oracle.com/netsuite/english/discussion/comment/16858592#Comment_16858592 Do not check that box! It will remove all system notes for records when they are created. I asked about this box because your transaction didn't show any system notes, which may occur if the box is checked. Please uncheck the box. My…

https://community.oracle.com/netsuite/english/discussion/comment/16858586#Comment_16858586 What you're mentioning is more of a process, not something managed in NetSuite. Users should be trained to not delete any rules. Note that users may create new rules as needed, to manage transactions that may not have a rule defined…

There is a free bundle by RSM 'Mass Delete With Saved Search' (234093) that works to delete multiple records using a saved search. Install the bundle, create a saved search of records to delete, add the search internal ID to the script deployment, and watch the records go away! Its a slick way to remove as many records as…

Any users who will be performing the bank matching for reconciliations will need full access to the reconciliation rules. Without permission, they will not be able to use the rules for reconciliation. I hope this answers your question. ~angela

https://community.oracle.com/netsuite/english/discussion/comment/16858400#Comment_16858400 As this is a system limitation, you won't be able to create a single bill and apply it against item receipts from different purchase orders, unless you are using inbound shipments. What you can do is create multiple vendor bills in…

You can easily customize your aging reports to filter out the intercompany accounts. Is this what you're looking for? ~angela

https://community.oracle.com/netsuite/english/discussion/4492745/permission-for-access-token-missed-configuration Try logging in as an administrator. The 'access token management' is a specific permission/role that can be used in place of an admin login. Another trick when setting up an integration employee record is to…

https://community.oracle.com/netsuite/english/discussion/comment/16858454#Comment_16858454 Perhaps if you communicate your case # here, and reach out to your AMO and ask that the case be escalated. The NetSuite users here seem to be helpful when you have a specific case to reference. Good luck! Crossing my fingers for you!…

OK< You tested this really well. I suggest you both file a case with NetSuite, push until you get a defect number, then let all of us know so that we can also get attached to the defect. The louder we are, the better odds of this getting fixed. It's clearly a bug. ~angela

All Period close activities must be completed manually. ~angela

https://community.oracle.com/netsuite/english/discussion/comment/16858332#Comment_16858332 It may look 'Odd' and you can edit the way it prints, but it is providing the information. It's not applied, and it's a customer deposit. Note that you can edit the layout. ~angela

https://community.oracle.com/netsuite/english/discussion/comment/16858431#Comment_16858431 You can try filing a support case, but I don't guarantee it'll be successful. I know this isn't the answer you want - but I'm pretty sure that it's too late. ~angela

https://community.oracle.com/netsuite/english/discussion/4492730/best-practices-for-multiple-ship-too-address When you enable the multi shipper on orders, each line may have it's own ship to address. You will need to split lines to support the different addresses. You won't be able to split one line and send to different…

If you're within 72 hours, you won't be able to cancel. ~angela

You can select 'Backflush' which allows you to create a completion & issue the components at the same time. ~angela

N/Task

https://community.oracle.com/netsuite/english/discussion/comment/16858217#Comment_16858217 In the results subtab, add the same formula except just use {quantity}-{quantityshiprecv} as the formula. The result is the open quantity per line. ~angela