Posts Tagged ‘Open Source’

Bulk import of serial numbers in CSV or XLS file into outgoing picking (Delivery Orders) – Odoo 11.0

Tuesday, July 15th, 2025

Below technique is used on Odoo 11.0 community edition but should work on all versions.

First, we need to make sure that the item we need to put on the delivery order is in stock with serial numbers and everything. Also, don’t forget to click on Check Availability to insure the serials numbers are populated and reserved from stock. Then we head to the Inventory menu, then select Delivery Orders sub-menu, and select the delivery order under Ready status and then export from the Action menu.

We need to choose the below fields to export:

  • Reference
  • Stock Moves/Description
  • Stock Moves/ID
  • Stock Moves/Destination Location/ID
  • Stock Moves/Lots/Lot
  • Stock Moves/Lots/ID
  • Stock Moves/Lots/Lot/Serial Number
  • Stock Moves/Lots/Done
  • Stock Moves/Lots/Unit of Measure

Creating a file similar to the below sample file:

We will delete the rows that has no serial number and work on the ones who has, creating a one similar to the below file, copying the ids and replacing the QTY Done from 0 to 1:

No, we head again to Inventory menu, then select Delivery Orders sub-menu, and select Import.

This should work just fine.

OpenERP 7.0 with full RTL Right-to-Left Support on openSuSE 12.1

Saturday, June 1st, 2013

Today, we installed the latest openERP 7.0 on our openSuSE 12.1 server. Also, we patched the new openERP 7.0 code similar to our post http://am4computers.com/wordpress/archives/258  to enable RTL support. As of now, all is working great with full support for Arabic and Hebrew.

RTL support in OpenERP 5.0.11 and openSuSE 11.1 64 bits server.

Thursday, September 2nd, 2010

Today, we managed to implement a solution that allows RTL Arabic support for OpenERP 5.0.11 reporting engine on our openSuSE 11.1 64 bits server.

It has to do with enabling RTL in ReportLab, which is used by OpenERP to produce PDF reports. Also, OpenERP server code has to be patched to allow it to identify RTL and LTR test direction. OpenERP reporting engine is by default recognizes LTR only.

Support for unicode characters has to be enabled to allow the display of Arab and Hebrew characters.

No more details can be provided as although the solution is open source, we don’t have the permission from the author to publish it.

Essential Open Source Software for MS Windows

Sunday, March 1st, 2009

If you want to save a few bucks, and in the mean time run a powerful MS Windows environment, you can find in this post some open source, free to download, software that will give you the same high performance and services offered by high cost software packages.

I personally always use the following open source software on my MS Windows XP and Vista desktops :

  • Mozilla Firefox Web Browser.
  • Mozilla Thunderbird Email Client.
  • GIMP – the GNU Image Manipulation Program.
  • Clamwin – an open source Antivirus for MS Windows.
  • OpenOffice – open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more.
  • MPlayer – multi-platform movie player.
  • KeePass – Password manager.
  • Notepad++ – a powerful free text and source code editor and MS Windows Notepad replacement.
  • PuTTY – an SSH and telnet client.
  • FileZilla – free FTP solution, both client and server.
  • 7-Zip – a file archiver.
  • Pidgin – easy to use and free chat client used to connect to AIM, MSN, Yahoo, and more chat networks all at once.
  • TurboCASH -Simple, easy to use application for managing personal finances.
  • Electric Sheep – free, open source screen saver.

Do you have a preferred open source package to share with others ?

OpenERP

Friday, February 27th, 2009

Today, we have employed OpenERP open source ERP suite for the first time in our offices. It will be used to manage inventories, deliveries, account payables and receivables.

As a first step, we have recorded year 2008 ending inventories. And we will gradually store sales and purchasing data in the database.

OpenERP is an open source suite that is based on a client-server platform. The server connects to a PostgreSQL database and the client connects to the server afterwards.

We will post the outcome of this experiment as more information are available.