Angela Bayliss · Senior Solution Architect · Gold Crown

Hi @User_8LGY2 By design, and administrator role has the 'override period restrictions' permission, so they can create/edit/delete Journals in closed periods. It's weird to me that there is a JE that you cannot edit as an admin. Especially if the transactions are in a closed period. UNLESS one of the journals has been…

Hello @Judith Culanding-Oracle A NetSuite account manager will not be able to provide information on 3rd party apps.

Hello @User_8LGY2 Are you using the admin role? What account types are on the editable v not editable lines?

https://community.oracle.com/netsuite/english/discussion/comment/16911290#Comment_16911290 Hi @Dext3r It may be showing the correct value, but if the value isn't stored, you won't be able to report on it. I've run into this a lot. My dev guys would script the setting of the value into a stored field from the sourced field…

Hey @Dext3r I'm a little confused about your approach. I think you may be overcomplicating it. If the account is set on the vendor record, can you source the department field from the account, and set the main department field on the vendor with a workflow? I haven't tested this, but the logic should be straightforward.…

@Elina Kourouzidou I don't believe that custom segments are supported in budgets. Suiteanswers ID 43584 has this note I'm sorry it's not the answer you want.

Hi @User_7SNLJ What a great question! In my experience, when migrating anything that can possibly throw an error message - loading these into production and managing them afterwards is easier than you may think. Have your NetSuite partner use 1 user login to migrate the customizations into your production account. This…

Hi @JM Benitez Is the item on the work order in demand? I've seen this happen when the built items were 'reallocated' to a different SO. If the built item is serialized or lot numbered, is it still available? Again, I've had this occur when people take the built item by reallocating it to a different SO. The only way I…

Hi @fworkman Which system is your system of record for accounting?

@Dext3r Kit items aren't really items though, it's a group of items you're selling together - like item groups. They just slap a different income account on the group. The availability won't show for the kit's themselves like you can for assembly items - because a kit is a group of different items, not a single item with a…

C

Hi @Vishnu Raj Absolutely it's possible to update via script - especially if you're using a custom record to store the data you're transferring into the item record.

@Ramu Komireddy_9891 Please reference the suiteanswer article number when you quote suiteanswers? It helps others find the information.

Hi @Owen_Ramirez In that case, you'll need a script to update the pricing after the substitution. It can't be done natively, I don't think. Sorry it's not the answer you want.

Hi @Ashoka_Sanjapu You can do this easily by clicking 'More options' and then clearing the checkbox labeled 'Show Zero's'

Hi @Owen_Ramirez Natively, the only way to have continuity on item pricing when using a substitute item it to ensure both items have the same price set for the price level you're using. I hope this helps

Hi @Thom62 I have confirmed with the creator of Coupa that this suiteapp will handle your specific requests. I copied your request and sent it to him, and he confirmed. Good luck!

Hi @User_JFFD2 I actually understand what you're looking for. Do this: Reports >Financial>Trial Balance>Customize When the page opens, click on the 'account' column the 'Group' checkbox is checked - uncheck it click 'Preview' This should be inline with what you're expecting to see?

Hi @Dext3r Your SO's are showing kit components due to a setting on the kit that says 'Display Components on transactions'. This is why the components are visible Kit items are not actual items, they are individual items that are sold together. Hence, the components showing on the transaction is a sublist pulled from the…

Hi @Bret Busse The only way I think this would be possible is if the naming convention of the files ties them to the corresponding expense report. Otherwise I don't think this is possible. Sorry it's not the answer you want.

A search is going to give you information about the files, it won't give you the actual image of the receipts @Stephen Lemp Hi @Bret Busse - There is no native feature that will allow you to export the transactions and the associated receipts with them. What are you trying to achieve?

Hi @Thom62 I'm checking with a few of the AP OCR vendors I work with. I'll come back and let you know what I find out.

Hi @Vishnu Raj In that case, you'll need to use your custom page for the pricing history. NetSuite doesn't capture the pricing history on items natively. To fix the issue, you'll need to include the currency for the purchase price. Do this - go to an item and try to update the preferred vendor price manually. You'll see…

Hi @User_1D0ZP The bank information at Payment Processing>Bank Details will provide zero value as you won't be able to transact and your bank details will then be available to all accounting users. If that's what you want, awesome. If an auditor sees them visible without restrictions, you may fail an audit. Good luck!

B

Hi @Audrey G. NetSuite won't allow you to replace the Retained Earnings account with any other account. That's as designed. I'm sorry it's not the answer you want.

Hi @Febin Antony , For any inventory items, you won't be able to set the items to 'Can be fulfilled' checkbox - you can do tthis for the non inventory or other charges - so that takes care of those item types. (Note that any existing orders with these items won't be affected and you'll need to fulfill those) For the…

Hi @Wishal44 , If you're using a custom billing schedule for this, then your only option will be to create an invoice for 0 manually. NetSuite won't calculate the first one due to the limitations on custom schedules. I hope this helps!

Hello @User_BCKYD, Payment terms appear on the following standard sales transactions: Cash Sale Customer Deposit Customer Payment Customer refund Cash sale refund I have to disagree with @Tigran Shahnazaryan There is no 'payment method' on the standard forms for these transactions: Bill Payment - Has a check number, but no…

Hello @User_X5ETD It looks like the wrong prepayment account was used originally and was updated after transactions were created using the incorrect account. Can you go to Setup>accounting>Accounting preferences. Once on this screen, go to the the word 'more' in the upper right, and hover over it and select 'Audit Trail'.…