Skip to Content

Aging AR / AP based on AR / AP account code

Dear All,

when running selection criteria either for customer receivable and vendor payable aging, is it possible to filter them based on their AP / AR G/L account code ? many of the customers have two AR G/L accounts code, e.g. in year 2006, the code is 12000-HQ. in year 2007, the code is 13000-HQ. meanwhile, there are still some unpaid invoices and any other transactions in the 12000-HQ G/L account code and need to be included in the customer receivable aging report. It is also needed to be reconcile. How to do that ? is it possible ? pls give advice. TIA

Rgd

Steve

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Dec 05, 2007 at 04:16 AM

    Hello,

    You could use SAP B1 2005A SP 01 PL 39. You must upgrade to the latest PL from current PL. SO, you could combine it into one aging report consists of transaction in the old AR account and new AR account, or you just use old AR account code although the AR account code is not used by the customer anymore (BP master data --> tab accounting --> account receivable field).

    The same things are also applicable to vendor aging.

    Rgds,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 04:26 PM

    Steve,

    I do not think it is going to be possible, as SAP's Aging Report is going to look at the current AR Receivable account and Pull the transaction from there.

    Unless, you choose to great a Custom Report.

    Thanks

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

    • Tks for your quick answer. Do not you think I can use query update ... set .... where ....= '..' and then using restore functionality in SAP B1 can move all transactions in old AR account no to the current new AR account no ? so that all unpaid invoices and other transactions can be displayed in the aging AR report ?

      Pls give advice. Tks.

      Rgd

      Steve

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 04:41 AM

    Steve,

    I did not understand what you meant by update ... set .... where ....= '..'

    But you can try using the import transactions functionality to transfer the balances to this AR account.

    Technically to be correct, you actually should Credit the Invoices from the Original AR Account and create new invoices from the New AR Account.

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 05, 2007 at 05:14 AM

    Hi All,

    Tks for the answers. I have checked the PL after upgrade and I could see there is a control account tick box that can cover the user request i.e. to generate aging report based on old AR account and new AR account..

    Rgd

    Steve

    Add a comment
    10|10000 characters needed characters exceeded

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.