Need help customizing a modules list view

[bstonehill]

I'm currently on 5.1.0a but I will probably upgrade to 5.2 before I implement this on production. I have created a custom inventory module with module builder. I've already implemented a popup that lets the user specify a quanitity and then creates that many duplicate records, but when it comes time to go back in and add serial numbers it's not feasible to click through and edit every one individually when you are dealing with 100 items on a single order. After asking around it was recommended I use AJAX to input the serials directly into list view.

I've found a javascript function to do that and successfully used it in some of my own applications, but after going through sugar's code I cannot find where I need to edit. All that is required is for me to do is assign the item that will be clicked on to edit (i.e. td) the class of "editText" and to assign it a unique id, and of course to attach the external javascript.

Can someone please point me in the right direction to make these changes?

Thanks In Advance!

[SugarDev.net]

Hi,

I'm finding it very difficult to understand what you want to accomplish. Do you have any screenshots or code to look at? Why are you duplicating records and not just have a quantity field?

[bstonehill]

I created a custom Inventory Project in Module Builder. It consists of 4 modules, Items, Pricebook, Vendors, and Purchase Orders. Vendors has a one-to-many relationship with Purchase Orders. Purchase Orders has a one-to-many relationship with Items. Accounts has a one-to-many relationship with Items.

The purpose is to track orders placed with our vendors and if and when they are received. Then once an order is received to be able to track each item by serial number from the warehouse to technician stock to customer location. In this case I need an actual instance of each item rather than simply incrementing/decrementing a qty field. Since it's not practical to create 40+ nearly identical items manually and then go back and edit them individually once they are received in order to add serial numbers, I created a popup form that allows the user to select a templated item from the pricebook and specify a quantity. When submitted this popup creates X quantity of the selected item related to the Purchase Order they were created under by copying the standard fields (i.e. part number, price, etc) from the Pricebook table. This all works fine.

Where I'm running into a problem is going back in to add the serial numbers after the orders come in. Mass Update is of no use since each item will have a unique serial number. I've discussed this problem with a few people and someone suggested I could use AJAX to edit the serial number fields directly in list view. I've got a script to do exactly this and have used it in another database that I created and it works great.

The only modification I need to make to the original files is to give the <td>'s for the Serial Number field class="editText" and a unique id, then attach the external .js file.I have looked everywhere I could think of in the code though and can't find the html I need to edit to apply it to Item Module's list view.