Angela Bayliss · Senior Solution Architect · Gold Crown

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'.…

hi @User_X5ETD When you enabled prepayments, a vendor prepayment account was created in your COA. In the accounting settings you have to set the newly created account to the prepayment setting. Update your prepayment account to be the one created automatically and it should work for you.

A

Hello @Vishnu Raj My question is why update the preferred vendor checkbox via script when you can easily update it via csv? I'm curious. It sounds to me as though you may be overcomplicating the task.

Hello @User_IQOCO THe 'entity' field on the ADJE entries is used when you are eliminating lines of the JE. When you are doing elimination, the 'entity' should have the Intercompany Customer/Vendor that belongs to the line. If you have Parent Subsidiary Entity - IC-Parent Child 1 subsidiary Entity - IC-Child1 Child 2…

Hello @Rachael_Ireland It almost sounds like someone deleted your RP account. Have you checked the status of your RP account at Setup>Company>Release Preview?

Hello @Valdi , #1 - you will need a tax nexus for every state where you will collect sales taxes. Setup>Accounting>Nexus Without a nexus for a state, you will not collect sales taxes in that state. Once you have the Nexus's created, you will need to apply them to the subsidiary where you will be collecting taxes -…

Hello @ABDUL HANNAN You don't include the step of closing the work order. When are you closing them?

Hello @User_1D0ZP If you don't have an account within your COA of each bank account, you won't be able to transact with the account not present. What is it that you're trying to accomplish?