accrual doc not reversed - displayed in open item list in sap fico

accrual doc not reversed - displayed in open item list

Question: Hello. My user created an accrual doc in 12/2003 with reversal in 1/2004 but failed to run F.81 for this particular doc last month.

The document appears in the open item list of the account. But when we do the 'Account - Clear', the system says there are no open items. Is there a way we can get this document out of the 'Open Item' List? How do we clear the account?


Thank you so much for your time.


Uni

Answer:
Please don't bother - problem's solved.

Thanks.

Accrual Calculation vs. Overhead Calculation w Costing Sheet

Accrual Calculation vs. Overhead Calculation w Costing Sheet

Question: I have a couple of questions concerning the differences between Accrual Calculations in CO and Overhead Calculations using costing sheets.

There are obvious similarities and differences, such as they both use an overhead structure which includes Calculation Base, OH rates and Credit key. The Accrual calculation uses accrual cost elements which are primary cost elements while Overhead Calculation uses a secondary cost element.

My main question is this: apparently they work in a similar fashion. Under what situations would you use Accrual Calculation vs Overhead Calculation? I do know that the accrual calculation will affect FI whereas OH calculation will only affect CO. However, I am having a hard time grasping under which situation one is used vs the other.

My secondary question is related to Accrual Calculation Methods; Percentage Method and Target = Actual Method. I understand the Percentage Method, but has anybody ever used the Target = Actual Method? If so can you give an example?

Any help you can provide is greatly appreciated.

Accouts Payble in sap fico

AccoutsPayble

Question: Hi Friends,

Pls give the table name, which should have the amount on cheque And transaction code for batch cheque paymets.


Rgds,
Chanrda

Answer:
PAYR

Accout determination types KOFI, KOFK in sap fico

Accout determination types KOFI, KOFK

Question: Hi,

There are 2 predefined account determination types for revenue account determination viz., KOFI(without CO) and KOFK (with CO) and both are assigned to an access sequnce the fiest being KOFI.

Can any one throw some tight on why we need KOFK and its significance as to why it is called "with CO".

I would appreciate if you can give me a small example.

Thank you,
Gangadhar.

Answer:
Hi Agr,

One example for KOFK (with CO) is when sales order functions as a CO object which relates to the settings in Requirement Class, Requirement Type and Item Category on SD side.

Regards,

Answer:
Hi Jun,

I am completely unaware of this as to how the sales order is made as Cost Object and in what business scenario. Can you explain little more if you have some time to spare?

Anyway, I will try to gather some material on this....

Thank you so much.
agr

Answer:
Hi,

An example is linking a sales order to a production order to capture production costs.

Program RFFMPS00. What is it's replacement in 5.0

Program RFFMPS00. What is it's replacement in 5.0

Question: Hi

We have just upgraded from 4.6C to mySAP ERP ECC5.0 (quite a mouthful ).

I have uncovered a program which no longer exists in SAP - RFFMPS00.

Can any one in 4.6C tell me what the description of this program is?

The closest OSS note have found detailing any change was an industry solution. Not applicable.

Many thanks people.
_________________
TeeJay

3kei for reversed documents

3kei for reversed documents

Question: Hello

We have set up 3kei to derive the profit centre from the business area for our balance sheet accounts.

We have a customer document posted that has a bus area of XXXX and profit centre of XXXX (this was derived at posting using 3KEI).

We then used FB01, post with reference and hit the post a revers tickbox.

SAP pulled up the reversed document and we changed the bus area to ZZZZ.

However when it was posted SAP did not derive the profit centre.

Can anyone help?

Answer:
Duplicate entry locked!
_________________

payments with same check number in sap fico

2 payments with same check number

Question: Hi there,

Last may, they run F110, for a payment to a vendor for say $100, it was carried out and a check number 1 was created. This June, F110 was run again, and another check was created for an amount of say $50 but the check number is also 1. This was not found out until the bank says that check number was processed.

I looked at F110 and it seems fine with both. I looked at tables REGUP and it says both are processed fine. But when I looked at table PAYR, the $100 dollars was not in the entry, so it printed yet it was not recorded, which is really wierd. What are our options to correct this. I am thinking that we can just re-print this amount using a different check number, is this possible?

Any suggestions?

Thanks,
Jigzy

Answer:
To start with look into the check register to see what was recorded there. From there come back and let us know of you findings so we may be able to give you some guidance.

ZZ

Answer:
Hi ZZ and all,

I looked at the check register and saw no amount or check in there for the first one for the amount of $100 that was printed and cleared. There was however an amount for check #1 for the amount of $50 that cannot be cleared cause the bank says it has the same check number as $100 which they cleared last month.

I looked at REGUS, and it was not blocked, I looked at REGUV, and it says, payment was carried out. (all this is for the $100 check #1, which is not in the check register and not in PAYR table)

Please advise as to what best to do with this.

Looking forward to your answer

Answer:
Hi,

In QAS, I tried to reprint an old check and having it print with a new check number just to see if it would work, I got an error saying this cannot be done as the check was already cashed out. I am thinking, this may be the case that can happen in production once I try it. Now, I am at a lost. We need to pay the vendor soon. Please give me any thoughts.

Answer:
Hi,

I actually thought that I may just reprint that check with another number, I tried it in QAS but I was given an error saying the check has been encashed. I looked at the check info in FCH1, and there was a date in the date encashed field.

On the other hand, I looked at the check info for this check number 1 in PRD, and saw that there is no date in the date encashed field, given this, do you think I just need to reprint the check using a new check number? Would you think there is a better process to go about this?

Thanks.

Answer:
If you reprint it will work because it was not cashed.

Now, based on what you said it seems that somehow you sent the check from QAS to a vendor and that was honored by your bank. I would check with the vendor from QAS if they received a payment on the amount and number of the check you have in QAS. If that is the case you should request a credit from them on the amount of the check.

In addition to that you may want to modify your check sapscript to have a control to print void if a check is printed from QAS. This would prevent future issues like the one you are having.

ZZ

Answer:
In addition to what ZZ said, maybe you also want to make a manual payment (on account) and assign check number "1". I am curious... you mentioned that check was cashed "last" May, then wouldnt there have also been bank reconcilliation issue? for which this manual "on account" payment would help resolve that issue and yet not clear any open items...

Dunning Notices for 1 Dunning Run in sap fico

2 Dunning Notices for 1 Dunning Run

Question: Hi there,

There is only 1 dunning level in the dunning procedure, however, 2 dunning notice need to be generated. 1 for items overdue > 30 days, dunning notice to be sent to the customers; and 1 for items overdue > 60 days, this notice to be sent to the top management (internal) for review & decision making.

Please advice if this can be done.

Thank you!

Answer:
There is only 1 dunning level in the dunning procedure, however, 2 dunning notice need to be generated. 1 for items overdue > 30 days, dunning notice to be sent to the customers; and 1 for items overdue > 60 days, this notice to be sent to the top management (internal) for review & decision making.

Please advice if this can be done.

I would suggest to change your dunning procedure and make it 2 level. Then implement user exit via BTE 00001040 to print/e-mail/fax dunning letter from Dunning Level 1 to the Customer and e-mail internal memo from Level 2 to decision maker.

document FI for 1 Document SD in sap

document FI for 1 Document SD

Question: Hi,

I have a strange situation: 2 FI document (sales invoice) was generating from 1 SD document (invoice).
Has anybody faced this situation?
Any help will be appreciated.
Thank you in advance,
Rubens.

Answer:
can u tell what r the accouting entries for the two accouting documents

1kek transfer pay/rec- experience w exchange rates problems in sap fico

1kek transfer pay/rec- experience w exchange rates problems?

Question: Hi,

Is there someone out there that has problems with the month end process?

Scenario is as follows:

Cntrolling area has different companies with different company code currencies.

When 1kek is started, exchange rates have changed. The calculation is based on the latest exchange rate for the month, but not the originally posted one.
THus, there are differences between amounts directly assigned to PCA and the ones from 1kek?

Who can help? What could be a solution to prevent differences?

Sam!

1099-misc printing script for IRS 2005 reporting

1099-misc printing script for IRS 2005 reporting

Question: We are using SAP 4.6C. Can report F_RFW1099M still be used for printing 1099's to the IRS for 2005. The current ABAP says it is not doable.

Or is there another report to copy to SAP.

Thanks!

Answer:
You have to create your own ABAP report to report 1099 transaction.l

1099 incentives- accounting entry in sap fico

1099 incentives- accounting entry

Question: For incentive payments to be reported in 1099, what will be the accounting entries in SAP.

I understand we will need to create 2 GL accounts: one alternative reconciliation account for 1099 vendors and one offsetting entry non reconciliation account; and we will need to link these accounts to special GL indicators. Do I need to create new special G/L indicator or use one already in SAP?

I understand we will need to post an invoice document and then reverse it.

But haven't been able to put together accounting entries for this.?

Answer:
I have no clue what you are trying to say, I have worked with 1099 functionality in SAP, and I am also a 1099 vendor to companies providing SAP consulting
Does anyone has any idea what sapfico73 is talking about would like to know and learn more about it
sapfico73 could you please explain the business process for what you have said in your post


Regards

Answer:
Yes, how do you pay incentives/gift checks to 1099 vendors; since those will not have any invoice?

Answer:
sorry, my question was not very clear. now that I've found the answer, let me share.

so, the question is for payments that are made outside of SAP but which need to be included in the 1099 report, how do you handle this case? if you posted actual invoice/payment in SAP, that would distort your financials.

solution:

have 2 new accounts: 1099 alternate reconciliation account (A) and 1099 contra account (B) e.g. 99999 and 99998 respectivley. create a special gl indicator to post to alternate reconciliation account.

now post a invoice fb60: credit account A , debit account B
now post a payment f-53: reverse of above

now run generic withholding tax report; specify special gl indicator in selection screen.

please reply if any questions.

now, if someone can help me with staggered printing in 1099 reporting program i.e. print forms 1 and 2 for one vendor, then do the same for 2nd vendor and so on.

1042s-Exemption Authority in sap fico

1042s-Exemption Authority

Question: Hi all,

Does any one know how to create new values for field: LFB1-QSBGR (Exemption Authority) - used while creating a Vendor Master Record. It is used for 1042s tax reporting. Any info will be appreciated..

thanxs!
Steph

Answer:
yeye girl

Tax Posting. Can it be done

100% Tax Posting. Can it be done?

Question: I am trying to create a process for reducing an expense account when VAT evidence has been submitted and increase the VAT account using a Tax Code, so that the TAX is show on the Tax return report.

My failed solution was to post a FB50 with a 50 from the expenses account and then a 40 back to the expense account but with a 100% input Tax Code.

Any other suggestions?

Thanks
Adam

Answer:
no it cannot be done in the way you describe.

if you want to post direct to the VAT account with a tax code, there is a special process for doing this. first the VAT account should have a tax code setting of "<" or ">" in FS00/company code view (it probably doesn't ...). WIth this setting you can post direct to the VAT account and include the base value on which the VAT was paid. You use the normal VAT posting keys.

Answer:
In which transaction can you post the Base Value? I can't see any field within FB50. I made the change in FSS0 (not FS00) adding < (input Tax) to the Tax Category field.

Cheers
AdamG

Answer:
You can try use tr.code F-02 for example.

As I remember there're some troubles with direct postings to tax accounts in Enjoy transaction in 4.6
_________________
Best regards,
Maxim

Answer:
once you have changed the setting in the GL (and the GL balance on the tax account must be zero to do this ...) you create an FB50 posting direct to the tax account. You get a message "enter the tax base for GL account xxx and company code yyy" plus a button towards the bottom of the screen that says "Tax Base". Click on this to enter the base ...

Answer:
Yes, that's done the trick. Thanks a bunch.

Answer:
tc_offline

Yes, that's done the trick. Thanks a bunch.

Cheers

Tax Key Calculation in sap fico

Tax Key Calculation

Question: We have a vendor in the UK that sends us quarterly invoices that are 100% tax. I cannot directly enter an invoice that is all tax. When I create a tax key that is 100% Input tax it doesn't calculate it correctly as it says "Tax Rate cannot be larger than base rate". Now if we do a journal entry to the vendor and to the tax account without using a tax key, the tax amount is not picked up on the monthly tax program S_ALR_87012357.
Any ideas how to process this?
Thanks in advance for your help

Answer:
SAP will not allow to process tax only invoice or correction, you have to be creative to process if you want to process that kind of invoice
Here is a creative solution tax rate is 7% and you receive invoice from vendor for 7% tax of $7

Post an entry FB60 to vendor

Debit Expenses 107.00
Credit Vendor 107.00

Tax code I1 or vendor charging 7% Tax on a $100 Invoice
System calculated $7 Tax that you would pay the vendor


Now create a credit memo
FB75

Same expenses account

Debit Vendor $100
Credit Exp $ 100

Tax code I0 non-taxable

Now clear the 107 with 100 and you have 7 to pay the vendor and tax in tax register

Answer:
Thanks for you quick response. I will try it out.



Answer:
Sory FB65 for a debit to vendor not FB75

Regards,

Answer:
use FB41. Sometime dont try to be too smart!

Answer:
SAPPeople,
How is using this tcode going to treat my tax calculation any different? I have tried and am getting the same problem.


Answer:
SAPPeople,
How is using this tcode going to treat my tax calculation any different? I have tried and am getting the same problem.


FB41 allowes you to post to tax account directly without specifying a base value. so i dont see how you can get the same result with a normal tcode.

Answer:
Try using F-43 this allows you to post to the vendor and direct to tax account, you will need a vat code setup which is 100% for vat.



Answer:
I must be crazy. This transaction allows me to post the invoice but when I run the tax report, it does not transfer the correct tax amount. It says the tax amount calculated is 0%.

What am I doing wrong here?

Answer:
Use the method i provided or keep trying SAP does not allow tax only posting means tax base is 0 and tax is $100

it is possible to have tax base $100 and tax $100

I am curious to see other solution

Regards

Answer:
I must be crazy. This transaction allows me to post the invoice but when I run the tax report, it does not transfer the correct tax amount. It says the tax amount calculated is 0%.

What am I doing wrong here?

=======================================

because you are not listening to me!

Answer:
Hey, let's "cooldown"! Remember that a solution that works in one system may not work in another and also that most of us don't have the same level of expertise.
_________________


Answer:
Dear TBajorek

Give FB01 a try using document type SA.

Post the amount GBP100 to the vendor without entering tax code or tax base.

Then post GBP100 to the tax account with tax code and tax base. It should then work.

Please note that the tax account should be without "Post Automatically" setting.

Good luck.

Anaid

Answer:
Thanks for you patience...

Although I am still getting the message "Posting is only possible with a zero balance".

Using FB01 I entered

PK 31 Vendor # 100 GBP
PK 40 Tax Acct 100 GBP Tax Key Tax Base Amt of 100

The tax key I am using is configured to post 100% to the tax account.

What am I doing wrong here?

depreciation in on the day of capitalisation of assets sap fico

Question: Hi sapfans,

My requirement is to configure for 100% depreciation on the day of capitalisation of assets. How to do that ? I have defined it in multilevel method, but it is prorating to an year instead of writing it off in a month.

Thanx in advance...

Answer:
There should be a standard SAP depn key for Low Value Assets that requires 100% depn.

Look at the settings for that and you can create your own calculation / depn keys.

Answer:
Hi,

The standard depreciation key for this is GWG.

Best regards, Mion

10 digit bank accounts for Citibank in Ireland in sap fico

10 digit bank accounts for Citibank in Ireland??

Question: Hi,

My client is trying to set up a vendor with a Citibank bank account. Apparently they have 10 digit account numbers, but the input mask for account numbers in Ireland is only 8 digits. Has anyone come across this problem before?

Thanks,

Russ

Answer:
Hi,

Check the transaction "Set country specific checks" from the customisation, under "General Settings". There select the country Ireland and then check the field "Bank account number - length". Probably there is a restriction regarding the length of bank acc. no. Change to 10, it should work then.

credit corresponds to multiple debit in sap fico

credit corresponds to multiple debit

Question: Hi,

We have scenario where 1 credit corresponds to multiple debit line item in Invoice. There is need of the business where, if there is error while loading one of the multiple Debit lines, instead of error ing out whole transaction, the error line item should post to suspense GL account.

For eg. If in one of line item there is Wrong GL account, whole transaction should not error out and wrong line item should be posted to Suspense GL account so that debit credit should match. This would than be reversed by business.

Can you pls let me know how should we do this in SAP

Thanks
Regds
_________________
Harry

Answer:
It isn't clear whether this is an interface or a normal manual posting, but in either case, the last line of your document would always be to the suspense account with amount "*". The asterisk indicates "post the balance" to SAP, so the last line will either post any balance, or zero, to the suspense account.

This approach does not resolve how/why errors are occurring or how they are handled - but that depends on the details of what you are doing...

relationship with the cost centers in sap fico

Hi FICO gurus,

I have a requirement to make 1 active profit center, lets say s1 into 4 profit centers, lets say s1,s2,s3,s4. This would then give a 1:1 relationship with the cost centers.

My question, is understanding the issues relating to the data already assigned to s1 which would now be relevant to s2, s3, s4.

I would appreciate if someone could highlight those issues.

Many thanks

G

Answer:
Hi G!
I do not think it would be possible. Coz there would be one to one relation ship between Cost Centers and Profit Centers.

Answer:
I think it could be possible... Just add new master data for PCA and CCA in your system.

You only need these PC's and CC's in your CO reporting?

In that case you can try using transaction KB11n. (Make a CATT for automatic upload if there is many lines to be reposted.)

Mind you: reconciliation with FI will be incorrect if you post the corrections this way.

US company code with plants in several states

US company code with plants in several states??

Question: Hi,

The European company I’m working for bought 3 factories in the US a few years ago. All 3 sites still have their own sales and accounting office and are using their own ERP system. All 3 companies will be merged in SAP and we would like to create 1 company code with 5 plants. However the 5 plants are not situated in the same state. The states involved are Georgia, Florida and Wisconsin.

I’m wondering if, from a financial point of view, it’s legally possible to merge 3 company codes into one when the companies are not located in the same state. I assume it is. And if this is possible, are there any regulations with respect to legal US requirements (eg tax reporting) that we need to be aware of? Regulatory reporting?

Besides this, are there any advantages/disadvantages for creating only 1 company code and not 3?

I hope you can share your knowledge with me. Your help is appreciated!

Thanks

Answer:
Anyone

Answer:
Dear Burt,

I'm not a FI/CO even thought I've been working in these modules
for three years.

However, I can assure that from my experience one of the most
important thing is having one controlling area. (for many company
codes and many plants).

I would create a separate company code for each of the factory.

Best regards,
Mark

Answer:
Hello Mark,

Many thanks for your reply. However if there are no legal requirements that force me to create more than one company code, I'll just create one. I don't see the need to make a split on company code level, so we'll make a split on plant level.