Thursday 30 July 2015

Ready Reference


COPA                                                                                                   
Costing based & Accounting based COPA
Structures
Values fields
Flow of actual values
                Transfer of Incoming Sales Orders – relation ship between condition type and   Value field
                Transfer of Billing Documents - relation ship between condition type and             Value field
                Order and Project Settlement – Maintain PA structure, maintain assignments, assign gl’s to it and finally update value fields.
Direct Posting from FI/MM
                Settlement of Production Variances
Transfer of Overhead

PA transfer structure: A rule that assigns costs and revenues from other applications to the quantity fields and value fields in Profitability Analysis (maintain assignments, assign gl’s to it and finally update value fields)
Profitability segment: object within Profitability Analysis to which costs and revenues are assigned.

FI-MM
Valuation group
General modifier: General modification(GM) is active only for transactions where offsetting entries are posted. (between cost center, transfer to Production order)
The valuation class allows you to define automatic account determination that is dependent on the material.
Transaction Key: These contain keys for the relevant posting transaction (for example, inventory posting and consumption posting) instead of actual G/L account numbers.
3 way matching
The Quantity & Price is matched between PO, GR & IR. (Three Levels)
Configuration for Quantity Variance (DW): Inv received before GR sets block (MRBR)
Tolerance Key DQ: Invoice qtr higher than PO and GR
Tolerance Key PP: compares the  price between purchase order & invoice with the Tolerance limit specified in the configuration. (MRBR)
Configuration for Order Price Quantity (OPQ)
Tolerance Key BR (IR before GR)
Tolerance Key BW (GR before IR)

APP
Sending company – grouping
Setup paying company code - Form – payment advise
Payment method at country – ACH or check – DME or z program details,
Payment method of company code -

DME
T.Code DMEE / DMEE1 - DMEE tree (Payment Media Format) is created and
activated. Outgoing Payment Files use Tree Type PAYM.
T.Code OBPM1 / OBPM1A– Assign the file format (eg. Xml) to the Payment
Medium Format. The names of the Payment Media Format and the DMEE tree
should be identical. Assign Text fields for Note to Payee for the length and
number of fields.
T.Code OBPM2 – Set the data fields for the Note to Payee.
T.Code FBZP: Payment Methods in Country - Payment Method is created and
assigned to Country. The DMEE tree (Payment Media Format) assigned in the
section of Payment Medium Workbench. The Bank Transfer needs the IBAN
and SWIFT set up. Assign parameters for “Note to Payee”.
T.Code FBZP: Payment Methods in Company Code - Assign the Payment
Method to the Company Code. Set the Payment Advice control.
T.Code FBZP – Configure Bank Determination for the Payment Method.
T.Code OBPM4 – Create Selection Variant for the Payment Medium Format
EBS  - External transaction 2. File unique identification number send by sender, 3. Account symbol, 4. Assign account to it, 5. Create posting rules, 6. Define posting rules, 7. Create transaction type, 8. Assign it posting rule, 9. Assign bank accounts to transaction types.

Document Splitting
Active – splitting rule, document type, business transaction and Item category
Passive (inherent logic) – determined program internal .. Inheritance and account

Asset Accounting
Chart of depreciation – List of depreciation areas as per business and legal requirement.
Depreciation area – Valuation of fixed asset for a particular purpose. Real dep get values by it own – derived get values some other dep areas
Depreciation Key
                Base method – Ordernary/ lease /diminishing
                Declining balance method (upper limit and lower limits)
                Multilevel method (%)
                Period control method (in which period should cal dep for ac, ret, )
Unit of production depreciation: Depreciation = acquisition value (net book value) / total output (remaining output) * period output (STCK) – maintain AO25

PERIOD END ACTIVITES - FICO
Update Exchange Rates
Gaps in Document Number Assignment
Invoice Numbers Allocated Twice
Open and Close Posting Periods
Enter Recurring Entries
Post Recurring Entries
Run Batch Input Session
Automatic Clearing of GR/ IR Account special process
Analyze GR/ IR Clearing Accounts
Automatic Clearing of GR/ IR Account
Post Adjustment Entries
Foreign Currency Revaluation
Post Tax Payable
Record of sales and Use Tax Report
Comparison Documents/ Transaction Figures
Close Previous Accounting Period
Balance Interest Calculation
Display Document Journal
Financial Statement

2. Year-end closing in Financial Accounting

Create Factory Calendar for New Year
Carry Forward AP/ AR Balances
Carry Forward GL Balances
Re-grouping Receivables/ Payables
Balance Confirmation Receivable
Balance Confirmation Payable
Final Close and Release Financial Reporting
Close Previous Accounting Period
Display Document Journal.

Print 1099 MISC forms (Only for USA)

Wednesday 6 May 2015

DOCUMENT SPLITTING

Passive: The account assignments of the items to clear are inherited to clearing line items.  Not only
               ensures that the account itself is balanced, but also the additional dimensions.

Active: Splitted based on document splitting rules

Clearing Lines / Zero balance formation by balancing factor:  Reclass/Reposted between account assignment objects. For example: Transfer posting from profit center A to profit center B.

Splitting characteristics: Need to define which FI characteristics document splitting is performed;
                                        BA, PC, Segment.

The system always processes document splitting in the sequence

Document splitting activated at client level further can be deactivated at company code level.

INHERITANCE: Inheritance means when customer invoice is created, from a revenue line, (business area or segment) are projected (inherited) to the customer and tax lines in the general ledger view.

CONSTANT VALUE: The standard A/c assignment can be used to replace all account assignments that could not be derived from the posting with a constant value.

Define Document Splitting Characteristics for General Ledger Accounting:

  • Proposes logical document splitting characteristics based on the scenarios.
  • Should use these characteristics in at least one ledger.
  • Mandate to maintain "Zero Balancing Indicator" if plan to create Financial statements, this ensures entity balancing.
  • Mandatory fields
    • Firstly it is an extension to FSV for the accounts in which the characteristics cannot be entered during document entry, and/or for accounts that cannot be controlled using the field status.  Eg; vendor line should always include a profit center.
    • Secondly, it is a check as to whether a business process-equivalent business transaction variant was selected (which determines whether a splitting rule can be found).
INHERITANCE: Account assignment is derived from the revenue or expense line item to customer or vendor account and to its tax lines.

Standard A/C Assignment/Constant:
Replace all account assignments that could not be derived from the posting with a "constant value".
ACTIVE Split  Example:

Entry view
Vendor Cr 11000
Exp1     Dr  5000 SEG1 PC1
Exp 2    Dr  4000 SEG 2 PC2
Tax       Dr  2000 

GL View
Vendor Cr 5000 SEG1 PC1
Exp1 Dr 5000 SEG1 PC1
Tax1 Dr 1000 SEG1 PC1

Vendor Cr 4000 SEG2 PC2
Exp2 Dr 4000 SEG2 PC2
Tax2 Dr 1000 SEG2 PC2

Vendor and tax line derives account assignment based on Expense line/Base item category - Rule-Based split.



Document splitting runs as follows:
  • When making a posting, the system determines from the document type the underlying business transaction, assigns the item category to the individual items within the document, and checks whether the item categories are permitted for that business transaction.
  • The system creates a reference to preceding documents (such as clearing and invoice reference). The system applies the account assignments that you have defined as document splitting characteristics for General Ledger Accounting. For more information, see Passive Document Splitting.
  • Depending on the classification of the document, the system applies the related document splitting rule for the document in which it is specified how the document is split and for which line items. For more information, see Active Document Splitting.
  • If the system cannot determine the account assignments of the document splitting characteristics for individual line items, it can determine the account assignments either by inheritance or by using a standard account assignment. This can be necessary if the required information is not yet available when the posting occurs. You can use account assignment inheritance or standard account assignment to simplify document splitting. For more information, see Enhancement Logic.
  • For individual document splitting characteristics for General Ledger Accounting, you can define that the line items for these document splitting characteristics must be assigned to an account (required entry field). The system then checks whether the line items for these document splitting characteristics have an account assignment. If not, the system rejects the posting and issues an error message. For more information, see Validation of the Document Splitting Characteristics for General Ledger Accounting.
  • If the document does not produce a balance of zero for balancing dimensions, the system creates additional clearing items that ensure that the balancing dimensions in the document do produce a balance of zero. For additional information, see Creation of the Zero Balance Setting for Each Document.
Zero Balancing:
The balance of the involved entities is then always 0 for every posting, ensuring "entity balancing".
Reason for reposting: A vendor invoice was assigned to an incorrect segment and paid with this
incorrect segment.
Zero balance creation is only useful and necessary if you want to create a complete balance sheet for
a specific characteristic

Mandatory Field:
Firstly, it is an extension of the field for accounts in which the characteristics cannot be
"entered" during document entry, and/or for accounts that cannot be controlled using the field
status. Example: Vendor lines should always include a profit center or a segment.

Secondly, it is a check as to whether a business process-equivalent business transaction variant
was selected (which determines whether a splitting rule can be found).

Splitting Method:
Defines how splitting is performed, here the individual item categories are handled in the individual business transaction, assigned to Ledger.

Business transaction
Business Transaction variant
Item category

SEGMENT

Segments can be used to meet the requirements of international accounting principles (=> IAS /
IFRS / U.S. GAAP) - IAS 14

  1. The ERP system enables you to assign a segment in the master data of a profit center.
  2. Postings are automatically made to the segment when the profit center is posted to.There is no "dummy segment posting", as in the profit center logic; if the profit center does not have a segment, there is no segment account assignment either.
  3. The default setting involves deriving the segment from the profit center, but customers can develop their own derivation solutions through a user exit (BAdI): BAdI is: FAGL_DERIVE_SEGMENT.

Tuesday 5 May 2015

SCENARIOS

A scenario determines which fields are updated when postings are received from other application components. You cannot define your own scenarios.
Assigned to leading and non ledger.

LEDGER


LEADING LEDGER
  • Two additional currencies apart from Local Currency
  • Fiscal year variant
  • Posting period variant


Only the values from the leading ledger are posted to CO in standard system

Currency Type:

Group currency: Group currency is the currency which is specified in the 
client table or which is to be entered there.

Hard Currency: Hard currency is a country-specific second currency which is used in countries with high inflation.

Index-based currency: Index-based currency is a country-specific fictitious currency which is required in some countries with high inflation for external reporting (for example, tax returns).

Global company currency: Global company currency is the currency which is used for an internal trading partner. Maintaining the two parallel currencies would highly impact the system performance as the system is preparing additional two ledgers, besides the normal ledger.

Index-based currency and Hard currency are maintained at country key level (T.code: OY01)

Group Currency will update from the client currency (T.code: SCC4).

Global Company currency is maintained at company level (T.code: OX15)


NON-LEADING LEDGER
Currency types in non-leading should be in line to leading ledger currency types i.e, currency types maintained at leading ledger and non-leading ledger are same.