3945492 Green Ribbon

If you edit your custom record and check the box "Use permissions," the go to the Permissions tab, you should be able to set which roles can edit (create, full, etc) this record type. Hope this helps!

Make sure your preferences (Home>Set Preferences>Reporting Search) are set to Reporting by Period - All Reports or None. The bank rec will always report by transaction date, the balance sheet is probably by Accounting Period (as it should be). The difference occurs when a cash transaction has a transaction date in a period…

Does anywhere know how to activate this so our check dates match the date printed? Thanks! -Carrie

We figured it out on our own after calling support but not getting anywhere. We went in and changed the transaction date on the two transactions that were causing the reconciliation to be off as the period was still open (someone put 2007 instead of 2008), which fixed the problem.

We just post a journal entry each time we draw on our line (debit cash, credit the line of credit account) and when we pay it back (debit the line, credit cash). We post any interest charges on it separately during our month-end close/bank reconciliation process. Hope this helps! -Carrie

Well we figured it out on our own....The issue was because bank reconciliation reports will only pull information by Transaction Date (as opposed to Posting Period), so since we use Reporting Periods and have our preferences set to "Report by Period: All Reports," any transactions with a date outside of the posting period…

Thank you, these were both helpful!

Hi Rebecca, You can try changing the width on the PDF form layout as well. We had to play around with the fields both in both places to make ours work. Setup>Customization>Transaction Form PDF Layouts. Hope this helps! -Carrie

Hi Miguel, We were able to add a custom formula field to our invoices, so I would think it should work for Sales Orders as well. You have to add it to the form as a custom column field and then make sure that box is also checked on the printing fields tab. Hope this helps! -Carrie

We have a similar situation, where a customer might need an invoice before our import is complete, so we also manually create those invoices. For the invoice that is imported, we either delete it if the period is still open or create a credit memo to wipe out the invoice amount. Creates some extra steps but this way only…

I was able to import the file using the Import Vendor Bill feature. Since only expenses to be imported (not items), I had to use a Multiple file import - one file is the primary/header information that appears on the top of the bill screen in NS and then the second file has the expense line details. It took a lot of trial…

In the Help Guide, NS has a recommended workflow for vendor prepayments. We use this and it works for us - hope this helps! https://system.netsuite.com/app/help/helpcenter.nl?topic=CARD_-29 -Carrie

Make sure under your preferences you have "Report by period" set to All Reports or Never. If you have Financials Only, it causes differences between aging reports and the GL.

We had the same problem. If you edit the original JE and included a name on the line items and then include that same name on the JE used to clear the account, you can then go in and Accept Customer Payment and apply the payment JE to the original JE. See this post:…

Make sure you set a width for the printing field. Sometimes they hide because their length is not long enough to show as a column on the form. Hope this helps! -Carrie

Will this change the account we're cutting checks from? I want a default cash receipt account and a different cash disbursement account. Thanks! -Carrie

Just in case anyone was wondering, these do appear under the customer payment screen. I had deactivated the related AR account, so once I re-activated it, I could choose it from the AR Account dropdown and then apply the journal entries against each other.

In response to Evan's suggestion... on the apply customer payment screen, none of these JEs appear (both the debit and credit were posted using JEs), so there is nothing there to apply. I will try Julie's suggestion though. Thank you! -Carrie

Evan, yes the JE does have the customer name on the AR lines.

We attach documents to journal entries, so you might be able to do something similar. On the record to which you want to attach the document (the bill?), click on the New Body Field button and set up a new field. You want the type to be document and then when you edit/create the bill, you can attach files there. I would…

That was it! Thanks so much!

We fixed the same problem by changing the selection to "All Reports" just as an FYI...

Thanks! I filed case #619704 this morning regarding the problem.

We have a similar process that we track all of our collection efforts in excel. I opened a ticket with Support about being able to add the User Notes field to reports and they replied this is currently not possible within NetSuite. They added to the list of possible enhancements to be considered for the next version.

I would like to import vendor bills with expenses only as well - did anyone figure out how do this? Thanks! -Carrie

I imported non-address information for existing vendors but there was a glitch with the new version in which all of our existing vendor addresses were reformatted to appear as a single line. So checks are printed with addresses that go all way across the check, not in the 3-4 lines in the address window. We called support…

We have a similar problem (we buy and sell digital media so we never hold the inventory) and in order to get COGS posted timely, we had to use an inventory item. The transaction flow works well (COGS and GRNI is hit timely and then reverses to AP once billed by the vendor). There are downsides to this process as well - the…

We actually use the item type of Inventory, assign a unit cost and quantity on the PO. We have the GL account post right to an expense (instead of an inventory/asset account) and the offset is to a "fees not yet billed" liability. It's then flipped into AP once we receive the invoice, similar to a regular "inventory"…

We had the same issue with the upgrade...apparently it was a bug that was fixed that the fields weren't showing as mandatory on that screen. We're just choosing an Admin department HQ location so that we can continue to process in batches.

Try "Posting Period on Transactions" - I think that should do it!