guys, is there any limitation on the demo version than the source one. as I cannot add any new organization with new products. However, the organization and the products exist in the demo version works fine between POS and ERP.
thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There is no limitation - source code and demo have the same fucntionality, don´t forget if you are adding new orgs you will need to update the ERP messages, POS resources and activemq queues definitions as it is shown in the demo, and it is explain in some of these threads: https://sourceforge.net/p/smart-pos/discussion/englishtechnical/thread/26803302/
Regards
Pedro Rozo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks Pedro for ur reply.the issue is that when I add new org or product it doesn't synch, but when I edit the existing demo products it accepts and synch fine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you managed to get working the demo with data, you will need to replicate the demo config with the three products ...which means a good understanding on the three : ERP, POS and activemq and their resources.
If during that process you have issues, you will need to be more specific (logs files, step by step, etc)
Regards,
Pedro Rozo.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As requested, Here are the steps I made:-
*SmartERP
- Login to the ERP (enter as System/sysDemo)
- Create Organization Type
- Create Organization (id: 1000008)
- Create Warehouse
- Create Locator
- Create Tax Category
- Create Price Schema
- Create Two Price List (Purchasing/Sales)
- Create Product
- Create Purchasing Order
- Create Material Receipt
So now, I have amount of this product in my stock
*Active MQ
- Create Queue with the organization id (1000008)
- Add queue (1000008) to activemq-security.xml
*SmartPOS
- login in as (System admin)
- Go to maintainance / resources and modify the following:-
--inqueu
--jms.url
--jms.url.out
--configuration
Now, I think, I am ready for sync
*SmartERP
- Login to the ERP (enter as System/sysDemo)
- Go to "SincronizaPOS" and click syncronize
*Activemq
- 1000008 queue have 735 message in it
*smartPOS
- synchronize with ERP .. sync finished
After Sync:-
The only Items I can see now in the SmartPOS is the tax and tax category.
Attached is my ERP log.
If you don't mind, Can I contribute to your project by providing a video tutorial of the configuration, creating a new organization, products and sync it to SmartPOS but just I need the steps
Please attach the smartpos log file as well to see more details about possible sync issues, and regarding contributions please go ahead an share with the communityt that is the spirit of open source working.
Pedro
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
your smartpos log suggests that your activemq config is wrong, ip address, port of similar (please double check them):
May 1, 2012 4:54:18 PM com.openbravo.pos.forms.JRootApp startActiveMQ
SEVERE: null
java.io.IOException: Failed to bind to server socket: tcp://196.218.198.51:61616 due to: java.net.BindException: Cannot assign requested address: JVM_Bind
The server log file that you have to analize and attach here is called /tmp/adempiere.log
Last edit: pedrorozo 2012-05-01
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
2.Please read inn special : SmartPOSResourcesReferenceV1-0.pdf with the information that you are requesting and all the other config parameters used for the POS:
Also check the demo config.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Now, I know for sure that:-
- jms url is <activemq server="" 61616="">
- jms url out <localhost 61617="">
- the product to be synced correctly we should make a super product category named "Pos" and put my product categories under it, Attach my product categories to my products. then you can find your products in the POS.
- to be able to make the sales transaction you need to add a group to your prodects and add it to SmartPos/Maintainace/Resources/Printer.Mapping
now, I can make the sales transactions from the pos but I can't get it on my erp.
when i had alook at the forums I can't get the "message" window that you mentioned in other discussions
From your screenshot I see your are not using the system admin role (during your login process you should choose it). That is the reason you still don't see all the system options .. include the message window
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Pedro you really are amazing , now I can see the message window you are talking about and I have found the "user maintained" messages. should I modify the pos resources based on these values or I modify these values inside the ERP.
I know I ask a lot of questions but this is the last step in the whole cycle to be able to prepare the video tutorial.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes Kalo .you should modify ERP messages and POS resource to be in sync, ip addresses, ports, queues and so on ..... be careful removing spaces and so on .. and analize the demo data in both ends (ERP and POS), you should have everything that you need there and detailed explanation of those parameters in the documentation.
BTW: Which country are you located ? what is your background .. ? how is yoru prod environment ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I found the message window, like you instructed and restored the db to the demo data. I made some sales and I can see the queue is increasing but i can't tell the erp to fetch these sales.
should I modify any properties in the ERP to be able to fetch the sales transactions (It's already syncing the products, taxes, customers data)
attached the Screen shots of the activemq and erp.
Glad to see you are almost done, If it is already syncing products, taxes, customers data and not the sales, you might have issues with the ERP configuration (accounting period closed, or similar issue), please analyze the ERP logs and look for warning or errors , usually they are very descriptive (/tmp/adempiere.log)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks Pedro the log was very helpful and we now can sync the sales transactions but one of the old errors that we faced was regarding the payment term as it accept one payment term (ex. Immediate) for all sales transactions (whether cash or credit card )
Exception:-
ERROR: insert or update on table "c_order" violates foreign key constraint "cpaymentterm_soheader"
Detail: Key (c_paymentterm_id)=(1000001) is not present in table "c_paymentterm".; State=23503; ErrorCode=0
our solution: was to set the payment term in message window to Immediate
how can we sync the payment term with the sales transaction correctly.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
-First Sale
On POS:- create a sale with payment cash or "Efectivo" (1000012)
on ERP:-sales order synced with Immediate as a payment term
-Second Sale
On POS:- create a sale with payment Creditcard or "Tarjeta de Crédito" (1000021)
on ERP:-sales order synced with Immediate as a payment term
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
1- I started ActiveMQ
2- I ran Adempiere (Swing) and ran the process SincronizaPOS
3- The messages are sent to activeMQ (I can see it in the queues in a browser)
4- I started SmartPOS as SytemAdministrator ->Maintenance->Resources and check: activeMQConfiguration it's Ok, jms.inqueue (1000007), jms.outqueue (ERP1000003), jms.userLogin (smart), jms.password (smartpwd), jms.url(tcp://172.16.5.33:61616) and jms.url.out(tcp://172.16.5.33:61617)
5- I restarted the SmartPOS and loggin as RestaurantAdmin and check customers and products and this data is synchronized in real-time when I make any changes in Adempiere. So it's Ok.
but I have a issue:
- When I try to change any customer or make a sale transaction not send xml messages to activeMQ.
- When I start the SmartPOS I notice in the log (SmartPOS-Sync.log) this log message: GRAVE: ** Connected to ACTIVEMQ url:>failover:tcp://172.16.5.33:61616<smart
I don´t understand your question, from your last message seems to be resolved, if not, please open a new thread with exact questions and so on to help you ....
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
guys, is there any limitation on the demo version than the source one. as I cannot add any new organization with new products. However, the organization and the products exist in the demo version works fine between POS and ERP.
thanks
Hi Kalo.
There is no limitation - source code and demo have the same fucntionality, don´t forget if you are adding new orgs you will need to update the ERP messages, POS resources and activemq queues definitions as it is shown in the demo, and it is explain in some of these threads: https://sourceforge.net/p/smart-pos/discussion/englishtechnical/thread/26803302/
Regards
Pedro Rozo
Thanks Pedro for ur reply.the issue is that when I add new org or product it doesn't synch, but when I edit the existing demo products it accepts and synch fine.
Kalo.
If you managed to get working the demo with data, you will need to replicate the demo config with the three products ...which means a good understanding on the three : ERP, POS and activemq and their resources.
If during that process you have issues, you will need to be more specific (logs files, step by step, etc)
Regards,
Pedro Rozo.
thanks Pedro, sorry for delay
As requested, Here are the steps I made:-
*SmartERP
- Login to the ERP (enter as System/sysDemo)
- Create Organization Type
- Create Organization (id: 1000008)
- Create Warehouse
- Create Locator
- Create Tax Category
- Create Price Schema
- Create Two Price List (Purchasing/Sales)
- Create Product
- Create Purchasing Order
- Create Material Receipt
So now, I have amount of this product in my stock
*Active MQ
- Create Queue with the organization id (1000008)
- Add queue (1000008) to activemq-security.xml
*SmartPOS
- login in as (System admin)
- Go to maintainance / resources and modify the following:-
--inqueu
--jms.url
--jms.url.out
--configuration
Now, I think, I am ready for sync
*SmartERP
- Login to the ERP (enter as System/sysDemo)
- Go to "SincronizaPOS" and click syncronize
*Activemq
- 1000008 queue have 735 message in it
*smartPOS
- synchronize with ERP .. sync finished
After Sync:-
The only Items I can see now in the SmartPOS is the tax and tax category.
Attached is my ERP log.
If you don't mind, Can I contribute to your project by providing a video tutorial of the configuration, creating a new organization, products and sync it to SmartPOS but just I need the steps
Kalo
Please attach the smartpos log file as well to see more details about possible sync issues, and regarding contributions please go ahead an share with the communityt that is the spirit of open source working.
Pedro
Pedro
As requested, here is the pos log file.
About the video, really thanks for letting me have this chance and if you want any specific scenarios please tell me.
Quick feedback:
May 1, 2012 4:54:18 PM com.openbravo.pos.forms.JRootApp startActiveMQ
SEVERE: null
java.io.IOException: Failed to bind to server socket: tcp://196.218.198.51:61616 due to: java.net.BindException: Cannot assign requested address: JVM_Bind
Last edit: pedrorozo 2012-05-01
thanks Pedro for quick feedback.
I attached the log that you requested.
can you please provide me with the correct way to get:-
jms.url
jms.url.out
I know that the "jms.url" ip is the server where i installed activemq but how can i get the port
and "jms.url.out" ip is localhost but how can i get it's port number too.
https://sourceforge.net/projects/smart-pos/files/docs/
2.Please read inn special : SmartPOSResourcesReferenceV1-0.pdf with the information that you are requesting and all the other config parameters used for the POS:
sorry Pedro for response delay (internet issue).
I'll check what u told me and feedback u.
thanks pedro for pointing me the solution.
Now, I know for sure that:-
- jms url is <activemq server="" 61616="">
- jms url out <localhost 61617="">
- the product to be synced correctly we should make a super product category named "Pos" and put my product categories under it, Attach my product categories to my products. then you can find your products in the POS.
- to be able to make the sales transaction you need to add a group to your prodects and add it to SmartPos/Maintainace/Resources/Printer.Mapping
now, I can make the sales transactions from the pos but I can't get it on my erp.
when i had alook at the forums I can't get the "message" window that you mentioned in other discussions
Kalo.
From your screenshot I see your are not using the system admin role (during your login process you should choose it). That is the reason you still don't see all the system options .. include the message window
Pedro you really are amazing , now I can see the message window you are talking about and I have found the "user maintained" messages. should I modify the pos resources based on these values or I modify these values inside the ERP.
I know I ask a lot of questions but this is the last step in the whole cycle to be able to prepare the video tutorial.
Yes Kalo .you should modify ERP messages and POS resource to be in sync, ip addresses, ports, queues and so on ..... be careful removing spaces and so on .. and analize the demo data in both ends (ERP and POS), you should have everything that you need there and detailed explanation of those parameters in the documentation.
BTW: Which country are you located ? what is your background .. ? how is yoru prod environment ?
I am from south Africa, my full-time job is in our embassy in Egypt and I work as a part time software engineer (java developer).
My production environment is ubuntu server 10.10
Hi pedro,
I found the message window, like you instructed and restored the db to the demo data. I made some sales and I can see the queue is increasing but i can't tell the erp to fetch these sales.
should I modify any properties in the ERP to be able to fetch the sales transactions (It's already syncing the products, taxes, customers data)
attached the Screen shots of the activemq and erp.
Glad to see you are almost done, If it is already syncing products, taxes, customers data and not the sales, you might have issues with the ERP configuration (accounting period closed, or similar issue), please analyze the ERP logs and look for warning or errors , usually they are very descriptive (/tmp/adempiere.log)
Thanks Pedro the log was very helpful and we now can sync the sales transactions but one of the old errors that we faced was regarding the payment term as it accept one payment term (ex. Immediate) for all sales transactions (whether cash or credit card )
Exception:-
ERROR: insert or update on table "c_order" violates foreign key constraint "cpaymentterm_soheader"
Detail: Key (c_paymentterm_id)=(1000001) is not present in table "c_paymentterm".; State=23503; ErrorCode=0
our solution: was to set the payment term in message window to Immediate
how can we sync the payment term with the sales transaction correctly.
Steps:-
-First Sale
On POS:-
create a sale with payment cash or "Efectivo" (1000012)
on ERP:-sales order synced with Immediate as a payment term
-Second Sale
On POS:-
create a sale with payment Creditcard or "Tarjeta de Crédito" (1000021)
on ERP:-sales order synced with Immediate as a payment term
Hi, I have been following this forum
regards Pedro and Kalo.
I installed full demo:
1- Install the databases: smarterp.backup and samrtpos.backup
2- Install erp Adempiere (with demo configuration)
3- Install SamrtPos (with demo configuration)
4- Install ActiveMQ (with demo configuration)
I tested it:
1- I started ActiveMQ
2- I ran Adempiere (Swing) and ran the process SincronizaPOS
3- The messages are sent to activeMQ (I can see it in the queues in a browser)
4- I started SmartPOS as SytemAdministrator ->Maintenance->Resources and check: activeMQConfiguration it's Ok, jms.inqueue (1000007), jms.outqueue (ERP1000003), jms.userLogin (smart), jms.password (smartpwd), jms.url(tcp://172.16.5.33:61616) and jms.url.out(tcp://172.16.5.33:61617)
5- I restarted the SmartPOS and loggin as RestaurantAdmin and check customers and products and this data is synchronized in real-time when I make any changes in Adempiere. So it's Ok.
but I have a issue:
- When I try to change any customer or make a sale transaction not send xml messages to activeMQ.
- When I start the SmartPOS I notice in the log (SmartPOS-Sync.log) this log message: GRAVE: ** Connected to ACTIVEMQ url:>failover:tcp://172.16.5.33:61616<smart
attached the log file
appreciate the help you can give me
regards
Edickson Martínez
Double Click Sistemas C.A.
Venezuela
Edickson, Please Start a new technical thread for your issue and please attach both ERP and POS log files ...
Hi Pedro,
is there any feedback for my issue. I appreciate your help as this the last step.
Kalo
I don´t understand your question, from your last message seems to be resolved, if not, please open a new thread with exact questions and so on to help you ....
ok I'll open New thread with title 'sales transactions on SmartPos received as only one payment type on SmartERP ' .
Thanks