Unified Operations & Dynamics AX Forum

Expand all | Collapse all

AR Payment Journal not showing settlement lines

  • 1.  AR Payment Journal not showing settlement lines

    SILVER CONTRIBUTOR
    Posted 06-13-2018 10:14 AM
    We just setup a new Accounts receivable customer payment journal.  So we now have 3 different ones depending on what type of payments are being processed with specific financial dimensions defaulted.
    However with our new payment journal it no longer shows settlement lines on the customer like our other journals do.  Has something been setup wrong or is there something else I don't understand and it is actually ok?
    Normally for every invoice there would be an invoice, a payment and two settlement lines as follows:
    Settlement lines showing
    The new journal now just shows as follows:
    no settlement lines
    One thing that is different is that our new journal has the default going to ledger instead of bank.  But we had some others like this that we believe still showed settlement lines.  We did also make sure that they settled the lines on the payment journal when it was entered and I can see that the payment was applied against the specific invoice instead of "on account"

    Any help is appreciated

    ------------------------------
    Angela Brown
    Manager of Accounting
    City of Kingston
    Kingston ON
    ------------------------------


  • 2.  RE: AR Payment Journal not showing settlement lines

    TOP CONTRIBUTOR
    Posted 06-13-2018 10:32 AM
    Hi,
    Does the bank account that you used in the other journals before have a different and possibly a fixed financial dimension setup? If you change the offset account in your new journal to the same bank - just for testing purposes - do you ge the same settlement lines posted? Is there any other difference that you can identify in the setup of your journals e.g. posting at the summary or detail level, etc.?
    Best regards,
    Ludwig

    ------------------------------
    Ludwig Reinhard
    Sycor
    Goettingen
    ------------------------------



  • 3.  RE: AR Payment Journal not showing settlement lines

    SILVER CONTRIBUTOR
    Posted 06-14-2018 10:49 AM

    ​Hi Ludwig,

    I feel as though it has to be something setup on the new journal type because if I use the same method of payments with the new and old journal I get different results.

    Maybe there is somewhere I haven't told the new journal to follow the proper posting definition?
    although I can see that for all method of payments to use AR Pay so it shouldn't make a difference that I have added a new journal?

    posting definition



    ------------------------------
    Angela Brown
    Manager of Accounting
    City of Kingston
    Kingston ON
    ------------------------------



  • 4.  RE: AR Payment Journal not showing settlement lines

    TOP CONTRIBUTOR
    Posted 06-13-2018 09:50 PM
    Where are you seeing these additional transactions?
    On the customer transactions form?
    (these are not transactions normally showing up when recording a customer payment)

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------



  • 5.  RE: AR Payment Journal not showing settlement lines

    SILVER CONTRIBUTOR
    Posted 06-14-2018 10:51 AM
    ​Yes in the customer transactions listing it shows the settlement lines

    transactions

    ------------------------------
    Angela Brown
    Manager of Accounting
    City of Kingston
    Kingston ON
    ------------------------------



  • 6.  RE: AR Payment Journal not showing settlement lines

    Posted 06-14-2018 10:01 AM
    ​Hi Angela -

    We have found that we see settlement lines only if the financial dimensions for the transaction lines have a different number of dimensions or sections behind it.  If they have the same number and type of dimensions, we see no settlement lines.  For example, if the payment is going to a customer invoice, the invoice line may have a customer number, project number, and division behind it.  The payment line may just have a customer number and division behind it.  If this is the case, we would see settlement lines.  If they contained the same exact financial dimensions, we would not.  I hope this helps!

    ------------------------------
    Christi Weber
    Accountant II
    ICM Inc
    ------------------------------



  • 7.  RE: AR Payment Journal not showing settlement lines

    SILVER CONTRIBUTOR
    Posted 06-14-2018 11:54 AM
    ​Thank you Christi for the idea!

    So what I did when you suggested to look at the default financial dimensions I tested changing the default to what the other journal was and that did change the way it populates.  So I think you are right that it relates to the dimensions.  In our case we have a fund 990 which is where all of our banks sit and that is what our previous journal was defaulted to.  The new journal is defaulted to fund 100 which is not where the banks sit.

    When I changed the new journal to fund 990 (for testing purposes) it shows the settlement lines so it must be something related to that fund.

    I think this means I am ok with our setup.  I just wanted to make sure down the line that we didn't have bigger issues that we may not be aware of.

    Thanks
    Angela

    ------------------------------
    Angela Brown
    Manager of Accounting
    City of Kingston
    Kingston ON
    ------------------------------



  • 8.  RE: AR Payment Journal not showing settlement lines

    Posted 06-15-2018 04:17 AM
    Hi Angela,

    Settlement posting are generated when the system needs to post adjusting entries.

    The most common one is where you have a bank payment paying multiple invoices all with different dimensions, the settlement postings will strip the dimensions from the invoice postings and replace them with the dimension of the bank payment (if any).

    In the below example the settlement postings have been invoked to strip out the invoice dimensions and post with the bank payment dimensions, this is to keep the dimensions in balance within the system.

    The other instance where you will see these postings are on FX revaluations at the point of invoice payment.


    Hope that helps to clarify

    Mark

    ------------------------------
    Mark Bailey
    Annata
    Portsmouth
    ------------------------------