 |
|
Topic: Quickbooks + MiniMRP best practice
|
| By: Dorel | Posted on: Mar 1 2020 at 10:49:02 AM | Hi there.
It seems that MiniMRP would do what I need as a one-person "company" but I am using Quickbooks for financial reasons (bank accounts, credit cards, tracking expenses not directly related to manufacturing costs, income from consulting, etc) that don't involve inventory.
How would I work with both of them?
There is a minimum amount of information that needs to be sent from one to the other obviously but how can one keep the double data entry to the minimum?
Is there some info on the best practice?
I would really appreciate any feedback on how you guys do it, which would help me to decide if I can use MiniMRP.
I did a search on the topic, but I could not find an answer, so I apologize if this has already been answered before. | |
| By: Support | Posted on: Mar 3 2020 at 04:09:29 AM | We've never used or even looked at Quick-Books so can't say for certain - but some people asked us to allow Customer orders and Purchase order to be exported to CSV. They seemed to be saying that quick books and some other accounts programs can then import that CSV.
So, when looking at a customer order (or PO) you see a green [X] Excel button at the right side of the window. Click that to export the rows of the order to CSV. This only exports the item rows of the order - now the customer/supplier data or order numbers etc. So may you still need to create an order in your accounts package and then import the rows. probably not much benefot if the order just had one or two rows but if there were many row then it might save a bit of work.
Let m know if that helps
Anyone else with ideas/suggestions please post here. Thanks
| |
| By: Support | Posted on: Mar 3 2020 at 04:11:42 AM | | I meant to say that it does NOT export the customer/supplier data - just the rows from the order. Apparantly it's easier to import that way? | |
| By: Dorel | Posted on: Mar 7 2020 at 06:12:34 PM | Thank you for your answer. Yes, Quickbooks can import info from CSV files but you are right that for a few lines it may be just easier to create the order from scratch. The CSV file may need to be changed in order to have the proper headers.
I would still like to hear from someone that has experience with this, if possible. | |
| By: Guest | Posted on: Mar 16 2020 at 05:25:20 PM | | I also use both QB and minimrp. The approach I use really only works because I do not invoice form either system, I sell most of my products through a e-commerce site. The only exception is the consulting side of my business. In this case I use QB for customers orders and invoicing. I do not load specific customers product orders into QB or minimrp. In QB I record sales by dollar value and a category (retail, wholesale, MSRP). I use two bank accounts one, a "Merchant Account" which dollars flow into and a "Business" that dollars flow out of. In QB when I receive funds in the Merchant account I transfer those funds into the Business account and code them into the correct sales category. In minimrp I also load customer orders in a generic sense (specific orders but generic customer) just related by an order ID from the e-commerce site. All other "Factory" financials (Inventory, COGS, WIP) are calculated monthly (inventory is done quarterly) and fed into QB to maintain the books for the whole business. This approach allows me to minimize double entries and keep financials and inventory in control. | |
| By: Guest | Posted on: Mar 16 2020 at 05:32:44 PM | | Also, material purchases. POs are cut in minimrp. In QB I create a bill related by the purchase order number and assign the correct QB account for the purchase. In this way inventory is valued in QB and every quarter when inventory is done the two systems get balanced. | |
| By: Guest | Posted on: Nov 27 2020 at 09:04:10 AM | | Quickbooks online is on a major trend, many online MRP or inventory management systems integrate seamlessly with QB. it would be great to get MiniMRP do the same, otherwise down the road , we would have to move to somehting else and that would be sad. | |
| By: Guest | Posted on: Nov 27 2020 at 09:07:10 AM | | quickbooks.intuit.com/app/apps/home?categoryId=Track-Inventory | |
| By: Support | Posted on: Nov 27 2020 at 09:16:17 AM | In March 2020 Support said that exporting a purchase order only exported the item rows. That 'was' true because that is what users asked us to do. I assume users would create a PO in QB and then import the order item rows into the order in QB.
But since version 5.0.85 MiniMRP also exports the PONumber, PODate and Supplier as well as the purchase order items.
| |
| By: Support | Posted on: Nov 27 2020 at 09:30:36 AM | Guest above used the words 'Seamless Integration'. What do you man by that? Do you mean reading/writing directly into the QB database?
I guess the kind of software you're talking about is something that adds features to QB that QB does not currently have built in.
What happens when QB make changes to their database design or API? Of course the software companies following QB's update path are also updating their own software to keep compatibility in realTime.
Just doing that is a full time job and the only way to make that viable is to charge a monthly fee.
We DO NOT charge a monthly fee. Not even an annual fee. In fact many users of MiniMRP are still using software they purchase 10 or more years ago and haven't paid a penny since then. This is only possible by keeping MiniMRP independent.
Sure. That means we can't ride on QB's shirt tails but it also means we're not affected by anything anyone does. | |
| By: Guest | Posted on: Dec 1 2020 at 07:35:54 AM | And then people would also be asking for Xero and Sage intergration, i have just moved from a fully intergrated MRP system, and for many reasons the route MiniMrp is taking works. Keep the inventory, PO's and MRP seperate from the financials.
Unless you are a big company that can justify the hundreds of pounds per month, this approached works fine. It's a bit more work, slightly higher risk of error, but it's a great little solution.
(Although i would love to have a few more features added, that have already been discussed in this forum, even if it meant paying for an update).
| |
| By: Guest | Posted on: Jan 23 2021 at 01:45:20 PM | If you have a CSV file from MiniMRP, it is a straightforward task to use a tool like Integromat or Zapier to generate a "native" Quickbooks Online invoice (or PO, or whatever). There are no changes required on the MiniMRP end.
What would be nice is the ability to schedule the generation of these CSV files in MiniMRP. Automatically generating a CSV report, and using Integromat to import the report into QBO, on a periodic basis would be great.
Periodically generated reports would allow MiniMRP data to be imported into a host of other programs (through Integromat) with placing an onerous burden on the developer :) | |
| By: Guest | Posted on: Jan 23 2021 at 03:53:04 PM | | sorry I meant, "without placing an onerous brden...". | |
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
|
|
|
