Olivier Gagnon NC Red Ribbon

No, not as a saved search. You would need to use a scheduled Workflow or a Scheduled Script

Ouch. Ok - *cracks nuckles* - let's start talking bout this my friend. Alright, so let's start with a 1:1 mapping. 1. You make a first PO/Receipt, but you buy Non-Inventory "placeholder" items. 2. You create a seconf PO/Receipt, this time buying the Lot Numbered items. Problem: the inventory value of your Lot Numbered…

The concept of Deposited vs Undeposited is unnaffected by making a refund. You can, afterall, refund an order whose cash you still haven't put in the bank - it's just that it makes a lot of sense as seeing the same cash from the CS leaving your hands in the form of the Refund. In any case, the solution is simply to depost…

Under Accounting Preferences, do you have "Accept Payment Through Top Level Customer" on?

There are no statistical accounts. You want to look at Saved Searches to pull this information. You'll need to record the input of customers you don't track somehow, however. I am thinking a simple custom record.

Well, every transaction prior to your Worksheet should be discarded. The Worksheet renders everything prior to it irrelevant. If you thus do your math by taking only what came after the Worksheet into consideration, does it add up?

Yes and yes :)

Try pressing Ctrl+F5. This is a "force refresh" and solves a lot of browser caching issues.

Closing means there will be no further action. For example, a Closed SO will not be fulfilled and/or will not be invoiced. It still keeps its "impact" though, such as it is currently. A voided transaction is basically the same as deleting it. Like a closed transaction, it cannot be further acted upon (a voided Invoice…

You can "pay" it with a Journal. Create a journal that hits the same A/R account as the invoice and then offset as you please (maybe you reverse the exact same income, maybe you want to redirect to some sort of write off expense). Then, create a Payment and apply the Journal as payment against the Invoice. This isn't a…

This is an Expense, yeah. You may want to look into the Landed Cost functionality (which requires an additional Module). There is no real other correct way to increase cost of an item. If you put the expense on the Bill but then increment your Receipt, your "Inventory Received Not Billed" account will be out of whack.…

In Accounting Preferences, tick in "Expand Accounting List". This will allow you to select whatever type of account, so you'll be able to select a COGS type account in the Expense accoiunt field. Of course, you won't actually be generating COGS with the service. The expense/cogs side will still come in by doing Vendor…

Yes, you are correct. It's possible to bypass inventory restrictions by back-dating transactions. Netsuite does not handle this well. You'll need to file an enhancement request or custom-code a solution.

Can you prevent what? The COS Adjustment or dragging your inventory into negatives? You can't prevent COS Adjustments if you've gotten your inventory negative, but you can prevent negative inventory.

I'm not sure I understand. You want to change the Trasaction exchange rate to something other than the daily exchange rate NS fetches? You can set the exchange rate straight on transactions, or like you point out you can turn off exchange rate integration and manually set the rate yourself.

To be precise, the Period auto-sets itself to the Period of the Transaxction Dare entered - not the current Period. Unless you are dating in a Close period, in which case the Period sets itself to the next open one there is. I am not aware of any setting that would stop the Period from setting itself. You could do it with…

Did you make Journals affecting Inventory Asset?

Hmm, not sure, I've never seen an account not use accounting periods from the get-go. That's an interesting problem. But, yes, you can run reports by DATe rather than period. Go to Home->Set Preferences->Reporting/Search and set "Report by Period" to "Never".

I would go with a Journal Entry for such exceptions. In the case of Income accounts, you could use a Kit to wrap your item, which would allow you to chose a different income account (but not COGS). In some case you could also maybe use a Discount item, which could post 100% of the income to another account (of course this…

I can confirm without a doubt I saw at least once an account change affect all existing accounts. Don't know why it would not have done so in your situation. In any case, point is it's doing it now and you want to know a workaround - I can't think of any. You'd need to create a new item, I don't see any way around it.

Transactions->Financial->Make Journal Entry->Search Ad a criteria for Account = your inventory asset account(s)

If you've never done Suitescript at all, you can review the entire Help topic SuiteFlex (Customization, Scripting, and Web Services) : SuiteScript Suitelets are specifically covered under SuiteFlex (Customization, Scripting, and Web Services) : SuiteScript : Understanding NetSuite Script Types : Suitelets

As far as I know changing the account of an item has always retroactively updated existing transactions.

Why yes you can! There is a Landed Cost functionality in Netsuite that does just that. Fire up ye olde Help system and look up the topic "Vendors, Purchasing, and Receiving : Purchasing and Receiving : Purchasing & Receiving Guide : Expenses : Landed Cost" If you have specific questions after checking that out just post…

Sounds like a defect... tax behaviour should be the same for any role with permissions to create transactions.

Hmmm... are you using a Posting or a Non-Posting Discount item? MAYBE a Non-Posting discount would correctly affect record cost.

I understood from the beginning it was tied to Role restrictions like that - I still maintain that is a defect. I can see, technically, why such a thing could occur. Doesn't mean it shouldn't be fixed.

You could have a Suitelet built to allow this

Incorectly charging taxes (and thus incorrectly filing them to the governement) can land you in jail, so I would say that's the more important one...

Confirmed. I just opened up a customer for which I am the primary sales rep, and I was able to enter an order and under the Accounting tab, the Taxable and Tax Item are both auto-populated. Shouldn't there be a way for me to enter an order for another sales rep and still retain that information??? :h_a_w: That's why I'm…