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

(0) Share

Report

Posted on by Rochelle Mausteller

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

All responses (7)

Answers (0)

Sheila Ochoa 855 on at

Like (0)

Report

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

Rochelle Mausteller 769 on at

Like (0)

Report

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
Rochelle Mausteller 769 on at

Like (0)

Report

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 65 on at

Like (0)

Report

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 25 on at

Like (0)

Report

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.
Rochelle Mausteller 769 on at

Like (0)

Report

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 25,195 on at

Like (0)

Report

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?