Skip to Content

AR alternate reconciliation aaccount from customer master

Dear All,

1) We have number of customers who give us business in DOMESTIC & FOREIGN markets.

2) We want to create only ONE customer code for such customer.

3) But in Balance Sheet we want to see posting to two different Reconciliation Accounts -

a) Domestic Receivable Account

b) Foreign Receivable Account

4) I tried using Alternate Reconciliation Account from FI & SD - Account Assignment/Costing. But still the entry is getting posted to the reconciliation account which is maintained in the Customer master & not to the Alternate reconciliation account.

Pl guide,

Thanks & regards,

Gov

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2009 at 06:50 AM

    Hi gov,

    Had u added tick mark reconciliation account ready for input in FS00 for the main reconciliation account, if not do that, then it will allow u to post alternate reconciliation account

    regards

    srikanth

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2009 at 09:11 AM

    Dear Gov,

    Have you tried SPRO->FI->...-> AP/AR-> Business transactions-> Posting with alternative reconciliation account for the respective chart of accounts.

    And also you have to set your reconciliation account <ready for input> (t-code FS00- <Create/bank/interest> tab) as Srikanth suggested above.

    kind regrads,

    milen.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2009 at 06:37 AM

    Hi

    It is suggested to create separate customer masters and then link to respective reconciliation accounts. Alternate reconciliation accounts, are only for special gl transactions like advances etc. linking that with this requirement may not be helpful

    Thank you,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2009 at 08:54 AM

    Hi,

    Alternative reconciliation account does not help in this scenario, one option i can see here is, if you have copa and sd functionality in place , put this domestic/foreign sales in the sales order itself like sales order type/order reason etc and pull that information in copa report.

    Regards

    Suresh Addagiri

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Suresh Addagiri,

      We have SD but no COPA. So I am doubtful whether the option given by you will work.

      We carried out following activities -

      A) SPRO->FI->...-> AP/AR-> Business transactions-> Posting with alternative reconciliation account for the respective chart of accounts.

      G/L Acc Alt.G/L

      140000 150000

      B) SPRO -> Sales & Distribution -> Basic Functions -> Account Assignment/Costing -> Reconciliation Account Determination ->

      --> a) Maintain Condition Types

      Here created ZALT = ALTERNATE RECON ACC & assigned to Access Sequence KOAB (Rec. account determination)

      --> b) Maintain Account Determination Procedure

      Here for procedure KOFIAB - (Standard rec. account determ.) control data is maintained. i.e. Assigned condition type ZALT ( as defined above)

      --> c) Assign Account determination procedure

      Here assigned the procedure KOFIAB to required Billing type.

      --> d) Assign GL Accounts

      Here selected Table 8 (SlsOrg/Dist.chan.)

      Put in following datails as required

      App CndTy. ChAc SOrg. DChln GL Account Provisional Account

      VB ZALT INT 7777 78 140000 150000

      These much settings are made.

      Still while posting we am not able to post the alternate account. Pl advice whether whatever we have done is correct?

      Thanks & regards,

      Gov

      Edited by: Gov on Mar 20, 2009 4:00 PM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.