วีดีโอ

Yes, this is possible. This has to come through via a JE. I've outlined the steps below from a previous requirements document I've put together. Deferred Expense will be established using amortization schedules in NetSuite. The amount remaining in the schedule will be brought in as a journal entry from the go-live date through the end date of the schedule. * Vendors will be referenced in the ‘Name’ field of the journal entry to provide tie back to the vendor record, where appropriate. For each Amortization schedule to be imported: * Debit the appropriate deferred expense (prepaid) account for the full amount remaining to be recognized as expense on a deferred basis. * Credit the appropriate expense account for the amount remaining in deferred. However, on this line item, select an amortization schedule along with a start date of the day after go-live and an end date of the end of the schedule. Note: The deferral GL account may be set on the expense GL account record or defined on a specific amortization schedule template.

Correct, this will send 1 document for each transaction. If you need to send out in batch for the same customer (multiple invoices, credits, etc.), that would most likely require a script.

Not easily. On the Amortization Template, you would need a 'Custom' method. You could then specify a 'Period Offset' to amortize every quarter. Not the most ideal situation as you also need to put the amount when specifying the custom method. Otherwise, you could modify the amortization template once its created to change from monthly to quarterly (manually) or run amortization every quarter and do a catchup for the entire quarter. Neither great alternatives.

Yes, it does indeed

Omg thanks so much! I had an issue with the invoices being sent out with our company header and the data from the invoice but not the original invoice. I’ve been spinning my wheels for days

It looks like it still shows the invoice with our company header. Do you know why it does that by default?

@@jennifer12345678 If you click 'Include Transaction' and then make the Type = PDF on the Email Workflow state, the PDF should be included in the email. Is it not?

@@JRTallman the PDF is included it’s just not the actual invoice from the vendor. It is a pdf with our company logo and the info from the vendor invoice

What are you trying to set as the default? You should be able to set all accounts as default in the actual expense amortization template. All segmentation (department, class, location) will come from the source transaction. Lastly, you can default the template on a purchase item.

Hi, yes this is possible. You need to have the paid version of electronic payments where you can customize the payment file format. You can then change the Output File Extension field to XML.

Thank you!

That would require a script to send the workflow and attach all files. The only option via workflow is if you had a custom field with an attachment. That field (attachment) could be picked up in the send email state. I'm guessing you have all files stored under the Communication subtab though? If so, a workflow won't work. Thanks

⁠​⁠@@JRTallman Got it, that’s helpful. Thanks a lot!

Unfortunately, I don't believe so as it will be copied over from the department from the original source (i.e., Bill)

You should be able to create a generic employee in the system with any email you want to use. Use that same employee as the 'Sender' in the workflow state. That should be the reply to email address

@@JRTallman thank you! I did this and it works for the sender but not for the reply to

@@MollyFlamholz Got it. Please check out SuiteAnswer's ID 78277. This is to be expected. However, the reply should get forwarded on to the sender and be recorded in NetSuite on the related record you are sending it from (Communication subtab). I would send an email to yourself in production and ensure that is the case.

@@JRTallman Thank you! I did receive the email but this will be confusing for clients when they reply. They may think it's Spam as it's a netsuite address and not our companies. Do you know of any other solution?

@@MollyFlamholz In that case, I believe you'll need to set up DKIM for email messages so mail is being delivered by your own email domain vs. NetSuite. Check out SuiteAnswer's 103008. Otherwise, you'll still have the 'sent-via.netsuite.com'

Hi, you may create invoice groups from standalone invoices. (previously this was not the case) Per NetSuite directly, "An invoice that is eligible for grouping is not required to have an associated sales order."

Hello - The customer should only show in the queue once a level is met. Once you send out from the queue, it should only reappear when another level is met. Is it possible to use another customer? Else, make a payment against the existing customer invoice and re-run the workflow so it updates the current dunning level on the customer?

@@JRTallman Thanks for the quick reply. I will try making a new payment against the customer records to see if that does it.

it should include both as long as you are attaching copies of invoices in the Dunning Template list

Did you set the condition on the workflow to execute only with Status = Approved? I would do that then run the workflow on create + edit. Once the workflow runs (Based on Status = Approved), set a checkbox that the email was sent. I would then add this checkbox also into the condition (Checkbox = False). This would ensure the email only gets sent once if someone edits the invoice after it has been approved.

@@JRTallman your advice worked perfectly, thank you so much.

Hello - yes, but the WF will need to run off the customer record (since that’s the only place you can send statements)

Hello - I don't believe the vendor name is part of the RBC positive pay format. I looked under Payments > Setup > Payment File Templates, edited the RBC format, and don't see anything related to the vendor name on the Bank File Templates section. I'm guessing you would need to customize the template to get this added.

Hello - Unfortunately, I do not know what is causing this SuiteScript error. Most likely with one of the scripts on the customer record if you are receiving when checking / unchecking the pause dunning box. You could go into the Script Deployments and undeploy each Dunning script to narrow it down, but that's as far as I would get. Probably best to create a support ticket with NetSuite directly.

I'm facing same issue. Did you get any resolution for the same?

By keeping those fields (Deferral Account and Target Account) blank on the amortization template, these fields will show 'Default' once you save.

@@JRTallman Thank you! Do you know why when I assign a schedule to a line inside a journal entry it is not using the end date I've entered? The end date it is using is the current month end.

@@PeterGutierrez-y7i I'd make sure you are using the standard Start + End date fields on the JE. In addition, make sure you don't have any custom methods set on the Amortization template (and the Amortization Period field is kept blank).

@@JRTallman double checked and I did not use any methods or period dates in the amort. template and the jounral entry is using the standard start and end date fields. So strange this problem is arising. Any other troubleshoot ideas?

@@PeterGutierrez-y7i Unfortunately, no. I assume you tried creating a new JE instead of updating the end date on the existing JE? As long as you're using the standard End Date field on the JE it should use that on the amortization schedule. Might be worth creating a case with NS Support.

Thank you. I don't have a specific import template, but the process should be as follows: For in-flight amortization, these would need to be brought in via a JE. The amount remaining in the schedule should be brought in as a journal entry from the go-live date through the end date of the schedule. Vendors should be referenced in the ‘Name’ field of the journal entry to provide tie back to the vendor record, where appropriate. For each Amortization schedule to be imported: Debit the appropriate deferred expense account for the full amount remaining in deferred. Credit the appropriate expense account for the amount remaining in deferred. However, on this line item, select an amortization schedule along with a start date of the day after go-live and an end date of the end of the schedule. Note: the deferral account may be set on the expense account record or defined on a specific amortization schedule template. Once you save the JE, there will be no GL impact as this will just establish the amortization moving forward.

Thank you! Unfortunately, no way to schedule amortization JE's (unlike rev. rec. JE's where you can)

Hi Ashish - Are you using SuiteBilling? If so, you should be able to create a workflow to email off the billing contact's email address. Otherwise, if you're identifying a true contact on the transaction you're probably best off with a script. Sorry I don't have more information than that as accounts can vary!

i need the same answer 📌I don't know if it will be very different

No video on this as there's a lot of variables on the bank side (host key, username/password, etc.) I'd recommend reviewing NetSuite's Help - 'Setting Up the SFTP Connector SuiteApp' as the best place to start

Hi - NetSuite (by default) doesn't send out to the recipient in sandbox accounts. The email will always get redirected back to the logged in user, which is why you see the email going to yourself (with the originally to...). However, this will get sent to the actual recipient in production!

@@JRTallman Thank you for your prompt reply! Thank you for clarifying the issue! Please keep making more cool tutorials like this one.