Chen Log

陳洛格

Posts Tagged ‘ERP

OPEN ERP 7.0 No period defined for this date: 2016-01-01 ! Please create one.

leave a comment »

OPEN ERP 7.0

「No period defined for this date: 2016-01-01 ! Please create one.」

處理辦法

 

Beside create “Fiscal Years”.

You need create a new one “Periods”,too.

Accounting -> Configuration -> Periods -> Periods

Advertisements

Written by chenagw

2016/01/07 at 10:10

Posted in Uncategorized

Tagged with ,

Disable Receive the “Access this document directly in OpenERP“ link in Mail

with 3 comments

Disable Receive the words,
“Access this document directly in OpenERP“ link in Mail.

Setting-> Users-> “Receive Messages by Email” -> select 「Never」

螢幕快照 2014 02 20 17 22 07

Written by chenagw

2014/02/20 at 17:24

Posted in Uncategorized

Tagged with ,

OpenERP RML判斷是否為 訂單、估價單的語法

leave a comment »

 

螢幕快照 2014 01 07 01 37 19

螢幕快照 2014 01 07 01 38 14

 

 

<para style=”terp_header”><b>[[ o.state not in [‘draft’,’sent’] and removeParentNode(‘para’) ]] 估價單 Quotation [[ o.name ]]</b></para>
<para style=”terp_header”><b>[[ o.state in [‘draft’,’sent’] and removeParentNode(‘para’) ]] 訂購單 Order [[ o.name ]]</b></para>

 

可以利用這去呈現 PDF檔的排版 或文字!

Written by chenagw

2014/01/07 at 01:40

Posted in Uncategorized

Tagged with , ,

Openerp 7 匯率 多幣別設定教學

leave a comment »

參考自:
http://www.serpentcs.com/serpentcs-currency-operations-in-openerp-7 

Hello Readers,
By default OpenERP configures EUR as its default currency, if you are working other than EUR currency, below are the simple steps of configuration of changing currency at global level.

  • Give necessary access rights to your current user:
    • Multi Currencies 多幣別
    • Sales Pricelists 銷售列表
    • Purchase Pricelist 購買列表

  • Go to your current company “Settings → Companies → Companies”:
    • Select “your company” and go to third tab “Configuration” and assign your country’s default currency.

  •   If company is dealing with multi currency, configure “Gain Exchange Rate Account” and “Loss Exchange Rate Account” for fluctuations of currency rate change gain and loss.

  • Go to Sales → Configuration → Pricelists → Pricelists(This step would only be needed only if Sales module installed before changing Company Currency, otherwise it will be assigned automatically)
    • Select Public Pricelist and assign your country’s default currency as highlated in below screen.

  • Go to Sales → Configuration → Pricelists → Price Types:(This step would only needed only if Sales module installed before changing Company Currency, otherwise it will be assigned automatically)
    • Go to Public Price and assign your country’s default currency in currency field.

    • Go to Cost Price and assign your country’s default currency in currency field.

  • Go to Purchase → Configuration → Pricelists:(This step would only needed only if Purchase module installed before changing Company Currency, otherwise it will be assigned automatically)
    • Select Default Purchase Pricelist and assign your country’s default currency in Currency field

By changing the above configuration at global level mainly objects(entities) affected which are Company(res.company), Pricelist(product.pricelist), Pricelist Type(product.pricelist.type)

Importance of all fields in Currency form:

Currency : Code of currency. For e.g. for US currency global code is used USD.

Current Rate : This field will display the current rate of currency compared with the base currency.

Company : Currency and all its configuration defined for selected company.

Price Accuracy

Rounding Factor : The computed currency will be multiple of this value.

Symbol : Currency sign, to be used when printing amount.

Miscellaneous

Base : If true, it will become the reference for the other currency. If this field checked the Current Rate should be 1.

  Usually this field should be checked in default currency of company. Make sure only one currency has this set to be True!

Active : If the active field is set to False, it will allow to hide the currency without removing it

Rates :This is one2many list of rates, where by adding a new rate with date, the respected Rate will be applied everywhere at global level.

When a company is working with multi currency, we have to keep system updated with latest currency rates. Now managing currency updation manually become very tedious task. Here we have a module which updates currency at FIXED interval basis. You can found that module at following branch:

bzr branch lp:account-financial-tools

Install module Currency Rate Update.

By installing this module a new tab will be added in Company Form at following path:

Settings -> Companies -> Companies -> Select “Your Company” from list of companies -> Go to forth tab “Currency auto update configuration”. and do below configuration:

  • Automatic update of the currency this company : True
  • Currency update frequency : Day(s) or  Week(s) or Month(s)
  • Multi company currency : True

Now add by which webservice you want currencies get updated automatically:

Here we have 4 webservices by which we can update currency, choose anyone of them:

  • Admin.Ch
  • European Central Bank
  • Yahoo Finance
  • Narodowy Bank Polsky

We have selected Yahoo Finance, and added number of currencies which we want to update by clicking on “ADD” button.

All currency data will look like as below:

We can manually update update currency by clicking on “Refresh currencies”. All currency rates will be updated based on your default Company Currency and also automatically updates rates based on currency update frequency(here in our case it will update on daily basis).

Hope this blog have helped you in multi currency as well as auto update currencies.

Thanks and Regards!

Serpent Consulting Services Pvt. Ltd

Written by chenagw

2013/12/26 at 14:30

Posted in Uncategorized

Tagged with