You’re offline. This is a read only version of the page.
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
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!
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
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?
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]
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.
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.
Are all batches posted already? Did any have errors that put them in Batch Recovery?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (