Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

What is the fix for this A/P apply to error message?

(0) ShareShare
ReportReport
Posted on by 769

[View:https://community.dynamics.com/cfs-file.ashx/__key/CommunityServer-Components-UserFiles/00-00-05-12-93-Attached+Files/2210.Doc1.docx]Hi,

I have an old credit document, that has two invoices applied to it, but there is still an open credit amount.  I was trying to remove the credit.  I created a dummy invoice, but recieve the following error when I try to apply the document:: 

This invoice is already partially applied to this credit document.  You cannot apply to this document until the other apply amount is posted. 

Does anyone have any ideas how to resolve this? 

Thank you.

Rochelle

 

 

*This post is locked for comments

  • Sheila Ochoa Profile Picture
    Sheila Ochoa 855 on at
    RE: What is the fix for this A/P apply to error message?

    This worked for me as well.  Thanks for the information on these two tables PM20100 and PM10201.  They both had records in them and when these records were removed and checklinks was run, the records moved to history.  Thanks so much!

  • Suggested answer
    Re: What is the fix for this A/P apply to error message?

    I found the following SQL script and it moved the items from open to history.

    begin

    insert into PM30200 (VCHRNMBR,VENDORID,DOCTYPE,DOCDATE,DOCNUMBR,DOCAMNT,

    CURTRXAM,DISTKNAM,DISCAMNT,DSCDLRAM,BACHNUMB,TRXSORCE,

    BCHSOURC,DISCDATE,DUEDATE,PORDNMBR,TEN99AMNT,WROFAMNT,

    DISAMTAV,TRXDSCRN,UN1099AM,BKTPURAM,BKTFRTAM,BKTMSCAM,

    VOIDED,HOLD,CHEKBKID,DINVPDOF,PPSAMDED,PPSTAXRT,

    PGRAMSBJ,GSTDSAMT,POSTEDDT,PTDUSRID,MODIFDT,MDFUSRID,

    PYENTTYP,CARDNAME,PRCHAMNT,TRDISAMT,MSCCHAMT,FRTAMNT,

    TAXAMNT,TTLPYMTS,CURNCYID,PYMTRMID,SHIPMTHD,TAXSCHID,

    PCHSCHID,FRTSCHID,MSCSCHID,PSTGDATE,DISAVTKN,CNTRLTYP,

    NOTEINDX,PRCTDISC,RETNAGAM,ICTRX,Tax_Date,PRCHDATE,

    CORRCTN,SIMPLIFD,APLYWITH,Electronic,ECTRX,

    DocPrinted,TaxInvReqd,VNDCHKNM)

    select

    VCHRNMBR,VENDORID,DOCTYPE,DOCDATE,DOCNUMBR,DOCAMNT,

    CURTRXAM,DISTKNAM,DISCAMNT,DSCDLRAM,BACHNUMB,TRXSORCE,

    BCHSOURC,DISCDATE,DUEDATE,PORDNMBR,TEN99AMNT,WROFAMNT,

    DISAMTAV,TRXDSCRN,UN1099AM,BKTPURAM,BKTFRTAM,BKTMSCAM,

    VOIDED,HOLD,CHEKBKID,DINVPDOF,PPSAMDED,PPSTAXRT,

    PGRAMSBJ,GSTDSAMT,POSTEDDT,PTDUSRID,MODIFDT,MDFUSRID,

    PYENTTYP,CARDNAME,PRCHAMNT,TRDISAMT,MSCCHAMT,FRTAMNT,

    TAXAMNT,TTLPYMTS,CURNCYID,PYMTRMID,SHIPMTHD,TAXSCHID,

    PCHSCHID,FRTSCHID,MSCSCHID,PSTGDATE,DISAVTKN,CNTRLTYP,

    NOTEINDX,PRCTDISC,RETNAGAM,ICTRX,Tax_Date,PRCHDATE,

    CORRCTN,SIMPLIFD,APLYWITH,Electronic,ECTRX,

    DocPrinted,TaxInvReqd,VNDCHKNM

    from PM20000

    where DOCTYPE = 1

    and VCHRNMBR = '00000000000000001'

    and VENDORID = '??????????'

    delete PM20000

    where VCHRNMBR = '00000000000000001'

    and DOCTYPE = 1

    and VENDORID = '??????????'

    print 'Your insert into PM30200 is complete. Now continue with update of the PM00400 table.'

    /*This script will update the PM00400 table and flag the document from Open to History */

    /*The CTRLNUM is the voucher number. The CNTRLTYP is 0 for invoice and 1 for payment */

    update PM00400 set DCSTATUS = 3

    where CNTRLNUM = '00000000000000001' and VENDORID= '??????????' and DCSTATUS = 2 and CNTRLTYP = 0

    print 'Your update on PM00400 is complete. Now continue with insert on the PM30300 table'

    end

  • Re: What is the fix for this A/P apply to error message?

    Tee,

    I deleted records from PM20100, PM10200 and PM10201.  After I deleted the records, I was able to apply the remaining credit balance to the dummy invoice and the account balance is now at zero.

    When I do a transaction inquiry on the account, the two fully applied invoices still appear and when I drill back there is no apply to information.  There is also now  a remit line in a work file.  

    In the tables:

    PM20000 - Has the two fully applied invoices

    PM20100 - Has the credit document in it

    PM10200 - no documents related to this

    PM10201 - Has the credit doc and the fake invoice

    I believe the next step I want to take is to write a fake check to remove the remit-to information.  What I'm not sure of is if this will also move the two open fully applied invoices to history.  I don't think it will.  Any suggestions?

  • Mohamed Kamel Profile Picture
    Mohamed Kamel 65 on at
    Re: What is the fix for this A/P apply to error message?

    First, you need to open the checks documents from receivables transaction inquiry window and verify the unapplied amount/amount remaining.

    Second, remove the checks apply details from apply sales document window and verify the unapplied amount.

    Third, in case you find amount in the unapplied amount, you need to remove the wrong apply details from your company database by removing the apply lines in table [RM20201]

  • Suggested answer
    Tee Lopez Profile Picture
    Tee Lopez 25 on at
    Re: What is the fix for this A/P apply to error message?

    I've been fixing corrupted GP data for 10 years now, but I had never gotten this error msg until last week.  My client had applied a posted check to 2 invoices, but was unable to apply the remaining amount to a 3rd invoice.  I got "This invoice is partially applied...etc..." error when I tried applying it to any other invoice or even unapplying to the 2 previously applied invoices.

    I basically ran a sql trace when generating the error so I could view the sql tables involved in the process and the PM20100 table was the only one involved.  

    I also ran some additional sql scripts to find the check  and invoices involved in various AP tables I determined that I needed to run deletion scripts in two GP tables.  

    1) Delete 1 record from the PM10201 which had my check.  It shouldn't be here since my check was posted and this is a PM work (unposted transactions) table.  

    ****Delete from PM10201 where docnumber = 'XXXX'

    2) Delete the 2 records appying the check to the 2 invoices from the PM20100 table.  This is a temp table and thus should NOT retain data permanently.  

    ****Delete from PM20100 where vendorid = 'XXXX' and APFRDCNM = 'XXXX'.

    I searched GP Knowledgebase, but they had no information on the error.  I believe that because the fix requires deleting data directly in the db MS is not going to provide such a solution on its site for fear that it will be improperly executed and create an even bigger data problem.  

  • Re: What is the fix for this A/P apply to error message?

    Richard,

    All of the batches are posted.  The transactions are dated 1999 and 2000 so I don't know if there was a batch recovery issue at the time of posting.

    What doesn't seem normal about this is that even though the two invoices are fully applied by the credit document, they still appear in open status.  The credit I would expect to still remain open because it has a balance.

    Even though the invoices are in open status, I can not unapply them from the credit.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: What is the fix for this A/P apply to error message?

    Are all batches posted already?  Did any have errors that put them in Batch Recovery?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans