Somehow A/P credit vouchers were entered with no "apply to" reference. Now when we try to use the credit when we enter a check, the credit memo stays in the open A/P file and a new entry, a debit in the amount of the credit with the reference "check" show up in the open A/P. How do I get rid of these items? I tried to delete through "open load" but the system won't let me delete them? Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
A/P Credit Voucher problem
- Thread starter jmanton
- Start date
Very strange.
When you say that the system won't let you delete these through open item load, what do you mean? Are you getting a particular error message? If so what is the message?
You could also try to do a zero dollar check, and print it on white papaer so you don't have to waste a check form.
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
When you say that the system won't let you delete these through open item load, what do you mean? Are you getting a particular error message? If so what is the message?
You could also try to do a zero dollar check, and print it on white papaer so you don't have to waste a check form.
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
- Thread starter
- #3
We have tried to write a check and take the credit memo. When we do that, the credit memo stays in the open A/P file and the check writing process issues a new item; a debit in the amount of the credit memo under the type "Cchk".
When we tried to delete this item using the "Open Item Load" feature, it won't let use delete it, giving the message "There checks or credit memos applied to this record, delete not allowed". We voided the check issued (as mentioned in the paragraph above and we still get the same message using the Open Item Load).
When we tried to delete this item using the "Open Item Load" feature, it won't let use delete it, giving the message "There checks or credit memos applied to this record, delete not allowed". We voided the check issued (as mentioned in the paragraph above and we still get the same message using the Open Item Load).
- Thread starter
- #5
I tried to print a zero check, however the system dosen't allow me to choose the credit memo. When I enter in the invoice number, it tells me "Invoice not on file", if I scroll through the open items using "Next Unpaid Voucher" the credit memo still doesn't show up. The credit memo does however show up on the aging report.
- Thread starter
- #7
Macoladownunder
IS-IT--Management
This may be a little off beat...so test first if possible.
But using SQL Enterprise manager, give you cheques and credit memos a 'dummy' apply to number and then try to delete them.
But using SQL Enterprise manager, give you cheques and credit memos a 'dummy' apply to number and then try to delete them.
Macoladownunder
IS-IT--Management
If you are using SQL version, I had a similar problem with AR credit memos and not being able to apply receipts to them because they were missing apply to numbers. This was a result of some very sloppy modifications written by support here in Australia. But I ran a script in AROPNFIL and AROPNHST for apply to with 0 or NULL and gave them a number - then I could apply and purge.
Good luck.
Good luck.
- Thread starter
- #11
I am using Progression Version 7.6.
As to Macoladownunder's comments, is there a way to change the apply to number for these open A/P items? I know that you can change the apply to in A/R, but the system doesn't allow me to change them in A/P.
As to Macoladownunder's comments, is there a way to change the apply to number for these open A/P items? I know that you can change the apply to in A/R, but the system doesn't allow me to change them in A/P.
Jmanton-
The question was are you using Pervasive or MS SQL version of Progression? The solution proposed by Macoladownunder will only be available if you are using the MS SQL version. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
The question was are you using Pervasive or MS SQL version of Progression? The solution proposed by Macoladownunder will only be available if you are using the MS SQL version. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
- Thread starter
- #13
This is what I would do but as mentioned earlier this is not anything to do lightly.
Go to start, programs, Pervasive, Pervasie Control Center. Drill down in the folders to your Pervasive server, then to the database and then finally the table, APOPNFIL_SQL.
Open up the table and browse to the offending record(s) and try to do what Macoladownunder said to do -- change the apply to numbers. There are several fields for apply to numbers:
Apply_to_no
Alt1_apply_to_no
Alt5_apply_to_no
You need to change all three of these for the record(s) in question. Then try to do what Macoladownunder said.
Another alternative is to simply delete these records from the Pervasive Control Panel. If you do that, go into AP and run a reset fully paid status and a recalc vendors balances.
If you have any questions please let me know. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
Go to start, programs, Pervasive, Pervasie Control Center. Drill down in the folders to your Pervasive server, then to the database and then finally the table, APOPNFIL_SQL.
Open up the table and browse to the offending record(s) and try to do what Macoladownunder said to do -- change the apply to numbers. There are several fields for apply to numbers:
Apply_to_no
Alt1_apply_to_no
Alt5_apply_to_no
You need to change all three of these for the record(s) in question. Then try to do what Macoladownunder said.
Another alternative is to simply delete these records from the Pervasive Control Panel. If you do that, go into AP and run a reset fully paid status and a recalc vendors balances.
If you have any questions please let me know. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
- Status
Similar threads