標籤

4GL (1) 人才發展 (10) 人物 (3) 太陽能 (4) 心理 (3) 心靈 (10) 文學 (31) 生活常識 (14) 光學 (1) 名句 (10) 即時通訊軟體 (2) 奇狐 (2) 爬蟲 (1) 音樂 (2) 產業 (5) 郭語錄 (3) 無聊 (3) 統計 (4) 新聞 (1) 經濟學 (1) 經營管理 (42) 解析度 (1) 遊戲 (5) 電學 (1) 網管 (10) 廣告 (1) 數學 (1) 機率 (1) 雜趣 (1) 證券 (4) 證券期貨 (1) ABAP (15) AD (1) agentflow (4) AJAX (1) Android (1) AnyChart (1) Apache (14) BASIS (4) BDL (1) C# (1) Church (1) CIE (1) CO (38) Converter (1) cron (1) CSS (23) DMS (1) DVD (1) Eclipse (1) English (1) excel (5) Exchange (4) Failover (1) Fedora (1) FI (57) File Transfer (1) Firefox (3) FM (2) fourjs (1) Genero (1) gladiatus (1) google (1) Google Maps API (2) grep (1) Grub (1) HR (2) html (23) HTS (8) IE (1) IE 8 (1) IIS (1) IMAP (3) Internet Explorer (1) java (4) JavaScript (22) jQuery (6) JSON (1) K3b (1) ldd (1) LED (3) Linux (120) Linux Mint (4) Load Balance (1) Microsoft (2) MIS (2) MM (51) MSSQL (1) MySQL (27) Network (1) NFS (1) Office (1) OpenSSL (1) Oracle (131) Outlook (3) PDF (6) Perl (60) PHP (33) PL/SQL (1) PL/SQL Developer (1) PM (3) Postfix (2) postfwd (1) PostgreSQL (1) PP (50) python (5) QM (1) Red Hat (4) Reporting Service (28) ruby (11) SAP (234) scp (1) SD (16) sed (1) Selenium (3) Selenium-WebDriver (5) shell (5) SQL (4) SQL server (8) sqlplus (1) SQuirreL SQL Client (1) SSH (3) SWOT (3) Symantec (2) T-SQL (7) Tera Term (2) tip (1) tiptop (24) Tomcat (6) Trouble Shooting (1) Tuning (5) Ubuntu (37) ufw (1) utf-8 (1) VIM (11) Virtual Machine (2) VirtualBox (1) vnc (3) Web Service (2) wget (1) Windows (19) Windows (1) WM (6) Xvfb (2) youtube (1) yum (2)
顯示具有 FI 標籤的文章。 顯示所有文章
顯示具有 FI 標籤的文章。 顯示所有文章

2014年3月19日 星期三

2014年3月13日 星期四

tax codes configuration

 http://scn.sap.com/thread/1162746

 tax codes configuration

1.Define Tax Procedure -- OBQ3
2.Assign country to Calculation Procedure --OBBG
3.Creation of tax codes---FTXP
4.Assign 0% tax codes for non-taxable transactions---OBCL
5.Assignment of Accounts----OB40
Here you will double click MWS and give Chart of Accounts and give tax code and sale tax account and VST , give tax code and purchase tax account.
6.Assign Tax Codes in Sales Account(G/L Account)----FS00

Tax Rate 稅率
Type Of Tax 稅類型
Tax Separate or Tax Included 外加稅或內含稅

IMG path : 財務會計(新) ->財務會計通用設定(新)->進項/銷項稅->計算->定義營業稅代碼

2014年2月4日 星期二

計算付款日期RFC



 FI_TERMS_OF_PAYMENT_PROPOSE

計算邏輯:
1)如果有 I_ZFBDT,就以I_ZFBDT為準計算
2)如果沒有I_ZFBDT,就以I_BUDAT為準計算

Import parameters               Value

I_BLDAT                         2014/01/24  --document date
I_BUDAT                         2013/10/01 --posting date
I_CPUDT                         2014/02/05 -- entry date
I_ZFBDT                         2014/01/24  --起算日
I_ZTERM                         M030
I_REINDAT
I_LIFNR
I_BUKRS


Export parameters               Value

E_ZBD1T                         32                  --base line date起算第一次付款日(底下數字為35,但應為32)
E_ZBD1P                         0.000
E_ZBD2T                          0
E_ZBD2P                         0.000
E_ZBD3T                          0
E_ZFBDT                         2014/02/01 --base line date
E_SPLIT
E_ZSCHF
E_ZLSCH
E_T052                             600M03000D01010000.000 0000.000 000050100000000

2013年10月16日 星期三

SAP FI Validation : OB28 menu path

http://ierp.us/sap-spro/sap_configuration_spro_img.php?id=4594

01. SAP Customizing Implementation Guide
02.-- Financial Accounting

03.---- Financial Accounting Global Settings
04.------ Document
05.-------- Document Header
06.---------- Validation in Accounting Documents - S_ALR_87003696  


2013年10月6日 星期日

計算duedate 的function module


https://scn.sap.com/thread/1155670

Function Module to Calculate Due Date from Payment Terms?
此问题 已被回答。
Gill Ackroyd
I'm writing an aged debtor report as the SAP standard one isn't quite right for our requirements.  Is there a function module that will calculate the payment due date if I give it the payment terms and the base line date?

I did a search in SE37 but couldn't see one which fitted my requirements (I was searching on CALCDUEDATE and variantions of).

Any suggestions welcome, thanks.

Gill
Nitin Karamchandani
正确答案 作者 Nitin Karamchandani  打开 Dec 5, 2008 10:27 AM
Hi Gill,

Use FM DETERMINE_DUE_DATE for the same.

Refer the following link:
FI-ABAP : how to calculate payment date using a module function ?

Hope this will help.
Regards,
Nitin.

2013年9月30日 星期一

F-02 的替代BAPI

1) BAPI_ACC_DOCUMENT_POST




2) BAPI_ACC_GL_POSTING_POST:
不過這只能使用posting key 40/50
40 : positive number
50 : negative number

http://scn.sap.com/message/1512737#1512737

data:
      obj_type like bapiache02-obj_type,
      obj_key like bapiache02-obj_key,
      obj_sys like bapiache02-obj_sys,
      documentheader like bapiache08,

      accountgl like bapiacgl08
                  occurs 0 with header line,
      currencyamount like bapiaccr08
                  occurs 0 with header line,
      return like bapiret2
                  occurs 0 with header line,
      extension1 like bapiextc
                  occurs 0 with header line,

      t_edidd  like edidd occurs 0 with header line,
      bapi_retn_info  like bapiret2 occurs 0 with header line.
data: error_flag.


*documentheader-obj_type     = 'BKPFF'.
*documentheader-obj_key      = '18000000002002004'.
*documentheader-obj_type     = 'BKPFF'.
*documentheader-obj_key      = '180000000010002004'.

*documentheader-obj_sys      = 'RD1CLNT200'.


documentheader-username     = sy-uname.
documentheader-header_txt   = 'Test using BAPI'.
documentheader-comp_code    = '1000'.

*documentheader-ac_doc_no
*documentheader-fisc_year    = '2005'.

documentheader-doc_date     = sy-datum.
documentheader-pstng_date   = sy-datum.

*documentheader-trans_date
*documentheader-fis_period

documentheader-doc_type    = 'SA'.


*documentheader-ref_doc_no
*documentheader-compo_acc
*documentheader-reason_rev



accountgl-itemno_acc = '1'.
accountgl-gl_account = '0000160100'.
accountgl-comp_code = '1000'.
accountgl-pstng_date = sy-datum.
accountgl-doc_type   = 'SA'.
accountgl-profit_ctr = '0000010000'.
append accountgl.

accountgl-itemno_acc = '2'.
accountgl-gl_account = '0000160100'.
accountgl-comp_code = '1000'.
accountgl-pstng_date = sy-datum.
accountgl-doc_type   = 'SA'.
accountgl-profit_ctr = '0000010000'.
append accountgl.


*AC_DOC_NO
*FISC_YEAR
*FIS_PERIOD
*accountgl-STAT_CON = 'X'.
*REF_KEY_1
*REF_KEY_2
*REF_KEY_3
*CUSTOMER
*VENDOR_NO
*ALLOC_NMBR
*ITEM_TEXT
*BUS_AREA
*COSTCENTER
*ACTTYPE
*ORDERID
*ORIG_GROUP
*COST_OBJ
*PROFIT_CTR
*PART_PRCTR
*WBS_ELEMENT
*NETWORK
*ROUTING_NO
*ORDER_ITNO


currencyamount-itemno_acc = '1'.
currencyamount-currency = 'GBP'.
currencyamount-amt_doccur = '100.00'.
append currencyamount.

currencyamount-itemno_acc = '2'.
currencyamount-currency = 'GBP'.
currencyamount-amt_doccur = '-100.00'.
append currencyamount.


  •   call BAPI-function in this system   
call function 'BAPI_ACC_GL_POSTING_POST'
     exporting
          documentheader = documentheader
  •     importing
  •          obj_type       = obj_type
  •          obj_key        = obj_key
  •          obj_sys        = obj_sys
     tables
          accountgl      = accountgl
          currencyamount = currencyamount
          return         = return
          extension1     = extension1
     exceptions
          others         = 1.
if sy-subrc <> 0.
  message e999(re) with  'Problem occured'.
else.
      loop at return.
          if not return is initial.
          clear bapi_retn_info.
          move-corresponding return to bapi_retn_info.
          if return-type = 'A' or return-type = 'E'.
            error_flag = 'X'.
          endif.
          append bapi_retn_info.
        endif.
      endloop.
  if error_flag = 'X'.
     message e999(re) with  'Problem occured'.
     rollback work.
  else.
  commit work.
  endif.
endif.


最後別忘了加上bapi_transaction_commit

2013年9月24日 星期二

Message no.AA347 You cannot post to asset in compa. code x fiscal year


執行ABAVN時遇到上述問題(DEV環境太舊)

Solution : 使用 T-Code : AJRW,拿掉TEST RUN,並在background執行

參考 http://scn.sap.com/thread/1460300

SAP : Fixed Asset Retirement (報廢) T-Code and BAPI

T-Code : ABAVN
BAPI : BAPI_ASSET_RETIREMENT_CHECK
            BAPI_ASSET_RETIREMENT_POST


2013年6月10日 星期一

MIRO 和 F-90 差別

https://scn.sap.com/thread/1105616

When there is a  PO you need to use MIRO and not F-90

The posting from the G/R from the PO is.

GR
70 Asset               100
50 Gr/IR account            100

Invoice MIRO

50 Gr/IR account   100
31  Vendor                      100

When there is prices differences it will be posted normal on the asset

What you then want to do with F-90? When there is a PO the invoice should always be posted with MIRO assigned to the PO! Other wise you have problems with your GR/IR account and the PO still expect an invoice!

2013年6月7日 星期五

SAP中采购订单形成的几种差异解释


http://www.wysap.com/xuexi/material/20130512/1684.html

SAP中采购订单形成的几种差异解释

时间:2013-05-12 22:06TAG标签: sap采购差异 作者:SAP中文学习网 点击:
从采购订单到收货,收发票,会有两个环节,会影响到物料。 1、收货: (1)如果物料是采用标准价S,那么采购所形成的差异不会立刻就摊到物料上,而是直接进差异科目。只生成一张会计凭证,借:库存 借(贷):差异 贷:应付暂估。 (2)如果物料采用移动平均价V,如果
从采购订单到收货,收发票,会有两个环节,会影响到物料
1、收货:
(1)如果物料是采用标准价S,那么采购所形成的差异不会立刻就摊到物料上,而是直接进差异科目。只生成一张会计凭证,借:库存 借(贷):差异  贷:应付暂估。
(2)如果物料采用移动平均价V,如果与物料价格有差异,则要视库存是否足够而定(库存数量比那个采购数量多还是少)。
     如果库存足够,那么就会立刻生成两张凭证,一张与刚才相同,但是同时生成另一张凭证,将差异摊到库存价值上,从而改变物料的价格。
     如果没有库存,就也是只生成一张凭证,差异进差异科目。
     如果有部分库存,那么就会按比例,差异一部分进库存,一部分进差异科目。
2、发票校验:如果收到的发票金额与原来的金额不等,那么,所形成的差异进差异科目。差异的处理,与上面是类似的。
3、补充一下,只有采购和生产才会影响到物料的成本,销售不会对物料的价格产生影响。

2013年6月5日 星期三

Create Chart of Accounts


1. Create Chart of Accounts


2. Create Company Code

Copy可能會遇到此warning,所以記得要assign controlling area給company code





3. Assign Company Code to Chart of Accounts (如item 1 路徑)

4.Define Account Group (如item 1 路徑)

5. ...

6.Create Retained Earnings Account (如item 1 路徑)