OK, I got it now. Thanks again for the help. Have a good one, Steve

Hi ray, Thanks for the reply. I took a look at the paper you mentioned. It covers builds and assemblies, but I didn't see anything specific to outsource manufacturing/assembly - could it be that I'm looking at the wrong paper? Either way, the paper I did read confirms what I've started to implement is the correct way, that…

Hi Mark, thanks for the response. I've set up the saved search and made it a dashboard thing that I can quickly get transactions relevant to a SN. Yes, the assembly itself has the SN. It's frustrating that we can't customize the Serial Number Records. I am keeping a MySql DB to track all of our device history information…

I looked into using Web Services to manage the inventory in NS and was surprised to find support for serialized items/kits/assemblies missing. From what I can tell and from what I have been told by support it is not possible to work with serialized items using Web Services. Just in case you have that need, thought I would…

Hi, I'm very interested in this "inventory activity report" - can you explain more what this does and how? Sounds like something we could use here. Thanks, Steve

Quick question: If I have a serialized assembly and one of said items has SN 'D+061027-001' (minus the single quotes) and I enter that SN in the Global Search field should I expect to see a result... of some kind? I've built the assembly, fulfilled a sales order and invoiced. A search for the SN yields zilch, nada, zip. Is…

Are you using version 11 (I think everyone is now)? I was speaking with gold support Friday and they opened an enhancement request for this. Interesting.... I need to manually copy and paste to get them to show up. I wonder why it works for you and not for me?

If you intend to use serialized items in serialized assemblies/kits STOP! - it doesn't work.

Hi, I also was entering them in the fulfillment transaction until I noticed that an Invoice would not pull the SNs from the fulfillment, only from the Sales Order. Again, serialized inventory is broken and useless in Netsuite. I agree that it's too bad this is a closed forum, had I known how poor inventory management was,…

The fact that serial number needed to be suppled early in the transaction was out of the question for our business model; there was no way our sales rep or shipping manager would know what serial number our warehouse would be picking later in the process. I forgot to add salt to this statement. Not only are we apparently…

Thanks for the reply, although I'm not thrilled that you have confirmed my suspicions :0( Version 11 has not changed anything, it's still broken. I'll note that there were suggestions to use a Serialized Assembly/Bill of Materials item instead, though that may raise some other possible problems. This doesn't work either.…

OK, thanks for the confirmation! I'll proceed with that plan. Have a good one, Steve

Leaving the Income account blank precludes the item from appearing in the list of items for selection during Sales Order/Invoice entry. I'm trying to find a way to setup inventory items as "Raw Materials". The main reason for this is to filter down the list of items on sales orders and other sales transactions. I tried…

Thanks for the confirmation. I had already proceeded with the original plan and meant to blog about it for future reference but haven't found the time. For anyone else coming across this thread: [LIST=1] [*]If you set the end date to, say, 5/30/2011 any previously authorized (or paid) commissions with a Sales Effective…

Actually I think I just found it! I just changed the Commission On to Quantity from Item and I'm waiting for the recalc. Hopefully this will give me what I want. I really don't know how I missed that before? I have confirmed that this does EXACTLY what I need. Stupid me for missing this quite obvious solution!

Missed your question, sorry. No, I never received any help on this and gave up.

Update: I was able to accomplish what I wanted by using the Authorized Commission Detail report.

[Solved!] While talking with support on the phone we stumbled across a strange transaction that was not listed on the Authorize Commission list earlier in the day. After reviewing the System Notes I remember that this transaction, which was imported from Quickbooks was missing a Sales Rep assignment and that I had edited…

Support confirmed that this behavior is by design. The good news is that they also provided workaround steps that seem to work fine: [LIST=1] [*]Transactions> Commissions> Authorize Commissions [*]Click on the Authorize link for employee Jimmy John [*]In the By Transaction Tab, select or mark the Commission you wish to…

Please file a bug. We'll need to investigate. Thanks, Darren I created two because otherwise I think support would get confused. Case# 880460 is for the "zeroed out" commissions still appearing as needing authorization. Case# 880461 (alright, consecutive bugs!!) is for the duplicate commission items and error messages

Looks like Commission transactions aren't supported in Web Services. Also looks like ODBC doesn't have very good support either.

What do you mean by "zeroed out all his commissions and saved"? Do you mean you authorized them fully or something else? What does the existing commission look like in view mode? I manually entered 0 (zero) for the amount and authorized them. In View mode they look fine, they are all zero amounts.

Defect 165196 - Reports > Commission > Commission Overview. Commission are not computed for transaction imported from Quick books.

Initial feedback from support is that authorizing a commission for 0.00 is not really authorizing and as such the commissions will continue to be due for authorization. Of course I disagree with this. If we can edit the value of the commission why can't we set it to zero? If I can make it $0.01 and that is valid why not…

Hi Martin, I was just about to reply to support (case# 882035) and surrender. ;) I had made it an issue that I felt a commission paid for x-dollars should be reversed for the same amount, regardless of Sales Effective Date. We went back and forth and I maintained that it seemed totally wrong to me. Anyway, support finally…

Hi Martin, I tried to reproduce my results and was unable to. It looks like I was probably doing something wrong, confused, etc. Thanks for the confirmation.

In the From and To Date fields have them both be today's date effectively ending the commission plan. Will this attempt to reverse past authorized commissions?

Are you suggesting that after doing that I could remove the schedule, then revert the end date on the plan? I tried another workaround suggested by support which seemed logical: Inactivate the schedule to remove, remove it, then reactivate it. After waiting 2+ hours for the recalculation and trying this I received the same…

Thanks for the response Antonio, I didn't think of the Credit Memo option. I ended up using Exclude Commissions. I understand your warning, but for my situation there is no one that should receive a commission on this transaction. I learned through support that the Exclude Commission option was available on Invoices as…

I'm not sure exactly what I did, but I was able to make sense of most of the issues and clear out some of the problematic ones. I think I had several things that were creating problems and stale data on top of it. The ASA stuff is working well. Thanks for the help.