Yes that is weird. A few possibilities I can think off the top of my head. Are you using Advanced Shipping and Advanced Receiving where you have separate Item Fullfillments (IF) and Item Receive (IR) transactions? If yes, then neither the SO or the RA has any G/L impact. Rather the G/L impact occurs with the IR and the IR…

I think I saw somewhere that you should return the item to the same location where it was sold from, and then use inventory xfer if you need to move it to another location. Costing is done per location.

Phil, I really think the correct option will be to use the new Restock? function in 2008. Let's review the G/L entries: Sales Side: (1) Sales Order - Cash Sale No G/L Entries (2) Item Fullfillment - Credit Inventory (reduce) Debit COGS expense (increase) (3A) Cash Sale - Debit Cash Asset (increase) Credit Sales Revenue…

Phil, I have a couple of ideas for you. We have created inventory sub-Locations to represent A stock, B stock, C stock within our warehouse. You could create another sub-Location called something like "shrinkage". Return the vapor items into the "shrinkage" inventory location and then periodically do an inventory…

There may be some type of sales & returns analysis report in the canned reports that breaks-out sales vs returns (dunno--don't use it). But, if not, you could probably create a custom report or transaction saved search that filters the transaction detail by (amount < 0) (because returns would be a negative amount in the…

Good point, Ray. So maybe you filter by tranaction type instead, for example, Tran Type = Credit Memo or Cash Return. (Although that wouldn't find if you did a return as a negative qty line item on a new Invoice). This is more complicated problem on further thought....

Hi Kathy. The feature to decline a mismatched AVS is a value-add feature offered by the gateway Cybersource. However, Visa & MC do NOT support this feature. So what Cybersource does, is locally changes the auth response to decline when sending it back to NS. So NS thinks the auth was declined. In reality, however, V & MC…

Yes, some customers have their Verisign Payflow Pro gateway security settings set to DECLINE any mis-matched AVS's. Then there is no way to actually put those mismatching transactions thru since they will always be declined due to the security settings. So I think this checkbox tells the gateway to ignore an AVS mismatch…

Tracy, the text you pasted here as the revised text looks exactly the same as the incorrect text... every instance of "name" should be "item name" (generally speaking). There is a weird sentence grammar so you've separated "item" from "name" but that makes it confusing. In NS, it is called "Item Name" so that noun unit…

Cybersource should be able to shut-off the AVS mismatch feature for you. FYI, "AVS mismatch decline" is a value-add feature that most of the gateways offer. What it does is to return a decline response to the requestor when the AVS mismatches, even though V or MC approved the transaction. A lot of merchants like this so…

Will, I assume you are using the "Accept Customer Deposit" function in NS which books it as a Liability on the Balance Sheet. If so, you can create Journal Entry to Debit your Accounts Receivable G/L for the amount (and make sure to put your customer's name in the "name" field so NS books the receivable to that particular…

Mike, that's a great idea to create a 2nd A/R account. Then you can pick which A/R account when you Accept Customer Payment and keep all the deposits in the 2nd A/R account. And that 2nd A/R acct will print as negative (contra) A/R under the real A/R account on the balance sheet, which is sort of correct theory. But, how…

You probably have to fiddle with the PDF layout to provide room in the layout for the Amount Due box to have room to appear on the form.

Angela: "Record Customer Deposit" credit Customer Deposits liability gl account (a system-generated account), and debits Undeposited Funds. That why they don't show in A/R..because they are aren't being posted to the A/R gl account. Then on the Accept Customer Payments function, there is a tab for "Deposits" that will show…

Yes I agree that it is stupid that the Customer Deposits are not netted with the A/R. The Customer Deposits don't show on the Customer's balance on the customer record, on the aging, or on the A/R report. Really dumb design I agree. You could record the prepayment as an Accept Customer Payment, which would post as negative…

Barry, has a good solution. Or, we put a Customer Message that says "DO NOT PAY THIS INVOICE IT HAS BEEN CHARGED TO YOUR CREDIT CARD ALREADY". And then we customized the Invoice form and added the CC# and Payment Method fields and Terms (of "Prepaid") to the body section so it prints the last four digits of the CC# and the…

I already voted back on 2/11/07. Maybe they'll install this by the next decade :) I also included in my description, that they modify all the A/R reports to contra the Customer Deposits so you can get an accurate net A/R that the customer really owes you after the Deposits are deducted. So not just show us the # on the…

They just added it. So if you have customized forms you won't see it. You have to be an Administrator and go to Setup > Customize Forms and you'll see 3 types of SO's listed. You'll have to create a customized version of the new flexible SO form if you want to use it and you use customized forms.

In the previous versions of NS, there were only 2 types of SO's: Sales Order - Invoice and Sales Order - Cash Sale. These were hard-coded to turn into the indicated tran form of Invoice or Cash Sale. In the new version of NS, they added a more intelligent "maleable" type of SO which can turn into either a CS or an IN…

Do you key all the retail sales under a single customer for each store location? If so set the Ship To address of that customer to the store's address, and the NetSuite's normal tax assignment should look at the Ship To address (which is the store's address) and then assign the correct tax code based upon the Ship To…

Yes, since you have an office in Dallas, you have nexus in Dallas, and the state can then force you to collect tax. That is correct logic. That's generallly how nexus works in all the other states, too. In California, technically we are supposed to collect the tax for the delivered TO jurisdiction, but if I don't have…

Nope. Again, it is calculated on-the-fly when you generate the B/S. The most current fiscal period will go into Net Income, and all prior periods earlier than that will go into Retained Earnings. If you want to see the numbers, what you do is run the I/S for the same period and you will see that the Net Income on the I/S…

No. No. No. NetSuite will AUTOMATICALLY dump the Income Statement net number into retained earnings for you whenever you run an income statement. It does this on-the-fly. So do NOT enter a y/e closing j/e as this will cause the behavior that dfranchak describes, which is the I/S will then show 0 if you try to run it at a…

Or you can go to the individual customer's record, click "Accept Payment", then go to the "Deposits" tab and you will see all the unapplied deposites listed. If you click "Mark All" it will total them for you and show you the total up in the Deposits tab (just cancel out so you don't save all the marked ones by accident!)

Also I believe there is a system-generated account that is an Other Asset where they park the value of the unbilled Cash Sale. We use Coastal EFT, and if the EFT rejects on a CS, I will get a debit to this system-generated account to warn me that I now have a receivable on the balance sheet. I'm not sure of the exact…

You customize the Payment tab on the Cash Sale form to make any of those fields mandatory then they can't leave it blank.

Brian, the Cash Refund versus Credit Memo is determined by why type of Return Authorization you created. There are 2 type: RA - Cash Sale & RA - Credit Memo. You have to create the correct RA in the first place to end-up with the correct end result. You can't switch types. So to Evan's advice. Open the first wrong RA. Use…

By the way Evan, this would be a useful enhancement to be able to change one type into the other. I have the situation all the time where I have a Cash Sale that I use Coastal EFT to collect. The Coastal ACH bounces. So now I have to go void the Cash Sale and create an Invoice instead. It would be really great if there was…

When you put an Item onto a CS or a CM, it should flow as a negative amount into the Income account that you have set on the Item record. They both use whatever Income account you have set on the Item's record, so I'm not sure how you are getting 2 different accounts. Could you paste here the GL Impact lines from both…

This is all related to the design flaw that once you turn-on allow per-line departments, the mainline of the transaction (which is the b/s line) gets a BLANK department, class, or location. See this thread. Please chime-in your vote that this needs to be fixed!!! https://usergroup.netsuite.com/users/showthread.php?p=32790