Right! My mistake. It is Metavante!

Well, that is my work-around I suggested to handle split tender situations(multiple payments). So, if you look at the G/L Impact, it should look like this: Debit A/R (Increase) by amount of payment line Credit Sales Revenue (Increase) by the amount of the merchandise lines Note that above G/L Impact looks exactly like the…

The person who created the record is already stored in the record as one of the canned system fields. This issue is how do you read that canned system field. It seems redundant to be storing it in a custom field when it already exists (perfectly) in the canned system field. Evan, is the createdBy field accessible on…

Ok, after much fiddling, I got it to work. Here is the secret: Your custom field will NOT show-up in the drop-down list unless you CHECK "Store Value" on the Item custom field definition. BUT, the problem is then once you activate storing the value, the Item records are all initialized with null (not with your {internalid}…

Glad that was the problem, Melissa. FYI, NetSuite has a design flaw in this area. Creating the RA from the Sales Order versus from the Cash Sale is actually not the problem. One would assume that if you created the RA from an SO-Cash that it would default to a RA-Cash Refund form type, and likewise if you create an RA from…

I voted for it. You're up to 4 votes now.

I assume you are trying to add a custom Transaction Column field? On the "Validation & Defaulting" tab, notice there is a checkbox for "Formula". Check that box. Then in the "Default Value" field put the code for internalid. I looked-up in the ScriptSuite Reference, and the fieldcode is: {internalid} or {externalid} I am…

If you want to use the "Record Customer Deposits" function in NetSuite, which records it as a liability on your balance sheet, then use a Cash Refund and pick Cash as the Payment Method (or use Credit Memo & Issue Customer Refund and pick Cash as the Payment Method)--put into Undeposited Funds. Then use the "Record…

See my post here with a formula: https://usergroup.netsuite.com/users/showthread.php?p=64367#post64367

DaBomb, if you accept payment in advance, you really should be using Cash Sales, and not Invoices. So in the future you can save yourself a ton of grief by using Cash Sales. Now to clean-up your mess, if you want to do it manually, you will have to visit every customer and click "Accept Customer Payment" then you should…

Hi Misela: There are 2 fundamental different process flows in NetSuite: Cash Sales and Invoices. Cash Sales NEVER post to A/R. The Cash Sale will credit sales revenue and debit undeposited funds. Invoices DO post to A/R. The Invoice will credit sales revenue and debit A/R. And remember there are 2 types of Sales Orders: SO…

It should be "Amount Remaining" (not amount due). Amt remaining is always the unapplied portion of any transaction type. What is the larger problem you are trying to tackle, i.e., why do you need this search?

nhorowitz@axeus.com

Something doesn't sound correct here. NS only supports 2 check layouts: The 3-checks-to-a-page, which is 3 business size checks on one page with no voucher (NOT the 3 personal size); and the Voucher style with the check in the top 1/3, the middle 1/3 is a voucher and the bottom 1/3 is a voucher. You have to set which style…

Ah, now that you explained about your nested sub-customers....it does sound like a capacity problem. For clients like you, NetSuite does offer an option where you can have your account hosted on its own dedicated server (instead of being shared with other clients). It costs extra for this option, but may be worth it for…

When you check the "To Be Printed" checkbox on the Bill Payments, they are queued in the Print Forms queue and the check# won't be assigned until you actually print them. You can find the print forms queue here: Transactions > Management > Print Checks & Forms.

Maybe this is a dumb observation, but shouldn't the customer have received a copy of the Cash Sale form in the package and each CS form would correspond to the charge on his CC stmt? You could write a Transaction Saved Search (not a report) where Tran Type = "Cash Sale" and Date range = between and Customer = x and that…

NEBS gives NS customers 33% off your first order at this link: http://www.nebs.com/NASApp/nebsEcat/products/partners/index.jsp?partnerID=64244 But you can use any Quickbooks-compatible checks from any vendor. Costco has 500 for less than $40 bucks. Word of caution: Costco has versions with lines for Payee and Amount and…

In theory, you should be able to write a javascript that would give a popup box if the Month of the Tran Date < Accounting Period. I don't use scripting, but you'd have to do this on EVERY transaction form (which may not even be available for customization), or possibly you could do a server-side script to enforce this.…

We use accounting periods. In fact, with accounting periods, you get the best of both worlds, because you can put an old date on the transaction, yet have it post in the current accounting period (for example an 11/11/2007 transaction can be posted in May 2008 accounting period). Then you can even run reports to see what…

Sometimes you get "orphaned" credits that get disconnected from being applied to what they should have been applied to. In this case sounds like you have 2 credits: Bill Credit and Bill Payment (both are credits essentially). NS has a trick "backdoor" method to get those credits applied to a debit item. Basically, go to…

Well, in NetSuite's defense, the design is to utilize the existing Intuit Quickbooks check stock, so the layout limitations are constrained by the global objective of using Intuit's check stock.

Gerry, glad we could help! One other thing to watch out for, you should turn-on the option to use Adjusting Journal Entries for Voided transactions. The reason is that once you lock the old period, you can NOT void a transaction anymore because it would affect the old close period. Whereas if you have the Use Adjustment…

This sounds like a problem with your version of Internet Explorer and/or version of Javascript. What version of IE are you using (or are you using another browser)? What version of Windows? If you are using IE, try CTRL-F5 on every page to force a complete reload of the html and javascript from NS's servers. Especially…

The instructions for ordering Intuit checkstock from the preferred vendor NEBS are in the online help. https://system.netsuite.com/help/helpcenter/en_US/Output/Help/Accounting/Banking_CheckForms.html#1032191 NetSuite checks can be purchased from the NEBS Web site. The following NEBS checks are compatible with NetSuite:…

Thanks for the compliment, Cecelia. When you click "Save" on the IF it fires the COGS recalculation logic on the NS side. Even if the COGS calculation came-up to be the exact same value, it nonetheless is trying to write the newly calculated COGS value to the IF record which is prohibited...hence the error. I think really…

I think support gave you a wrong answer. I think the "Allow Non-GL Changes in Closed Periods" option was working exactly correctly, and that you were blocked from modifying the IF due to NS trying to modify the COGS G/L as we have been discussing on this thread. I would say that the "Allow Non-GL Changes in Closed Periods"…

Cecelia, the IF record does the following G/L entries: credit inventory (reduce) and debit COGS expense (increase). NS does an on-the-fly calculation for COGS using FIFO, LIFO, or Avg Cost however you have yours set. The problem is that this constantly changes. So if you go back and edit the IF, necessarily, the COGS will…

Sanda, I have not tested this, but IN THEORY, if you use the "Authorize Return" button on the Sales Order, it should link the RA to the SO (since the RA will be spawned from the SO). If you look at the RA spawned in this manner, then you should see the "Created From SO12345" field in the header. I am pretty sure they are…

See answers below: *************** Results as follows: - Create seperate location = still pushes stock level up. Making SKU's instock which are out of stock. This is correct result. You will need to train your salespeople to not sell from that location, and also you will need to periodically write-off that stock to an…