Nick Horowitz Green Ribbon

Wow. I am surprised it is supposed to work via Credit Memo and not Cash Refund. The problem with Credit Memo is that a Credit Memos can be related to many different Invoices and/or partial refund amounts. (Just like how Accept Customer Payments can be related to many different invoices and/or partial payments). So the CM…

Did it work?

You definately want to use the form "Return Authorization - Cash" (because if you use the "Return Authorization - Credit" that only creates a credit balance in A/R. Then you would have to use the "Issue Customer Refund" to refund the credit balance back to the customer, which is an extra pain) Basically if you sold it with…

Post Deleted

Misela, why don't you ditch Paypal Express and instead get a full real merchant account and use the Paypal Payflow Pro gateway, then you can process credits cards using the easy way and customers have a much easier checkout experience. Paypal can be your acquirer bank for you and you will pay the exact same discount rates…

J- In 2009.2, they are adding an InternalID to the Address records, so you will be able to do a CSV import to update specific address records identifying them by their InternalID. I would wait for this update and then do an update. In earlier versions you could only reference a specific address by the address label (which…

Misela, I have found a work-around for you! This is actually a trick we posted to the User Group for handling split tender or mulitple payment types on a Cash Sale, but it works for this situation too! (1) Go to your Items list, and create a Payment Item. Call it something like "Transfer to A/R". For the Account, pick your…

Ok, just to make sure I am clear, the bug then is that the PayPal UniqueID is NOT copying from the Cash Sale onto the RA - Cash form. Correct? Are you spawing the RA - Cash form from the Cash Sale by clicking the "Authorize Return" button? Or are you trying a RA - Cash solo with Transactions > Customers > Issue Return…

Yes, I suspected it is the Paypal Unique ID not populating. Ok, try this. Instead of doing a Return Authorization - Cash, try instead pulling-up the Cash Sale then clicking the "Return" button on the Cash Sale. Does that copy the Unique ID into the Cash Refund form? If yes, then the bug is that is does not copy to the RA…

Is this the one Department field in the header that affects the entire transaction, or is it the Department field on the line-items where you can pick different Dept's per line (those are 2 different switches in Setup)?

Mike, sorry I originally responded before reading your supplement. Ok, you are correct, if you do the saved search from the customer record you can only grab the default Bill To and default Ship To as a CSV export. HOWEVER, if you do the saved search from the Transactions table instead, then you will get a record returned…

Yes it is!! You need to use the Saved Search function. You would use Customer records if you want the data out of the Customer record. Or Transaction records if you want the addresses from Ship to or Bill to as stored on the Invoices. You can pick the separate parsed fields. Or they have one long concatenated string. Take…

Hey Mike. Alas, this is where the value of paying a consultant to help you implement (correctly) would have come in handy. I am not a consultant, but I can tell you from practical personal pain, that it's well worth the money to implement correctly upfront rather than try to go back and clean it up later! Ask Ray Tetlow of…

So Mike, back to Ray's analogy, you have 1 single customer with 7000 addresses stored on the address tab? That can't be the case the NS UI would blow up. So you must have multiple customers but you must be doing some other type of aggregation besides pure sub-customers. As Ray points-out, the best practice is that you have…

The ExternalID is the Handle that you assign in smbXML. If you leave this null, then NS auto-assigns an ExternalID of the format RecType+InternalID, for example "CUST" + InternalID for Customers. So you have only a 1-time window to control the ExternalID, and you must do it via smbXML, otherwise NS will create it for you…

Jedi, NetSuite uses Oracle 10g, so you can search the internet for Oracle 10g or 9i date conversion functions and most of them work just fine in NS. In this case, you would want the CHAR function and then it has some masks to format times. The CHAR is very flexible to format all types of data, so you need to look for the…

Make it Formula(Numeric) and then you can set a between two numbers. TO_CHAR makes it into a string. But then putting that string into a Formula(Numeric) will convert the string back into a numeric. (In theory). If that doesn't work, you can use a CASE statement to do the comparison in your formula, then return a 1 or 0…

Just a thought, maybe the Item Name field which you can source, behaves the same way as on a Sales Order, i.e., if you have UPC Codes activated, then the Item Name field will accept either a name or the UPC code? Just a thought. Give it a try.

First of all, you need to have UPC Codes turned on in your company options. Once that option is turned-on, then you get a UPC Code field in your Item Record. You can use the scanner on the line-item of a Sales Order, Cash Sales, etc. to scan the UPC Code, and NS will populate the item from the UPC Code. (Or of course you…

That what the credit card gateways are for that are already integrated into NetSuite. Don't rebuild the wheel. That is a ridiculous waste of time. Check out these gateways that are already integrated with NetSuite: Payflow Pro, CyberSource, and RBS WorldPay

Did you open a bug ticket on the defective nlapiDateToString({Date}, 'time') has a bug from two years ago? Could you post it here. If not, let's open one.

Wow messy! I don't know Javascript, but isn't there a Javascript function for Substr like in Excel or Mid$ in basic? Your getting the ASCII code and converting back to the Char works but very convoluded.

Hi Linda. We used B2B Gateway for several years. This was back in 2005-2007 before Web Services existed, so we had to manually import smbXML files to bring-in the transactions. I am sure it is much better today with Web Services, because they can do the importing for you completely automatically via WS. It takes a little…

Vesa, there is a Netsuite partner, B2B Gateway, that already has EDI working with NetSuite. We used them for several years (even before webservices existed and we had to do CSV imports). Now with webservices it is quite automated.

chammock isn't the ShipTo on a Vendor record, by definition, the address you would use to ship things to the Vendor?? Just like the BillTo is where you would send the check to pay them.

I agree it is not stored as a date type. It is just regular text/string and you have to analyze MM/YYYY yourself with some script.

Charlie, great script. Thanks for sharing.

Mighty, they are listed in your Netsuite Support Center. However, most people don't have that access in their role (including Administrators), so you first have to go add the "NetSuite Support Center" role to your userid. Log off. Then log back in. Then you'll see it on Support > NetSuite Support Center. Then go to the…

Yes, just remove the "e=T" from the get string (edit=true)

For tax, you would have already refunded the tax on the credit memo. So it would be the exact same impact on tax reports as your system today. The impact on P&L would be exactly the same as today. The only difference would be that the credit balance would be held on the balance sheet as a liability in the gift certificates…