This is NOT NetSuite. This is a function of your credit card processor. There is nothing NetSuite can do. Basically, if the delayed capture amount and the auth amount do not match exactly, a lot of processors will go get another authorization, this is dependent on what host authorization system that your merchant acquiring…

Each Payment Method in the Payment Methods list has a default bank account attached to it. If you press the "Refund" button from the Cash Sale screen, it will pre-fill a Cash Refund form, and presuambly it will pre-fill with the same Payment Method that was used on the Cash Sale. As Evan was saying, if the Customer has a…

Yes, the Due Date is only stored in the Main Line. Note: Each transaction record in NetSuite is stored as rows in a one-to-many table. The "Main Line" is the header Row 0, and the line-items (called "splits" in Quickbooks and NS) are Rows 1+. The Due Date is only stored in Row 0. So, when tech support told you to include…

I agree with you 100% conceptually, but that's not how databases and SQL queries work. In NS, transactions are stored in the "Transaction" table with all the rows mixed together in the same table, sequenced by InternalID and then RowNumber. Row0 is always the Mainline, and Rows1+ are always the line-item details. Row0…

In order to use Tran Date, you must setup Terms and pick a Term, and then NS will use that Term to calc the date due from the Tran Date + Term. In contrast, in Due Date mode, you can (and must) manually type any date you want in the Due Date field, and NS will use it. You don't have to use Terms. You can pick a Term as a…

If you have it set for Due Date, you have to watch out because sometimes the Due Date field on the transaction is BLANK, in which case it won't age properly, which appears to be your symptom. This can also occur if you forget to pick a Term on the txn, then the Due Date will also be blank, because Due Date doesn't get…

Also watch out because the zipcode field length is limited to 4000 chars. Assuming you have a 5-digit zipcode + comma, that limits to 666 zipcodes. You have to break-up larger cities into 2 separate records (for example, Los Angeles-1, Los Angeles-2)

3 answers to this question: (1) IF you have the C/C info stored on the Customer record, that will pre-populate into any form. However, I think most web orders don't store the C/C info, especially if the customer opts-out of having it stored. (2) If you pull-up the original Cash Sale, and use the "Refund" button on the Cash…

Use a Cash Refund (Transactions > Refund Cash Sales) transaction, put the credit card info in the "Payment" tab, and it will process a credit back to the credit card.

You must be doing something custom to get a line-item level differential tax rate; I haven't played with the new expanded tax capabilities in NS, so maybe you are using some of this new functionality. But, the line-item tax isn't really designed to work that way; line-item tax is intended, for example, if you have soda on…

By the way, all this behavior I am describing is my experience using the UI when I key SO's myself thru the UI. I do not have any experience with online SO's originating from web orders, so I disclaim any knowledge for that area!

The taxable checkbox on the line-item inherits its value from the Item List. So, you need to go thru your Item list and make sure that every taxable item is correctly marked as Taxable in the Item List record. The Item taxability used is to generally classify an item as taxable, or not. For example physical products are…

The Item Fullfillment transaction is what CR Inventory & DB COGS expense. So your COGS expense is not being recognized correctly. Yes I know you are selling subscriptions, and you probably pickup the publishing expense elsewhere when you pay your printing vendors, BUT it's not correct GAAP. Look at the GL Impact on the…

I don't think there is a way to do have a field directly on the transaction, because the entire txn record is locked. BUT, you may be able to have a Custom Record that is linked to the transaction, and then you probably can edit the Custom Record regardless that the txn itself is locked.

You have to make sure "Charge Out Of District Tax" is turned on in Sales Tax preferences in order to cause NS to use the Ship To zipcode to determine sales tax (otherwise NS uses the tax item of your company's address--which is your symptom). Also, you need to make sure that the Tax Item on the Customer's Record is BLANK.…

Why not just Make a Copy of the manually closed SO, and that new copy will have all the line-items open. And then just delete the line items for lines that have already been fullfilled on the first SO.

Done. Thanks, Evan.

They assumed it was an alignment issue, and that it was fixable by fiddling with the horiz & vert alignment...even though I told them that the numbers get chopped-off the right-hand side of the page even with a huge left hortiz alignment adjustment. You should be able to see the PDF sample I attached to this case: Thank…

There is a Horizontal and Vertical adjustment on your personal preferences. Home > Set Preferences. These are stored per userid, so each user has to set their own adjustments depending upon their printer. Also, I cannot get the QB deposit slips to align even using the above adjustment method (the right-hand side gets…

Are you kidding? NO!!!

I assume you are in MI too. If yes, then shut-off Charge Out-of-District Tax, and NS will use the tax rate associated with your company's zipcode as that zipcode is set in company setup section. You still have to put zipcodes in your Sales Tax Item, but you only need the 1 zipcode that matches your company's zip. Or, you…

Yes, in V11 they added a hard-coded Tax Item called "- Not Taxable -", but it doesn't work correctly in several cases, like the one you are describing. But the Taxable? checkbox ought to work correctly. My situation is that I need the Taxable? checkbox checked, but the Tax Item to be "- Not Taxable -" so that when I am…

No. But the work-around would be to put your warehouse's location address in the Ship To, then it would tax correctly. OR, you can manually override the Tax Item and pick the correct Tax Item for your warehouse (and you could probably write a simple javascript to automate this for you on the form).

I guarantee this works-I just retested mine today. Verify that the "Taxable" checkbox on the Customer record you are using is checked, but the Tax Item on the Customer record is blank. (This is imperative). You have to make sure ALL your Customer records are correctly set this way (because NS may not have created them…

Sales Tax IS calculated from the Ship To ZIPCODE. However, there is some incorrect code in the system currently. You need to make sure that the Sales Tax Item on the Customer record is BLANK. Be careful, because the bug is that NS currently defaults the Sales Tax Item on the Customer record when you create a new record, to…

Ethan-the reason you couldn't find the j/e import, was because NS didn't include it in the CSV Import menu where all the rest of the CSV imports are launched--it is off on its own on the Make Journal Entries menu. editoral comment to NS: that's really poor design!

Nope. Not fixed in 2007 Beta. So someone try my work around ideas below and let everyone know if those are viable workarounds...

No Progress. They won't even open a bug ticket, because they think it's working properly. I submitted ticket #550340 on 3/20, but they haven't even started it yet! I submitted ticket #542786 on 3/1. They responded that they didn't think anything was broken. I re-opened the case on 3/5, but the re-opened case has not yet…

Cecilia: I have given-up on NS. I am waiting for the NS2007 beta to be available to me in a few days and I was going to see if they solved this problem in that new version. In the meantime, if you shut OFF "Allow Per-Line Depts" and/or "Allow Per-Line Classes", NS will populate those segments correctly on all lines (the…

That's great Evan, but in the meantime could you fix the Dept & Class functionality in Cases A & C that is broken?