BlueHub is the UK’s leading Cin7 Core (Dear Systems) Implementation Partner and Xero Integrator.
We make content about how product-based businesses, such as Manufacturers, Wholesalers, Distributers and Ecommerce companies, can get the most from their software. Using best in class cloud-based systems like Cin7 Core (Dear Systems) and Xero, and integration to access better reporting data, streamlined processes and keep ahead of their competition in a digital age.
Subscribe so you can learn about the latest developments from experts who have helped hundreds of businesses around the world pull their systems into the 21st century.
You can read more by visiting our website here: bluehub.co.uk/
Hello, at 07:40 of the video, we are sending the products we entered for manufacturing. However, we cannot see these products during stock transfers. I would like to explain it this way. The entered components appear clearly in the invoice, but we cannot see the semi-finished item "SK-00062:Unpainted Chair" (mentioned in step #2) in the stock transfer order. This situation prevents me from tracking the quantity of the product I sent to the co-manufacturer. How can I track the semi-finished product I sent along with its quantity before sending it to the manufacturer? Thank you
How do I turn off Backorder Functionality Completely? If I am short of Stock, I just want to fulfil what I have and invoice what I have partially fulfilled (or Short Supplied) and Close the Sales Order.
We are seeing 3PLs use something like mintsoft as their WMS so might need to connect to it. There are others. If no 3PL involved you can use Cin7 Core modules to cover so no 3PL integration would be needed. For this you would link e-commerce to core to accounting.
Thanks guys. Well done. Question - what is the benefit of something like a mintsoft in this set up? I understand that cin7 core, xero, shopify will manage almost all required workflows.
We are seeing 3PLs use something like mintsoft as their WMS so might need to connect to it. There are others. If no 3PL involved you can use Cin7 Core modules to cover so no 3PL integration would be needed. For this you would link e-commerce to core to accounting.
Thanks for the video. Must you enter batch numbers and Expiry or can you leave them as N/A if Batch FEFO or Batch Special is the costing method? What impact will this have?
If you use the filters to select a specific bin to do a stocktake on will it only lock the inventory in that bin or will it still lock the whole warehouse?
We're a new user (in NZ) who went live 1Nov 23. We have around 500 lines that we retail through our POS and 1800 lines total. We have 4 locations, one of which is the main operation. We import products and store these at 2 locations ( one local the other in the north Island). Our operation is fairly complex, manufacturing, processing waste, composting, retailing, import and distribution, cartage. I'm in the process of setting up supply rules for selected products however, SELECT PRODUCT FAMILY only displays half of the Product families listed and when trying to select a product the list only displays approx 50 inv lines. I can't see why these lists are so limited. Any suggestions
At 11:32 in this video, you show a matrix where the sizes are on the top and the colors are on the left. We have the Sizes on the left and the colors on the top. We also can't get the sizes to populate in the S-XL order as it is going alphabetically. How did you overcome this?
Hi, I have created a BOM for a 12 pack made of 12 individual products and ticked Auto disassembly but the individual items don't seem to be in stock even though there are 2 boxes of 12 in stock. What am I missing?
Really helpful Callum. I am struggling with Full Co-man and ensuring the costs all pull through correctly. Cin7 seems a bit hit and miss on whether Co-man works reliably and values stock consistently
Hi there, Reorder is identifying items to order based on Minimum Before Reorder Levels set against the product. Reorder Backorder is identifying items that have gone into a backorder state (negative availability) Hope this helps!
Hi, Thank you, It really helped me but I have questions, if you can answer me I would appreciate to you. First of all we don't have ''fill from order'' button to copy paste my transfer data, should I open it or is it an automatian that I can create? Second one is how I will transfer my box into base SKU? I mean I have carton which includes 55 quantity of base SKU and it stays in A warehouse, and my base SKU stays in B warehouse, when the stock ends in B warehouse, I want to transfer one of my boxes to A to B. So I can have 55 quantity of my base SKU in B warehouse. How it will be possible. Hope I'm clear. Thank you :)
Hi David, Good question, as per the Dear documentation on this process, your GRNI account can be an ASSET or LIABILITY account. Please see here support.dearsystems.com/support/solutions/articles/11000033637-inventory-accrual-and-stock-in-transit-implementation-grni-ginr-#:~:text=To%20enable%20Inventory%20Accrual%3A,Accrued%20Inventory%20transactions%20to%20Enabled. Hope this helps
Hi, Yes this is possible. Please refer to Dears help page on Invoices Merge fields here: support.dearsystems.com/support/solutions/articles/11000093779-sale-process-and-customer-mailmerge-fields-for-dear-templates#InvoiceLines
Question if I may, regards the 'Actual Quantity' produced: If I make a run for 100 finished products (that use component items), but actually build 110 (and fill our 'Actual Quantity' as 110) Will Dear book out the extra components needed for those extra 10? Or will it presume that I magically managed to use the same amount of component items needed for 100 to make 110?
Hi, Really good question. If you were to enter 110 in the output section, it would NOT book out the extra 10 components. To manage this, i would advise creating a second run for the extra 10 or when completing the run adding the extra components required in the actual quantity field. Hope this helps!
Hi, I have a combination of skus of single units and kits. Auto assembly is turned on for kits and off for single units. When I select an expanded pick list is showing bill of materials for everything. This has only happened this week. Any advise on how I can revert it back to only show skus that have auto assembly switched on?
Can you automate an additional charge for each customer? For example, we have one customer that has the same additional charge per product, and the price is always the same. Is there a way to automatically have that added to each order? Thanks!
Hi Rachel, this isn't possible per say but one way that you could do this is by using Sales Order "Presets" in the top right corner you will see you can save a layout of a sales order. So you will need to create the order with the customers name and the additional charge and save this, each time this customer orders you can then select this pre set.
If supplier combined multiple PO in an invoice, In this case I add the freight cost in addition costs box of only one PO because the supplier can not split invoice of freight cost for me. how can we allocate the freight cost to multiple invoices?
Hi, at around the 9:00 minute mark, when i select allocation and the purchase invoice it relates to, you would in this scenario, select all the invoices it relates to and click save. In my example, i only selected one invoice but you can actually select multiple. Hope this helps!
@@BlueHubYT Thank you for your reply and yes, it's working on separate PO with marked Blind Receipt. BTW, if the freight cost is in "the Additional cost section" with also contain product items in "Order section". Can I still allocate the freight cost across other PO?
Hi, Unfortunately, you will not be able to allocate this to other POs if included in the Additional Costs section. The additional costs should only be used if the supplier you purchased the stock from has charged you for freight for that specific Purchase Order.
Hi, Please refer to the below video, this will allow to add freight and other costs to incoming raw goods :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YsKw9aZZwO0.html&lc=UgzdR6gJIlmqFFrZB7N4AaABAg Hope this helps!
Thank you! We manually input over 50 large system builds as assembly BOMs and realized they don't take raw materials from stock for the builds to inventory. We thought we would have to start completely from scratch! This helps so much!
I had an employee input BOMs from a previous system we used, but they are all Assembly BOMs. Is there a way to convert the existing materials from the Assembly BOM to a Production BOM? Or do I need to completely start from scratch?
Hi Nick, Thank you for your question. We'll look to make a video on this soon, but for now, you will only need to partially start from scratch, although there is definitely more information required in the Production BOM compared to Assembly BOM so there will be additional data you will need to gather. You will be able to reuse information such as SKU, Name and Quantity. I would recommend exporting your Assembly BOM from Dear and watching our Import Production BOM via CSV video and converting the data over in Excel for reimport to Dear. Video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q-xJX3kDP0U.html Hope this helps!
Hi Xavier, Thank you for the question. In this particular example there is no requirement for input in step 2 as we're not "inputting" a "Semi-finished item" from the previous stage. For an input to be used, there needs to be an output from the previous stage. Step 1 is just the process of us sorting the lumber and as it's listed as a component, it's still being consumed to make the unpainted chair. That being said, Dear Production BOM's are really flexible, and you could in fact configure this example in a way that we do use an input in step 2. For example in step 1 we would have a component as "Lumber" and an output as "Processed Lumber", this could need be carried to step 2 as an input and folowing the process of drilling the step would output the unpainted chair. Hope this helps. Callum
Thank you for the feedback and great to hear! To restore the data, you can use the import function on each section of Dear. For example, if you completed a backup of products and you then needed to restore this data because an error happened or you made a mistake, head to the Inventory > Products page and import your most recent inventory back up. Hope this helps!
Thanks for this, great summary of options. Just a note, I use A2X and if you Group Sales by SKU and set up the relevant tracked inventory in Xero, you can keep your inventory up-to-date in Xero.
Thanks for your tip, Retrob0r0. Amazon back office is SUCH a MAZE to me!!!! I haven't yet figured out how to run reports even. I'm not a numbers person at all. :) Except when Amazon pays me. THOSE numbers are easily understandable. :)