Re: POS Integration: Step 1

[Rushabh Mehta]

Hi Jude / Olawale,

You can also post this on the developer forum, so that others can also benefit and we can share knowledge.

1. Direct database push is not recommended, a lot of validations and triggers are written inside the python app. 

2. The trasaction names and table names have a direct mapping - For example Sales Invoice has table `tabSales Invoice` and so on and so forth. You should just do some transactions from the client and then check the database for the impact.

best,

Rushabh

best,

Rushabh

W: https://erpnext.com
T: @rushabh_mehta

On 17-Jan-2013, at 8:39 PM, jude....@microtrainingrooms.com wrote:

Dear Rushabh Mehta,

we are working on integrating a POS system with ERPNext.

The POS application is a client - server application; so the plan is to create a Windows Services that will at intervals pick transactions from the database and post to ERPNext.

the easiest approach from our perspective is a direct database hit. these are the questions therefore

1. can we have direct connection to the database as against using the python api?
2. what are the tables (and columns) affected by various types of transactions (data dictionary)?



Thanks

Jude Mgbaka
Xavier Ltd (consulting developer)

[Bhuvaneshwari S]

can you say me the integrating steps with erpnext

[rushabh]

You can use web services to integrate with ERPNext

In version 3, use: 

https://github.com/frappe/wn-client/blob/master/wn_client/wn_client.py