MCS_Martin Posted December 13, 2013 Share Posted December 13, 2013 Ok I have an issue, Inventoria and Copper work well to transfer stock levels but I can't get any profit or tax details. Inventoria has it but it dosn't link with Copper and Copper doesn't have that type of report ability. Anyone know how to get around this issue? Starting to wonder if Copper OR inventoria were a good investment! Link to comment Share on other sites More sharing options...
apstewart Posted December 18, 2013 Share Posted December 18, 2013 You can integrate Copper with Inventoria. For instructions, please see this discussion and scroll down to the bottom: http://nch.invisionzone.com/index.php?/topic/19764-copper-and-inventoria-together/ Let me know if I misunderstood your question... Link to comment Share on other sites More sharing options...
burton2663 Posted December 29, 2013 Share Posted December 29, 2013 i have configured sync access of copper and inventoria, i can view the data of inventoria in copper. made a transaction in copper gave me this error Sync error connection rejected - application integration not enabled by copper Link to comment Share on other sites More sharing options...
burton2663 Posted December 29, 2013 Share Posted December 29, 2013 im good now, changed all ports to 1097 Link to comment Share on other sites More sharing options...
burton2663 Posted December 29, 2013 Share Posted December 29, 2013 i tried deleting transactions in copper, will inventoria return quantity back to how many it was before transaction? it is still unchanged tnx Link to comment Share on other sites More sharing options...
osos Posted January 28, 2014 Share Posted January 28, 2014 Novice, same here , when deleting or refunding , the transaction is not reflected on inventoria . have you found any solution Link to comment Share on other sites More sharing options...
MCS_Martin Posted January 28, 2014 Author Share Posted January 28, 2014 You can integrate Copper with Inventoria. For instructions, please see this discussion and scroll down to the bottom: http://nch.invisionz...toria-together/ Let me know if I misunderstood your question... Sorry about the delay in getting back to you! Yes you have misunderstood the question. I have copper and Inventoria talking to each other just fine, this issue is the reporting of profits and such. Inventoria shows the stock levels dropping when I use copper to sell and item but the reporting functions don't show the sales that have gone through Copper, only the stock levels. For accounting purposes I NEED the sales figures and profit, tax margines which Copper doesn't have the full range of reports but Inventoria does but won't show the sales infromation! Thanks Martin Shelton Martin's Computer Service Link to comment Share on other sites More sharing options...
apstewart Posted January 29, 2014 Share Posted January 29, 2014 I checked and verified the limitation in the reports. In the short term, would it be sufficient if the Copper data could be imported and displayed in the Inventoria "Sales Report"? Or will you need more information than that? Link to comment Share on other sites More sharing options...
apstewart Posted January 29, 2014 Share Posted January 29, 2014 The feature is not supported, but you can save the reports in CSV format and manipulate the data in Excel. Here is one approach: (1) Open the Inventoria "Inventory" report. Go to Report -> Save as CSV and save it. (2) Open the Copper "Item: Sales" report. Go to Report -> Save as CSV and save it. (3) Open the Copper "Item: Refunds" report. Go to Report -> Save as CSV and save it. (4) Open all three files in Excel. (5) Also open a blank file in Excel. (6) Copy and paste the tables from the Inventory, Item Sales, and Item Refund reports into the new table. Paste them side-by-side with a column between each one. (7) You now have three tables, side-by-side, on a single Excel sheet. If you want, you can insert a top row and label them as "Inventory", "Sales", and "Refunds". (8) Select and highlight in bold the columns that will matter. These are "Item" and "Item Code", "Cost Value", "Disc. Value" (the price after discounts), and "Qty". (9) Make sure the Item Codes match up on all three tables, so that an item is on one row. You may need to move the refund values down to the correct locations. (10) Create a new column, "Net Sales", to the right. It is calculated as the Sales table "Disc. Value" minus the Refunds table "Disc. Value", or =M2-S2 (11) Create a new column, "Net Cost" to the right. it is ((Sales:Qty)-(Refunds:Qty)) * (Inventory:Cost Value), or =(K2-Q2)*F2 (12) Create a new column, "Net Profit" to the right. It is "Net Sales" - "Net Cost". Then add column totals and any other calculations you need. I hope that helps, even if it's not as easy as it could be. Link to comment Share on other sites More sharing options...
Kuberan Posted February 20, 2015 Share Posted February 20, 2015 Dear All, Is there any updated suit release for sales report? Kuberan Link to comment Share on other sites More sharing options...
miedzi Posted May 4, 2016 Share Posted May 4, 2016 sell report still not function Link to comment Share on other sites More sharing options...
miedzi Posted May 4, 2016 Share Posted May 4, 2016 hi, im purchase inventoria and cooper sell. its work perfect togather. The problem is one only, i cannot view sell report on inventoria, when i click sell report, its blank and and showing profit is 0. Somebody can update me what is the problem Link to comment Share on other sites More sharing options...
eroxas Posted May 17, 2016 Share Posted May 17, 2016 Hello, Same here. No Sales Profit Report either in Copper or Inventoria. Hopefully someone from the "Admin" of this forum give us answer if they releasing a new version where we can generate a Sales Profit Report. I think including it on Copper POS system will be great. Link to comment Share on other sites More sharing options...
Chris75 Posted May 17, 2016 Share Posted May 17, 2016 The synchronization works for Inventoria to keep track only of the stock availability, everything related to sales, reports and anything else not Stock would be handled by Copper. The sales profit reports is not available on Copper but we will forward your suggestions to our developers for further consideration. Link to comment Share on other sites More sharing options...
bayusatrialegawa Posted March 22, 2017 Share Posted March 22, 2017 Same issue with me.. copper records transaction but not profit report, meanwhile inventoria records sales profit but not the transaction that recorded in copper (even it already integrated with copper)... I cannot understand what is the purpose of each program in term of this matter. But I think the software creator designed copper for the employee who better don't know about the things that should be considered as a company confidential such a : profit report, cost value etc.. you can imagine what happen if the employee knows about the profit or cost value.. so copper was designed to be operated by employee not the business owner. And the missing link is when the business owner cannot see the sales profit.. and their products movement.. so i suggest to the software developer to : 1. Leave copper just like now, (no need to make any revision in copper), so the profit and cost value only known by business owner 2. Provide sales report and other important report for the business owner (maybe can thru express account because inventoria is for inventory management) And I still don't see the connection of express account on this issue.. Link to comment Share on other sites More sharing options...
Jacques Posted September 15, 2017 Share Posted September 15, 2017 On 12/29/2013 at 8:09 PM, burton2663 said: i have configured sync access of copper and inventoria, i can view the data of inventoria in copper. made a transaction in copper gave me this error Sync error connection rejected - application integration not enabled by copper I have the same error. Any resolution on this yet? Link to comment Share on other sites More sharing options...
shazzaB Posted February 22, 2018 Share Posted February 22, 2018 Same here guys put the programs on new pc before was working fine could get everything sales report included but now on the new pc i cant even get a sales report and help would be great all 4 programs are linked together stock changes on inventoria when a sale is made but thats it Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now