FICO Faqs - Integration of FICO with Other Modules

What are the steps for integration of FICO with other modules SD, MM etc. ?

Some basic information :

FI-MM: The integration between FI-MM happens in T-code OBYC.

1. When PO is created :

---- No Entry -----

2. When GR is posted

Inventory Account dr (Transaction Key BSX in OBYC)
To GRIR account (T.Key WRX in T-code OBYC)

3. When Invoice is posted

GRIR account Dr.
Vendor account Cr.

4. Payment made to Vendor

Vendor A/c Dr
To Bank Clearing A/c Cr.

Points to know : Movement Types, Assignment of Movement types to T-keys (T-code OMJJ), Value string (I also need some information on this) , OMWN and OMWB transactions.

---

There is a close integration b/w FI & MM, actually document flows from MM to FI in the following areas such as,

1. Movement Types:

Used to enable the system to find the predefined posting rules determining how the accounts of financial accounting system are to be posted & to update the stock fields in the matrl master data.(Goods Receipt, Goods Issue, etc)

2. Valuation Class:

Assignment of material to grp of gl account, used to determine the gl accounts that are updated as a result of goods movement.

3. Transaction/Event key:

Used to control the storage or filing of documents & assignment of documents.Used to differeniate b/w various transactions such as goods movement tht occur in inventory.

4. Material Type:

Each material should assign mtrl type in mtrl master record used to update whether changes made in qty are updated in material master record & change in value also updated in stock account.

FI-SD Integration: The integration is done in T-code VKOA

1. Sales Order Created

---No Entry---

2. PGI done (Goods issue)

Cost of Goods Sold Dr (Configured in OBYC GBB T-Key)
To Inventory Account

3. Billing document released to Accounting

Customer Account Dr.
To Sales Revenue Account (ERL T-key in Pricing procedure)

Note : The GL account is assigned to this ERL in VKOA

4. Payment Received

Bank Clearing A/c Dr
Customer A/c Cr.

Points to Know : Good to understand the pricing procedure and how the different transaction keys are used like ERL, ERS etc.

FICO Account Payable Set the baseline date=Invoice date FICO Account Payable

Through payment terms, you can set the baseline date=Invoice date.

The payment term is entered in the Vendor Master Record and it will be defaulted in MIRO.

If payment term in Purchase Order is different from the Vendor Master Data, it will have preference over the Vendor Master Data.

FICO Account Payable Configure the Data Medium Exchange for making payments - FICO Account Payable

How can I configure the Data Medium Exchange for making payments?
How can I link it to (F110) payment program & get the file MT100 to be sent to the bank?

When configuring the payment methods for the country (transaction OBVCU), choose the payment medium program as RFFOM100.

From se38, pls read the documentation for the program, which will give you the various options & the required config too.

You would also need to configure the instructions keys as required.

To generate the DME file, you have to run the automatic payment program with this payment method.

After the payments have been successfully posted, you can go to DME administration and with the help of dme manager download files on your PC.

SAP has determined that the standard print programs for automatic payments will no longer be supported, and will be replaced by transfer structures created by a tool called the DME Engine.

This tool enables the business to create DME output files without ABAP development, and can be attached to a print program and form for the creation of Payment Advices.

Outside of the DME Engine (DMEE), the majority of the configuration takes place within the following IMG menu path:
IMG Path: Financial Accounting -> Accounts Receivable and Accounts Payable -> Business Transactions -> Outgoing Payments -> Automatic Outgoing Payments -> Payment Media -> Make Settings for Payment Media Formats from Payment Medium Workbench

Config
Assign Selection Variants
IMG -> Financial Accounting -> Accounts Receivable and Accounts Payable -> Business Transactions -> Outgoing Payments -> Automatic Outgoing Payments -> Payment Media -> Make Settings for Payment Medium Formats from Payment Medium Workbench -> Create / Assign Selection Variants or transaction

OBPM4..select your format that you are using

Check in FBZP config that all is linked!

Although this is bitty but you need to work through it!

Start with FBZP, create all there than go to DMEE either to create your own format or use the standard ones.. than go to the menu path above and work through from create to assign...

FB50, FB60, No document number was display FICO Account Payable - FICO Account Payable

On the first day of business after the basis people apply an upgrade to a kernel, over the weekend, we lost visibility to the document numbers in the status bar after we posted transactions FB50 and FB60.

An OSS message was created and the reply was that it was an issue with a kernel patch level.

They refer us to OSS note 510815, and kernel patch level 1121.

MIRO No FI document after upgrading to 4.6x FICO Account Payable - FICO Account Payable

When we upgrad to 4.6x, users was not willing to access the FI document through Invoice display :-

MIR4 -> Follow on documents

I agreed with them because it is really troublesome to go through such a long steps in order to find out the FI document number.

In 4.6x, SAP only display the Invoice document number after posting.

In order to display both the Invoice and FI document number at the same time, you have to apply OSS notes 216935 and 310231.

You need to changed the programs in order to get the message
"Invoice Document no. & and FI Document no. & created."

The following messages which were modified as per the OSS note to get the FI document number.

Message no
Newtext Old text
060 Document no. & created
Invoice Document no. & and FI Document no. & created

075 Document no. & created (blocked for payment)
Invoice Document no. & and FI Document no.& created (blocked for payment)

282 Document reversed with no. &: Please manually clear FI documents (No change done in
the message text). But it will display FI document number after changes.

392 Invoice document & has been posted (Now this displays Invoice document number.
After changes,it will display FI document number).

After these changes you will be able to see the FI document number and Invoice document number displayed in the message bar after executing the MIRO Transaction.

You will need authorizations and access key to do the modification.

To avoid transfer posting of the same vendor invoice FICO Account Payable - FICO Account Payable

You can check "Flag for double invoices or credit memos" on Vendor master data.

In FK02, Company code data -> Options Payment transactions.

Tick Check double invoice.

Different Between Posting, Clear and Payment - FICO Account Payable

Posting occurs with many different types of documents. It indicates that all sides of the FI entry are in balance. Posting actually writes the document to the G/L.

Payment on the other hand is the actual issuing of a check. Payments can also be processed in accounts receivable.

In that case, you are posting (updating your books to reflect) the receipt of a check from a customer and the deposit of said check in the bank.

Accounts payable is processing the money your company owes to a vendor for goods and services received. Account Payable is a liability on the balance sheet.

Accounts receivable is collecting the money that other companies/customers owe you. It is an asset on the balance sheet.

SAP is integrated. In most instances, there isn't a "link." The transaction directly updates the tables involved. There is a semi-severance between FI/Payment to allow checks to be issued even if there's a minor imbalance in the FI side of the posting.

Asset depreciation and physical inventory are some example that don't update FI (CO/FM) as soon as the document is saved.

Modules that appear in more than one place is caused by SAP trying to be flexible in where it places things on its menu, so that different users/companies find it easy to locate a given transaction within the confines of the module they work in. This has become more pronounced since the change to role based authorization management. That's why you can reach Create a
requisition from 4 different pathways, why Project Systems is in both Logistics and FI, and why Travel Management is in both HR and FI.

In some organizations, travel authorization and tracking is an HR function, in some it is an FI function.

Difference between Clear and Payments

Apart from processing open items, what is the difference between:
1. Accounting-->FA-->AR-->Document entry-->Incoming payment > F-28 and
2. Accounting-->FA-->AR-->Account-->Clear F-32 and the difference between F-53 and F-44 in AP.

When you post a transaction, you will get a Accounting document. If you are creating a payment document through F-53 or F-58 without linking the Accounting document, than we have to create a link between the accounting document and payment document and that can be done through F-32 (for GL) and F-44 (for AP). An good example is when we make down payment, a payment document is created. If we post the invoice, an accounting document is created. To clear this payment document and accounting document, F-44 is used.

- F-28 will be used to make trasactions for income payments.
Eg: If you receive from a customer by using above T code will be passed necessary entries.
- F-32 will used used for clear the Customer line items.
- F-53 will be used for making payments to vendors.
- F-44 will be used for clearing the Vendor Line items.

Vendors not used within a specified period - FICO Account Payable

Subject: vendors not used within a specified period

Hi,

Wondering if any one can help me?
A while back I found a report which listed vendors not used within a
specified period i.e. list all vendors with no movement over the past 6
months. I can't seem to locate this report/programme?

Regards

-----Reply Message----
Subject: RE: vendors not used within a specified period

Try report S_ALR_87010043 - Vendor Business. Within the report, under the
Output Control section, select the indicator "Accounts With No Purchases"
and run the report for the time period which you wish to evaluate. Hope
this helps

-----End of Message-----

Delink Cheque Payment from Payment Document FICO Account Payable - FICO Account Payable

I want to delink cheque number 000100 from payment doc 4500021.
I want to reverse the payment doc 4500021 and pass a new payment doc 4500022 and attach (Link) the cheque number 000100 to this new payment doc 4500022.

Note the follwoing functionality :

Cheque Voiding ( same as cheque cancellation as we call it )

FCH3 - For unused Cheques i.e. cheques that are not yet assigned to Payment docs.

FCH9 - For issued cheques i.e. cheques assigned to payment docs.

The above will only void the cheque and the payment doc will stand as it is. After voiding the cheque the related payment doc can be reassigned to a new cheque.

If you reverse a Payment document itself ( T.Code FB08 ) then the system will ask for a void reason if a cheque is already assigned. The voiding of cheque will be done automatically if you reverse the payment doc and enter a void reason code. You cannot reverse a payment doc that has been assigned a cheuqes unless you enter a void reason code.

There is a nother transaction available for Payment Cancellation - FCH8

The cheque that has been voided is blocked for further use. If you still want to use it you need to first delete the cheque information. T.Code FCHE.

Also cheque related t.codes in this aspect. related T.Codes start with FCH* and can be found in the Area Menu Cheque Information.

How Down Payments Are Configured FICO Account Payable - FICO Account Payable

The following Customizing settings have to be made for down payment processing:

Settings for the billing plan - To activate the billing plan function, maintain the materials, for which you wish to process down payments, with item category group 0005 (milestone billing). This gives the item type TAO via item type determination. The item type TAO calls up the billing plan function.

You need to implement the following activities in the billing plan for down payments:

Maintain deadline category - This determines the billing rule (percentage or value down payment) for the down payment request. The system assigns billing type FAZ (payment request) defined in the standard system with billing category P. (For the billing type FAZ there is the cancellation billing document type FAS in the standard system).

Maintain the deadline proposal - Use the down payments that are due for the proposed deadlines.

Maintaining a Pricing Procedure with the Condition Type AZWR:

In the standard system the condition type AZWR is delivered for the down payment value already provided but which has not yet been calculated. You must include this condition type in the relevant pricing procedure before output tax.

Enter condition 2 (item with pricing) and the calculation formula 48 (down payment clearing value must not be bigger than the item value) for the condition type AZWR.

Before the condition AZWR you can create a subtotal with the base value calculation formula 2 (net value). If the condition AZWR is changed manually, you can get information on the original system proposal from the subtotal.

Maintain the printing indicator - The pricing procedure can not be marked as a transaction-specific pricing procedure (field Spec.proc.) The condition type AZWR has the calculation type B (fixed amount) and the condition category E (down payment request / clearing).

Maintaining the Billing Document - In the standard system there is the billing type FAZ (down payment request) and the billing type FAS for canceling . The down payment is controlled using the billing category P of the billing type. A billing type becomes a down payment request when the billing category P is assigned. You have to maintain blocking reason 02 (complete confirmation missing) for the billing documents and assign it to billing type FAZ.

Copying control - Copying requirement 20 must be entered in copying control at item level for the down payment request. In the standard system the order type TA for copying control is set up according to the billing type FAZ for the item category TAO.

Copying requirement 23 must be entered in copying control at item level for down payment clearing. In the standard system the order type TA for copying control is set up according to the billing type F2 for the item category TAO.

Financial Accounting settings - A prerequisite for down payment processing is that the account is assigned to the underlying sales document. To do this, change the field status settings in Customizing as follows:

Set reconciliation accounts (transaction OBXR) - For the `received down payments' and `down payment requests' from
the G/L accounts you have selected, you should assign the field status definition G031.

Maintain accounting configuration (transaction OBXB) - For the down payments (posting key ANZ in the standard system) and the output tax clearing (posting key MVA in the standard system), you must maintain the posting key.

You must also carry out a G/L account number assignment for the tax account.

Maintain the posting key (transaction OB41) - For posting key 19, set the sales order as an optional field !!!

Maintain the field status definition (transaction OB14) - For field status variant 0001, field status group G031, set the
sales order as an optional field !!!

Assign the company code to the field status variants (transaction OBC5)

FICO Account Payable Setting Up Manual & Automatic Payment Program - FICO Account Payable

I am doing a project in my institute. we are facing a problem in running a automatic payment program. Suppose I have a balance of Rs 100000 in my bank account and today I am running a Automatic payment run. Total payment of the run are Rs 150000. So when I run Automatic payment run it is not giving any error message. What to do with this problem.

In my point of view we have to create validation. And link between bank account and payment method. If the balance is less than the automatic payment amount the run should be stopped .

The Automatic Payment Program does not check the Balance of your Bank Account.(GL A/c. Bal.)

What it does check is the min & max amounts that you have maintained in your customisation.

In FBZP Transaction (type in easy access screen), you have to maintain the config for your automatic payment runs.

In Bank determination (in FBZP), you have to fill in the available amounts for each Bank. This is the maximum amount up to which payments will be generated by the Auto. Pay. Run.

So if you want to ensure that on any single day the payment run does not pay more than bank balance, you have to update on a daily basis available balance to match with your bank balance .

In SPRO you can find the customisation for A P Run, but FBZP is the old transaction for the same thing. Plus it lets you do all the related customisation, in one place.

As far as I know, there is no direct way of linking your GL account balance to the A P Run. *-- Uma

I am creating a new company code 'A', in which the paying company code will be 'B' and the sending company code will be 'A'. Now I have to configure for both manual and automated payments.

Couple of questions on that:

1. For cross-company payments what do I have to do different in the configuration settings.

2. In manual outgoing payments, My user has a list of reason codes ( for overpayment/underpayment) defined for an old company code, it's not allowing me to copy that into my new company code. How can I do that.

In Customizing Maintain Payment Program : Transaction code FBZP
1) define your company code'A" & "B" both in section tab (All Company code)

2) Define Paying company Code for example "A" paying company

3) Payment Method in country in tab
Country IN (India) - Name of Country - Payment Method "C" is for Cheque "D" for Demand Draft etc

4) Payment Method in Company code - for example "A" is paying company define payment method in same section

5) In Bank Determination Section - define Ranking Order, Bank Accounts, Available Amount, Value Date, Expences/ Charges

6) Define House Bank : HB Name , Account ID Bank Account Text,

While runing APP (F110) user should select paying Co Code "A" in maintain variant,

FI Questions about GR/IR - FICO Account Payable

1. How do we post the FI transactions after doing MIGO?
Does the Migo generate FI postings or do we manually do the posting.
If we do it manually what is the T.Code to do it.
2. How do we reverse an Invoice?
We go to miro and enter a credit memo.
How do we post the reversal entry?

In SAP, the moment you save the MIGO transaction, it automatically generates FI document. It will create following entry:-
Raw Material Stock A/c Dr
To GR/IR Clearing A/c

In MIGO transaction itself, you can post Excise by choosing Capture and Post Excise Invoice. The FI document will be as follows:
RG23A Basic Excise Duty A/c Dr
RG23A Education Cess A/c Dr
To CENVAT Clearing A/c

After doing MIGO, you execute MIRO. In this transaction also, SAP will generate FI document automatically. The entry will be as follows:-
GR/IR Clearing A/c Dr
CENVAT Clearing A/c Dr
VAT Setoff A/c Dr
To AP-Vendor A/c

Reversion of entry of material purchase can be in entered on rejection of material partially or wholly. In this case, you will
have to raise a debit note on the vendor. But before raising debit note, you have to first ensure that the Invoice verification of the material (to be rejected) is complete at the time of purchase.

Purchase documents cannot be reversed directly like pure financial document entry. To reverse the material document,
following procedure should be followed.
1) Create Return Delivery (MIGO)
2) Reverse the Excise Duty Posted (J1IS)
3) Raise the debit Note. (MIRO) * -- Rajesh Birari

Cancel Invoice In MR8M

While cancelling invoice in mr8m, I'm getting a message that FI documents to be cancelled manually. What does this means?

If the cancellation / reversal of MIRO invoice is done through MR8M, only the MM invoice / documents gets reversed but the FI document will not be reversed or cancelled.

We have to follow the following procedure.

1. Goto T.Code MIRO
2. Select Credit Memo in the transaction field.
3. Fill up all the details in the fields for the invoice to be reversed.
4. Give the P.O. no
5. Select the line item to be reversed.
6. Simulate and save.

The impact will be as CR - GR/IR clearing a/c
DR - Vendor a/c

By this procedure, the purchase order history in P.O. will also get updated and there is no requirement of any manual clearing. Only in the Vendor a/c, the DR. and CR should be knock off.

FICO Account Payable Recurring Documents and Interest Calculation - FICO Account Payable

How to create recurring document template? How to run recurring document and what date should normally put to run it and what are the steps for Interest Calculations?

For Recurring document template you can use the following T.Codes

FBD1 - Creation of recurring document
FBD2 - Change recurring document (This is for changing of amount and recurring periods)
FBD3 - Display recurring document
F.14 - Posting of recurring document
F.15 - Display of recurring document

For Diff. run schedule recurring documents you can use this T.Codes

OBC1 - Creation of Diff. Run schedule Recurring document
OBC2 - Enter run dates for Recurring document
F.14 & F.15 steps are same

Steps For Interest Calculation you can use this following T.Codes :

OB59 - Define valuation method
OBA1 - Preapare automatinc postings for foreign currency valuation
FS00 - Assign exchange rate different key in loan a/c
F.05 - Foreign currencty revaluation
OBAA - Prepare account balance interest calculation
OBAc - Define reference interest rate
OB81 - Define time dependent terms
OB83 - Enter interest value
OBV2 - Assignmen of accounts for automatic
F.52 - Interest calculation

FICO Account Payable Update Trading Partner Field for Posted Documents - FICO Account Payable

In FBL5N/FBL1N, I have checked the related documents and found that one of the line items is having 'Trading Parnter' field as BLANK. So I need to enter the Trading Partner in the document header. Here I have noticed that the Trading partner field is DISABLED and hence I am unable to enter the values and proceed further.

I think if I can fill the trading partner field with the required value the documents can be cleared.

How can I make the Trading Partner field active. In the document type setting KA (used here) the 'Enter Trading Partner' flag is ON. Also I have check the Field Status settings for the Posting Key also for Trading Partner.

Solution:

On the first hand it is not possible to update the trading partner field for posted documents, as per SAP Standard. There are two alternatives to this:

Alternative 1:

REVERSE AND DOCUMENTS CAUSING THE PROBLEM AND RECREATE THEM AFREASH

1. Find out if there are any clearing documents within the main document in question which is not getting cleared due the trading partner field.
2. Goto FBRA: Reset and reverse the clearing documents if any as found in step 1.
3. Goto F-02 give the main document number; then goto "Document>Reverse" menu or press CTRL+SHIFT+F12 to reverse the document.
4. Goto F-02: Recreate the main document using "Post with reference" function of document header which gets automatically populated (with correct Trading Partner field )as per setting defined in the customer/vendor master data once the document is saved.
5. Goto F-44/F-32 and then try clearing the vendor/customer.
6. Dont forget the post the clearing documents which were reversed in Step 2.

Alternative 2: This shall be taken as the worst case which shall not be recommended as normal practice.

To develop an ABAP which shall update the trading partner field VBUND in Table BSEG, BSIK, BSID and then try clearing the documents.

What is Trading Partners?

In Business Terms Trading partner is your business partner within Group with whom you are doing business.In order to identify Inter Company transactions Trading partner field is used. You need to define all the Group Companies as company in SAP and all the defined Companies will be available for selection in Trading partner field. Trading partner can be defaulted in GL, Customer or Vendor Master. If you need you can populate trading partner at Document level too by doing settings in Document Type Master in T Code OBA7. *-- Suresh

Trading partner is normally used to control (payment/transaction) vendor/customer business with the group. Something like group/inter group business. You have to go to master record. for eg, in customer master, go to CONTROL DATA tab so see Acccount Control, in which you have provide trading partner number/reference.

FICO Account Payable Process Of Letter of Credit for Imports - FICO Account Payable

1. The Clearing agent ask for amount, the person who receive the product will give Letter of Authority to Clearing Agent. The clearing agent move to bank and take check.

For this purpose, we just issue LA.

2. Prepare Purchase for the Vendor from whom we are going to receive the product. There may be 2 or more Vendors.

1. Product cost to be transferred to Vendor A
2. Freight or Other Charges to Vendor B
3. Customs Duty and Others to Vendor C

Tcode : Me21n

3. First We have to pay Customs Duty to Commissioner of Customs after LA issued.

Entry : Customs Clearing a/c Dr
Cess on Custom a/c Dr
CVD Clearing a/c Dr
Cess on CVD a/c Dr
Special CVD a/c Dr

Vendor C a/c Cr.

T-code :MIRO or YMIROOTH

4. Cenvat credit for the product will be taken by person who handling Excise in that company

Entry : Cenvat Clearing a/c Cr.
RG23A Part II a/c Dr.

5. Clearing of Cenvat Credit

Entry : Cenvat Clearing a/c Dr.
CVD clearing a/c Cr.
Cess on CVD a/c Cr.
Special CVD a/c Cr.

6. After Bank payment they will transfter to us

Entry : Vendor a/c - Dr.
Bank a/c - Cr.

FICO Account Payable How To Make a Residual Payment To a Vendor - FICO Account Payable

Residual Clearing – full amount is cleared for the remaining amount system will generate one more line item as open item (or) due item.

1st POST BELOW INVOICE:
PstKy – 31 Account – ****** (WELL) & press enter
Amount – 45,000/- Business Area – 830B, Payt terms – 0001
Text – Goods purchased

PstKy – 40 Account – 401000 (Material Purchased) & press enter
Amount – * Business Area – 830B (Under MORE button you will find it)
Text – + & press enter. Select menu item DOCUMENT –> SIMULATE & POST.

OUTGOING PAYMENT (using Reason Code):
Accounting –> Financial Accounting –> Accounts Payable –> Document Entry –> Outgoing Payment –> Post (or) F-53

Residual payment
Document Date – **/**/**** Document Type – KZ
Company Code – 8301 Currency/Rate – INR

Account– 211000 (ABN Bank A/C) Business Area – 830B
Amount– 43,000/-,
Text – Part payment,
Account– ****** (WELL) And enter & select RESIDUAL tab and double click in the RESIDUAL ITEMS column and select DR (Discount Received) reason code.
Go to menu item DOCUMENT –> SIMULATE & press POST button.

An example:

While processing thru F-58, First enter the payable amount.

Next Go To Process open items. Go to Res. Items tab and double click on the Residual items.

Bills Of Exchange Concept In AP FICO Account Payable - FICO Account Payable

About bills of exchange concept in Accounts Payable.

Bills of exchange may be defined as a commitment subscribed by your customer to pay a certain amount on a given date upon presentation of the bill of exchange. They can be used to materialize installment payments.

For example, you have accepted that your customer pays the invoice amount in 3 monthly installments of 1000 USD each. You will issue 3 bills of exhange of 1000 usd each and maturing in month in month m, m+1 and m+2. The bills of exchange will be sent to your customer for acceptance(customer signs them).

Once accepted they will be returned to you. You will have to post accounting entries. But note that even though the accepted bills of exchange can be considered as payment, you cannot clear the outstanding customer invoice until the bills are effectively paid at maturity date. You then have to post the bills of exchange as a special GL transaction.

Again once you have received the bills of exchange you may decide to discount them right away with your bank and this is done with or without recourse. Depending on the option choosen, accounting entries are different. by discounting the bills you receive payment of the bill and this can be used to clear the outstanding customer invoice.

Using 1099 MISC Reporting - FI Reports

Using 1099 MISC Reporting

In order to use 1099 MISC reporting is something that needs to be configured or set up in the vendor master records? I am trying to run the report and I don't get anything.

To flag a vendor in SAP as a 1099 vendor, two fields need to be populated.

1. On the Control screen of the vendor master, populate either "Tax Code 1" field with his social security number if his social security number is his tax id. or "Tax Code 2" field with his corporate tax id. if he has been issued a corporate tax id. Input either of the two in their correct format i.e. social security as xxx-xx-xxxx or corporate id as xx-xxxxxxx.

2. On the Accounting Info. screen, populate the "W.tax code" field under the "Withholding Tax" box with the value "07" if it is a US vendor or "42" if it is a foreign vendor.

These are the two fields that specify a vendor as being a 1099 vendor.

Any posts done before this changes were implemented will not show on 1099.

You will need to run program RFWT0020 to flag 1099 items retroactively.

...and/or you can change the "Document Change rules" for BSEG-QSSHB and BESG-QSSKZ for account type "K" so that you can change the Withholding tax code after the line item has been cleared (i.e. after entering the required information in the vendor master record as the user above has recommended) (Refer to OSS Note: 363650).

But if you use MIRO to post invoices, you might want to look at Note 482245 too...

In SAP v40b, the new 1099 report is RFW1099M. It is a neat report since it merges all the three reports that are listed in the AP info system under the withholding tax.

---

In my system the witholding tax code field shows only one option Y (back-Up Witholding) instead of 7 and 42. ALso it gives me message "Extended witholding tax functionality is not active".
Do I miss some settings on the global level, or I just need to update the vendor master records?

We are on 40b. If you do not have any w.tax code, you can create them in Tcode OBC7. But I have seen standard w.tax code on this screen provided by SAP. Pl. note that you may only be able to see the w.tax code on the vendor master if you are in change mode. For some unknown reason, when you are in display mode, SAP tells you that there are no w.tax codes.

The first report in 4.0b gives all the correct 1099 vendor numbers as well as the error list of incorrect vendor numbers.

The second report gives all the 1099 line items by vendor posted during the year.

The third report lets you print the actual form for IRS/vendors and also lets you send the file electronically to IRS.

---

You mentioned running RFWT0020 - what exactly does this do? I have the same problem that our A/P staff did not update some vendors with the appropriate 1099 data. Now we are getting the data needed - I usually have someone in our IT dept. create a spool manually for those vendors. Will the program above update our vendors' transactions with 1099 info (assuming the vendor master has been updated)?

Yes. This report flags all the past vendor line items as 1099 items retroactively. FYI, we're on 4.0b. One thing that is peculiar about this report is that on the selection screen, you need to put 00000000 to zzzzzzzzz in the vendor number field otherwise it does not flag any records (at least that's what it did with our records).

Customizing for Drilldown Reports - FI Reports

You carry out G/L account information system Customizing in the General Ledger Accounting IMG.

Here you can make the following settings.

• Make report selections
• Maintain reports (create/change/display)
• Transport reports to a different R/3 System
• Import reports from client 000
• Reorganize reports (that is, delete)
• Reorganize report data (that is, delete)
• Maintain forms (create/change/display)
• Transport forms to a different R/3 System
• Import reports from client 000
• Reorganize forms (that is, delete)
• Define and valuate constants
• Define global variables
• Translate reports

To find out how to make the above mentioned settings, see the documentation for each activity in the G/L Accounting Implementation Guide.

Specific examples of creating forms and reports can be found in Appendix: Sample Reports for General Ledger Account Information System.

Entering Exchange Rate - Exchange Rate

Entering Exchange Rate

You used OB08 to enter the exchange rate ratio (from) and ration (to).

There are three type of Exchange rate :-

1. EURO Euro Dollar

2. M Standard translation at average rate

3. R Exchange rate for currency revaluation

FI Document: List of Update Terminations - Error Message

FI Document: List of Update Terminations

To analyze the FI update error posting, make use of report RFVBER00, FI Document: list of update termination.

Execute the report with transaction code SA38 or SE38.

Entering Invoice Receitps for PO - Data Entry

Entering Invoice Receitps for PO

The Invoice Verification component is part of the Materials Management (MM) system. It provides the link between the MM component and the Financial Accounting, Controlling, and Asset Accounting components.

Invoice Verification in Materials Management serves the following purposes:

- It completes the materials procurement process - which starts with the purchase requisition, continues with purchasing and
goods receipt and ends with the invoice receipt
- It allows invoices that do not originate in materials procurement (for example, services, expenses, course costs, etc.) to be
processed
- It allows credit memos to be processed, either as invoice cancellations or discounts

Invoice Verification does not handle the payment or the analysis of invoices. The information required for these processes is passed on to other departments.

Invoice Verification tasks include:

- Entering invoices and credit memos that have been received
- Checking the accuracy of invoices with respect to contents, prices, and arithmetic
- Executing the account postings resulting from an invoice
- Updating certain data in the SAP system, for example, open items and material prices
- Checking invoices that were blocked because they varied too greatly from the purchase order

An example on how to enter an Invoice Receipts :-

Transaction code MRHR - MM Invoice Verification and Material Valuation

First Screen

Document date : Date of PO Company code :

Document type : There are two standard document types in the standard system:
RE - The invoice is posted gross
RN - The invoice is posted net

Posting date : Date of open period Currency :

Purchase Order : PO Number

Second Screen

Posting

Amount : Enter the gross invoice amount Tax code :

Enter and then click Simulate button

Click Adjustment on/off button

Click Edit -> New item -> G/L Account

a) Enter the G/L Account Number and click whether Debit or Credit

b) Enter the Amount and Cost Center

Repeat Step a) and b) if you have additional G/L Account Number

There must be no Variance and Balance must always be ZERO before you can save the entries.