Financial Accounting
  • Complete Document
  • Document Header
  • Line Item

    • Complete Document
    Step CUR TECR REFI LCP1 SING * Description
    1 Y Y Y Y Y E Required JV explanation
    2 Y Y Y Y Y E All the account sets must be balanced
    3 Y Y Y Y Y E Posted JV's cannot be changed
    4 Y Y Y Y Y E EXPORT BKPF,BSEG,SYST to MEMORY


    [Back to top]

    Document Header
    Step CUR TECR REFI LCP1 SING * Description
    1 Y Y Y Y Y E Post invoices on end-of-month date
    2 Y Y Y Y Y E Doc.type FY => period is 13-16
    3 Y - - - Y E Doc.type SG => period is 1-13
    4 Y Y Y Y Y E Period 13-16 => FY or SA-settlement
    5 Y Y Y Y Y E Check User Authorized for Post Period
    6 Y - - - Y E Posting Period on Reversed document


    [Back to top]

    Line Items
    Step CUR TECR REFI LCP1 SING * Description
    1 Y Y Y Y Y E Parked JV(SA,FY,SI): Item text required
    2 Y - - - Y E AR docs: Incorrect Dunning Area
    3 Y - - - Y E AR Docs: Dunning Area Required
    4 Y - - - Y E AR Docs: Spon Cust SR Dunning Area
    5 Y Y Y Y Y E Revenue/expense=>Exactly ONE CO obj
    6 Y - - - Y E GL Account/cost-object consistency
    7 Y - - - Y E FY doc: do not allow research WBS's
    8 Y - - - Y W AR line-items > 10,000.00: WARNING
    9 Y - - - Y E Doc.type SI: restricted accounts
    10 Y - - - Y E GLAccts 9000xx => FEED doc.types
    11 Y - - - Y E Spon.Res: Check WBS valid in ZUONR
    12 Y Y Y Y Y E G/L accts.used only in settlements
    13 Y - - - Y E Utility usage G/Ls require UoM
    14 Y - - - Y E Utility usage inv=> no control acct
    15 Y - - - Y E Utility JV's => restricted G/L's
    16 Y - - - Y E Cashier doc(SK) => restrict.GL Acct
    17 Y - - - Y E Facilities RFPs => Put ContrAccKey
    18 Y - - - Y E UR: GL/cost-object consistency
    19 Y Y Y Y Y E Intercompany JV

    (* : E-Error, W-Warning, I-Inactive)

    Introduction | Cost Accounting | Financial Accounting

    Last Updated: July 2005

    [FI Complete Document]

    Step 1: Required JV explanation

    In the parked document of type SA/FY (or FS), the correspondence long text is required.

    Criteria

    • If the document is parked document (BKPF-GLVOR = 'RFBV'), not direct post,
      and document type is one of the following:
      • For CUR : SA/FY/FS (BKPF-BLART = 'SA' OR BKPF-BLART = 'FY' OR BKPF-BLART = ‘FS')
      • For TECR: SA/FY (BKPF-BLART = 'SA' OR BKPF-BLART = 'FY' )
      • For REFI: SA/FY (BKPF-BLART = 'SA' OR BKPF-BLART = 'FY' )
      • For LCP1: SA/FY (BKPF-BLART = 'SA' OR BKPF-BLART = 'FY' )
      • For SING: SA/FY/FS (BKPF-BLART = 'SA' OR BKPF-BLART = 'FY' OR BKPF-BLART = ‘FS')

    Verifications (user exit: ULTE)

    • Check the texts in accounting document, make sure the Correspondence Text is entered.

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 018 Val.FI_DOCU: Enter JV explanation (menu: Extras->Texts->"Correspondence")

    [Back to top]

    [FI Complete Document]

    Step 2: All the account sets must be balanced

    The Account sets for all the documents must be balanced except those are feed by Payroll System.

    Criteria

    • All the documents except the document type is one of the following, 09/10/15/SW/SM/PA
      ( BKPF-BLART = '09' OR BKPF-BLART = '10' OR BKPF-BLART = '15' OR BKPF-BLART = 'SW'OR BKPF-BLART = 'SM' OR BKPF-BLART = 'PA' ).

    Verifications (user exit: UASB)

    There are three account sets: Salaries and Wages, Transfers, and Cost Sharing.
    The debits and credits should be equal in each set.

    The G/L accounts for each set:
    1. Salaries and Wages:
      1. 400005-400812
      2. 490100-490103
    2. Transfers:
      1. 800010-800011
      2. 800333-800334
      3. 800325-800326
    3. Cost Sharing:
      1. 800701-800702

    Override (user exit: UVD3)

    Name Subroutine Active
    FI_DOCU ACCTSET_BALANCED X

    Message

    Type Number Text
    Error 017 Val.FI_DOCU: Balance & of acct.set & should be 0

    [Back to top]

    [FI Complete Document]

    Step 3: FI posted JV's cannot be changed

    Can NOT change the posted JV.

    Criteria

    • If the document is direct posted document (BKPF-GLVOR = 'RFBU'),
      and the document type is one of the following, SA/SP/SI/FY/FS (BKPF-BLART = 'SA' OR BKPF-BLART = 'SP' OR BKPF-BLART = 'SI' OR BKPF-BLART = 'FY' OR BKPF-BLART = 'FS').
      And the activity category in SAP transaction is change activity (user exit: UGD2).

    Verifications (user exit: N/A)

    Override (user exit: UVD4)

    Name Subroutine Active
    FI_DOCU CHANGE_FI_POSTING X

    Message

    Type Number Text
    Error 021 Val.FI_DOCU: Changing a posted doc.of type & is not allowed

    [Back to top]

    [FI Complete Document]

    Step 4: EXPORT BKPF,BSEG,SYST to MEMORY

    Export structures BKPF, BSEG and SYST to memory when an FI document is posted.

    NOTE: This is a timing issue, when trigger WK event, the SAP hasn’t saved the data into proper tables, export the tables info into memory when an FI document is posted. (Check table TRWPR, function: ZZWF_BKPF_EVENT_CREATE )

    Criteria

    • ALL FI documents.

    Verifications (user exit: UMEM)

    • Export the contents of structures BKPF, BSEG and SYST to memory.

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 100

    [Back to top]

    [FI Document Header]

    Step 1: Post invoices on end-of-month date

    For the invoice documents, the posting date must be the last day of the month.

    Criteria

    • If the document is an invoice document (Set ID: FI_INV_DOCTP.BKPF)
      and activity category in SAP transaction is create ( user exit: UGH1 ).

    Verifications (user exit: UFH1)

    • Posting date in the document must be the last day of the month.

    Override (user exit: UVH1)

    Name Subroutine Active
    FI_HEAD INVOICE_MONTH_END X

    Message

    Type Number Text
    Error 050 Val.FI_HEAD: In doc.type & use end-of-month date as posting date

    [Back to top]

    [FI Document Header]

    Step 2: Doc.type FY => period is 13-16

    For document type FY only can be used in period 13 to 16.

    Criteria

    • If the document type is FY.

    Verifications (user exit: N/A)

    • Posting period is between 13 to 16.

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 011 Val.FI_HEAD: Doc.type FY => posting periods 13-16

    [Back to top]

    [FI Document Header]

    Step 3: Doc.type SG => period is 1-13

    For document type SG can be used in period 1 to 13.

    Criteria

    • If the document type is SG.

    Verifications (user exit: N/A)

    • Posting period is between 1 to 13.

    Override (user exit: N/A)

    Message

    Type Number Text
    Error

    [Back to top]

    [FI Document Header]

    Step 4: Period 13-16 => FY or SA-settlement

    During the period 13 to 16, ONLY document types FY and SA Settlement are allowed.

    Criteria

    • If the period is either 13, 14, 15, or 16.

    Verifications (user exit: N/A)

    • The document type must be:
      FY - Fiscal Year Journals
      AF - Depr. postings
      SX - Co-Code transfers
      SA settlement.

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 009 Val.FI_HEAD: Post.period 13-16 => Doc.type FY or AF or SA(settlements)

    [Back to top]

    [FI Document Header]

    Step 5: Check User Authorized for Post Period

    Check if user is authorized for the desired posting period.

      Note:
    • Joe Keohan said "No one should be allowed to change Any header text, unless the user is in override table." -- Lucia Ma 07/10/2000
    • Validation error occurs when the user is not authorized to post to non-current period or the user does not exist in ZVOVR table.
    • No one should be able to post to non-current period unless they have the following authorization:
      OBJECT = 'F_BKPF_BUP' & BRGRU = 'NCUR'
      or
      are in the ZVOVR table with entry FI_HEAD, POST_PERIOD_AUTH & "X"

    How to fix it:
    1) short term fix: Add the user into ZVOVR table
    2) long term fix: Get the authoization so the user can post to non-current period

    Criteria

    • If user is authorized for the desired posting period (user exit: UFH4) and
      SAP FI transaction is either of type "CREATE" (user exit: UGH1) or "Change Parked document" (SYST-TCODE = 'FBV2' OR SYST-TCODE = 'FBV4')

    Verifications (user exit: N/A)

    Override (user exit: UVH4)

    Name Subroutine Active
    FI_HEAD POST_PERIOD_AUTH X

    Message

    Type Number Text
    Error 015 Val.FI_HEAD: User & cannot post to period &/&

    [Back to top]

    [FI Document Header]

    Step 6: Posting Period on Reversed document

    The posting period on reversed documents must be current period.

    Criteria

    • If posting period on reversed document is not current period (user exit: UFH5) and
      SAP transaction is reverse document (SYST-TCODE = 'MR08' OR SYST-TCODE = 'MR8M' OR SYST-TCODE = 'FB08' )

    Verifications (user exit: N/A)

    Override (user exit: UVH5)

    Name Subroutine Active
    FI_HEAD REVERSE_DOCUMENT X

    Message

    Type Number Text
    Error 045 Val.FI_HEAD: &/& is not current period. Pls. use a current posting date.

    [Back to top]

    [FI Line Item]

    Step 1: Parked JV(SA,FY,SI): Item text required

    For the parked document types SA/FY/SI, line-item text is required.

    Criteria

    • If it’s a parked document (BKPF-GLVOR = 'RFBV') and document type is either SA or FY or SI or FS (BKPF-BLART = 'SA'or BKPF-BLART = 'FY'or BKPF-BLART = 'SI'or BKPF-BLART = 'FS').

    Verifications (user exit: N/A)

    • Check if item text is entered for each line item (BSEG-SGTXT NE ).

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 022 Val.FI_ITEM (itm &): Line-item text is required.

    [Back to top]

    [FI Line Item]

    Step 2: AR docs: Incorrect Dunning Area

    Check Dunning area when creating Account receivable documents.

    Criteria

    • If the document type is not Customer Payment or Accounting Document (BKPF-BLART NE 'DZ' and BKPF-BLART NE 'AB' )
      and the transaction is creating FI document (User Exit: UGH1)
      and account type is 'Customer' (BSEG-KOART = 'D' )
      and general ledger account is account receivable general reconciliation account (BSEG-HKONT = '101200').

    Verifications (user exit: N/A)

    Dunning area is required and

    # document type dunning area
    1 BA or B1 BA
    2 CA or C1 CA
    3 DS or D1 DS
    4 HD or H1 HD
    5 LB or L1 LB
    6 MD or M1 MD
    7 AL or A1 AL
    8 DR or DG MS

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 007 Val.FI_ITEM (itm &): Incorrect dunning area in DocType & (->long text)

    [Back to top]

    [FI Line Item]

    Step 3: AR Docs: Dunning Area Required

    Check Dunning area when changing Account receivable documents.

    Criteria

    • If the document type is not Customer Payment or Accounting Document (BKPF-BLART NE 'DZ' and BKPF-BLART NE 'AB' )
      and the transaction is changing FI document (User Exit: UGH2)
      and account type is 'Customer' (BSEG-KOART = 'D' )
      and general ledger account is account receivable general reconciliation account (BSEG-HKONT = '101200').

    Verifications (user exit: N/A)

    • Dunning area is required (BSEG-MABER NE '').

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 029 Val.FI_ITEM (itm &): Dunning Area required for DocType &

    [Back to top]

    [FI Line Item]

    Step 4: AR Docs: Spon Cust SR Dunning Area

    In AR sponsored reconciliation account, the dunning area is 'SR'

    Criteria

    • If the document type is not Customer Payment or Accounting Document or Billing Doc. Transfer (BKPF-BLART NE 'DZ' and BKPF-BLART NE 'AB' and BKPF-BLART NE 'RV') and account type is 'Customer' (BSEG-KOART = 'D') and general ledger account is sponsor reconciliation account (BSEG-HKONT = '101205').

    Verifications (user exit: N/A)

    • The dunning area must be 'SR' ( BSEG-MABER = 'SR' ).

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 031 VAL.FI_ITEM (itm &): & Dunning Area incorrect for & (->long-text)

    [Back to top]

    [FI Line Item]

    Step 5: Revenue/expense=>Exactly ONE CO obj

    For Revenue/Expense, only one cost object is allowed.

    Criteria

    • If G/L account starts with either '4' or '6' or '8' (BSEG-HKONT LIKE '00004*' or BSEG-HKONT LIKE '00006*' or BSEG-HKONT LIKE '00008*'); exclude MM auto posting (AND NOT ( BSEG-HKONT = '0000420309' AND BSEG-XAUTO = 'X' ) ).

    Verifications (user exit: N/A)

    • Only one cost object is allowed.
      ( ( BSEG-PROJK NE ' ' OR BSEG-AUFNR NE ' ' OR BSEG-KOSTL NE ' ' )
      AND ( BSEG-PROJK NE ' ' AND ( BSEG-AUFNR = ' ' AND BSEG-KOSTL = ' ' ) )
      AND ( BSEG-AUFNR NE ' ' AND ( BSEG-PROJK = ' ' AND BSEG-KOSTL = ' ' ) )
      AND ( BSEG-KOSTL NE ' ' AND ( BSEG-PROJK = ' ' AND BSEG-AUFNR = ' ' ) )       )

    Override (user exit: UVI5)

    Name Subroutine Active
    FI_ITEM EXACTLY_ONE_COBJ X

    Message

    Type Number Text
    Error 020 Val.FI_ITEM (itm &): Fill exactly one cost obj.(WBS/Ord/CCtr)

    [Back to top]

    [FI Line Item]

    Step 6: GL Account/cost-object consistency

    Check G/L Account and Cost Object consistency.

    Criteria

    • If G/L account starts with either '4' or '6' or '8' (BSEG-HKONT LIKE '00004*' or BSEG-HKONT LIKE '00006*' or BSEG-HKONT LIKE '00008*'); exclude MM auto posting (AND NOT ( BSEG-HKONT = '0000420309' AND BSEG-XAUTO = 'X' ) ).

    Verifications (user exit: UFI6)

    • Do not check if the following condition is true,
      if G/L account equal to '400000' and
      • Document type is '09' and cost object equal to '1436500', OR
      • Document type is 'SM' and cost object equal to '1436500', OR
      • Document type is '15' and cost object equal to '1435700', OR
      • Document type is '25' and cost object equal to '1050500', OR
      • Document type is '25' and cost object equal to '1071200', OR
      • Document type is 'SW' and cost object equal to either '1436500' or '1435700', OR
      • Document type is 'SS' and cost object equal to either '1050500' or '1071200', OR
    • Do not check for a balance sheet account
    • If none of above then check if the combination of G/L account and cost object exists in ZFICOLINK table.

    Override (user exit: UVI6)

    Name Subroutine Active
    FI_ITEM GLACCT_COSTOBJECT X

    Message

    Type Number Text
    Error 014 Val.FI_ITEM (itm &): GL acct & cannot be used with CO &

    [Back to top]

    [FI Line Item]

    Step 7: FY doc: do not allow research WBS's

    Do not allow research WBS as account assignment in FY Document type.

    Criteria

    • If the document type is FY (BKPF-BLART = 'FY') and WBS element is used for account assignment(BSEG-PROJK <> ' ').

    Verifications (user exit: UFI7)

    • If WBS element is NOT less than ‘5000000’. (Research WBS's have numbers above or equal to 5000000.)

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 019 Val.FI_ITEM (itm &): In FY postings use WBS elts < 5000000

    [Back to top]

    [FI Line Item]

    Step 8: AR line-items > 10,000.00: WARNING

    Give warning, if the amount in an invoice is greater than $10000.00.

    Criteria

      If it’s
    • alumni invoices (BKPF-BLART = 'A1' or BKPF-BLART = 'AL') or
    • benefits invoices (BKPF-BLART = 'B1' or BKPF-BLART = 'BA') or
    • CAES invoices (BKPF-BLART = 'C1' or BKPF-BLART = 'CA') or
    • other invoices (BKPF-BLART = 'DR' or BKPF-BLART = 'DG') or
    • document services invoices (BKPF-BLART = 'D1' or BKPF-BLART = 'DS') or
    • housing-dinning invoices (BKPF-BLART = 'H1' or BKPF-BLART = 'HD') or
    • library invoices (BKPF-BLART = 'L1' or BKPF-BLART = 'LB') or
    • medical invoice (BKPF-BLART = 'M1' or BKPF-BLART = 'MD') or
    • payment from normal A/R customer (i.e. not sponsors) (BKPF-BLART = 'DZ' and BSEG-HKONT = '101200' ) .

    Verifications (user exit: N/A)

    • Check if the amount is less than $10000.00 ( BSEG-DMBTR <= '10000').

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 008 Val.FI_ITEM (itm &): Large amount entered (&); please verify

    [Back to top]

    [FI Line Item]

    Step 9: Doc.type SI: restricted accounts

    On JV’s of type SI (internal providers), no payroll, property, U/R transfer, travel, EB, OH and cost sharing G/L accounts are allowed.

    Criteria

    • If the document type is SI (BKPF-BLART = 'SI').

    Verifications (user exit: UFI9)

      The following G/L accounts are not allowed:
    • EB (GL 490200 - 490203)
    • OVERHEAD (GL 490300, 490302-490306)
    • COST SHARING (GL 490400 - 490402)
    • PAYROLL (GL 400005 - 400899)
    • ALLOCATIONS (GL 490100 - 490106)
    • TRAVEL (GL 420050, 420060, 420070, 422065)
    • PROPERTY (GL 420152, 421771, 421774, 421800-421899)
    • I/O TRANSFER (GL 800325, 800326)

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 030 Val.FI_ITEM (itm &): On doctype &, GL acct & is forbidden (->long-text)

    [Back to top]

    [FI Line Item]

    Step 10: GLAccts 9000xx => FEED doc.types

    G/L accounts 9000xx only used in feed Doc. types.

    Criteria

      If the G/L accounts like 9000* (BSEG-HKONT LIKE '00009000*').

    Verifications (user exit: UFI0)

      Check if the document type is valid one. Check the following conditions:
    • Ignore if G/L account equal to '900030'. (CASH FEED EXCEPTION)
    • If G/L account equal to '900009', the document type must be either '09' or 'SW' or 'SM'.
    • If G/L account equal to '900010', the document type must be either '10' or 'SW'.
    • If G/L account equal to '900015', the document type must be either '15' or 'SW'.
    • If G/L account equal to '900020', the document type must be '20'.
    • If G/L account equal to '900025', the document type must be either '25' or 'SS'.
    • If G/L account equal to '900030', the document type must be 'SK'.
    • If G/L account equal to '900033', the document type must be '33'.
    • If G/L account equal to '900037', the document type must be 'SG'.
    • If G/L account equal to '900040', the document type must be '40'.
    • If G/L account equal to '900090', the document type must be either '90' or 'ST'.

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 032 Val.FI_ITEM (itm &): GL acct & cannot be used with doctype &

    [Back to top]

    [FI Line Item]

    Step 11: Spon.Res: Check WBS valid in ZUONR

    For Sponsor Research, check if allocation is a valid WBS element.

    Criteria

    • Check if document type is not a customer payment (BKPF-BLART <> 'DZ') and account type is "customer" (BSEG-KOART = 'D') and G/L account is a sponsored reconciliation account. (BSEG-HKONT = '101205').

    Verifications (user exit: UFIA)

    • If allocation field is not empty ( BSEG-ZUONR <> ' ') and allocation is between '1000000' and '9999999' then the allocation must be a valid WBS element.

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 034 Val.FI_ITEM (itm &): Valid WBS required in Allocation. & not valid WBS.

    [Back to top]

    [FI Line Item]

    Step 12: G/L accounts used only in settlements

    G/L settlement accounts only can be used in settlement transaction.

    Criteria

    Verifications (user exit: N/A )

    • Check if it’s a settlement transaction (BKPF-AWTYP = 'AUAK').

    Override (user exit: UVIB)

    Name Subroutine Active
    FI_ITEM FI_STL_HKONT X

    Message

    Type Number Text
    Error 036 Val.FI_ITEM (itm &): GL acct & can be used only in settlements

    [Back to top]

    [FI Line Item]

    Step 13: Utility usage G/Ls require UoM

    Specific utility G/L accounts must be posted with their respective unit of measure only.

    Criteria

    Verifications (user exit: N/A)

    • If G/L account equals to '421105', then Unit of Measure must be 'MLB'. (BSEG-HKONT='0000421105' AND BSEG-MEINS='MLB')
    • If G/L account equals to '421106', then Unit of Measure must be 'THR'. (BSEG-HKONT='0000421106' AND BSEG-MEINS='THR')
    • If G/L account equals to '421107', then Unit of Measure must be 'CCF'. (BSEG-HKONT='0000421107' AND BSEG-MEINS='CCF')
    • If G/L account equals to '421108', then Unit of Measure must be 'CCF'. (BSEG-HKONT='0000421108' AND BSEG-MEINS='CCF')
    • If G/L account equals to '421109', then Unit of Measure must be 'CCF'. (BSEG-HKONT='0000421109' AND BSEG-MEINS='CCF')
    • If G/L account equals to '421111', then Unit of Measure must be 'KWH'. (BSEG-HKONT='0000421111' AND BSEG-MEINS='KWH')
    • If G/L account equals to '421112', then Unit of Measure must be 'GAL'. (BSEG-HKONT='0000421112' AND BSEG-MEINS='GAL')
    • If G/L account equals to '421113', then Unit of Measure must be 'BBL'. (BSEG-HKONT='0000421113' AND BSEG-MEINS='BBL')
    • If G/L account equals to '421114', then Unit of Measure must be 'GAL'. (BSEG-HKONT='0000421114' AND BSEG-MEINS='GAL')

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 037 Val.FI_ITEM (itm &): GL acct & requires a quantity and appropriate unit

    [Back to top]

    [FI Line Item]

    Step 14: Utility usage invoice => no control account

    On utility invoices do not enter control account. ( PO invoices with utility G/L accounts; except WATER,SEWER )

    Criteria

    • If Document type is RN (BKPF-BLART='RN') and G/L account is an Utilities G/L (BSEG-HKONT IN FI_UTL_SAKNR.BSEG ).

    Verifications (user exit: N/A)

    • Can NOT use the following control accounts for the account assignment:
      • 1803400 -- UTILITIES-SYSTEM CONTROL
      • 1803500 -- ENGINEERING AND UTILITY CONTROL
      • 1804200 -- MIDDLETON LINEAR CONTROL
      • 1804600 -- TECH SQUARE-CONTROL
      (BSEG-KOSTL<> '0001803400' AND BSEG-KOSTL<>'0001803500' AND BSEG-KOSTL<>'0001804200' AND BSEG-KOSTL<>'0001804600')

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 039 Val.FI_ITEM (itm &): On utility invoice do not enter control acct &

    [Back to top]

    [FI Line Item]

    Step 15: Utility JV's => restricted G/L's

    On utility JV’s, only restricted G/L usage accounts can be used.

    Criteria

    • Check if the document type is 'SU' (BKPF-BLART = 'SU').

    Verifications (user exit: N/A)

    • The G/L account is an utility G/L (BSEG-HKONT IN FI_UTL_HKONT.BSEG ) or an utility accrual G/L (BSEG-HKONT = '0000200043').

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 040 Val.FI_ITEM (itm &): Utility JV's (d.t. &) cannot use G/L account &

    [Back to top]

    [FI Line Item]

    Step 16: Cashier doc(SK) => restrict.GL Acct

    On Cashier’s document, only restricted G/L accounts can be used.

    Criteria

    • Check if the document type is 'SK' (BKPF-BLART = 'SK').

    Verifications (user exit: N/A)

      The following G/L accounts are not allowed:
    • 400005 to 401599 -- Salaries ( (BSEG-HKONT>='0000400005' AND BSEG-HKONT<='0000401599')
    • 490100 to 490199 -- Allocated Expenses ( (BSEG-HKONT>='0000490100' AND BSEG-HKONT<='0000490199')
    • 800001 -- PR Gifts ((BSEG-HKONT='0000800001') )
    • 800301 -- UR Gifts ((BSEG-HKONT='0000800301') )
    • 422065 -- Travel ((BSEG-HKONT='0000422065') )

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 041 Val.FI_ITEM (itm &): Cashier JV's (d.t.SK) cannot use GL account &

    [Back to top]

    [FI Line Item]

    Step 17: Facilities RFPs => Put ContrAccKey

    A valid control account key is entered on RFPs of the Department of Facilities.

    Criteria

    • Check if it is RFP (non PO invoice) ( BKPF-BLART='KN') of the Department of Facilities ( BSEG-PRCTR LIKE 'P591*').

    Verifications (user exit: UFIG)

    • Check the control account key is entered in the first 4 characters of the document header text. It is used to trigger the double-posting to the Facilities control account.

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 042 Val.FI_ITEM (itm &): In Facilities RFPs put Contr.Acc.Key in Header Text

    [Back to top]

    [FI Line Item]

    Step 18: UR: GL/cost-object consistency

    For research F&A under-recovery, GL/cost-object consistency.

    Criteria

    • If it’s a parked document (BKPF-GLVOR = 'RFBV') and document type is either SA or FY ( BKPF-BLART = 'SA' or BKPF-BLART = 'FY' ) and Cost Center is a under-covery cost center ( BSEG-KOSTL IN FI_UR_KOSTL ).

    Verifications (user exit: N/A)

    • G/L account is a under-covery G/L account ( BSEG-HKONT IN FI_UR_HKONT ).

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 044 Val.FI_ITEM (itm &): G/L account & cannot be used on CO &

    [Back to top]

    [FI Line Item]

    Step 19: Intercompany JV

    Can NOT mix company code in the regular JV.

    Criteria

    • Check if document type is NOT one of the intercompany JV document type ( NOT BKPF-BLART IN FI_MES_DOCTP ).

    Verifications (user exit: UFIH)

    • Check consistency of the company codes in the document.

    Override (user exit: N/A)

    Message

    Type Number Text
    Error 052 Val.FI_ITEM (itm &): Can NOT mix company code for Doc. type &

    [Back to top]

    FI_INV_DOCTP.BKPF

    1. MD -- Medical Invoice
    2. AL -- Alumni Invoice
    3. HD -- Housing & Dining Inv
    4. CA -- CAES Invoice
    5. DS -- Doc. Serv. Invoice
    6. DR -- Customer invoice
    7. DN -- Dental Service

    [Back to top]

    FI_STL_HKONT.BSEG

    1. 101225 -- Accounts Receivable - Internal Order Account
    2. 101506 -- Pledges Receivable
    3. 101600 -- Contracts in Progress
    4. 101801 -- Deferred Charges - Suspense
    5. 101802 -- Deferred Charges - Clearing Accounts
    6. 101804 -- Deferred Charges - Other
    7. 170001 -- Lnd/Bld/Eqp - Plant
    8. 200060 -- Lnd/Bld/Eqp - Plant in Process
    9. 201200 ~ 201202 -- Settlement
    10. 600500 ~ 600599 -- Settlement

    [Back to top]

    FI_UTL_HKONT.BSEG

    1. 421105 -- *Steam Usage (Mlb)-not MTDC
    2. 421106 -- *Chill.Water (Thr)-not MTDC
    3. 421107 -- Sewage Usage (Ccf)-not MTDC
    4. 421108 -- Gas Usage (Ccf)-not MTDC
    5. 421109 -- Water Usage (Ccf)-not MTDC
    6. 421110 -- Electric Commodity - kwh
    7. 421111 -- Electricity Usage (Kwh)-not MTDC
    8. 421112 -- Fuel Oil #2 (Gal)-not MTDC
    9. 421113 -- Fuel Oil #6 (Bbl)-not MTDC
    10. 421114 -- Fuel: Diesel (Gal)-not MTDC
    11. 421118 -- Gas Commodity - ccf

    [Back to top]

    FI_UTL_SAKNR.BSEG

    1. 421105 -- *Steam Usage (Mlb)-not MTDC
    2. 421106 -- *Chill.Water (Thr)-not MTDC
    3. 421108 -- Gas Usage (Ccf)-not MTDC
    4. 421110 -- Electric Commodity - kwh
    5. 421111 -- Electricity Usage (Kwh)-not MTDC
    6. 421112 -- Fuel Oil #2 (Gal)-not MTDC
    7. 421113 -- Fuel Oil #6 (Bbl)-not MTDC
    8. 421114 -- Fuel: Diesel (Gal)-not MTDC
    9. 421118 -- Gas Commodity - ccf

    [Back to top]

    FI_UR_KOSTL

    1. 1400501
    2. 1733000
    3. 1733100 -- 1733299

    [Back to top]

    FI_UR_HKONT

    1. 420316 -- 420317 -- Cost Shared/ Other Spon Funded Costs-F&A-not MTDC
    2. 490318 -- 490325 -- Adj CY On/Off to Spon Base/Rate
    3. 800703 -- F&A Under/Over-recovery Funded Trans In
    4. 800704 -- F&A Under/Over-recovery Funded Trans Out
    5. 800325 -- 800326 -- Transferred In/Out

    [Back to top]

    FI_MES_DOCTP

    1. SX -- Co-Code transfers
    2. SM -- Payroll Feed Monthly
    3. SW -- Payroll Feed Weekly
    4. ST -- Telecommunications
    5. SI -- Internal Provider JV
    6. ZP -- Payment posting
    7. KZ -- Vendor payment

    [Back to top]

    Table ZFICOLINK

    last updated: 10/23/2007
    G/L Accounts Cost Objects CO Type Description
    400000 ~ 499999 1000000 ~ 2734599 CIP Primary Costs
    400000 ~ 499999 2734800 ~ 9999999 CIP Primary Costs
    400000 ~ 499999 S000000 ~ S999999 CP (SING cost objects)
    400250 ~ 400255 2734600 ~ 2734799 I Admin. Staff To Funds No Fee
    400600 ~ 400613 2734600 ~ 2734799 I Support Staff To Funds No Fee
    400617 ~ 400617 2734600 ~ 2734799 I Sup Staff-On-REDEB
    420262 ~ 420262 2734600 ~ 2734799 I Temp. Services To Funds No Fee
    600500 ~ 600599 1000000 ~ 9999999 CIP Settlements to G/L Accounts
    600500 ~ 600599 S000000 ~ S999999 CP (SING cost objects)
    800000 ~ 800012 3000000 ~ 4999999 CIP Principal G/L Accounts
    800013 ~ 800300 1000000 ~ 2734599 CIP Revenue
    800013 ~ 800300 S000000 ~ S999999 CP (SING cost objects)
    800013 ~ 800300 2734800 ~ 9999999 CIP Revenue
    800301 ~ 800301 2000000 ~ 2734599 CIP Gifts/Pledges
    800301 ~ 800301 2734800 ~ 4999999 CIP Gifts/Pledges
    800302 ~ 800309 1000000 ~ 2734599 CIP Revenue
    800302 ~ 800309 2734800 ~ 9999999 CIP Revenue
    800302 ~ 800309 S000000 ~ S999999 CP (SING cost objects)
    800310 ~ 800310 2000000 ~ 2734599 CIP Gifts/Pledges
    800310 ~ 800310 2734800 ~ 4999999 CIP Gifts/Pledges
    800311 ~ 800317 1000000 ~ 2734599 CIP Revenue
    800311 ~ 800317 2734800 ~ 9999999 CIP Revenue
    800311 ~ 800317 S000000 ~ S999999 CP (SING cost objects)
    800318 ~ 800324 3000000 ~ 4999999 CIP Investment Income
    800325 ~ 800329 1000000 ~ 9999999 CIP Transfers
    800330 ~ 800330 6000000 ~ 9999999 P OSP Pledge Payments
    800330 ~ 800331 2000000 ~ 2734599 CIP Gifts/Pledges
    800330 ~ 800331 2734800 ~ 4999999 CIP Gifts/Pledges
    800332 ~ 800332 1000000 ~ 2734599 CIP Revenue
    800332 ~ 800332 2734800 ~ 9999999 CIP Revenue
    800333 ~ 800334 3000000 ~ 4999999 CIP Principal G/L Accounts
    800335 ~ 800399 1000000 ~ 2734599 CIP Revenue
    800335 ~ 800399 2734800 ~ 9999999 CIP Revenue
    800335 ~ 800399 S000000 ~ S999999 CP (SING cost objects)
    800400 ~ 800402 2000000 ~ 2734599 CIP Gifts/Pledges
    800400 ~ 800402 2734800 ~ 4999999 CIP Gifts/Pledges
    800403 ~ 800599 1000000 ~ 2734599 CIP Revenue
    800403 ~ 800599 2734800 ~ 9999999 CIP Revenue
    800600 ~ 800601 1000000 ~ 2734599 P Spons. Billings + Spons. Gifts
    800600 ~ 800601 2734800 ~ 9999999 P Spons. Billings + Spons. Gifts
    800600 ~ 800601 S000000 ~ S999999 CP (SING cost objects)
    800602 ~ 800699 1000000 ~ 2734599 CIP Revenue
    800602 ~ 800699 2734800 ~ 9999999 CIP Revenue
    800602 ~ 800699 S000000 ~ S999999 CP (SING cost objects)
    800700 ~ 800701 1000000 ~ 2734599 P Cost Sharing Transfers
    800700 ~ 800701 2734800 ~ 9999999 P Cost Sharing Transfers
    800702 ~ 800703 1000000 ~ 2734599 CI Cost Sharing Transfers
    800702 ~ 800703 2734800 ~ 9999999 CI Cost Sharing Transfers
    800704 ~ 800704 1000000 ~ 2734599 CI F&A Under/Over-Recovery Funded Transfers
    800704 ~ 800704 2734800 ~ 9999999 CI F&A Under/Over-Recovery Funded Transfers
    800705 ~ 800705 1330000 ~ 1999999 C Draft Transfer In
    800706 ~ 800708 1000000 ~ 2734599 CIP Transfers
    800706 ~ 800708 2734800 ~ 9999999 CIP Transfers
    800709 ~ 800709 1330000 ~ 1999999 C Space Change Transfer In
    800710 ~ 899999 1000000 ~ 2734599 CIP Transfers & Revenue
    800710 ~ 899999 2734800 ~ 9999999 CIP Transfers & Revenue

    [Back to top]