Found this. It works but also really doesn't. NetSuite Applications Suite - Unbuilding Assemblies and Purchased Assembly Costing (oracle.com) NetSuite Applications Suite - Entering an Inventory Adjustment Before the Unbuild (oracle.com) This will affect the average cost of the item, which I can confirm is driving the price…

I've made progress on the PO by also setting a GBP value, since the PO is in GBP. I wonder if this correlates to the unbuild as well... Nope, it did not change anything on the unbuild.

Unless there's something wrong with my vendor setup? As it looks like the vendor price isn't being suggested on POs either based on Vendor. If I set the items global purchase price, that does work.

Hey @Angela Bayliss I've been having some trouble with this. The cost of the items coming out appears to be derived from the average cost to the item per location above all else. I've been trying to change the price via the location, vendor or global and it appears to be locked or I can't figure out how to overwrite the…

Yea, I understand that some of the transactions in my example have been filled where there is a purchase price on the item record. But what I'm asking is can I not set my own price or overwrite the purchase price for the item during the upload? Otherwise I would first have to do an item upload with the correct pricing and…

I think further to this however, my issue is that the assembly items are built in our subsidiary MPUK, they're then sold as fully assembled items to MPSL, but MPSL is where they become fixed assets. Because of this, it's not recognizing the item as a culmination of components but just as one item. To achieve what you have,…

I think it answers it, I need to do some more testing. Thank you for the detailed guide. If I can't list the components, can I have them each on different asset accounts?

I'm going to build my own last purchase price field that finds the value specifically from MPCN transactions. Transaction Saved Search > List Transactions for the basis of Last Purchased Price (custhelp.com)

It seems last purchase price is also not able to be separated by subsidiary. The reason I'm getting $100 is because of the following rule on last purchase price. "If multiple purchases are made on the same day with different prices and locations, then the highest price paid on that day becomes the last purchase price." I…

Nevermind. I made another PO to the vendor for a $10 item and it's set the average cost at $50.50. So the average cost is what's in inventory. If I sold that itemto MPUK for $100, the average cost would go back up to $100 as the $10 item is no longer in MPCNs inventory and not counted. I need to change my search to…

If this were me I'd be taking this to my account manager first. Usually anything to do with licensing and stuff not being implemented or activated.

Thanks Micah, all very helpful to know. I think still the last point I'm focused on is how I actually go about creating them. I do want them to be compound assets containing the components, as the components are all very valuable and sometimes need replacing. My main concern is the amount of time it will take to create…

Giving this a bump as I'm still very stuck with it! :c

Yep, I got it working. Indeed the main purchase price field. Thank you! I need to do some further reading on this, as I need the purchase price to be different for each of my subsidiaries. But this gets me on the right path.

I think I need to look into Standard Costing and Standard Cost Rollup for assembly items? Surely it's not tied to the costing method as I'm sure I still want to be able to use average costing method. NetSuite Applications Suite - Standard Cost Rollup (oracle.com)

Sorry, I'm not sure what else to suggest as this still works for me the same way with locked forms.

I think this makes sense, thanks! I'll have to put it into practice.

Ok, that makes sense. I think I'll end up turning that on. Thank you! Would you say that the popup should instead read that it WILL cause items to be de-committed instead of MAY cause?

Thanks, I'll take that into consideration and try to move forward with it. As it stands, I've currently taken a different approach to solve my problem by searching for SOs instead, returning less lines and then filtering them down with a custom field to match the info I need from the IFs. So I'll accept yours as the answer…

A, C and D :)

Hey Gert~ I managed to get an example working on mine. It looks like this, does yours look similar? If so and it's still not working, let us know what type values the fields are (int, text, percentage..) and it may be best to next take a look at the workflow history to see if it gives any more info on why it's not working.…

The 'approval circuit' is likely a workflow, is it not? If it is, go to any approved purchase order you have and under the System Information>Workflow History subtab you can probably see what workflow is being used to route your approvals. Go to Customization>Workflow>Workflows list and open the appropriate workflow. In my…

I don't believe there is a way to do this for reports. It can be done for saved searches, if that's of any use. Find All Saved Searches Where a Field Is Used (custhelp.com) I've heard strongpoint can do this, but you'd probably need a lot more than this to justify the cost of it. Stress-free NetSuite — at any stage of…

What page are you looking at this from? For me, a very simple way to do this is to go to Customization>Forms>Transaction Forms and simply click the inactive box. Hope that works for you.

Afraid it hasn't improved anything, I'm still getting up to 3 lines for each item. Sorry for the delay on the response. I'm now settled after returning from holiday and catching up with work.

After reading through the documentation, I'm still struggling a bit and would appreciate further help over here on a new topic with a more of a direct question. :)

Thank you for that! A very good answer to some of my questions and now I'm able to find a lot more information on the topic now that I know they're called compound assets.

Fixed that rather quickly. The preferred checkbox needed to be checked for the items vendor.

Going to agree that it's most likely #3 and will keep my wits about me for the next time this happens. Appreciate the help~!

I made a new separate order for the assembly item and it's working now. The old one is still there and not working. Perhaps something to do with the dates? Maybe because I made the order and then made the new revision?