My Stuff
Going to SuiteWorld? Connect with SuiteGurus—Your NetSuite Product Experts!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Comments
-
Why don't you get it out of the bank account G/L instead of out of A/P G/L? The check in the bank account would have the correct post-discount amount. You can use the Cleared? checkbox in the check register to mark those items that are cleared. And then when you do your saved search, you just filter for the uncleared items…
-
I am pretty sure it presents a warning box and you can choose whether to unapply the payments, or not. Maybe your clerk can do it differently so they don't get unapplied. Editorial note: that is just a stupid feature in NS!!! Same problem with reconciling your checking account--if you edit a reconciled transaction, it…
-
YIPIEE!!! Glad I could help. Let us know about your next annoying issue.
-
Do any of the items pull-up, or none of them? Did you make sure to go add the Vendor Name in the Name field on the J/E's first? There must be the Vendor Name on the J/E's or else the J/E's definately won't pull up.
-
Check and Bill Payment are not the same thing. If you write a Check and offset it to A/P, that is not linked to the Bill at all. It is just a stand-alone check. These would show as negative items in your A/P because they aren't linked to the Bill correctly (and you should also see the Bill as being open on the A/P aging)…
-
RBS Worldpay is the only NS gateway that supports multi-currency
-
You post does not make sense about COGS. If you have Advanced Receiving turned on, then you use the Item Receive transaction to receive the items. The Item Received does this: DB Inventory (asset increase) CR Inventory Received but not Billed (liability increase) Then when you Bill Purchase Order, the GL impact is: CR…
-
Yes, use Transactions > Purchases/Vendors > Pay Bills. This will show you a queue of all open Bills that need to be paid. Check the Bills you want to pay and it will aggregate payments by vendor and print the invoices being paid on the check stub. Or go the Vendor record, and click "Make Payment" in the upper right corner.…
-
Yes Miguel the poor design with periods always bites me in the butt each year. The clerks diligently key their data and NS stuffs the transactions in the last open period with NO warning to the clerks that something is wrong. So by the time you catch it, you have a ton of txns that have to be cleaned-up. NS ought to give a…
-
For the J/E's, if you add the Vendor's Name to the Name field in the J/E, then it will group with that Vendor on the A/P report and that Vendor should drop-off, or at least net to zero. It may not drop-off because again the J/E's aren't applied to the Bills, they are just general offsets to the Vendor's total. Try my trick…
-
There already is a hyperlink in the upper right corner called "Generate Statement". (Look right under where it shows your company name and your role)
-
No. The item field on the line-item will accept either the Name or the UPC code (in case you have a scanner), and will populate with the Name. (So for example you scan the UPC code, it sends that to NS, and NS returns with the Name instead). Change your User Preferences so you don't get the drop-down, but rather just an…
-
This is a linkage problem. Bill Payment (checks) are linked to the Bill that they are paying. If you go look at the Bill Payment and look at the Apply tab, what is it applied to? The Bill or the J/E? Next question, when you voided the Bill Payment, that should have reopened the Bill that it had previously paid. So you must…
-
B, you left out an important detail, which is that you have the option activated to Use Reversing Journals for Voids. Unfortunately there is no way to fix your problem because the open Bills are not extinguished on the Balance Sheet until the Date and Period of the reversal J/E. So if you are running a report that only…
-
I am not sure if this still works in version 10, but create a Credit Memo spawned from the original Sales Order. Now put a positive quantity 1 with the wrong price amount (this "returns" the item to your inventory), then put a negative quantity with the correct price amount (this "resells" the item from your inventory).…
-
Both. And that's what you want--to see it in both places.
-
Sandra, this is usually caused by someone posting something directly to the G/L using a J/E or some other weird tran type (this is a bad practice by the way). The A/P report only culls certain tran types. So if you have other esoteric tran types posted directly into the G/L, the A/P report won't pick them up. Run a…
-
If you make J/E entries and post them to A/R or A/P, you MUST include a value in the "Name" field to match-up to the customer or vendor...otherwise you end up with orphaned "No Customer" or "No Supplier" records, as you have found. So just remember that A/R and A/P are grouped automatically by the Name field, so EVERY…
-
The IRNB is a liability account on your Balance Sheet...i.e., you debited Inventory asset on your B/S when you received the inventory, so they have to credit something, and that credit is posted to IRNB which is a liability account (because you owe money for the assets they just don't know to who yet). So this is actually…
-
Yes, just make sure to put the vendor's name in the 'name' field in the J/E for the line that posts to A/P and then it will be allocated on the A/P report. Also make sure to open a bug ticket for the forex issue. Sounds like a bug to me.
-
First of all, you need to check your states escheat laws. All 50 states have laws requiring that you remit unclaimed credit balances to the state treasurer if you cannot locate the customer. So first thing is to find out the law for your state. Assuming you are allowed to keep the credit balance, what you do, is create a…
-
Ok everyone, I got Olivier's script to work with some slight syntax changes. Here is the final version of the script that works below. You need to load this into ScriptSuite as a scheduled script, and then you can click Save & Execute and it will queue it to run immediately. When it asks for the function name, make sure…
-
Dave, there is an option to only show open items. I think you have that option checked. Payments by definition are closing transactions, so they won't show when this option is checked. I think that is your problem.
-
There is a setup option in NS that allows you to be able to Bill your PO in advance of receiving the PO. (Normally you receive the PO first, then Bill it second; but this option lets you flip that around). You need this option turned on or it won't let you Bill the PO first. So after the option is on, then go ahead and…
-
Evan we really need DLE / Bulk Editing for Dept/Class/Location. That is more important than the other fields that you are exposing. Also, we need to be able to edit Dept/Class/Location on Transfers, and we need per-line granularity on Transfers. Otherwise we have to use J/E's to get the granularity.
-
Has anyone written a server-side script to loop thru a set of transactions and update the Department value? I have 40,000+ txns that I need to fix the Department value. Or, has anyone seen some type of utility that uses Web Services to do this? (like the old smbXML Wizard from WebWatchConsulting?) Transactions are NOT…
-
Just put some type of abbreviation in the check number field like OACH, and uncheck "Print", then it won't print a check for you. NS will warn you of a duplicate check # once you use OACH more than once, but just click the button to ignore the warning and keep OACH as the check number. NetSuite treats all debits in the…
-
P.S. Tony, I did some fiddling in my NetSuite account, and you can NOT do what you want unless you have the optional ODBC access to your data. There are linkages in the SQL tables that are only exposed via ODBC. You cannot get the linkages using Saved Searches as I originally instructed below.... What is the larger…
-
This feature has been requested for past 7 years, so don't hold your breath. In NetSuite's defense, the banks are very picky about proper alignment of the MICR line at the bottom of the check. It would be very difficult for NS to control the alignment in a browser even with PDFs given that users have many different…
-
You could do a Transaction Saved Search to create a CSV export of the check data, and then import that into any check printing software. All the fields on that print on the check are certainly exportable easily. The check stub will be a little harder to export. You certainly could do it with ODBC, but I think you could do…