Re: [sap-acct] Error msg F5A047 while trying to Calculate Tax in vendor invoice
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Roy B (SAP Financials Expert) on Apr 11 at 9:28 AM |  Mark as helpful |
SAP has always had the problem that tax lines do not
automatically pick up Profit Centres or Cost Centres or
Business Areas. On previous projects I have had an ABAPer
program a user exit that calls a validation that takes the
customer or vendor line item and copies the PC, CC or BA
into the tax line. This will get rid of the error message.
The system has not been "meddled with" and it is nothing to
do with the GL accounts. SAP takes the view that the BA
balancing program or equivalent in PCA / CCA will deal with
the tax line items at month-end, but that did not suit my
Italian clients since it would add many lines to their
fiscal journal, which would have to be explained to the tax
inspectors, hence my user exit as above.
Rgds, Roy
Vidhyadhar via sap-acct wrote:
>
>
> Hi Maxarora
>
> In SAP, if at any time you get an error message which is displayed at the
> bottom left of your screen, I would suggest you double click on the error
> messge and see what it states . Please always make a note of the message
> number and the description you see on screen. This could provide a clue as
> to where things are going wrong.
>
> Regards
>
> VidhyaDhar
>
> On Sun, Apr 11, 2010 at 7:55 AM, Vidhyadhar via sap-acct <
> sap-acct@groups.ittoolbox.com> wrote:
>
>>
>> Posted by Vidhyadhar (User-friendly Consultant)
>> on Apr 10 at 10:36 PM
>> Hi Maxarora
>>
>> Let me suggest you a test.
>>
>> Try to post a transaction with some taxcode in company code 1000.
>>
>> If you are interested in posting a vendor invoice:
>>
>> a. You could use 1000 for as your vendor and 400020 as the G L account
>> If the system prompts for a cost center , enter 1000 as your cost center.
>>
>> Simulate and look at the result ( see if tax line item is created) and
>> post.
>>
>>
>> If you are interested in posting a customer invoice:
>>
>> b. You could use 1000 for as your customer and 800200 as the G L account
>>
>> Simulate and look at the result ( see if tax line item is created) and
>> post.
>>
>> If this works Okay, then there is no problem with the basic SAP system on
>> your machine. If it does not work , I am afraid you are working on an SAP
>> system which has been meddled with.
>>
>> Please check it out and let me know the result.
>>
>> We can proceed thereafter.
>>
>> Regards
>>
>> VidhyaDhar
>>
>> By the way, you can change the language setting alone in your company code
>> as EN ( unless you understand German).
>>
>>
>> On Sat, Apr 10, 2010 at 11:19 PM, maxarora via sap-acct <
>> sap-acct@groups.ittoolbox.com> wrote:
>>
>>> Posted by maxarora
>>> on Apr 10 at 1:50 PM
>> > Hi savior VidhyaDhar, thanks again! Since I'm recreating my CC, this
>> time I
>>> didn't touch any other settings as you advised in the previous posts.
>>> Germany is the country assigned to my CC. This CC was copied from cc1000.
>>> Language: DE and Chart of Accounts: INT. I'm using predefined Tax codes.
>> I
>>> was following the exercise at pp173-147 (task 2).
>>>
>>> Here are the settings for the GL a/c AE0293 (for authorized expenses)
>> that
>>> I'm dealing with. (created as per instructions)
>>>
>>> TAB: TYPE/Description
>>>
>>> Account Group: Authorized Expense 93
>>> P&L A/C: Yes
>>> PL Statement Type: X
>>> Group Control Number: 312600
>>>
>>> TAB: Control Data
>>>
>>> A/C Currency: EUR
>>> Tax Category: "-" (even I tried to change to *, nothing worked)
>>> Line Display: Yes
>>> Sort Key: 008
>>>
>>> TAB: Create/bank/Interest
>>> Field Status Group: FS93 (created as per instructions)
>>>
>>> TAX Account Settings: GL Account: 154000
>>>
>>> All setting untouched.
>>>
>>> The difference I thought would have been in Tax Category under Control
>> Data
>>> tab of these both accounts. AE0293 has -, and 154000 has <. So I changed
>> the
>>> tax category of AE0293 to * but it still didn't work. I think last time
>> when
>>> we were dealing with cross cc transactions, same problems must be
>> arising.
>>>
>>>
>>> ---------------Original Message---------------
>>> From: Vidhyadhar
>>> Sent: Saturday, April 10, 2010 12:48 PM
>>> Subject: Error msg F5A047 while trying to Calculate Tax in vendor invoice
>>>> Hi Maxarora
>>>>
>>>> 1) To which country does your company code belong to ? Is it Germany or
>>> US?
>>>>
>>>> This is important because your company code should be assigned to the
>>>> appropriate tax procedure.
>>>>
>>>> It is most likely that you would be using a German company code since
>>> might
>>>> have copied and created your company code from Company Code 1000. Am I
>>>> correct?
>>>>
>>>> 2) Did you create a Tax code or are you using a pre-defined tax code?
>>>>
>>>> If you are using a tax code created by you,then the related
>> configuration
>>>> such as condition type, account key, account determination etc. needs
>> to
>>> be
>>>> checked.
>>>>
>>>>
>>>>
>>>> Please do not use the supplement auto posting.
>>>>
>>>> 3. Are you using INT Chart of Accounts? If so, I would suggest that you
>>> do
>>>> not tweak the settings of General Leger Accounts and leave them at that
>> (
>>> It
>>>> would be a wise idea to document your tweaked settings and they may
>> have
>>> to
>>>> be reset to the default setting in case of a problem)
>>>>
>>>> There are three kinds of General Ledger Accounts
>>>>
>>>> a. General Ledger Accounts necessarily attracting Tax ( accounts such
>> as
>>>> Purchases , Sales etc.)
>>>>
>>>> b. General Ledger Accounts which may or may not be attracting Tax. (
>> Zero
>>>> Tax percent Purchase, Sales etc)
>>>>
>>>> c. Tax Accounts themselves ( such as Input tax and Output tax )
>>>>
>>>> Some of the accounts mentioned in A may attract input tax only / output
>>> tax
>>>> only / both / none / a pre-defined input tax only / a pre-defined
>> output
>>> tax
>>>> only.
>>>>
>>>> Some of the Tax accounts mentioned in C may be input tax / output tax
>>> etc.
>>>> All these settings have to be made in all the related accounts.
>>>>
>>>> In the absence of what settings you have done, I am unable to fathom
>> the
>>>> problem faced by you. Could you please be more specific as to what you
>>> did
>>>> in this regard?
>>>>
>>>> Regards
>>>>
>>>> VidhyaDhar
>
>
>
>
--
Roy Brookes AFA, FInstBA,
Senior SAP??? Financials Consultant
Tel: +49 171 268 9635 (mobile)
Tel: +49 40 793 19642 (landline)
Roy.Brookes@Hamburg.de
Roy.Brookes@RoyBrookes.com
RB@Software-Partner-Solutions.com
www.RoyBrookes.com
www.Software-Partner-Solutions.com
www.linkedin.com/in/roybrookes
SAP Expert Index Registration: CRF **42819*
__.____._ automatically pick up Profit Centres or Cost Centres or
Business Areas. On previous projects I have had an ABAPer
program a user exit that calls a validation that takes the
customer or vendor line item and copies the PC, CC or BA
into the tax line. This will get rid of the error message.
The system has not been "meddled with" and it is nothing to
do with the GL accounts. SAP takes the view that the BA
balancing program or equivalent in PCA / CCA will deal with
the tax line items at month-end, but that did not suit my
Italian clients since it would add many lines to their
fiscal journal, which would have to be explained to the tax
inspectors, hence my user exit as above.
Rgds, Roy
Vidhyadhar via sap-acct wrote:
>
>
> Hi Maxarora
>
> In SAP, if at any time you get an error message which is displayed at the
> bottom left of your screen, I would suggest you double click on the error
> messge and see what it states . Please always make a note of the message
> number and the description you see on screen. This could provide a clue as
> to where things are going wrong.
>
> Regards
>
> VidhyaDhar
>
> On Sun, Apr 11, 2010 at 7:55 AM, Vidhyadhar via sap-acct <
> sap-acct@groups.ittoolbox.com> wrote:
>
>>
>> Posted by Vidhyadhar (User-friendly Consultant)
>> on Apr 10 at 10:36 PM
>> Hi Maxarora
>>
>> Let me suggest you a test.
>>
>> Try to post a transaction with some taxcode in company code 1000.
>>
>> If you are interested in posting a vendor invoice:
>>
>> a. You could use 1000 for as your vendor and 400020 as the G L account
>> If the system prompts for a cost center , enter 1000 as your cost center.
>>
>> Simulate and look at the result ( see if tax line item is created) and
>> post.
>>
>>
>> If you are interested in posting a customer invoice:
>>
>> b. You could use 1000 for as your customer and 800200 as the G L account
>>
>> Simulate and look at the result ( see if tax line item is created) and
>> post.
>>
>> If this works Okay, then there is no problem with the basic SAP system on
>> your machine. If it does not work , I am afraid you are working on an SAP
>> system which has been meddled with.
>>
>> Please check it out and let me know the result.
>>
>> We can proceed thereafter.
>>
>> Regards
>>
>> VidhyaDhar
>>
>> By the way, you can change the language setting alone in your company code
>> as EN ( unless you understand German).
>>
>>
>> On Sat, Apr 10, 2010 at 11:19 PM, maxarora via sap-acct <
>> sap-acct@groups.ittoolbox.com> wrote:
>>
>>> Posted by maxarora
>>> on Apr 10 at 1:50 PM
>> > Hi savior VidhyaDhar, thanks again! Since I'm recreating my CC, this
>> time I
>>> didn't touch any other settings as you advised in the previous posts.
>>> Germany is the country assigned to my CC. This CC was copied from cc1000.
>>> Language: DE and Chart of Accounts: INT. I'm using predefined Tax codes.
>> I
>>> was following the exercise at pp173-147 (task 2).
>>>
>>> Here are the settings for the GL a/c AE0293 (for authorized expenses)
>> that
>>> I'm dealing with. (created as per instructions)
>>>
>>> TAB: TYPE/Description
>>>
>>> Account Group: Authorized Expense 93
>>> P&L A/C: Yes
>>> PL Statement Type: X
>>> Group Control Number: 312600
>>>
>>> TAB: Control Data
>>>
>>> A/C Currency: EUR
>>> Tax Category: "-" (even I tried to change to *, nothing worked)
>>> Line Display: Yes
>>> Sort Key: 008
>>>
>>> TAB: Create/bank/Interest
>>> Field Status Group: FS93 (created as per instructions)
>>>
>>> TAX Account Settings: GL Account: 154000
>>>
>>> All setting untouched.
>>>
>>> The difference I thought would have been in Tax Category under Control
>> Data
>>> tab of these both accounts. AE0293 has -, and 154000 has <. So I changed
>> the
>>> tax category of AE0293 to * but it still didn't work. I think last time
>> when
>>> we were dealing with cross cc transactions, same problems must be
>> arising.
>>>
>>>
>>> ---------------Original Message---------------
>>> From: Vidhyadhar
>>> Sent: Saturday, April 10, 2010 12:48 PM
>>> Subject: Error msg F5A047 while trying to Calculate Tax in vendor invoice
>>>> Hi Maxarora
>>>>
>>>> 1) To which country does your company code belong to ? Is it Germany or
>>> US?
>>>>
>>>> This is important because your company code should be assigned to the
>>>> appropriate tax procedure.
>>>>
>>>> It is most likely that you would be using a German company code since
>>> might
>>>> have copied and created your company code from Company Code 1000. Am I
>>>> correct?
>>>>
>>>> 2) Did you create a Tax code or are you using a pre-defined tax code?
>>>>
>>>> If you are using a tax code created by you,then the related
>> configuration
>>>> such as condition type, account key, account determination etc. needs
>> to
>>> be
>>>> checked.
>>>>
>>>>
>>>>
>>>> Please do not use the supplement auto posting.
>>>>
>>>> 3. Are you using INT Chart of Accounts? If so, I would suggest that you
>>> do
>>>> not tweak the settings of General Leger Accounts and leave them at that
>> (
>>> It
>>>> would be a wise idea to document your tweaked settings and they may
>> have
>>> to
>>>> be reset to the default setting in case of a problem)
>>>>
>>>> There are three kinds of General Ledger Accounts
>>>>
>>>> a. General Ledger Accounts necessarily attracting Tax ( accounts such
>> as
>>>> Purchases , Sales etc.)
>>>>
>>>> b. General Ledger Accounts which may or may not be attracting Tax. (
>> Zero
>>>> Tax percent Purchase, Sales etc)
>>>>
>>>> c. Tax Accounts themselves ( such as Input tax and Output tax )
>>>>
>>>> Some of the accounts mentioned in A may attract input tax only / output
>>> tax
>>>> only / both / none / a pre-defined input tax only / a pre-defined
>> output
>>> tax
>>>> only.
>>>>
>>>> Some of the Tax accounts mentioned in C may be input tax / output tax
>>> etc.
>>>> All these settings have to be made in all the related accounts.
>>>>
>>>> In the absence of what settings you have done, I am unable to fathom
>> the
>>>> problem faced by you. Could you please be more specific as to what you
>>> did
>>>> in this regard?
>>>>
>>>> Regards
>>>>
>>>> VidhyaDhar
>
>
>
>
--
Roy Brookes AFA, FInstBA,
Senior SAP??? Financials Consultant
Tel: +49 171 268 9635 (mobile)
Tel: +49 40 793 19642 (landline)
Roy.Brookes@Hamburg.de
Roy.Brookes@RoyBrookes.com
RB@Software-Partner-Solutions.com
www.RoyBrookes.com
www.Software-Partner-Solutions.com
www.linkedin.com/in/roybrookes
SAP Expert Index Registration: CRF **42819*
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Roy BSAP Accounting Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement
In the Spotlight
Did this response help you resolve your issue? Click the green 'Mark as helpful' arrow to vote on the entry.
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
