Hi @Jjzwang , The Bank Feeds SuiteApp is supposed to pull up 60 days worth of transactions from the bank. However, due to different algorithms in security, some banks may only allow a shorter timeframe. Can we check if you were able to map/link the account/s: 1. Setup > Accounting > Financial Institution > Lists 2.…

What bank are you using, @Jjzwang ? ?

Hi again, Kumar! By default, fields that are greyed out cannot be updated even through a CSV Import. I have found an enhancement that was filed to address the same concern. This is documented in Enhancement 143166 Transactions > Financial > Create Revenue Recognition Journal Entries > List > open any Journal entry > Lines…

Hello there, @Jjzwang ! I created this new thread so we can better track our topics. Also, so other members will easily be able to search for it. With regards to your concern, you can refer to these SuiteAnswer Articles: Manual Refresh of Bank Data for Bank Feeds Automated Bank Data Import for Bank Feeds…

Hello @user12240883 ! Could you open the journal entries involved and check if the field for class is greyed out? Let us know so we can further investigate. Thanks!

Hello there, Elena! @User_QHG6U Thanks for creating this thread! Let us help you out on how you can create a saved search for this one. One of my colleagues will be checking on this and will reply with the answers as soon as possible. To our members out there who would like to share their insights, feel free to comment! ☺️…

Hello @Jjzwang One possible reason why you are receiving the error is because the total sum of transactions imported per account does not match the Account Control Total amount in the file. As per SuiteAnswer ID: 88063 | BAI2 File Record Formats, Record 49 Account control total is the Algebraic sum of all amount fields in…

Hello again @jb123 We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would be very much appreciate your feedback and any input you can provide . ? It would also be great if you can mark the comment/s which was/were most helpful for you. Thanks!

Hello there, Igor! Thanks for creating this thread! One of our gurus will be checking on this and will reply to this thread as soon as possible ? To our members out there who would like to share their insights, feel free to comment! Cheers!

Hi there Paul! I checked your screenshots again and it seems like the reason why the Make Auto Create Rule From Selected Transactions is because there is no Payee on the imported bank transaction. As mentioned, Your imported bank line contains a Payer/Payee or Memo. -------------------------------------------- Kindly click…

Hello Tim, The expenses that you have entered on your mobile are actually considered as "expense logs" and not really an expense record yet. They are locally stored that's why you are unable to see them on the UI itself. What we need to do is to create the "Expense Report" on the mobile first and then add it. Here are some…

Hello Jinbai, Here a few guidelines for the file -- For BAI2: File extension should be .txt File name should not exceed 50 characters including the extension Bank Import Mapping subtab in the Account record should have the correct values for Originator Identification and Customer Account Number Date format on the file…

Hello Tim! Could you check if the permission is given to the role? 1. Go to Setup > Manage Roles 2. Edit on the Role 3. Go to Permissions subtab 4. Go to Transactions subtab 5. Under Permission section, add Expense Report with a Full or Edit Access Level. 5.Click Add then save. Let me know if it solves it.…

Hello there @David_NSI ! Thank you for creating this thread! This will be very helpful for our other members who may be experiencing the same. My fellow gurus will be checking this one out for you and we'll see what we can do. To our other members out there who would like to share their insights, feel free to comment on…

Hello Paul, Could you check if the Amount on the GL impact of the account transactions matches with the amount of the imported transaction. Based on my investigation, Tax Code should not be a non-zero tax rate. You must change the tax code containing a non-zero tax rate to a tax code with a 0% tax rate if applicable.…

Hello there again, @User_B1J9S We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would be very much appreciate your feedback and any input you can provide . ? It would also be great if you can mark the comment/s which was/were most helpful for you.…

Hello there, @User_EKY01 We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would be very much appreciate your feedback and any input you can provide . ? It would also be great if you can mark the comment/s which was/were most helpful for you. Thanks!

Thanks so much for sharing that, @Tafara ! You're the best! ?

Hello @jb123 ! You can try this one out --- 1. Navigate to Transactions > Financial > General Ledger > Customize. 2. In the Edit Columns Page, expand the Transactions Folder. 3. Select the 'Created From' field from the said folder. 4. Hit Preview/Save. You can also refer this SuiteAnswer Article so you can further…

If what we want to achieve here is to import our JP Morgan / Silicon Valley bank transactions so we can reconcile them with our NetSuite Bank Transactions, we can the Bank Feeds SuiteApp which will automate the transfer of your bank data from your financial institution accounts into NetSuite. After doing so, you can…

Hi Kf! Since the child account transactions do not show up when you click on the parent account, we can just multi-select the child accounts in the Filters sections. Hope this helped! -------------------------------------------- Kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread…

Could you also clarify if we're trying to reconcile your NetSuite Bank Transactions against your transactions in JP Morgan / Silicon Valley? Thank you. ☺️

Hello there, KF! I believe you can do this through a Saved Search. You can try this one out -- Go to List > Search > Saved Searches > New - Choose Transaction - On the Criteria tab, -- Account = choose the account -- Period = choose the period - On the Results Tab -- Checked the Box where it says "Show Totals" -- Click…

Hello there, @Deepak Joshi ! Could you elaborate more on exactly what we would like to achieve here so we can further investigate on what we can do ? Thanks!

Hi @User_B1J9S , Here are the permissions you need --- This one is documented in SuiteAnswer Article: 91223 - Roles and Permissions for Bank Feeds SuiteApp. Hope this helped! -------------------------------------------- Kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread helpful. This…

Also, just in case you currently have a workflow, this previous discussion may also help -- JE Approval Workflow Email Not Sent ☺️

Hello @User_EKY01 ,m You can follow these steps below: 1. Navigate to Lists > Search > Saved Searches > New > Transaction 2. Set this filter under the Criteria tab > Standard sub tab, Type = Journal 3. Set the following under the Email tab --Send Email Alerts When Records are Created/Updated = True --Enter value under the…

Hello there again, Kev! @User_B1J9S We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would be very much appreciate your feedback and any input you can provide . ? Thanks!

Hello there again, Jonathan! @User_YAIGW We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would be very much appreciate your feedback and any input you can provide . ? Thanks!

Hello there, Kev. @User_B1J9S Changing the account on the source/destination accounts on the allocation schedule will not affect the previous journal entries that were made. This change will only apply moving forward. If you want to change the account on the allocation journal entries, here's what you can do though:…