ERP | OpenERP Implementations

Bista Solutions and OpenERP announced the release of an ecommerce module which integrates eBay with OpenERP. The OpenERP eBay connector was developed by Bista Solutions over a period of two years. Bista Solutions developed this connector while working with several leading eBay sellers. With the addition of this eBay connector, OpenERP further consolidates its position as a leading open source web based ERP and a solid alternative to expensive ERP…

A number of times clients ask us whether OpenERP has the capability to make Adhoc reports. It is very important for the client to have access to information which has been entered into the ERP and view it from a particular perspective. The base_report_creator module can be used to create powerful Adhoc reports, though it requires some level of technical expertise from the user to create the report – they…

There are many companies or people who feel more comfortable with excel file format. OpenERP allows you to export the reports in Excel, word or pdf format/ Whenever we create the report in RML it just outputs in pdf. Hence further processing on the generated reports and the pdf version is just not enough. There are 2 ways to generate report which can be exported to Excel / Word formats….

How to set up OpenERP for various timezone kindly follow the following steps to select timezone in OpenERP: Click on the “Edit Preferences” wheel at top right corner Click on the “Preferences” tab Select the timezone from Drop Down Menu Following code will be working for “GMT-x” time zones. Mostly US based. FMT = ”%Y-%m-%d %H:%M:%S” #Time Format #########################Timezone Logic######################## timezone_time = self.pool.get(”res.users”).browse(cr,uid,uid).context_tz #Timezone selected in OpenERP now_utc = datetime.now(timezone(”UTC”))…

Below is the method of calculating the Average Pricing in OpenERP Formula NP = (AP * QS + PP * QP) / (QS + QP) Example: NP = [AP(13.42)*QS(733)+PP(15)*QP(10)] / [QS(733)+QP(10)] NP = 13.44 Abbreviations: NP (New Price): New Average Price once product have been received in the warehouse. AP (Average Price): Old Average Price before product received in the warehouse. QS (Quantity Stock): Quantity stock before product received in the warehouse…