Olivier Gagnon NC Red Ribbon

So, you send people a piece of paper telling you how much they owe you, and they pay it, but it does not hit AR? How does that work? What should be the GL Impact? I'm guessing it hits a sales account, but what's the offset?

I can't think of any other way.

Check out Home->Set Preferences->Transactions->Auto-Fill Transactions

Were you dating your Inventory Adjustments in the past, or always dated the current day?

We have a customer with similar restrictions. Solved the problem using scripting.

Concerning your question about Inv Adjustments listing 0$ - NS uses Average Cost, not Purchase Price or anything else. So if your item has 0 on hand right now, your average cost is going to be 0 and thus the up adjustment will default to 0. In this situation, you should manually provide the Unit Cost to use.

Generally speaking, the SO is considered useless once an Invoice is issued. The SO is non-posting, the "truth" is the Invoice, the SO is just a warm up. So there generally aren't any status changes going on on the SO after you've actually invoiced it. I don't know, maybe you can add a junk item, and then Close that item.…

If it's just a Reporting thing, I'd but a custom checkbox on it and then customize the report to ignore SOs that have this field ticked in or whatever.

Yeah, some odd behaviour in there then that I can't really explain.

Yes, but only by using scripting

You can CANCEL SOs that have not been yet approved You can CLOSE SOs that have not yet been fully fulfilled and billed Closing a SO that has been billed (but, presumably, not fulfilled) will simply prevent the SO from being fulfilled. Once the SO is billed, I don't think you have many options to take it off the "Booked…

No, there is no netting in Netsuite. There is no impact to the functiality, the Vendor and Customer are considered to be completely independant for financial purposes.

Depends how you record your traval charge. The most complete approach would for the employee that travelled to enter an Expense Report, charging all expenses. When entering the expense report, the user can tick in the box to Bill Customer for the expense, then you can use the Invoice Billable Customers for that expense. If…

Your best bet would be to use suitescript to cause a smart cascade delete. Otherwise, you're looking at manual work. I would take the customers with a "marked for deletion" checkbox, and then run associated record searches (transactions, events, etc) and shift-click delete each search one at a time. Would take several…

Shipping costs come out as a line item on the invoice, not as a column. So you'll either need to use some grouping+formulas to shift lines to columns, or just go with a multi-line layout rather than many columns.

There is an amazing amount of factors that could be at cause. I can't say anything without detailed analysis.

While I cannot give any sort of ETA, I do know for a fact Inventory Adjustments are being worked on to be exposed to CSV import. In the meantime, we have often used the common trick of a custom record + scripting to allow Inventory Adjustment import via CSV for small jobs. For larger/ongoing jobs, we and several other…

I concur with Wally's sagely advice.

Here are the GL impacts of the various transactions. So let's say I am buying a widget at 100$ on the Receipt but I correct it to 150$ on the Vendor Bill: PO (non-posting so who cares) Purchase Orders CREDIT 100$ Inventory DEBIT 100$ Item Receipt Inventory Received Not Billed CREDIT 100$ Inventory DEBIT 100$ Vendor Bill…

Do you need the accounting features that come with Drop Shipping/Special Ordereing? Specifically, do you need the COGS to take the price of the PO, or would it be alright if the COGS used avg cost like a normal PO would?

You're actually correct there is no direct link between Item Receipt and Bill. The linking element is of course the PO, and after that it basically matches items by internal id and some other elements I think. The match ends up pretty accurate, I don't think it's ever mismatched anything, though if your business had the…

That is not a Special Order, that is a Drop Ship order. Use the drop ship functionality and this should solve your problem, as this is shipped to the customer.

Discount items can either post their rebate to a specified account, or deduct directly from the AR of the transaction. You can make this decision on the item when you set it up. If you don't want to have to manually detect when to add the discount and then add it yourself, you could consider using Kits to package certain…

Yes your calculations are correct. Your certainly right it's not very easy to determine what the problem is. Your best bet is to start with the Inventory Received Not Billed ledger. That basically contains your error + what is legitimately received but not billed yet. So the tricky part is chopping out the legit part, and…

Peter Are you saying the Vendor Bill Variance functionality affects inventory values? Does it retroactively do so?

Lots of people have this problem. I think it sounds like you are aware exactly of the problem, but a lot of users don't know the price on the Item Receipt MUST be modified, not just the value on the Vendor Bill. So this problem often comes up. One solution we have made before for users is a script that simply monitors…

Might be possible to add custom fields with this info. You might be able to source the info, I don't remember if you can fully source address or not. Then you would need to modify the PDF printout to use the sourced fields. If you're using integrated shipping, or generally speaking need the *real* shipping address to be…

Non-Posting it the option that removes from AR, as above.

I am not familiar enough with the functionality to say. However, it SOUNDS like it gets rid of the cumulated value in the Inventory Received Not Billed account, without actually incrementing your inventory value. In a perfect world, you want your inventory value fixed as well. HOWEVER, fixing your inventory value for…

Selectively answering the bits I know off the top of my head- 3. I have £40,000 in "Inventory received not billed". This means that my stock in undervalued by that amount. When we have subsequently sold that stock, does Netsuite calculate our profit and loss based upon the actual vendor bill or on the incorrect under…