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
-
I couldn't get the Custom Body Field thing to work, but maybe you can. Some background... The reason the AmountRemaining suppresses when it is zero, is because the 3 elements are intended to be used together in a stacked block in the totals sections of the invoice-- TOTAL: AMT PAID: AMT REMAINING: Of course when Total =…
-
Ok, you need to move further up the chain. Create a Custom Transaction field in the body, type of numeric, make it NOT saved, and put the {AmtDue} fieldcode in the Defaulting tab and check formula. Then you should be able to pick that custom field in the drop-down menu in the PDF form customization. Try this approach.
-
Use the Sales Tax Payment screen to do your adjustment (i.e., do a phoney payment for the overage). Then use a Journal Entry to offset that payment accounting-wise.
-
Ok, I see what you mean now. You have your form modified to include the "Total Amt Due on This Invoice" field, and that field does not print if the bal due is zero. This looks like a bug to me, not an enhancement request. But I did find some work-arounds: The HTML format instead of the PDF format does print just fine. Home…
-
Write back to support and tell them 94328 should be a defect and not an enhancement request.
-
Try this Oracle SQL formatting function: TO_CHAR({AmtDue},'L99G999D99') I don't know the exact fieldname for amtdue, so just fix the spelling between the curly brackets so the fieldname is correct. The TO_CHAR function in Oracle SQL formats a number according to the format specification. This will show dollar sign, with…
-
Really? That doesn't sound correct.
-
Maybe we're not talking about the same thing. My test: Added an inventory line-item to an Invoice for $300. Add a payment line-item to an Invoice for -$300. Printed Invoice Total at bottom of printed Invoice shows "$0.00" Is this what you mean? Or did you add a custom field to your Invoice to print the mini aging info of…
-
Hi Rafe. The "Memo" line on the check (not the voucher) shows whatever text is in the "Memo" field on the Write Check screen.
-
You need to void all the invoices first. I would do a void rather than a delete so that you keep a placeholder of the previous invoices. Then you can close the Sales Order which will put it into a status of having been complete fullfilled. Or you can void the Sales Order. Or you can delete the Sales Order. But in general…
-
We leave the Invoices open so that we know all our bad debt when working with collection agencies. And we use reversing J/E's instead to keep the Balance Sheet GAAP compliant. In accordance with GAAP, we create a reversing journal entry each month which credits Allowance for Bad Debt (a contra-asset account which reduces…
-
Try toggling the "Print Accounts on Vouchers" option to OFF. Save. Then turn it back ON and save. Sometimes the options need to be re-set after upgrades and toggling it will do this trick.
-
By the way, I think when you enter an opening balance for a new customer record, that NS actually creates journal entry?? Not totally sure, but I think that's what happens. Which then begs the question, can you take the Accept Payment accepted in 2007 and apply it against the Opening Balance transaction (or the underlying…
-
OK, I just tested this. On a brand new customer record, if you fill-out the Opening Balance fields, NS will create an Invoice for that customer which debits A/R and credit misc. income. So it is a real invoice. It does not have an Invoice# (even though auto numbering is ON), but the memo line does read "Opening Balance".…
-
Yes, you can Accept Payment and have it unapplied. That will cause the customer to have a negative A/R balance, and your balance sheet will have a negative figure (because the customer has a credit balance). You can then apply that payment to future invoices using the Accept Payment function again....put zero in the…
-
Make sure you have the setup option ON to show expanded accounts in your drop down.
-
Julie, I saw another post on here with a completely different method that I thought was cool. Using Vendor Credit which then floats around in A/P and you can use that to apply to your Bill when it is time. Check out this post for procedure. You have to use an "exchange" account which is basically a temporary wash acct…
-
This is the edge case where you must log into the Payflow Pro Gateway admin panel and manually void the transaction in the gateway. You must do this the same day before the batch is closed. Then void the transaction in NS so your accounting is balanced. Ray's method will work, but as another user indicated, the cardholder…
-
You also have to make sure you preferences are set correctly on Home > Set Preferences > Transactions tab > Email/Print as HTML UNCHECKED. Each user must set his/her preferences separately.
-
Since they behave the same as Customers, I would assume that the Default Ship To would go on Purchase Orders, and default Bill To would go on Checks. Run a couple of trial-and-error tests and you could confirm this.
-
Julie, there are 2 different areas where you can create reports in NetSuite. One is the obvious REPORTS area. BUT, the other is called Saved Searches. Transactions > Saved Searches > then create a new one there. Your need to reconcile basically to make sure that all fullfilled SO's have actually been invoiced is something…
-
The Fullfill and Bill are 2 separate steps. The best way to make sure you are doing it correctly, is to open the SO, and then use the "Fullfill" and "Bill" buttons on the SO. That will assure that they are linked correctly. What you did, was you must have opened a separate stand-alone Cash Sale and then you would have had…
-
Cindy, the customer:job field is stored on each split LINE of the vendor bill, NOT at the header mainline. So the trick is you have to get a report that displays the line-level granularity for you. Did you try fiddling with the Unbilled Cost by Customer reports?
-
If the Sales Orders say "Pending Billing" status, then you have not correctly billed the SO's. You need to make sure that you use the "Bill" button on the SO, or bulk Billing, so that the SO is properly linked to the CS. I have a hunch that you keyed a stand-alone CS that wasn't linked to the parent SO. You could verify…
-
The Not Yet Charged, are pre-auths done on a Sales Order - Cash Sale. For whatever reason, you did NOT re-use those pre-auths, but instead you must have re-run the txn as a stand-alone sale transaction. You could verify this if the auth codes are different from the pre-auths versus the actual sales that cleared. You must…
-
Ok, here's your confusion. The web does collect their credit card, but it runs only a pre-auth on the SO. So you will see the auth code on the SO. BUT, that is not submitted to your C/C processor for payment until you use the "BILL" button. That is an auth-only. Now, if your cardholder is using a debit card, that auth only…
-
Enhancement 80215 - Accept Payments & Unaffiliated Credits opened 12/9/04 per Evan's request on the old User Group. Obviously nothing has been done on it, but please go vote for it!!
-
Chris, that is a great J/E! Do you also go back an re-apply how the Payment was applied? For example, you should unapply the payment from the underlying Invoice, so that the Invoice goes back into an Unpaid status. And then re-apply the original payment to Line1 of Chris's J/E so that the original Payment and the bounce…
-
Maybe you could use a Statement Charge transaction for the DB A/R piece and CR Bank Account (Lines 1 & 2) and the DB A/R and CR Svc Charge piece (Lines 5 & 6). a Statement Charge is a 1-line transaction that will print on the Statement with the description that you enter. In order to post CR from Line 2 and Line 6, you…
-
There is an option you have to enable which allows you to enter the Vendor's Bill and Bill the Vendor's Bill in advance of receiving the item. You must have that option shut-off. Setup Accounting > Ordering/Shipping > Bill in Advance of Receipt = ON