Make volume & weight data available on Sales / Purchase / Transfer
Daniel Millott
Total Order volume and/or Total Weight information can be very important for many businesses at the time of keying in a Sales/Purchase/Transfer order.
I'm proposing that the following information is made available in the Transaction screen and in mergefields in related documents
- Line sub-totals: Volume (LxWxH x qty), and Weight (unit weight x qty)
- Total volume, and Total Weight (Total of all line item sub-totals) for the overall Sales/Purchase/Transfer
The data points are already in Dear in the Product Details > Dimensions so it's just a case of bringing these data points through to the transaction screen and related document templates.
Thank you so much for sharing the sweet shout-out. I am very much excited to check out the sites you listed that I haven’t visited before. I know I am too late to this post but still want to make a comment on it. I have gone through with too many blog sites till now but I didn’t addict to any of them. Most of them are related to beauty, recipes, technology etc. But this is something I feel unique from other sites. You are in a good direction. I found this is an informative and interesting post, so i think it is very useful and knowledgeable. I am glad to read this post hope your next article is are so useful for me so you are meet in next process for more information click this link below
Firstly, DEAR mods, can you delete the spam backlink comment above? Secondly, agree with this. Getting the following merge fields from the Product Record onto the Sale and Purchase templates as a minimum is important:
Cross linking these requests:
https://support.dearsystems.com/support/discussions/topics/11000015108
https://support.dearsystems.com/support/discussions/topics/11000037230?page=1
It appears Line Item volume is available for PO's. See below link:
https://support.dearsystems.com/support/solutions/articles/11000094759-define-carton-item-volume-and-pack-quantities#:~:text=be%20overridden%20manually.-,Adding%20pack%20quantities%20and%20carton%20volume%20to%20purchase%20documents,-%5Bback%20to%20top
Thanks Daniel. This is exactly what we are needing, it's crazy. Also to not be able to export/import the csv is very frustrating and ridiculous to have to check each product manually.
It just needs to be added to this list of options surely?
Christie, most of the detailed product data is within the 'Inventory list' option you see there, and there is where I would expect the volume data to go. The point too is that the product dimensions (L W H) are already in there, so we really near the Sales/STock Transfer module to pull that data and calculate the cube
Yes exactly so hopefully this can be implemented as it's halfway there having the fields but little point if we can't work with them. We need to build export containers and trucks so it's very necessary.
Nice to meet you Daniel Millott :-)
Hi Dan, great! Thanks for the intro :) . Hi Christie, I think i've seen Oneworld at the trade fairs :)
Ive followed up Dear Support again on this yesterday and they came back advising no update from their dev team - same message i got 12 months ago :(
Hopefully these requests gain more popularity for Dear dev to consider fast-tracking it. And Dan, you have a direct line to the top so if you can give the powers that be another nudge Im sure that will help too :)
As a workaround in the meantime, i'm planning to set up an Additional Attribute field dedicated to cubic volume. I'll need to export all product data and set up a formula in Excel to calc the cube from the standard dimension data (not the import dimensions which dont exist in the import file), then reimport back in.
I can bring the AA mergefield into the Sales & Transfer doc templates, along with formulas to get it to sum up with qtys to give line & transaction totals.
Will be a great day when its implemented so we can use in the system as such, not rely on the doc templates..
This is a very obvious requirement for an Inventory System. i.e. knowing your inventory specs (cbm and weight) and making this information available during the sale process. I think it's crazy that this isn't available on Dear. As Dan and Christie have stated above, the information is already entered into Dear per SKU - so why not make the information available when you need it most ... i.e. when you want to ship it!
Having visibility of weight per item/ line/ order is critical to our business. The fiels]d is already built in to the Product file, please add it to all sales screens as well
I have created this information for our Picklist templates which is great if you're using printed picklists not WMS.
It uses Additional Attributes and a series of formulas within the Word doc template to sum up the total m3 & KG per line, and then a group total*
We use this in our Pick List, Packing List, and Delivery Docket documents and seems to work quite well.
If you're interested in getting a copy of this for a small fee (it took several weeks to complete), please get in touch with me direct: daniel.m(at)anstel.com.au
*Note that my example shows items grouped in Kit SKUs as we use Kit SKUs in our business... More info on this: