Unified Operations & Dynamics AX Forum

Back to discussions
Expand all | Collapse all

Unique voucher number in AP payment journal

  • 1.  Unique voucher number in AP payment journal

    Posted Dec 05, 2018 12:31 PM
    Hello,

    Does anyone know of a way to enforce unique voucher numbers by payment in a vendor payment journal?

    We have a scenario where users are entering additional vendor payment lines with no offset account.  These lines all inherit the same voucher number.  As a last step, the user then enters the offsetting bank account.  The journal posts with multiple vendor payments using the same voucher number.  We would like each vendor payment to use a unique voucher number.  Is it possible to systematically enforce this?

    We are running AX 2012 R3.

    Thanks for any assistance!

    -Andy

    #AX2012
    #UnifiedOperations​​
    #Admin​

    ------------------------------
    Andy Walton
    Systems Analyst
    The Pokémon Company International
    Bellevue WA
    ------------------------------


  • 2.  RE: Unique voucher number in AP payment journal

    TOP CONTRIBUTOR
    Posted Dec 05, 2018 02:40 PM
    Hi,
    If you specify a default offset account that would be inherited in each journal line then a new voucher number should be created for each line included in your journal. Would be great if you could test this and let us know if this resolves the issue.
    Best regards,
    Ludwig

    ------------------------------
    Ludwig Reinhard
    Sycor
    Veitshoechheim
    ------------------------------

    Original Message


  • 3.  RE: Unique voucher number in AP payment journal

    Posted Dec 05, 2018 04:25 PM
    Thank you Ludwig,

    I've tested this solution and adding the default offset account will prevent duplicate voucher numbers from being created.

    Much appreciated!

    -Andy

    ------------------------------
    Andy Walton
    Systems Analyst
    The Pokémon Company International
    Bellevue WA
    ------------------------------

    Original Message


  • 4.  RE: Unique voucher number in AP payment journal

    TOP CONTRIBUTOR
    Posted Dec 06, 2018 08:31 AM
    Andy,

    We had a similar issue going on, where somehow we were ending up with payments to multiple vendors on a single voucher, which in turn caused the Payment Summary By Date report to show extra lines with the other payee amounts for every vendor on the voucher. In addition to the fix that Ludwig mentioned, which we have deployed, we also checked the box "Number allocation on posting" in the journal names setup for our payment journals. This helps us ensure that we don't accidently end up putting multiple vendors on a single voucher. As long as the default is set for each line, the voucher numbers get assigned per vendor upon posting the journal.

    ------------------------------
    Steve Latta
    Accountant
    Ortec, Inc.
    Easley SC
    ------------------------------

    Original Message


  • 5.  RE: Unique voucher number in AP payment journal

    SILVER CONTRIBUTOR
    Posted Dec 07, 2018 08:51 AM
    When setting up the journal for payments in the voucher number set up there is a selection you can choose for the Voucher number and series, New Voucher in connection with balance, this assures the voucher number will change when the payment is balanced for each vendor.  Setting the default offset account to bank and the correct bank account will auto fill these settings.  I have a different payment journal for each bank account, I have a CD, ACH, Wire and VendorACH payment journals that the voucher series corresponds, this makes it much easier to distinguish what you are seeing when looking in the GL accounts.

    ------------------------------
    MARY LYNN KINCHEN
    Sr Systems Analyst
    SNF HOLDING COMPANY
    ------------------------------

    Original Message


If you've found this thread useful, dive deeper into User Group community content by role