MikeGodbout Red Ribbon

Thank you!!!! The creating a custom role was the piece I was missing.

Thank you for your responses. I went through them and had already done everything that was presented. I'm using the administrator role for the profile. I even went into "Global Permissions" and enabled access token management and log in using access tokens there, but as you can see from the attached image I don't get…

Yes and through upload. So far I have created a custom item field. I can populate that through a JE and a JE upload. Unfortunately that doesn't populate the native item field. I'm thinking I need a script that would run periodically or whenever something is keyed into the custom item field, which would automatically update…

Thank you for your reply. We do not have SAML turned on. The profiles are the same. One of the individuals is an administrator. They had no issues before.

I was able to find my issue. The "Account" field requires the entire Account number and including the text. I was only using the number. This is apparently different than my uploads into the transaction file in another template where I just specify the number. I want to thank Tigran VERY mch for all his help on this.

It is coming back with the 25 Internal ID with me using the entity name so it is a valid match. I had tried a different subsidiary before and got the same answer. I'm going create a brand new csv to see if there is something I did wrong. I want to thank you again for you time on this. I will let you know what I find. have…

Ok - I just did the upload again changing the account number to be the same as the second account, basically putting an out and the in to the same account. It comes back with the same error.

I believe you wanted me to enter it manually through the form. It went in without an issue.

BTW if it helps this is the account in question

Invalid account reference key 863 for subsidiary 25. This is the message if I do that. By the way. I neglected to thank you for trying to help me. I really appreciate it.

This is what the pencil shows

FYI - I noticed a mistake in my question. To avoid confusion when I said customer I really meant custom. Thanks

I am basically modifying another upload that has no issues. When you are asking about the Name or Internal ID are you referring to the entity name or the GL account number?

One quick update. Although it didn't change what happens, I have since changed the status in the customer transaction type to "posting". I ran the upload again and it still fails for the same reason.

What steps did I do? I grabbed the wrong entity to dispose of leasehold improvements. I uploaded the asset numbers using a template as a csv through Fixed Assets>Transactions>Asset Disposal selection. What was I expecting? I was expecting to dispose of the proper assets and not make a mistake disposing of the wrong assets.

Thank you for the quick response. Is there a way I could generate an invoice at the master account level and then subtotal it by the sub account customer?

I realize I neglected to mention something. The Product sku is the custom field and it does not currently exist in NS.

We are in the process of working on this, so I can't provide screen shots. However think of it this way. We want the ability to produce revenue reports showing monthly earned revenue like this: For each of the above lines there would be multiple product sku. We want to show revenue for each product sku. Then revenue could…

Thank you for your reply. You provided the answer that I was hoping was not the only solution. I have to create another account for this.

Are you saying that the report will not have a limitation if I run it as a scheduled report?

Usually is a relative term. During the course of a month looking at accounts for close or analysis purposes we do not have an issue. It is when we try to produce reports for the auditors that we have issues because we are trying to run them for such a large volume of transactions. I have attached a screen shot of the error…

Thank you for your response. I was afraid that would be the answer. I will have to make JEs to remove the foreign currency to an put the local currency in.

Thank you for your fast reply. We really want the last payment date to appear on the aging. You did confirm that it can't be done in the AP aging. Your saved search suggestion would have to be married to the aging through a formula. My boss is not going to want to spend any time doing that. Thanks again.

Thank you very much for the reply. I have finally gotten permission to reopen last year's books and dispose of these assets. Unfortunately now depreciation has hit in January. I will take a look at your methodology above.

Micah, Thank you for your response. I have been doing the csv upload. The issue is if the asset is still depreciating or it depreciated to a point beyond the date it was actually disposed Netsuite will not let you use the actual disposal date. What I have been doing is to do the csv upload and then go into each disposal…

One more thing. If it helps anyone, I did speak with a Netsuite support person at the manager level. She confirmed that the eliminate flag is not available in a saved search or report. She did come up with a solution that I have now looked at but need to play with it more. It is building a new Transaction Dataset…

Hi - I wanted to circle back around and tell people I found my answer. We had created a new account that inadvertently did not have the eliminate intercompany flag or the revalue opening balance flag turned on. I turned it on and went back through the entries that had been booked in the account and manually coded the…

I refreshed the sandbox. The fist month I have issues with is June. I reran the close eliminations, revaluation, and for May and June. Not changes to the balances. I went through the intercompany eliminations report and did find a transaction for each of three months that did not eliminate fully (which I need to review),…

Before I start let me say thank you for trying to help. I updated our sandbox, reopened the first period in question. I reran the closing back to revaluing the opening balances through the end. Nothing changed, so I still have the same issue. If it was an issue with the consolidated rates it would have fixed itself the…

Thank you for your reply. I was off for a couple of days and am just now getting back to it. I'm not sure going into my sandbox and comparing it to production would be useful. I don't know the last time we refreshed it. As an FYI I am and administrator. Also I'm not sure why we can't run intercompany eliminations multiple…