Phreesoft Support Forum

I want some extra features for handling inventory. We can start with exploding assemblies. I want to have inventory items that are assemblies that don't really exist. When they are used in another assembly, I want them to automatically expand into their component parts. I changed things so I had exploding assemblies on my screen, but that is not what was posted. In what program(s) do you actually post inventory items for an assembly?

If I want to do major surgery to assembly programs, can I copy your programs into an addon module that might survive an upgrade?

You can create a custom module that does what you want. You will need to add a file to /my_files/custom/extra_menus/ to get the module to show up in your menu. I recommend using the RMA module as a template to set up the core files and structure. Use the current assembly code (/modules/inventory/pages/assemblies) as the base to start your mods. Assemblies can be tricky as there are dependencies and this is a transaction type of operation, be careful.

Dave

Do you store inventory transaction items anywhere? If my letter assembly has a paper, an envelope and a stamp, do you store records for the three removed items somewhere, or just subtract from the quantity_on_hand and store one record for the completed letter?

Thanks,
Roger

Not that easy. Each piece of the assembly needs to be pulled from the inventory history table according to its method and it's cost calculated. This table needs to be reduced by the quantity of each item as part of the assembly, The assembly then needs to be costed and put into the history table (for use in another assembly or sale). Then all the quantity on hand numbers are adjusted, This process involves several database transactions and the results vary depending on many factors, including negative inventory balances which may trigger re-posting sales to properly determine cost of goods sold.

Dave