Dear Team
My company is wood importer, we manage inventory in “lenght x Widht x Depth x Qty” which give cubic meter.
Is it possible to insert separately the above dimensions in inventory section. Same would be used in sale invoice to sale number of pieces to customer.
If it is not possible in manager. Is it possible you guys can customize the software for us.?
There is no customisation option available with Manager
You can create custom fields to record the dimensions
Yes I can creat custom field to record transaction. Is there any way i can add funchions in custom fields.
eg, if i creat custom field “lenght” , “widht”, “Depth”, “Quantiy” and i can multiply these to get cubic meter (CBM) ?
No. That’s not an option - unless you program it into a custom theme but that is beyond the scope of this forum
If you want to record those parameters for a transaction, you can use custom fields, but unless you program a custom theme to use those fields, they will just be information. That is, they will not be used in any calculations. And they will not support tracking of cubic meters of wood in inventory.
If you only want the program to do the math for you, define the unit of measure for the type of wood as cubic meters. Then enter the dimensions in a formula in the quantity field of transactions. See the Guide: Perform calculations in number fields | Manager.
You can make your items with various “lenght” , “widht”, “Depth”. like w101 “lenght” x “widht” x “Depth” w201“lenght” x “widht” x “Depth” and add the qty on qty field. which need to calculate manually.
on sale invoice just add item and qty you want to sale and sale price.
if adding purchase invoice add item, purchase price, sale price qty.
This may help you
No, you do not need to calculate manually. That is what the Guide linked in my previous post is about.
enter the text in the custom field showing the calculation. So for a length 5 m, Width 0.24 m, depth 0.050m, Quantity 70 →
5.000 * 0.240 * 0.050 * 70
then paste that in Managers quantity field
With unit per cubic meter price in the unit price field
and Manager will calculate it for you
In the inventory item description(or item name) include the L:W:D and the M3.
In the Inventory item price field enter the price per M3.
Create line item custom field called “Pieces”.
When creating the Sales invoice the M3 per piece will be visible in the description, so in the quantity enter the M3 * Pieces (e.g. .025 * 50). The customer can then see the number of pieces and the M3 on the invoice.
Like this:
To produce this:
The trick is to have a text description some where which is also a formula Manager can calculate the result for. To do so you have to move the unit and measurement specifier outside of the calculation text eg “5* 0.100 * 0.050 * 50 (L * W * T * Qty)”
@Malik_Meghani, if you take advantage of any of the more advanced methods suggested, you need to understand that including dimensions in an inventory item name causes all pieces of that item to be named with those dimensions.
While you can insert dimension calculations in various numerical fields in Manager, causing the program to perform the math for you, I doubt you are able to purchase wood with all standard dimensions unless it is a manufactured product. For example, you might buy timber 25mm thick, but in random widths. Or 50 x 100 mm dimensional timber in random lengths. These cannot be named in such a way that Manager will calculate cubic meters of wood from their names.
Even standard wood products, such as fixed-length studs or joists, cannot have their volumes calculated from their names by the program. You would have to calculate the volume of one piece and use that in conjunction with your unit of measure.
yes that can be. but we need to type the formula in every qty field. any way that may help in Calculate Qty or any other things.
Thanks.
No, there is really no way to make the program calculate with contents of fields unless it is already programmed to do so. The accounting results could be disastrous.
Also understand that calculations entered as formulae in fields are transitory. As soon as you move on, they are converted to a result, and the formula is not preserved.
Enter a formula template in form defaults or clone an existing transaction.
Note
Cool. A way to save time and typing. Such type of data (What i am dealing with) needs to calculate newly on maximum time. Various items with Various measurement but those are common.
Say ten companies, each supplying ten items with 10 more sizes. in sales invoice not sure what coming next. A bit difficult to handle such data.
I am trying to find a way to push data from template on few line custom fields. that will be a very helpful for me.
Any way thanks for your tricky idea.
