Olivier Gagnon NC

If you still wish to be able to purchase the item, what would "discontinuing" mean to you, from a functionality perspective? What should and should not be allowed in regards to this item?

in Discontinued Items with Inventory Comment by Olivier Gagnon NC Dec 15, 2015 7:00AM

Possible via customization. This is probably one of the first customizations I ever did, years ago. You need a little custom record and a little bit of scripting. You use the custom record to define possible alternatives to every item (lots of data entry...) and then add a little custom dropdown on the line next to the…

in Item Substitution Comment by Olivier Gagnon NC Sep 1, 2015 7:14AM

Inventory Adjustments can take up to 24 hours to "settle". You should not analyse the results of an Inv Adjustment until the following day, the figures you see are untrustworthy. That being said, if after a day the numbers are still wonky, you should do an Inventory Adjustment Worksheet to set the quantity and value to…

in Inventory Adjustment Not Zeroing Value Comment by Olivier Gagnon NC Jun 5, 2015 7:08AM

Not possible. The system is hard-coded to use that account. You can change the account number on it though if you like.

in Inventory Receipts Account Change? Comment by Olivier Gagnon NC Jul 28, 2015 1:27PM

According to what's written here, it should be 238. There may be many other factors in regards to the transactions as to why they aren't being properly accounted for. Things that come to mind are location and bin. Are those all set correctly?

in inventory adjustment worksheet behaviour Comment by Olivier Gagnon NC Apr 24, 2015 7:09AM

Off the top of my head, so this may not be super thorough, but my thoughts is that it's a 2-step process. You need to first find out that Assembly's S/N. Then, you need to fire a search to pull up the Assembly Build for that SN, which will tell you the component SNs used. In essence I guess that is just 1 search, really. I…

in Serialised Assembly Items and Serialised Components Comment by Olivier Gagnon NC Dec 12, 2014 9:24AM

Either of those solutions are good. I would go with inventory adjustment. Why do you feel that is not a clean solution?

in Using Inventory Internally Comment by Olivier Gagnon NC Dec 11, 2014 7:11AM

Yeah I was thinking of an adjustment to bring in the serialized item to avoid having it on the PO, cause that will definately be a source of confusion for vendors. But ultimately, it's the same basic solution. I'd have to double check, but as far as I know there is no problem doing adjustments to a serialized product.

in Serialized inventory with value zeroed out on receipt Comment by Olivier Gagnon NC Dec 12, 2014 9:12AM

There is a fundamental contradiction between having the item in stock, and it's accounting hitting COGS. You'd have to do an Inventory Adjustment after you receive it to post it to COGS, but then it won't be in stock anymore. But, fundamentally, the only way an item can hit COGS is as it leaves inventory. So you can't both…

in Serialized inventory with value zeroed out on receipt Comment by Olivier Gagnon NC Dec 11, 2014 11:21AM

Oh, that's odd. I think that is a setting in your forum preferences. I am Director of Technical Services at Ncompass now. Here's my linkedin: http://ca.linkedin.com/pub/olivier-gagnon/6/557/b92

in Using Inventory Internally Comment by Olivier Gagnon NC Dec 12, 2014 9:18AM

Line Item filtering is indeed limited to static filters. It cannot be made dynamic. To do dynamic filtering, you would need to add a custom column field to the line items, where you would then filter that based on Vendor or whatever. Then, using scripting, you would transfer the selected value into the "real" NS Item…

in Item Filter dropdown -saved search to be dynamic? Comment by Olivier Gagnon NC Nov 12, 2014 10:15AM

Where does the need for serialization come from?

in Serialized inventory with value zeroed out on receipt Comment by Olivier Gagnon NC Dec 11, 2014 10:57AM

Hi Paul, Can you provide some context as to why you'd want to write the item off to COGS right away? What does this item's lifecycle look like?

in Serialized inventory with value zeroed out on receipt Comment by Olivier Gagnon NC Dec 11, 2014 7:14AM

I can't really offer any explanation other than confirming that this is how NS works. So, always make sure to edit the Item Receipt to reflect the final cost.

in Inventory Valuation based on vendor bill rate Comment by Olivier Gagnon NC Oct 6, 2014 8:58AM

Even if it HAD members, it would function pretty much exactly like an Inventory item... the only difference is, you can Unassemble it. The members, and the fact it's an assembly, play no role right until the point you want to unassemble it. Otherwise, purchase, storing it, even selling it - acts, accouting and "proces"…

in Receiving an Assebmly? Comment by Olivier Gagnon NC Aug 18, 2014 3:51PM

It's called "Location Average Cost" in a search. It can't be sourced from a field, but you can use the functionality to have the value populated from search results.

in Average cost per location Comment by Olivier Gagnon NC Aug 29, 2014 1:59PM

When purchasing Assembly Items, you are purchasing the entire, finished thing. Components would ONLY matter if you UNBUILT the assembly at this point. So long as you don't unbuild it, the components are irrelevant. The item's COGS is set at the purchase price. Really, the building process (accounting wise) serves only to…

in Receiving an Assebmly? Comment by Olivier Gagnon NC Aug 15, 2014 8:29AM

It can happen. Best thing to do is call NS Support. The usual culprits tend to include Serialized or Lot Numbered items and/or Bins, and the deletion of certain transactions. There's a number of scenarios that can cause wacky problems, NS is nevver going to be completely bullet proof. Calling Support is a good way to hunt…

in Inventory Item with -1 committed quantity Comment by Olivier Gagnon NC Jul 17, 2014 2:46PM

I would back out your JE to Inventory Asset, offsetting to Opening Balance Then I would make an Inventory Adjustment to bring the stock in, using Opening Balance as the offset. With these two operations, Opening Balance should be a wash. If it isn't, you have a problem. In regards to your question regarding Landed Costs -…

in How to clean up Inventory Asset account in relation to Inventory Valuation Comment by Olivier Gagnon NC Jul 16, 2014 7:04AM

You need to use Location Quantity on Hand and filter based on Inventory Location, not "Location"

in Inventory Count by location Comment by Olivier Gagnon NC Jun 9, 2014 4:30PM

Just delete the Adjustment instead of zeroing it out. If that doesn't work, call Ns Support.

in Inventory Adjustment Screw UP Comment by Olivier Gagnon NC Apr 11, 2014 1:09PM

Well, orders have a dropdown on each line that lets you control the commitment level (commit, do not commit). So, a small script that checks the item type and then sets the field accordingly would be very possible. Otherwise you can still set the field manually of course.

in Commitment not required for assemblies? Comment by Olivier Gagnon NC Apr 3, 2014 7:01AM

Ooooh, that's not good. So, the Pick/Packed Fulfillment in a Closed period is one of the worst problems you can have. The Fulfillment is non-posting, so you never incurred Inventory Asset or COGS hits. However, the Fulfillment commits your inventory, and you can't UNcommit it like you could if was just on an open SO. So,…

in How to manually uncommit inventory Comment by Olivier Gagnon NC Nov 27, 2013 1:56PM

You say Item Fulfillments were created - are we talking about Pick Pack and Ship Fulfillments set to either Pick or Pack, in a closed period?

in How to manually uncommit inventory Comment by Olivier Gagnon NC Nov 27, 2013 6:39AM

Who told you that?

in Light Manufacturing Module Comment by Olivier Gagnon NC Oct 21, 2013 6:53AM

This is typically done by adding a Service Item to BOM recipes. While the value (i.e. number of hours) can be adjusted on-the-fly on the Work Order, it does not automatically feed in from the Time Entry module. Does this answer your question?

in Light Manufacturing Module Comment by Olivier Gagnon NC Oct 18, 2013 2:37PM

Oh my god that actually works! Thanks!!

in How to manually uncommit inventory Comment by Olivier Gagnon NC Dec 17, 2013 7:27AM

This account is called "Inventory Received Not Billed" in NetSuite. I recommend you take a look at the Help topic found under Vendors, Purchasing, and Receiving : Vendors : Vendor Bills : Vendor Bill Variances : Posting Vendor Bill Variances. NS offers a functionality to manage discrepancies between Item Receipt value and…

in Goods Received Not Invoiced Comment by Olivier Gagnon NC Nov 20, 2013 7:21AM

You would be able to get that info, but probably not using a single step/single search.

in Serial & Lot Number Traceability Comment by Olivier Gagnon NC Sep 17, 2013 11:01AM

It would be a "Service Item for Purchase", actually. What you'll need to set is the Purchase Price field on it, as that will determine its value. Being a "Service Item" it will not track inventory. Should work fine!

in Light Manufacturing Module Comment by Olivier Gagnon NC Oct 30, 2013 6:47AM

Olivier Gagnon NC Red Ribbon

Comments