Open Forum

Expand all | Collapse all

Unposted APAY General Ledger Batches due to Currency Issues

  • 1.  Unposted APAY General Ledger Batches due to Currency Issues

    Posted 13 days ago
    Problem: APAY Sub-Ledger batches that will not post to the GP General ledger

    Cause: The Transaction Currency on the individual Payables transactions = CND (Canadian Dollars) and the GL Distribution Accounts on the transactions only allow US dollar transactions.  Note:  These transactions were integrated into GP via a PO Receipt SmartConnect integration with the wrong CurrencyID's.

    What would be the best way to correct this? Is there a table that I can simply update/change the currency ID?

    Thank you

    ------------------------------
    Renee Boucher
    Data System Services
    Sterling Heights MI
    ------------------------------


  • 2.  RE: Unposted APAY General Ledger Batches due to Currency Issues

    Posted 12 days ago
    So the batches are in the GL already?
    Or are you still posting on the AP module?

    If already in the GL side, you can check the GL10001 table.. the currency info should be in there.
    I would recommend backing up the table before doing the update.. you will want to check also the exchange rate info as it will be stored in there.

    If in the AP module, it will be in the PM10000 table, but you will need to check the distribution table as well: PM10100..
    *based on the voucher number.

    ***but if you can re-do the upload, it may be easier to just delete the batch in the GP, modify the currency on the upload file, and re-upload.. that will be safer.


    ------------------------------
    Elena Papio
    Glidewell Laboratories
    Irvine CA
    ------------------------------



  • 3.  RE: Unposted APAY General Ledger Batches due to Currency Issues

    Posted 12 days ago
      |   view attached
    I am able to locate the batches in the GL10001 table however I'm not seeing where the Currency can be altered. I've attached an example.

    Thank you


    ------------------------------
    Renee Boucher
    Data System Services
    Sterling Heights MI
    ------------------------------

    Attachment(s)

    txt
    GL10001.txt   4K 1 version


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