Pages

Monday, November 19, 2018

Apply Payable Document Error


While applying a payment to a posted invoice in the payable module, an error pops up indicating that " You can't choose this document because it is part of a recovered batch or is still in the process of posting" as illustrated in the screen shot below.


Resolution:

Nothing exists in the batch recover, don't waste time looking for any corrupted records there 
This issue occurs due to having the same record ( mostly an invoice ) in both work and open tables (Unposted and Posted table) . As the apply function checks for any open transaction, duplicated records are found across PM10000 and PM20000, which results with this issue. 

In order to resolve the issue, you basically need to delete the record from the PM10000 which already exists in the PM20000. Then, try again and the apply payable document will work perfectly as designed. 

          DELETE FROM PM10000 WHERE VCHNUMWK = 'XXXXXXX'


Run the script as you replace the XXXXXXX with the specific voucher number which already exists in PM20000. 

Best Regards, 
Mahmoud M. AlSaadi

3 comments:

  1. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete
  2. Hello,
    We are a professional Cyber Tech credit team with a large ring around
    the globe infected with more than 3 million debit malware and
    skimmers, we get a blank ATM card and load them with a lot of money
    quickly and safely, with which one can withdraw Cash either in euros or
    Swiss franc from ATMs and can be used by any POS system
    Note: Our cards are Illegal but trust me its 100% safe
    Contact: Kelvin Ericksson
    Email: blankatmmaster5555@gmail.com
    WhatsApp +3197005033695
    web site: http: //blankatmmaster5555.wixsite.com/
    Harkers

    ReplyDelete