Microsoft Dynamics GP (Archived)

find Invoice linked to Voided check

(0) Share

Report

Posted on by Babin

2,961

I issued and posted two checks for an invoice - ChK-A and ChK-B. I voided one of them ChK-A.

Now i am trying to find original Invoice/Voucher linked to for voided check Chk-A.

Is this possible to see in GP or query in SQL?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Bill Campbell 12 on at

Like (0)

Report

When you voided ChK-A did you get a posting / voided transaction journal from the Purchase module?

If you did not, then you might first consider a quick reprint of that document. It should tell you what you need to know.

Was this reply helpful? Yes No
Babin 2,961 on at

Like (0)

Report

Bill, It only tells the Payment Number linked with the voided check # but not the voucher number. I am trying to find the voucher number here for which the voided check # was issued.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Hi,

If the check was applied in the same transaction that created the check, you might find the information by reprinting the posting journal from the original transaction.

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

Thanks for that Leslie.

Bab, I believe that Leslie is correct, that is going to be your best best for finding the Voucher number.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

I think, if you created a payment & invoice separately and applied to each other then voided the check, you can not find out the applied invoice/voucher number.

Hope this helps!!!

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

Best practice is, before voiding get the applied details then void the check if you need the applied information.

Hope this helps!!!

Was this reply helpful? Yes No
Babin 2,961 on at

Like (0)

Report

Soma,

Yes I created the payment and invoice separately and applied to each other.

So is that mean the applied details get deleted instead of moving to some tables in GP when voiding the payment/check?

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Hi Bab,

When you applied the check to the invoice(s) a record or records was written to the PM30300 table. That table holds all of the apply information. When you voided the check, those records were deleted because an apply no longer exists.

Kind regards,

Leslie

Was this reply helpful? Yes No