My Stuff

Nick Horowitz Green Ribbon

Comments

  • Hey Eric, I just sent you a private reply. Thank for finding this out. So everyone, now we have some more detail. You must call PayPal and tell them you need the OLD LEGACY 2.0 Payflow protocol with PayPal acting and the acquirer. Again, the off-the-shelf WPP 3.0 does NOT work -- it is the wrong protocol. You have to call…
  • 2 suggestions: (1) Just close the Sales Order and it will go away as being open. Go to the line items and there is a checkbox for "Close". Just close all the lines and it will go into completed status. Option 2 will take some fiddling. Basically you create an Other Charge Item, and pick your A/R account as the income…
  • oya, I bet if you look at Paymentech's surcharges for non-qualified & mid-qualified transactions, and rewards cards, and business/commerical cards, and foreign cards, that you will find that PayPal's blended rate is cheaper overall, because PayPal has NO surcharges. And Amex is certainly cheaper.
  • Payflow keeps the money in your paypal account online. You have to manually ACH the money to your bank account periodically. Yes PayPal show you exactly how much discount was deducted from the txn. And PayPal refunds the discount to you if you issue credits back to your customer! Or you can use your PayPal debit card to…
  • Once a void, always a void. Do NOT try to unvoid a transaction. NS will let you do it, and it looks okay on the screen, BUT that txn will be EXCLUDED permanently from ALL financial reports WITHOUT any warning! So use the make a Copy function and create a new txn from scratch.
  • Kewl. Didn't know PayPal added auto sweep feature! That is great. So that eliminates the last competitive deficiency.
  • Erik thanks for documenting the problem and the fix here. This is the first time in 2 years that we've actually seen exactly the technical problem, and how to fix it. So thank you for being the guinea pig and documenting your findings for the UG.
  • Do a Cash Return for the negative quantity item (but actually put a positive qty on the Cash Return since it is implied to be negative)
  • Don't know. But if you put a subtotal line it will subtotal everything above it, then put the discount line underneath and it will apply the discount to the line above (which is the subtotal line). This behavior works just like QuickBooks.
  • NS will AUTOMATICALLY zero-out all the I/S statement accounts, and post them to the system-generated account called "Retained Earnings". Now, you have probably added a number to this system-generated account and moved it into your COA. Since this is hard-coded in NetSuite, you cannot change it. So you are going to have to…
  • You can override the taxable flag on the line item on the PO. Did you accidentally override the flag? And the PO as a whole must be set in the header to be taxable and a tax jurisdiction selected in the drop down. And then the ship to address must not be out-of-state (out-of-state is automatically tax exempt) If all of…
  • Hey Barry. Don't have the CPA designation, but I have an MBA in Finance and you know m NS and credit card processing expertise from all my posts on the user group. I've been the CFO for a tech company in San Diego for past 10 years which has now ceased operations. I am looking for free-lance work with NS customers. Could…
  • Roth, if you don't have a problem with the prior periods being locked, then this is easy. What you have to do is Void the first invoice (or delete it). This will cause the SO to go back into "Fullfilled but Unbilled" status. Then go to the original SO, and click "Bill" button, and that will create a new linked Invoice.…
  • NetSuite supports Level2 purchasing card and commercial card with some caveats. V & MC require 2 additional fields of data to qualify for Level2: Sales Tax and Customer Code. First, you'll notice the "Customer Code" field on the payment tab. This is the customer code that goes to V/MC and passes back to the card issuer.…
  • Putting Inventory items on unlinked CM's or IN's impacts Inventory!! Unlinked meaning a CM not spawned from an RA, or an IN or CS not spawned from an SO...impacts Inventory. (In contrast, if using an RA, then the IR impacts Inventory, or using an SO, then IF impacts Inventory). An unlinked CM like you are doing WILL affect…
  • Thanks Malin, that was it! Can you have the doc folks add that tip to the online docs.
  • There is a list of Employee Expense Report categories which you create & define, which links the "friendly" name of the expense category to a specific G/L. This is so employees can pick an easy "friendly" expense category name from a list rather than having to know your company's G/L. Therefore, since you have control over…
  • Erik, yes, then I would create a separate payment type called something like external as Vijay suggests. This is best practice anyhow, since your external batch will be paid into your checking acct as a separate ach credit than your NS internal batch. So you want separate payment methods anyways so that you can group your…
  • Do you exclusively process all your credit cards outside NetSuite? If so, just create a new Payment Item for External CC's and make sure NOT to check the "Credit Card" box on the payment item...then NS won't even know that payment type is a CC. If you do both internal and external CC processing in NS, then unchecking the…
  • Yea, and if you Invoice and Fullfill in different months/account periods, then your rev & exp are mismatched in different periods too!! (another design flaw in NS)
  • You were just upgraded to 2008.2 this past weekend, so that is probably the difference. Evan Goldberg did mention that they were changing the way they do duplicate detection, so that is probably what happened. Read my post below about the 2 ways that transaction numbering can be handled in NS, and then you may have to…
  • Jesus, there are 2 ways for NetSuite to assign transaction numbers. The first way, which is what you have, pre-assigns the transaction number when you first pull-up the screen. You can see the transaction number on the empty screen. In this scenario (which is your problem), the 2 rep's will pull-up the screen and they will…
  • Steph, that sounds like a bug with the duplication detection on the RA. Open a ticket about the bug. RA should behave exactly the same as IN for duplicate detection.
  • Just make sure you have your G/L mapping set to where you want the Transaction Discount to flow into.
  • That sounds like a bug. The status should be "Closed", or the same as if the entire PO has been received (or every line item had the "Closed" box checked). Try approving the PO and see if the status changes to "Closed". By the way, NEVER try to resurrect a voided transaction. NetSuite will let you unzero the lines and…
  • I don't know, but you may try checking on the forms customization for Bills to see if there is a tab with System Notes showing the changes.
  • Try the percent sign. I think it will trigger an on-the-fly math calculation to be done on the line above it (just like QuickBooks)(If you want all the lines, then you may have to include a subtotal item line first, then the % line). If that doesn't work, you may have to create a different type of item--a Discount item.…
  • Yes you can have a negative charge -15%. Credit Memos (& Cash Refunds) behave backwards. So, if you put a positive # on a CM, then it increases the amt of the CM. If you put a negative # on a CM, then it decreases the amt of the CM.
  • Depends if you have the option to use reversing journal entries for voids activated, or not. If you are using reversing journal entries, then YES you should see both the debit and the credit in the account. If you are NOT using reversing journal entries, then the transaction amount is just changed to zero and it will show…
  • Per Theresa's post, the solution is to turn-on the new costing feature (but be warned it may screw-up you old numbers), and then when you create the RA, make sure you spawn the RA from the previous IN (meaning go to the IN, and click the "Create Return" button on the invoice), and then the RA will pick-up the costing from…