Menu
▾
▴
web-erp-developers
|
From: Phil D. <ph...@lo...> - 2010-02-13 09:28:28
|
I've been trying to learn a bit of java so I can modify a java POS to work with webERP data .... I tried to get synPOS going but couldn't figure out why it didn't work. I have found a very steep learning curve getting going with Java - I have netbeans IDE installed. I installed openbravoPOS too - at least this seems to work but I just can't get into the logic of the application is so abstract it is unbelievable the amount of knowledge you need to start off is mind blowing - I've been reading for two days solid!! Has anyone got a good open-source desktop POS - that works with local hardware ideally USB printers, cash drawers and barcode scanners. Unfortunately, PHP based POS is a non-starter as far as I can see because the web-server is potentially remote from the hardware? Phil |
|
From: Phil D. <ph...@du...> - 2004-02-24 07:31:12
|
I am almost clueless about what is required for a POS system but here are a few links: The perl ones ... ??? http://gibbon.sourceforge.net/ http://l-ane.sourceforge.net/ a php one ... http://www.phppointofsale.com/ java ones .. http://freemercator.sourceforge.net/ http://www.open-mag.com/features/Vol_65/POS/mercator.htm General POS info: http://www.linux-pos.org/openspos.html Phil |
|
From: Stins, D. <DR...@Zi...> - 2004-02-24 21:24:33
|
Hoi, I know that in The Netherlands, there is a bakery chain using (free?) mercator. I has over 100 shops. Their amount of different items is limited. I guess about 200. With best regards, Dick Stins > ----- Original Message ----- > From: "Phil Daintree" <ph...@du...> > To: <web...@li...> > Sent: Tuesday, February 24, 2004 8:31 AM > Subject: [Web-erp-developers] POS > > > > > > I am almost clueless about what is required for a POS system but here are > a > > few links: > > > > The perl ones ... ??? > > http://gibbon.sourceforge.net/ > > http://l-ane.sourceforge.net/ > > > > a php one ... > > http://www.phppointofsale.com/ > > > > java ones .. > > > > http://freemercator.sourceforge.net/ > > http://www.open-mag.com/features/Vol_65/POS/mercator.htm > > > > General POS info: > > > > http://www.linux-pos.org/openspos.html > > > > Phil > > > > > > > > > > > > ------------------------------------------------------- > > SF.Net is sponsored by: Speed Start Your Linux Apps Now. > > Build and deploy apps & Web services for Linux with > > a free DVD software kit from IBM. Click Now! > > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click > > _______________________________________________ > > Web-erp-developers mailing list > > Web...@li... > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > |
|
From: Phil D. <ph...@du...> - 2004-09-14 23:46:54
|
Alan or anyone else, I am actually after a bit of advice. I remember Alan's postings to the web-erp list regarding the use of POS terminals with web-erp and the difficulty associated with getting the specs and low level data on them. I wondered if you ever had any success? Or if you had explored any other POS solutions for web-erp. Phil |
|
From: Chris F. <chr...@ch...> - 2010-02-13 21:54:23
|
Hi Phil, I agree with you, Java is way too complicated syntax-wise. Have you ever heard of xTuple (http://www.xtuple.com/xtpos)? They have a POS extension to their xTuple ERP function. I have not used this but I have looked at the ERP functionality before and it appears to be quite complete. It is open source though certain functionality requires license purchase. It is definitely easier on the eyes than the synPOS you mentioned. Back when I was in college, I used to work for an American retail chain called RadioShack. We used to have small servers in the store that were the main data repository for the store POS terminals. In the same sense you could have a small linux server serving up your webpages on site and run a PHP-based POS. Or you could actually run the entire mySQL/PHP server on every POS and have a sync process to the main server offsite. There are many options, I am not sure of the constraints of the project you are working on and what device communication you may need (serial or otherwise) that may preclude the PHP-based solution even if you could remove the remote server issue. Cheers Chris On Feb 13, 2010, at 5:32 AM, Phil Daintree wrote: > I've been trying to learn a bit of java so I can modify a java POS to > work with webERP data .... I tried to get synPOS going but couldn't > figure out why it didn't work. > > I have found a very steep learning curve getting going with Java - I > have netbeans IDE installed. I installed openbravoPOS too - at least > this seems to work but I just can't get into the logic of the > application is so abstract it is unbelievable the amount of knowledge > you need to start off is mind blowing - I've been reading for two days > solid!! > > Has anyone got a good open-source desktop POS - that works with local > hardware ideally USB printers, cash drawers and barcode scanners. > Unfortunately, PHP based POS is a non-starter as far as I can see > because the web-server is potentially remote from the hardware? > > Phil > > ------------------------------------------------------------------------------ > SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, > Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW > http://p.sf.net/sfu/solaris-dev2dev > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Phil D. <ph...@lo...> - 2010-02-14 02:20:43
|
Thanks Chris I'll check it out. Phil Chris Franks wrote: > Hi Phil, > > I agree with you, Java is way too complicated syntax-wise. > > Have you ever heard of xTuple (http://www.xtuple.com/xtpos)? They have > a POS extension to their xTuple ERP function. I have not used this but > I have looked at the ERP functionality before and it appears to be quite > complete. It is open source though certain functionality requires > license purchase. It is definitely easier on the eyes than the synPOS > you mentioned. > > Back when I was in college, I used to work for an American retail chain > called RadioShack. We used to have small servers in the store that were > the main data repository for the store POS terminals. In the same sense > you could have a small linux server serving up your webpages on site and > run a PHP-based POS. Or you could actually run the entire mySQL/PHP > server on every POS and have a sync process to the main server offsite. > There are many options, I am not sure of the constraints of the project > you are working on and what device communication you may need (serial or > otherwise) that may preclude the PHP-based solution even if you could > remove the remote server issue. > > Cheers > Chris > > > > > On Feb 13, 2010, at 5:32 AM, Phil Daintree wrote: > >> I've been trying to learn a bit of java so I can modify a java POS to >> work with webERP data .... I tried to get synPOS going but couldn't >> figure out why it didn't work. >> >> I have found a very steep learning curve getting going with Java - I >> have netbeans IDE installed. I installed openbravoPOS too - at least >> this seems to work but I just can't get into the logic of the >> application is so abstract it is unbelievable the amount of knowledge >> you need to start off is mind blowing - I've been reading for two days >> solid!! >> >> Has anyone got a good open-source desktop POS - that works with local >> hardware ideally USB printers, cash drawers and barcode scanners. >> Unfortunately, PHP based POS is a non-starter as far as I can see >> because the web-server is potentially remote from the hardware? >> >> Phil >> >> ------------------------------------------------------------------------------ >> SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, >> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW >> http://p.sf.net/sfu/solaris-dev2dev >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, > Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW > http://p.sf.net/sfu/solaris-dev2dev > > > ------------------------------------------------------------------------ > > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Moxx C. <sa...@mo...> - 2010-02-15 05:17:10
|
Hi Phil - Barcode scanners could work with WebERP - all that is needed is to ensure the cursor is on the field that receives input (just like a keyboard), and configure the barcode scanner to end its input with a carriage return or a tab. We have set up a few pages to accept orders and print sales receipts - though they use Javascript, they are built on WebERP, so may be easier to integrate. A few features: - Customer if not explicitly selected, defaults to a "anonymous customer" - Faster data entry - scan barcode or autocomplete on product name - Quantity defaulted to 1 - on entry of sales order, invoices are automatically created with delivered qty = ordered qty - page to receive cash (cheques/Credit cards could be added if needed) - total received and change to be provided back is displayed. - on receipt of cash, create customer payment receipt, update stock. The sales receipt would be a PDF - it may be possible to use a window.print() to print quickly or use background printing. Let me know if you need the code - it may need some tweaking and then be ready to use with WebERP. One solution to the cash drawer interface (I haven't tried this) can be found here: http://bit.ly/6ITAON Regards, Nagaraj ______ http://weberp.moxx.in -- View this message in context: http://n4.nabble.com/POS-tp1549501p1555791.html Sent from the web-erp-developers mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2010-02-15 08:52:56
|
Yes barcode scanning is easy using a keyboard wedge arrangement ... but opening a cash drawer and printing to a receipt printer... the web-server in the US and the POS in New Zealand? Those articles are exactly what I was looking for - I did google around but didn't scroll right on this web-page which didn't render correctly on seamonkey!! I think receipts need to print text immediately, directly to the printer. Is it possible then to have POS inside webERP? It seems I may have been I have been too hasty to rule this out before? Great to have you back Nagaraj - hope your honeymoon is not yet over! If you could send me the code - I'd like to have a play with it! Many thanks Phil Moxx Consulting wrote: > Hi Phil - > > Barcode scanners could work with WebERP - all that is needed is to ensure > the cursor is on the field that receives input (just like a keyboard), and > configure the barcode scanner to end its input with a carriage return or a > tab. > > We have set up a few pages to accept orders and print sales receipts - > though they use Javascript, they are built on WebERP, so may be easier to > integrate. A few features: > > - Customer if not explicitly selected, defaults to a "anonymous customer" > - Faster data entry - scan barcode or autocomplete on product name > - Quantity defaulted to 1 > - on entry of sales order, invoices are automatically created with delivered > qty = ordered qty > - page to receive cash (cheques/Credit cards could be added if needed) - > total received and change to be provided back is displayed. > - on receipt of cash, create customer payment receipt, update stock. > > The sales receipt would be a PDF - it may be possible to use a > window.print() to print quickly or use background printing. Let me know if > you need the code - it may need some tweaking and then be ready to use with > WebERP. > > One solution to the cash drawer interface (I haven't tried this) can be > found here: http://bit.ly/6ITAON > > Regards, > Nagaraj > ______ > http://weberp.moxx.in > > > |
|
From: Phil D. <ph...@lo...> - 2010-02-15 09:19:10
|
Ah reading a little more about this ...to use this solution to open cash drawers and link to printers the php extension PHP-GTK needs to be used. From the PHP-GTK FAQ at http://gtk.php.net/faq.php Why is it not working with the browser/web server? PHP-GTK is not meant to be used in the Web environment. It is intended for creation of standalone applications (run via command-line, user's desktop, etc.). Interesting - maybe this is a way to leverage PHP knowledge to write a client side POS that works on any platform... could be opening up a whole new field!! Phil Moxx Consulting wrote: > Hi Phil - > > Barcode scanners could work with WebERP - all that is needed is to ensure > the cursor is on the field that receives input (just like a keyboard), and > configure the barcode scanner to end its input with a carriage return or a > tab. > > We have set up a few pages to accept orders and print sales receipts - > though they use Javascript, they are built on WebERP, so may be easier to > integrate. A few features: > > - Customer if not explicitly selected, defaults to a "anonymous customer" > - Faster data entry - scan barcode or autocomplete on product name > - Quantity defaulted to 1 > - on entry of sales order, invoices are automatically created with delivered > qty = ordered qty > - page to receive cash (cheques/Credit cards could be added if needed) - > total received and change to be provided back is displayed. > - on receipt of cash, create customer payment receipt, update stock. > > The sales receipt would be a PDF - it may be possible to use a > window.print() to print quickly or use background printing. Let me know if > you need the code - it may need some tweaking and then be ready to use with > WebERP. > > One solution to the cash drawer interface (I haven't tried this) can be > found here: http://bit.ly/6ITAON > > Regards, > Nagaraj > ______ > http://weberp.moxx.in > > > |
|
From: David L. <da...@ra...> - 2010-02-15 09:48:16
|
From memory when I used to play with such things - The cash drawer was connected to the receipt printer and you just printed a special escape sequence and the drawer popped open. HTH, David Phil Daintree wrote: > Ah reading a little more about this ...to use this solution to open cash > drawers and link to printers the php extension PHP-GTK needs to be used. > > From the PHP-GTK FAQ at http://gtk.php.net/faq.php > > Why is it not working with the browser/web server? > > PHP-GTK is not meant to be used in the Web environment. It is > intended for creation of standalone applications (run via command-line, > user's desktop, etc.). > > Interesting - maybe this is a way to leverage PHP knowledge to write a > client side POS that works on any platform... could be opening up a > whole new field!! > > Phil > > > Moxx Consulting wrote: >> Hi Phil - >> >> Barcode scanners could work with WebERP - all that is needed is to ensure >> the cursor is on the field that receives input (just like a keyboard), and >> configure the barcode scanner to end its input with a carriage return or a >> tab. >> >> We have set up a few pages to accept orders and print sales receipts - >> though they use Javascript, they are built on WebERP, so may be easier to >> integrate. A few features: >> >> - Customer if not explicitly selected, defaults to a "anonymous customer" >> - Faster data entry - scan barcode or autocomplete on product name >> - Quantity defaulted to 1 >> - on entry of sales order, invoices are automatically created with delivered >> qty = ordered qty >> - page to receive cash (cheques/Credit cards could be added if needed) - >> total received and change to be provided back is displayed. >> - on receipt of cash, create customer payment receipt, update stock. >> >> The sales receipt would be a PDF - it may be possible to use a >> window.print() to print quickly or use background printing. Let me know if >> you need the code - it may need some tweaking and then be ready to use with >> WebERP. >> >> One solution to the cash drawer interface (I haven't tried this) can be >> found here: http://bit.ly/6ITAON >> >> Regards, >> Nagaraj >> ______ >> http://weberp.moxx.in >> >> >> > > ------------------------------------------------------------------------------ > SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, > Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW > http://p.sf.net/sfu/solaris-dev2dev > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 9.0.733 / Virus Database: 271.1.1/2688 - Release Date: 02/15/10 06:35:00 > -- Regards, David Lamotte Managing Consultant Rams-Pro Technology Pty Ltd ABN: 43 126 822 026 Phone: (02) 4021 1079 Fax: (02) 8569 0320 Mobile: 0422 978 643 Int'l: +61 240 211 079 +61 422 978 643 Web: http://rams-pro.com.au Disclaimer: This email and any attached files are intended solely for the named addressee, are confidential and may contain legally privileged information. The copying or distribution of them or any information they contain, by anyone other than the addressee, is prohibited. If you have received this email in error, please advise the sender by telephone or return the email before destroying all copies. Thank you. |
|
From: Matt T. <ma...@li...> - 2010-02-16 16:27:21
|
I have been hearing about Mozilla's Prism, and wonder if it might have features that would help in this effort. Matt David Lamotte wrote: > From memory when I used to play with such things - The cash drawer was > connected to the receipt printer and you just printed a special escape > sequence and the drawer popped open. > > HTH, > David > > Phil Daintree wrote: > >> Ah reading a little more about this ...to use this solution to open cash >> drawers and link to printers the php extension PHP-GTK needs to be used. >> >> From the PHP-GTK FAQ at http://gtk.php.net/faq.php >> >> Why is it not working with the browser/web server? >> >> PHP-GTK is not meant to be used in the Web environment. It is >> intended for creation of standalone applications (run via command-line, >> user's desktop, etc.). >> >> Interesting - maybe this is a way to leverage PHP knowledge to write a >> client side POS that works on any platform... could be opening up a >> whole new field!! >> >> Phil >> >> >> Moxx Consulting wrote: >> >>> Hi Phil - >>> >>> Barcode scanners could work with WebERP - all that is needed is to ensure >>> the cursor is on the field that receives input (just like a keyboard), and >>> configure the barcode scanner to end its input with a carriage return or a >>> tab. >>> >>> We have set up a few pages to accept orders and print sales receipts - >>> though they use Javascript, they are built on WebERP, so may be easier to >>> integrate. A few features: >>> >>> - Customer if not explicitly selected, defaults to a "anonymous customer" >>> - Faster data entry - scan barcode or autocomplete on product name >>> - Quantity defaulted to 1 >>> - on entry of sales order, invoices are automatically created with delivered >>> qty = ordered qty >>> - page to receive cash (cheques/Credit cards could be added if needed) - >>> total received and change to be provided back is displayed. >>> - on receipt of cash, create customer payment receipt, update stock. >>> >>> The sales receipt would be a PDF - it may be possible to use a >>> window.print() to print quickly or use background printing. Let me know if >>> you need the code - it may need some tweaking and then be ready to use with >>> WebERP. >>> >>> One solution to the cash drawer interface (I haven't tried this) can be >>> found here: http://bit.ly/6ITAON >>> >>> Regards, >>> Nagaraj >>> ______ >>> http://weberp.moxx.in >>> >>> >>> >>> |
|
From: Janvl <jv...@st...> - 2010-04-01 21:37:34
|
Hi, I have implemented Openbravo POS and it is a bit of work to learn how to handle it, the structure is not that difficult once you get a hold on it. I want to connect it with webERP, that must not be too difficult using PHP and Mysql so if you want to do it together, let me know. Kind regards, Jan -- View this message in context: http://n4.nabble.com/POS-tp1549501p1748627.html Sent from the web-erp-developers mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2010-04-02 03:44:41
|
Jan, I came to the same conclusion - openbravoPOS seems to be the best open-source real POS software. Where I fell down though was I just didn't have the staying power to learn Java!! It would be brilliant to offer some mods to openbravoPOS to enable integration with webERP - but it looks just too tough for me sadly. I'd be happy to help on the webERP end though if someone else has some Java skills. Phil Janvl wrote: > Hi, > > I have implemented Openbravo POS and it is a bit of work to learn how to > handle it, > the structure is not that difficult once you get a hold on it. > I want to connect it with webERP, that must not be too difficult using PHP > and Mysql > so if you want to do it together, let me know. > > Kind regards, > Jan > |
|
From: Janvl <jv...@st...> - 2010-04-03 14:39:10
|
Hi Phil, in my opinion one does not need to programm in Java, the database is a Mysql database and the tables have a very logical structure, so we just need to decide what needs to be imported to webERP and how. I have considered that maybe EDI is an option. But I am open to any idea. Main point is that if one is using both, the inventory should be done inside webERP because it has a much better structure to do so. BTW even openbravo itself only connects the databases using Kettle/Spoon in order to get the data from POS to ERP and in the forum one developer already made a PHP-script to interchange data with the POS. Kind regards, Jan -- View this message in context: http://n4.nabble.com/POS-tp1549501p1750164.html Sent from the web-erp-developers mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2010-04-03 23:29:22
|
Well I suppose you could Phil Daintree Logic Works Ltd - 0275 567890 -----Original Message----- From: Janvl <jv...@st...> Date: Sat, 3 Apr 2010 06:39:03 To: <web...@li...> Subject: Re: [WebERP-developers] POS Hi Phil, in my opinion one does not need to programm in Java, the database is a Mysql database and the tables have a very logical structure, so we just need to decide what needs to be imported to webERP and how. I have considered that maybe EDI is an option. But I am open to any idea. Main point is that if one is using both, the inventory should be done inside webERP because it has a much better structure to do so. BTW even openbravo itself only connects the databases using Kettle/Spoon in order to get the data from POS to ERP and in the forum one developer already made a PHP-script to interchange data with the POS. Kind regards, Jan -- View this message in context: http://n4.nabble.com/POS-tp1549501p1750164.html Sent from the web-erp-developers mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Phil D. <ph...@lo...> - 2010-04-04 01:44:26
|
Well yes you could do periodic updates to the POS master data but maybe the POS master pricing was updated after the webERP master. To do a proper job of it after every sale on the POS the data needs to be propogated back to webERP and the stock at the POS location updated. Sales analysis tax GL etc all updated in as close to real time as possible. This is what Tim's API would allow if we could insert the calls to the webERP inside a queueing transactioninitiated from the java code that captured the return status to ensure the connection to webERP was live and the update happened. If the transaction was not processed by webERP it was logged for later processing. This way a live connection to webERP maybe not necessary but when one is the system could sync up to real time. I am sure a hack could be done more simply but there is no fun in half doing it! Phil Phil Daintree Logic Works Ltd - 0275 567890 -----Original Message----- From: Janvl <jv...@st...> Date: Sat, 3 Apr 2010 06:39:03 To: <web...@li...> Subject: Re: [WebERP-developers] POS Hi Phil, in my opinion one does not need to programm in Java, the database is a Mysql database and the tables have a very logical structure, so we just need to decide what needs to be imported to webERP and how. I have considered that maybe EDI is an option. But I am open to any idea. Main point is that if one is using both, the inventory should be done inside webERP because it has a much better structure to do so. BTW even openbravo itself only connects the databases using Kettle/Spoon in order to get the data from POS to ERP and in the forum one developer already made a PHP-script to interchange data with the POS. Kind regards, Jan -- View this message in context: http://n4.nabble.com/POS-tp1549501p1750164.html Sent from the web-erp-developers mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Janvl <jv...@st...> - 2010-04-04 11:32:00
|
I see it like this: The producttable in POS is a copy of that in the ERP, so if you add a new product it must be done in the ERP and a sync must be done with the POS The customertable in POS is a copy of that in the ERP, so if you add a new customer it must be done in the ERP and a sync must be done with the POS Sales made in the POS WITH an productnumber will be brought to the ERP in batches, or through a transaction Sales made in the POS WITHOUT a productnumber must be treated different, not yet sure how Sales made on a customername must somehow be linked to the customers in ERP Stock will be maintained in the ERP, with the POS you can sell even with no stock available, so the inventory is better done inside the ERP. I once had a system in the hospital I used to work that used a "virtual-printer" to send transaction-records to a system for X-ray results, sent to general practitioners. The POS has the ability to define the output of certain events, so maybe this would be an option. Working in realtime would be nice but we must consider if the work to be done and the benefits to gain are in balance. Kind regards, Jan -- View this message in context: http://n4.nabble.com/POS-tp1549501p1750845.html Sent from the web-erp-developers mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2010-04-05 05:06:41
|
I see it the same... In a full retail management system - POS integrated to accounting back end - there is linker software that manages the queued transactions from the separate POS's to ensure that not a single transaction is lost and the network can be lost at any time or be over 9600bps and still result in all transactions from the POS getting back to the core. So a new customer added at the POS must get back to webERP and there could be many POS's in operation all adding customers. The way to do this is to call Tim's add customer function through XMLRPC - this needs to be done from the java code of OpenBravoPOS.... if the network link is down and the function to the webERP API is not successful the change needs to be logged. Perhaps the easier way is to log all the changes using java to a local file and then run a PHP process against the file to the webERP API to do the updates. Similarly sales made at the POS should be logged to perhaps the same file and processed in the same way through the webERP API... I am not sure if there is yet an API function to process a sale directly creating the order etc ... I could do this bit if needed. I am surprised that sales are allowed without a product number?? The local POS stock would need to be maintained and if now unique identifier for stock exists I am not sure how effective the stock management in the local POS would be! In a full retail management system you can see the stock at each POS throughout the country for a given item this would be data fed back from webERP and is of course changing constantly as sales are made at each POS. If only half the job is done with the integration then we accept that the solution will never be ideal. Goals need to at least start to aim high. We need someone who can write java to log transactions sales returns, receipts of stock, stock adjustments etc performed through the POS to a file recording a transaction id, the item code, the quantity, the date/time, the customer (if any specified). The file would also allow changes to customers or additions and deletions of customers to be logged as transactions We can then run a PHP script on the file and process the transactions in webERP... What about price changes, stock takes and stock adjustments in webERP .... we would need these to come down to the POS too. We would need some process on the webERP end to manage transactions against the POS stock location to be sent back to the POS. Also stock master changes and bar codes etc to be sent down to the POS. It is not actually as easy as it sounds. Phil Janvl wrote: > I see it like this: > > The producttable in POS is a copy of that in the ERP, > so if you add a new product it must be done in the ERP and a sync must be > done with the POS > > The customertable in POS is a copy of that in the ERP, > so if you add a new customer it must be done in the ERP and a sync must be > done with the POS > > Sales made in the POS WITH an productnumber will be brought to the ERP in > batches, or through a transaction > > Sales made in the POS WITHOUT a productnumber must be treated different, not > yet sure how > > Sales made on a customername must somehow be linked to the customers in ERP > > Stock will be maintained in the ERP, with the POS you can sell even with no > stock available, > so the inventory is better done inside the ERP. > > > I once had a system in the hospital I used to work that used a > "virtual-printer" to send > transaction-records to a system for X-ray results, sent to general > practitioners. The POS has > the ability to define the output of certain events, so maybe this would be > an option. > > Working in realtime would be nice but we must consider if the work to be > done and the benefits to gain are in balance. > > Kind regards, > Jan > |
|
From: Lindsay H. <li...@bl...> - 2010-04-05 06:11:09
|
On Monday 05 April 2010 16:05:31 Phil Daintree wrote: > I see it the same... > > Similarly sales made at the POS should be logged to perhaps the same > file and processed in the same way through the webERP API... I am not > sure if there is yet an API function to process a sale directly creating > the order etc ... I could do this bit if needed. That bit works! I now regularly create sales orders by downloading an XML file from the online store (VirtualMart running under Joomla), then feed it through a PHP program and into the API. Bingo, sales orders entered. The API does not fully handle invoicing. Tim's application is a hospital, and (I'm guessing) his needs were only for the "executive summary" invoicing, namely transferring funds. There is no stock adjustment and all those other complications. I have been thinking about this for some time. Thuoghts are not fully set yet, but here's a rough sketch. WebERP's code structure should be split into 3 functional groups. 1/ Database manipulation 2/ HTML/web interface 3/ API 4/ POS???? Obviously 2 and 3 make calls into 1. The API is already structured as a 2 layer operation - the first deals with the RPC, converting incoming data to calls to regular PHP functions. And, obviously, doing the reverse on the way back. The other layer verifies the data and meddles with the database. Yet another benefit of this is another project I have for the future. The PHP program I use to transform the XML from VirtualMart is all table driven, coupled with PHP's XML decoding. This could be added to the HTML interface, with a set of tables to translate from XML tags to DB fields. In this instance, it would likely be that the HTML section (basically its job is to upload the XML and feed it into the XML decoder) would call the internal API functions to validate the data before applying it to the database. This is not a UTF style project, requiring it all be done at once. Before being distracted onto other subjects, I started ripping the invoice generating code out of the HTML generating file it is in currently. Then amend the API to use this to transfer stock and do all the other things the current API does not need to do. And then I also want to look at having webERP talk to PayPal. My problem is continuing to think of new ideas :-) Lindsay |
|
From: Janvl <jv...@st...> - 2010-04-05 07:40:09
|
Hi Phil, did you ever actually work with Openbravo POS? Using Mysql, I only have one Database on the server (intranet) and 3 POS-locations. Stock maintenance is poor, negative stock is possible. Discounts can be given on every product, even with a percentage that can vary. Sales can be done without a product, you only must (can) give a description. The POS is designed to catch all cash-movements, so you cannot project the high data-integrety of webERP on the POS if it is openbravo. This is why I think we should start with transactions that are easily feasable, happen on the server and limit it to pooring the data from openbravoPOS to webERP because stockmaintenance in webERP is superior to that in openbravoPOS. Kind regards, Jan -- View this message in context: http://n4.nabble.com/POS-tp1549501p1751385.html Sent from the web-erp-developers mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2010-04-05 20:53:24
|
I have only downloaded openbravoPOS and attempted to import the project into netbeans IDE. Had a play with sales only. I can't get into the logic of Openbravo without dedicating more time than I am prepared to commit. Hence I gave up! Phil Daintree Logic Works Ltd - 0275 567890 -----Original Message----- From: Janvl <jv...@st...> Date: Sun, 4 Apr 2010 23:40:03 To: <web...@li...> Subject: Re: [WebERP-developers] POS Hi Phil, did you ever actually work with Openbravo POS? Using Mysql, I only have one Database on the server (intranet) and 3 POS-locations. Stock maintenance is poor, negative stock is possible. Discounts can be given on every product, even with a percentage that can vary. Sales can be done without a product, you only must (can) give a description. The POS is designed to catch all cash-movements, so you cannot project the high data-integrety of webERP on the POS if it is openbravo. This is why I think we should start with transactions that are easily feasable, happen on the server and limit it to pooring the data from openbravoPOS to webERP because stockmaintenance in webERP is superior to that in openbravoPOS. Kind regards, Jan -- View this message in context: http://n4.nabble.com/POS-tp1549501p1751385.html Sent from the web-erp-developers mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: dxxchung <dom...@gm...> - 2010-04-07 03:44:23
|
I just installed openbravopos on my server. The connection with mysql driver is tricky. The mysql scripts for mysql files are not user-friendly and you have to find them somewhere and somehow. I installed them via phpmyadmin. I still don't know whether they are properly installed or not. For me, the connection of the product file with an ERP is the main concern. This must be done automatically to reflect price changes in a retail environment. Customer history and address is meaningless in a high volume retail outlet. Then everything can be done offline to update the stock movement. -- View this message in context: http://n4.nabble.com/POS-tp1549501p1753811.html Sent from the web-erp-developers mailing list archive at Nabble.com. |
|
From: Janvl <jv...@st...> - 2010-04-08 16:57:50
|
Hi, I do not understand the trouble with installing OBPOS, I have done it a few times now and it is not such a big deal. One needs to use the right drives for the DB. Considering the exchange of information between POS and ERP, here is how they do it at openbravo, http://wiki.openbravo.com/wiki/Openbravo_POS_Integration#Openbravo_POS_Web_Service Does not reallz look like a realtime-connection does it? Regards, Jan -- View this message in context: http://n4.nabble.com/POS-tp1549501p1774359.html Sent from the web-erp-developers mailing list archive at Nabble.com. |
|
From: Tim S. <ti...@we...> - 2010-04-08 19:41:52
|
Hi Jan, A real time connection is easier to do, and a better solution IMHO. The fact that Openbravo have chosen a different solution doesn't alter that. Tim On 8 April 2010 17:57, Janvl <jv...@st...> wrote: > > Hi, > > I do not understand the trouble with installing OBPOS, I have done it a few > times now and it is not such a big deal. One needs to use the right drives > for the DB. > > Considering the exchange of information between POS and ERP, here is how > they do it at > openbravo, > http://wiki.openbravo.com/wiki/Openbravo_POS_Integration#Openbravo_POS_Web_Service > > Does not reallz look like a realtime-connection does it? > > Regards, > Jan > -- > View this message in context: http://n4.nabble.com/POS-tp1549501p1774359.html > Sent from the web-erp-developers mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > -- WebERP Africa Ltd +447710427049 +255784602561 www.weberpafrica.com |
|
From: Janvl <jv...@st...> - 2010-04-08 21:07:40
|
Hi Tim you are absolutely right. I am now busy bringing the austrian general ledger into weberp, after the weekend I will have a look at the possibilities at the OBPOS side. Jan Tim Schofield-4 wrote: > > Hi Jan, > > A real time connection is easier to do, and a better solution IMHO. > The fact that Openbravo have chosen a different solution doesn't alter > that. > > Tim > -- View this message in context: http://n4.nabble.com/POS-tp1549501p1788675.html Sent from the web-erp-developers mailing list archive at Nabble.com. |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X