Feed aggregator

Social Space Is Now Live! Follow Trends On Social Media

Learn New Marketing Trends - Mon, 2011-05-23 09:44
net Time Machine has just released "Social Space" - a cutting edge software that allows you to see what is trending on Facebook, Twitter, and other social media outlets.  Take a look at this training video by head fo technology, Ali Khan.    

ITM ALERT - Tiger Mom For Parenting and Education

Learn New Marketing Trends - Thu, 2011-05-05 19:52
rases as "work at home moms", then something must be moving. Amy Chua is the Tiger Mom based on an interview she did with the Wall Street Journal back in January.  Her piece stirred up so much emotion and controversy that this trend in parenting is jumping into search volumes.  There is really not much information beyond Amy, so there is an opportunity. When looking at tiger mom, tiger mom book, and tiger mother, notice the other PPC ads as some marketers are just starting now with tshirts and stickers.  Watch the video below to learn more..

Training Video For New User Interface - Click Here.

Learn New Marketing Trends - Wed, 2011-04-13 13:51
cking of trends as well as using our categories tag for trend analysis. The video presented here is intended to give you a quick walkthrough of our new system and how to use it effectively to either find new trends and analysis data from around the world, or use the system to zoom into your current business and to find out how things are changing in your own niche area. One exciting new feature is the "Trends Directory" where you can start at the macro level and then drill down into niches or hot topics.  The second feature that is sure to make people sit up and take notice is the "social media" section that shows how a phrase, niche, or trend is performing in the social media realm like Twitter, Facebook, or Digg.  This is a unique tool for Internet marketing or branding purposes that is not offered anywhere else. You may also notice in this video two new growing demand trends we picked on just while filming this tutorial.  Check out the video to see how "online crosswords for the IPAD" or "Google webmaster tools for SEO" are starting to show growing demand and low results or products available.

Pregnancy Diabetes - National Crisis?

Learn New Marketing Trends - Fri, 2011-04-01 15:56
ld diabetes diet.  The interesting part of this video is the massive demand for such information almost disqualifies the subject at a niche.  There is so much national interest in these two subjects, that to call pregnancy diabetes  a niche is an understatement. The geo targeting feature used by Internet marketers to track where the trend is gaining momentum or where there is growing positive sentiment for an idea is working overtime for pregnancy diabetes.  As you can see by the following video the demand for information around diabetes during pregnancy is surging almost all over the country.  The East coast of the US is showing a very strong demand feature with low informational supply.  Even parts of Europe that have English based sites and blogs, is showing demand for this information. Watch this video to see how the Internet Time Machine uses the filter tools and options to find the other most prominent keywords for diabetes that have growing demand and low supply.

Home Solar Panels - Fad or Trend?

Learn New Marketing Trends - Tue, 2011-03-15 11:41
d turbines, and algae testing were all the latest buzz words when oil was topping out at $150 per barrel. We take this opportunity to give you the first look at our new TRENDS DIRECTORY, where you can sort by categories to see niches and phrases within those categories.  Say you are in the health niche and you wanted to know the best phrases to use in your blog posts to get traffic.  Traffic that was following a hot subject or niche, yet didn't have tough competition on the organic results side? You can now use our niche and trend software to find the right category to sort by, whether the niche was politics, health, crime, tech, or something else.  This is an invaluable service for Internet marketers as well as businesses doing sales online, as now you can track trends within your industry and match them up with geo targeting to find the areas in which the trends are taking off. Take a look at this video to see how we use "home solar panels" as a niche to get a review site up for in the time of rising oil prices.

Political Trends - How To Start Your New Career

Learn New Marketing Trends - Thu, 2011-03-10 11:45
king, political strategist have taken notice. Political races will be heating up headed into the 2012 elections, and local as well as national political campaigns are always looking for trend and sentiment research. By using the predictive algorithms of the Internet Time Machine and the new geo tracking feature, we are able to spot areas, or "hot spots" for politicians.  By using the keyword tool and niche tracking maps, local politicians can see sentiment spots where they are seen as favorable on certain issues and where there is negative sentiment about an issue or trend. In our most recent video on niche and trend solutions, our head of IT, Ali Khan, takes a look at President Obama and his national heat maps on certain broad based issues.  Energy, security, and taxes rank high as phrases that concern the voting public heading into 2012.  Not surprisingly, showing up as the number area of search with little information is the term "should Obama control the Internet".  Since trend analytics takes its information from millions of online sources, this is not a surprise concern since the online community is the one being "polled". Check out the new Internet Time Machine interface with geo tracking of sentiment and trends for President Obama and his 2012 election campaign.  The new interface will be available for members next week, as well as new tutorial videos as well. Have you ever thought of using the new ITM 2.0 software as a consulting service to local and regional political parties as they gear up for elections?  I bet they have never seen anything like this and would love to see and here more about it. 

5 Secrets From The Underground Seminar (Members Only)

Learn New Marketing Trends - Thu, 2011-03-10 11:41
g industry is going is to hang out at the premier seminar for Internet Marketers in the world, Yanik Silver's Underground Seminar.  The event takes place every year in Washington, DC.  It brings together the "power brokers" of the Internet marketing arena.  By "power brokers", I don't just mean the well known gurus, but also the faceless and nameless people who drive millions of dollars of sales and traffic to different websites. The event is a "pitch free" environment, so there is no hard sell to buy products or courses, at least on the first two days.  By day three, some of the presenters are allowed to pitch products and services, but in a non-intrusive way.  There is no hard sell, just soft sells if you are interested in a product. So, what inside information did I learn being a speaker this year?  What tips would I only share with members of the Internet Time Machine? 1. The next 18-24 months is all about WEBINARS.  That is the new hot phrase and buzz word in the IM space. Since the long tail sales page is dying, and now the video sales page is slowly giving less and less results, the next logical step in getting someone to "like, know, or trust" you, is a webinar.  For those that don't know, a webinar can be a live or recorded presentation, lasting between 45 minutes and 90 minutes, where you listen to audio and have a visual presentation as well.  This could be a slide show presentation or a live software demonstration.  The conversion rates on webinars are MUCH HIGHER than sales pages and even videos.  Why?  If you can get a person to listen to you, and get to "know" you over 90 minutes, the chances they buy are much greater than if they just read a sales page.  The moderator can control the offers, the bonuses, and sales techniques much more acutely on a webinar as well.   WEBINARS The webinar itself is fairly easy to do yourself as services like gotowebinar or gotomeeting make it almost fool proof to set up your webinar, get the links to email people, and to run your webinar, whether it is live or recorded.  Affiliates like webinar's because they convert well to sales, and the tracking is very easy with the unique links that the gotowebinar and gotomeeting software generate.  I can think of at least 8-10 "How To Do Great Webinars" type courses that are already out there or plan on launching. This is just the type of the iceberg.  There are plans for at least 10 more "how to make money with webinar" products coming out. The opportunity I see for this niche, ISN'T in the IM niche, but taking the webinar technology to "real" businesses that are starving for content and user interaction.  I think selling a full webinar service to offline and legit online companies is a niche that no one is talking about.  Have a webinar series devoted to each person in management sharing their business philosophy. Send out the recordings to employees and customers. Have the webinar transcribed (super cheap) and release it in text format as in interview on their sites.  Maybe a press release is in order when the president or CEO of the company is interviewed. Just something to think about. APPS The actual app presentation left a bit to be desired at Underground 7, but don't let the presentation fool you from the point.  APPS are big and getting bigger, BUT they are now being used in lead generation and other tactical and practical areas of business.  The latest idea is to add a "nag" button to your app. This is the screen that comes up and asks the person if they would like to upgrade from the fee version to the paid version.  Well, that screen and the text on it can be use to ask any question and when the person hits the "yes" or "no" button, it can redirect them to a website or optin form.  So, if you have an APP and wanted a "nag" screen to say "Would You Like Our Free Tip Sheet" or "Would You Like Our Free Report on SEO" or something like that, the user can hit "yes" and be taken to a mobile ready optin form. Very sneaky and a nice way to build a list through mobile traffic. THE DEATH OF THE IM SPACE The more you listen the more you hear of gurus and famous IM marketers dying to leave the industry. I was curious as to why so many "successful lifestyle millionaires" where saying the IM space is dead and don't bother with it as a niche.  Two main reasons came out through my hours of talks. 1. The biz opp offer area has ruined the IM space.  The super-scammy work at home offers have blurred the lines (at least to regulators and Google) between legit IM marketing courses and ideas and scammy ripoff artists.  The IM space is now being lumped in with the scam biz opp area and Google doesn't like either one and neither does the Federal government.  One prominent industry leader told me, "What the biz opp offer is promising to do for $27, it would take me $3,000 of coaching to get that real results, so why would anyone chose me over the $27 fake product." 2. English affiliate marketing - Believe it or not the affiliate marketers in the US are crying foul at their counterparts in England.  The US marketers claims that because we have the FTC over here, and that the FTC is now cracking down on the IM space, that the products and claims of IM marketers in the US are more realistic with the products now.  (IE, not fake and crazy promises, or at least more controlled).  With no FTC equivalent in England, the English products and marketers have taken the claims of their products and promises on what they can do to a whole new level of absurdity.  The US marketers feel they are ruining the industry for all, forcing a government step in as complaints mount, and they will cause a restructure of the industry sooner rather than later. Other notes...   If you are in to domain flipping or domaining, as it is called, check out Chad Fulkering at ecorp.com.  They are set to release a software that drops a website on your URL's that are in your portfolio so that they can be optimized to get Google Adwords traffic on day 1 while you wait to sell them. It is a turnkey solution for people that buy 10-20-50 domains at a time and just want to drop a site on each one to start getting traffic. Checkout Matt Mickiewicz, of Flippa and 99 Designs fame, new website, learnable.com that launched this week. It is a platform for schools, teaches, or anyone to run an online teaching system for very short money.  Matt is continually one step ahead of markets and this learnable website is one of his most exciting projects. Facebook traffic seems to convert to webinars better than websites or optin forms. Seems most of the success right now is sending Facebook traffic to a webinar signup page, then sell them from there. Hellobar.com is a great way to increase conversions in non-spammy way on your website, check it out! Have a little bigger ad budget, I heard on the down low that ADready.com is the place to go for very good prices on Google traffic and other major network traffic on the cheap.

GR-Based Invoice Verification

SAP Tutorial - Mon, 2011-01-03 17:44

In GR-Based Invoice Verification in SAP , goods receipt must occur before the invoice is entered in the SAP system. Invoice verification is GR-based if the GR-based invoice verification flag is checked in the purchase orders (PO).

This setting is at PO line item level, i.e. it is technically possible that in one PO, one line item requires GR-based invoice verification while another line item does not require GR-based invoice verification.


In the purchasing organization view of the vendor master, there is also a GR-based invoice verification flag. This checkbox should be checked for all vendors (except import vendors where countries will practice non GR-based invoice verification).

If this checkbox is checked in the vendor master (FK02 transaction), when PO is created for this vendor, the GR-based invoice verification checkbox in the PO will be checked by default.


In the purchasing organization view of the info record, there is also a GR-based invoice verification flag. If this checkbox is checked in the vendor master, when PO is created for this vendor, the GR-based invoice verification flag in the PO will be checked by default.

For GR-based invoice verification in SAP, when the invoice is posted, GR/IR account is debited and vendor account is credited. The GR/IR account which gets debited is based on the valuation class of the material.

Logistics Invoice Verification

SAP Tutorial - Mon, 2010-12-27 15:56

Logistics Invoice Verification process covers the processing of vendor invoice/credit memo that is linked to a purchase order (PO), service provider invoices (e.g. delivery cost) as well as consignment settlement.

Logistics invoice verification for all PO-based invoices will be GR-based only. For GR-based invoice verification, 3-way match will take place in the SAP system.

This will match the invoice to the PO quantity or price to the goods receipt quantity. If all 3 documents match completely, the SAP system will allow the invoice to be posted.

Generally, invoice should arrive directly in the Accounts Payable Department and posted directly if the invoice is 3-way matched. If there is mismatch and the difference is within tolerance limit that set in SAP configuration, the invoice will be posted.

If the difference is not within tolerance limit, then the invoice will be parked as parked document in SAP system and the buyer will be informed to investigate the discrepancies.


Possible Corrective Action for Price or Quantity Mismatch during Invoice Verification

• Price in PO is different from Invoice price – Update PO or Create Credit Memo

• GR quantity is different from Invoice quantity – Update GR quantity or Create Credit Memo

• The invoice price or quantity is incorrect – Update PO or GR quantity or Create Credit Memo

• The invoice price or quantity is incorrect – Return the invoice to the supplier to be revised


When the difference is due to vendor error (e.g. incorrect price on the invoice), the vendor will be requested to provide a credit memo. The invoice is posted after the credit memo has been received.

If the mismatch is not due to vendor error (e.g. price on the PO was incorrect), the invoice should be posted and automatically blocked for payment (as difference exceeds tolerance). The blocked invoices need to be released before payment can be made.

PO price for future POs will then be updated. Alternatively, the GR will be reversed, then PO price updated, post the GR again and then perform the invoice verification. Countries are free to decide the corrective actions they want to adopt when there is mismatch between invoice and PO/GR.


If a down payment was paid to the vendor previously, a SAP system message will be shown when the invoice is being posted. The down payment should then be cleared against the invoice. For import invoices where invoice verification is GR-based, down payment functionality will be used if payment has to be made prior to GR.

For consignment, payment is made to the vendor based on the quantity of the material which has been used.


Double (duplicate) invoice checking is carried out by the SAP system to ensure that the same PO invoices is not posted twice. Criteria for checking for duplicates are Vendor, Document Reference Number, Invoice Amount and Currency. Invoice Date is removed as a criterion to tighten the control during invoice processing.

Valuation of a material document posted

SAP Tutorial - Wed, 2010-12-22 15:22

The difference between the valuation of a material document which is posted to the previous period and a posting to the current period are as follows:

In the previous period, the price or the stock situation can differ from the current period in such a way that a goods movement is valuated differently than it would in the current period.

In this case two accounting documents are generated in SAP system:

For the previous period, the SAP system generates a document with the posting lines of the stock posting which are to be expected for the respective constellation in the previous period.

For the current period, the quantity moved is revaluated (UMB) so that the valuation for this quantity corresponds to the previous period.

Release Credit Cards Setting

SAP Tutorial - Mon, 2010-12-20 16:24

Release Credit Cards only carry out such as enter the payment method class card payment if you are using the application FSCM Biller Direct.

Specify whether Web users can release their bills of payment by credit card.

Define Additional Permitted Payment Meth.Classifications per Client

The entry Orbian means that Orbian payment methods can be used in this client.


Define Minimum Term for Clearing Items

Only items whose maturity date is after the current date plus the minimum term are imported.

If a minimum term of nill is entered then all items irrespective of their maturity date are included by the program automatically. In addition, the maximum term continues to be taken into account.


Define Maximum Term for Clearing Items

Only items whose maturity date is before the current date plus this maximum term are imported.

Operating Concerns in SAP

SAP Tutorial - Sat, 2010-12-18 06:42

The two forms of profitability analysis in CO-PA in standard SAP system that are:

Costing-based profitability analysis:

Costing-based is a form of profitability analysis in CO-PA. Costing-based Profitability Analysis represents costs, revenues, and revenue deductions for internal controlling purposes. The direct costs are collected from the relevant material cost estimate for the product sold. All values are stored in value fields.


Account-based profitability analysis:

Account-based is a form of profitability analysis in CO-PA. Account-based profitability analysis reconciles the data between Financial Accounting and Controlling, since all costs and revenues are stored in accounts.


In order to implement Profitability Analysis (CO-PA), operating concerns have to be defined. An operating concern is an organizational unit in Financials module (SAP FI). The structure of an operating concern is determined by analysis criteria (characteristics) and the values to be evaluated (value fields).

SPRO → Controlling → Profitability Analysis → Structures → Define Operating Concern


An operating concern consists of:

1. objects valid in all clients: These include the data structures and the environment of the operating concern.

2. client-specific objects: These include the attributes, PA transfer structures, forms, reports, and so on.


Maintain Characteristics: define characteristics is a number of frequently used characteristics are already predefined in the standard SAP system.


Maintain Value Fields: define your own value fields. Frequently used value fields, such as “Revenue” and “Sales quantity“, are already predefined in the standard SAP system. The name of a value field is 4 or 5 characters in length and must begin with “VV“, except for the predefined value fields.


Maintain Operating Concern: define and maintain the operating concerns you are going to use in your SAP system.


You can work with sample operating concerns to simplify the definition of your own operating concerns. Some of these operating concerns are templates delivered by SAP for you to use for demonstration purposes and as copy templates.

EC-PCA: Dummy Profit Center

SAP Tutorial - Tue, 2010-12-14 15:35

Data will be posted to a dummy profit center in SAP system when the original account assignment object (such as an cost object or order) is not assigned to a profit center.

This ensures that the data in Profit Center Accounting is complete. The data in the dummy profit center can be transferred to the correct profit center later then by whether assessment or distribution.

The dummy profit centers can only be created in Customizing for Profit Center Accounting under Master Data → Create Dummy Profit Center.

To change or display a dummy profit center in SAP system, use the change or display function in the application menu for profit centers.

The dummy profit center receives all the postings in your SAP system to objects which are not assigned to a profit center.


Dummy profit center indicator in profit center master

This dummy profit centers flag determines whether the profit center is defined as the dummy profit center for the controlling area.

If so, all profit-related postings in the controlling area which cannot be assigned directly to a profit center are automatically posted to this dummy profit center. These postings can then be assessed or distributed as necessary.

An overview of the dummy profit centers can be displayed in the controlling areas in EC-PCA Customizing under Environment COAr settings.

Controlling → Profit Center Accounting → Basic Settings → Maintain Controlling Area Settings

The dummy profit center can be created by using a separate function (KE59 transaction).

Valuation During Goods Movements in SAP

SAP Tutorial - Sun, 2010-12-12 15:28

The valuation during goods movements is documented in the valuation guide of materials management (MM application). However, there are many special cases are only described in SAP notes such as 212286.

SAP Note 212286 is an overview note should help make this information accessible.


Overview note: Valuation During Goods Movements

Value of goods movement:

With most goods movements, a corresponding value flow also arises with the quantity flow. This value of the goods movement corresponds in most cases to the value of the stock posting (for example, for consumption).

However, the value can also be determined by a purchase order price (goods receipt for purchase order), can come from plan credit of a production order (goods receipt for production order) or can simply be entered externally as a local currency amount (for example, for an initial entry of stock balances at production startup).


Stock posting:

The stock posting is determined according to the current price control and the current stock situation. If the value of goods movement deviates from stock posting, the current stock situation must be taken into account.

Example: The complete stock of a material want to be cleared. A value of 100 USD is predefined externally. However, the stock has only a value of 50 USD, thus, a price difference must be posted.


• For materials controlled by moving average price, the stock posting always corresponds to the value of the goods movement if the current stock situation allows this.

Vice versa, the stock posting always determines the value of goods movement if the value of goods movement is not determined differently (purchase order price, plan credit / production order, external amount in local currency). The stock posting is always determined in proportion to the value for materials controlled by moving average price.

• For materials controlled by standard price, receipts are posted with proportion to the price but issues are posted with proportion to the value.


Formula for the value determination with proportion to value:

Value of stock posting = (Total value of stock * quantity) / entire valuated stock

Formula for value determination with proportion to price:

Value of stock posting = (Standard price * quantity) / price unit


Revaluation postings:

If you post goods movement to the previous period, the stock posting amount determined for the current period can deviate from the previous period. If this is the case, a revaluation document must be created in the current period.

Further information in the most important SAP Notes: 0196505


Negative stocks:

For negative valuated stocks, a special posting logic must be followed for determining the stock posting for moving average price.

Further information in the most important SAP Notes: 0196505


Price differences and exchange rate differences:

If the value of the goods movement deviates from the value of the stock posting, the difference is posted to a difference account independent of whether a moving average price or a standard price material exists.

Exchange rate differences can be posted during the goods receipt for a foreign currency purchase order.

Further information in the most important SAP Notes: 0191927


Transfer postings:

For transfer postings, the value of the goods movement is calculated from the stock posting of the stock issued.

Further information in the most important SAP Notes: 0071124, 0180503


Calculation of clearing entry during goods receipt to purchase order:

During the goods receipt to the purchase order, the value of the goods movement is calculated with the clearing of the GR/IR clearing account. If a quantity is already calculated during goods receipt, the GR/IR clearing account is cleared proportionally, thus, the value of goods movement is determined by the invoice value.

If there is no invoice for the quantity of goods received, the goods receipt is valuated with the net purchase order value / purchase order price.

The same clearing logic is also used to calculate delivery costs during goods receipts.However, the clearing posting is executed on a separate account.

Further information in the most important SAP Notes: Notes: 0049995, 0191927


Determination of the debit entry during the goods receipt for an assigned purchase order item:

The account assignment of the purchase order item is posted to the total of the amount posted for the GR/IR clearing account and the provisions for delivery costs (if available).


Determination of credit posting to order during the goods receipt for production order:

During goods receipt for the production order, the value of goods movement is determined by the credit of the production order. If a quantity of goods received is not yet calculated, credit posting to order is calculated from plan credit.

If the quantity of goods received is already calculated, the order is credited for actual costs.

Country Key in SAP

SAP Tutorial - Fri, 2010-12-10 15:24

The country key contains the information which the SAP system uses to check entries such as the length of the postal code or bank account number, check rule, ISO Code and so on.

The two-character ISO code in accordance with ISO 3166, which is delivered by SAP as a default, is usually used.

The entry is used in some countries to check the VAT registration number (VAT reg.no.). The VAT registration number can be stored in the master record of a customer or vendor, or for the company code.


The country keys are determined at SAP system installation in the global settings.

SPRO → SAP NetWeaver → General Settings → Set Countries → Specify Countries in mySAP Systems (CRM, SRM, SCM,…)

Since the country key does not have to correspond to the ISO code in all installations, programs that differ according to certain values of the country key cannot query the country key T005-LAND1, but have to program based on the ISO code T005 INTCA.

Posting / Valuation Logics for Goods Receipt Process

SAP Tutorial - Wed, 2010-12-08 17:00

While posting a goods receipt (GR) for a foreign currency purchase order (PO), for example THB, with the local currency being USD. The following describe how SAP system calculate / convert amount from foreign currency to local currency in system.


Valuation during GR for foreign currency purchase order

The example of posting logics in SAP system for a foreign currency purchase order (PO):

    1. The amount of the inventory posting in the local currency is identical with the amount of the inventory posting in the foreign currency. With an exchange rate between USD and THB of 1 : 29.4569

    2. The relationship of the amount of the inventory posting in the foreign currency and the amount of the inventory posting in the local currency does not correspond to the exchange rate in SAP system (OB08 transaction).

The described result is caused by rounding in SAP system.


Sample scenario:

60,000 pieces of material A for 104.5 THB / 1,000 pieces are ordered. The material has a standard price of 0.01 USD / 1 piece in the local currency.

For the goods receipt of 20,000 pieces, the SAP system creates the following postings:


Local currency in USD:

Inventory posting (BSX) → 20,000 pieces * 0.01 USD / piece

= 200 USD

GR/IR posting (WRX) → (104.5 THB / 1,000 pieces) * 0.03395 * 20,000 pieces = 70.9555

= 70.96 USD (rounded)

Price difference (PRD) → 200 – 70.96

= 129.04 USD


Foreign currency in THB:

Inventory posting (BSX) → 0.01 USD / piece = 0.294569 THB / piece → 0.29 THB / piece (rounded) = 20,000 pieces * 0.29 THB / piece

= 5,800 THB

GR/IR posting (WRX) → 20,000 pieces * 104.5 THB / 1,000 pieces

= 2,090 THB

Price difference (PRD) → 5,800 – 2,090

= 3,710 THB


Further explanation for the posting logic of  foreign currency purchase orders in SAP Note 191927.

No rounding problems occur when calculate the postings in local currency. When you calculate the inventory posting in the foreign currency (Document currency), the price was rounded, therefore, the relationship between local currency amount and foreign currency amount does not always correspond to the conversion factor.

Since the inventory accounts are managed in local currency, the amounts in document currency are only of informative nature.

SAP General Ledger Reference Books

SAP Tutorial - Tue, 2010-12-07 12:00

General Ledger Accounting (FI-GL)

The central task of General Ledger accounting is to provide a comprehensive picture for external accounting and accounts.

Recording all business transactions (primary postings as well as settlements from internal accounting) in a software system that is fully integrated with all the other operational areas of a company ensures that the accounting data is always complete and accurate.

The SAP General Ledger (2nd Edition) provides complete coverage of the SAP General Ledger, including all of the new features such as Document Splitting, Profit Center Accounting, parallel accounting, and Balanced Scorecard.

It also includes a complete chapter on the SAP General Ledger’s role in reporting for IFRS, including parallel valuation.

A must-have for all finance professionals who have migrated or are migrating to the SAP General Ledger, The SAP General Ledger (2nd Edition) book is a resource that can be used in both daily work and at the implementation level.


Integration of Financial Subledgers with SAP General Ledger

The following are SAP FI General Ledger features:

• Free choice of level: corporate group or company

• Automatic and simultaneous posting of all sub-ledger items in the appropriate general ledger accounts (reconciliation accounts)

• Simultaneous updating of general ledger and cost accounting areas

• Real-time evaluation of and reporting on current accounting data, in the form of account displays, financial statements with different financial statement versions and additional analyses.

Deactivate Update of Classic General Ledger (GLT0)

SAP Tutorial - Tue, 2010-12-07 04:53

Deactivate the update of tables of classic General Ledger Accounting

When new General Ledger Accounting is activated, not only the tables of the new General Ledger Accounting are updated in the standard SAP system, but also the balances in the tables of classic General Ledger Accounting (GLT0 table).

This default setting enables you to use comparison reports during the implementation phase of new General Ledger Accounting to ensure that new General Ledger Accounting delivers correct results.

To compare the data, you use the IMG activity Compare Ledgers. Once you have established that new General Ledger Accounting and it is set up correctly and is operating correctly, you can deactivate the updates from classic General Ledger Accounting.

To do this, deselect the indicator Write Classic General Ledger (GLT0).


Access the activity as follows to deactivate the update of tables of classic General Ledger Accounting:

Financial Accounting(New) → Financial Accounting Basic Settings (New) → Tools → Deactivate Update of Classic General Ledger (GLT0) or SAPLFAGL_ACTIVATION transaction


One of the key points to be noted to deactivate the classic GL totals table: GLT0, is the results must be the same when you do a ledger comparison between classic GL (totals table GLT0) and new GL (totals table FAGLFLEXT).


The standard ledger comparison tool in SAP system as follow:

IMG → Financial Accounting (New) → Financial Accounting Global Settings (New) → Tools → Compare Ledgers

In this standard tool, classic GL is represented by ledger 0 and new GL by ledger 0L.


You can use a setting in Customizing to set the option of reading data from the tables in classic or new General Ledger Accounting.

If you want data to be read from the tables in classic General Ledger Accounting, go to the Implementation Guide for Financial Accounting (New), choose Financial Accounting Global Settings (New) → Tools → Deactivate Update of Classic General Ledger (GLT0), and set the Read Classic General Ledger (GLT0) indicator.

• When Read Classic General Ledger (GLT0) indicator is set, you can use the drilldown function in classic General Ledger Accounting for reporting in new General Ledger Accounting.

• When Read Classic General Ledger (GLT0) indicator is not set, all programs that use the logical database in Financials (General Ledger Accounting) read data from the totals table in new General Ledger Accounting.

Define Ledgers for General Ledger Accounting

SAP Tutorial - Tue, 2010-12-07 04:37

To define the ledgers that will be used in General Ledger Accounting (New G/L). The ledgers are based on a totals table. SAP recommends using the delivered standard totals table, FAGLFLEXT table.

There are 2 types of ledgers are available:

Leading Ledger

The leading ledger is based on the same accounting principle as that of the consolidated financial statement. It is integrated with all subsidiary ledgers and is updated in all company codes. One ledger must be designated as the leading ledger.

In each company code, the leading ledger automatically receives the settings that apply to that company code: the currencies, the fiscal year variant, and the variant of the posting periods.


Non-Leading Ledger

The non-leading ledgers are parallel ledgers to the leading ledger. They can be based for example on local accounting principles such as German Commercial Code.

A non-leading ledger must be activated by company code. For each ledger that you create, a ledger group of the same name is automatically created.


Define Ledgers for General Ledger Accounting Steps:

1. Access the activity SPRO transaction

Financial Accounting (NEW) → Financial Accounting basic settings (NEW) → Ledgers → Ledger → Define Ledgers for General Ledger Accounting

2. Make the following entries:

    Ledger: 0L

    Ledger Name: Ledger Principal

    Totals Table: FAGLFLEXT

    Leading: X

Clear G/L Account (F-03)

SAP Tutorial - Wed, 2010-12-01 16:31

The following are differences between clearing accounts function and posting with a clearing transaction or posting with a payment:

• A document header don’t need to be entered

• You can only clear open items from one account

Clearing accounts function can be used to clear debits and credits that balance to zero (for example, invoices and payments that have already been entered).

Since internal transfer postings may have to be generated, a document type must be defined for clearing in customizing by selecting the activity Define Posting Keys for Clearing in the Implementation Guide for Accounts Receivable and Accounts Payable.

The Maintain Accounting Configuration: Clearing Procedures – List screen appears. Select the Transfer Posting with Clearing transaction. A detailed screen appears. For each account type, you can specify a default document type to be used for posting a clearing document (if this is required for the clearing transaction).


To clear a G/L account, proceed as following steps:

1. From the Accounts Receivable, Accounts Payable, or General Ledger menu, choose Account → Clear. Then the screen for entering header data is displayed.

2. Enter the account number in the Account field and if necessary, also enter a currency key for the clearing document in the Currency field. If you do not enter a currency key, the company code local currency is used. The company code and clearing date is proposed by the SAP system.

3. You have the option of searching for specific items for clearing. To do this, select a field (for example, Amount) and choose Enter. The next screen prompts you to specify which open items to select.

4. To display the open items for processing, choose Goto → Open items.

5. Process the open items as described in Open Item Processing.

6. Once the debits equal the credits, choose Account → Clear.


SAP system will assign the clearing date and clearing document number to each open item cleared. To check whether an open item has been cleared in the line item display (FBL3N transaction) or document display (FB03 transaction).

In the line item display, the last three digits of the clearing document number are displayed if you choose the standard line layout variant.

Syndicate content