Menu
▾
▴
web-erp-developers
|
From: Phil D. <ph...@lo...> - 2010-04-08 22:06:51
|
I still don't understand how the sales in the POS are brought into the ERP application. Processing the sales and credits requires updates and inserts to many tables it is not just a question of harmonising the tables between the POS and the ERP system. Much better to process transactions through the XML-RPC API in as close to real time as possible but with some mechanism to deal with interuption to connectivity. The Pentaho approach would work ok for stock quantites and stock master info and pricing. However I think we could do better and with less complexity for the configuration. Phil Daintree Logic Works Ltd - 0275 567890 -----Original Message----- From: Janvl <jv...@st...> Date: Thu, 8 Apr 2010 13:07:32 To: <web...@li...> Subject: Re: [WebERP-developers] POS 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. ------------------------------------------------------------------------------ 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: Tim S. <ti...@we...> - 2010-04-09 16:02:07
|
Hi Phil. I agree completely. The only way to have a sensible interface as I have said before is through the api. Tim On 8 April 2010 23:05, Phil Daintree <ph...@lo...> wrote: > I still don't understand how the sales in the POS are brought into the ERP application. Processing the sales and credits requires updates and inserts to many tables it is not just a question of harmonising the tables between the POS and the ERP system. > > Much better to process transactions through the XML-RPC API in as close to real time as possible but with some mechanism to deal with interuption to connectivity. The Pentaho approach would work ok for stock quantites and stock master info and pricing. However I think we could do better and with less complexity for the configuration. > > > > Phil Daintree > Logic Works Ltd - 0275 567890 > > -----Original Message----- > From: Janvl <jv...@st...> > Date: Thu, 8 Apr 2010 13:07:32 > To: <web...@li...> > Subject: Re: [WebERP-developers] POS > > > 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. > > ------------------------------------------------------------------------------ > 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 > ------------------------------------------------------------------------------ > 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: ExsonQu <hex...@gm...> - 2010-10-08 07:09:36
|
Hi, Logam Sunwares
The message shows that there is some problem about tax setting
for the item invoiced.
You can check the item details of Tax category. Is it set? And
please check if the taxprovince for warehouse has been set or not. And then
the Tax group is right or not?
Concerning to tax setting, please refer to the link for more
details: http://www.weberp.org/BasicSalesTax
http://www.weberp.org/BasicSalesTax
And you can also find tax setting in the manual in your system
about tax setting.
Hope it's helpful.
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/POS-tp1549501p2967933.html
Sent from the web-erp-developers mailing list archive at Nabble.com.
|
|
From: Tim S. <ti...@we...> - 2010-04-05 19:43:50
|
Hi, Years ago I did some stuff with Java and xml-rpc, and the xml-rpc implementation on Java was very easy to use. I'm sure we could make a direct link from openbravo to weberp fairly easily here. Trouble is I am unfamiliar with the workings of openbravo, and how easily the code could go into there. I guess as their main product is an erp they may be reluctant to take our code. As Lindsay has pointed out there so far isn't an api call to convert an order into an invoice, but the coding isn't hard to do, just a bit time consuming. Tim On 5 April 2010 07:05, Phil Daintree <ph...@lo...> wrote: > 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 >> > > > ------------------------------------------------------------------------------ > 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: Phil D. <ph...@lo...> - 2010-04-05 21:12:16
|
I think I would be able to add the code to do all the updates required to do the invoicing bit in webERP if there is a java developer who can send out openbravoPOS transactions - to a file for syncing with webERP. Yes most unlikely that there is any chance of having openbravoPOS support a link to webERP but why couldn't we host this as a separate project if need be. Phil Phil Daintree Logic Works Ltd - 0275 567890 -----Original Message----- From: Tim Schofield <ti...@we...> Date: Mon, 5 Apr 2010 20:43:39 To: webERP Developers<web...@li...> Subject: Re: [WebERP-developers] POS Hi, Years ago I did some stuff with Java and xml-rpc, and the xml-rpc implementation on Java was very easy to use. I'm sure we could make a direct link from openbravo to weberp fairly easily here. Trouble is I am unfamiliar with the workings of openbravo, and how easily the code could go into there. I guess as their main product is an erp they may be reluctant to take our code. As Lindsay has pointed out there so far isn't an api call to convert an order into an invoice, but the coding isn't hard to do, just a bit time consuming. Tim On 5 April 2010 07:05, Phil Daintree <ph...@lo...> wrote: > 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 >> > > > ------------------------------------------------------------------------------ > 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 ------------------------------------------------------------------------------ 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: Tim S. <ti...@we...> - 2010-04-05 19:48:54
|
Hi Jan, One of the problems with updating the weberp database directly from the pos, rather than using the api, is that often transactions are complex and must update several tables, and perform other checks on the data. Also the db structure can change over time, causing problems when you do the updates. The api takes care of that and does all the transactions and checks seamlessly for you. Tim On 5 April 2010 08:40, Janvl <jv...@st...> wrote: > > 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 > -- WebERP Africa Ltd +447710427049 +255784602561 www.weberpafrica.com |
|
From: Janvl <jv...@st...> - 2010-04-05 20:46:20
|
Hi Tim, the POS and the ERP that are called Openbravo nowadays are in fact an ERP fork from Compiere and the POS is actually Tinapos, both are written in Java but a realtime connection is absolutely not there. This API is something I must read about, since I am rather new here and not such a great developer I might ask some more questions . . . . The first is for a link where to start reading about the API. The ERP is installed at my customer, customer-tables and vendor-tables are loaded and now I am preparing to load the general ledger (in Austrian version). When that is done we will start running some tests with life examples. Kind regards, Jan Tim Schofield-4 wrote: > > Hi Jan, > > One of the problems with updating the weberp database directly from > the pos, rather than using the api, is that often transactions are > complex and must update several tables, and perform other checks on > the data. Also the db structure can change over time, causing problems > when you do the updates. The api takes care of that and does all the > transactions and checks seamlessly for you. > > Tim > > > On 5 April 2010 08:40, Janvl <jv...@st...> wrote: >> >> 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 >> > > > > -- > WebERP Africa Ltd > +447710427049 > +255784602561 > www.weberpafrica.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 > > -- View this message in context: http://n4.nabble.com/POS-tp1549501p1752083.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