Is there a way to unmatch an AP invoice that has been posted and then voided?
our steps went like this:
- We entered the AP invoice, and matched it to the Landed Cost.
- We posted the Invoice, (with the batch).
- We voided the historical Invoice.
Now we would like to enter the updated invoice, and match that to the landed cost, however the landed cost is no longer available for matching. Neither does the Landed Cost show up on the POP10500 table anymore.
*This post is locked for comments
Correct, the landed cost is now posted. Unless you are highly familiar with T-SQL and document flow in Microsoft Dynamics GP, I do not recommend you go this route.
Hi Mariano,
Yes, I am referring to the invoice entered under "Enter/Match Invoices", and I was trying to stay away from entering under "Transaction Entry" since this is not going to link it to the original inventory receipt, it is not going to capture the value under the actual inventory GL account, and will not transfer it to COGS later when the item gets sold/adjusted.
The landed cost is still in GP, (in the historical tables). Do you know of any way to bring it back to the work tables, so that it can be matched again, this time to the right invoice?
I assume when you say "AP Invoice" you are referring to the invoice entered under Purchasing > Transactions > Enter/Match Invoices, correct? If so, you should have used a Return Transaction Entry to reverse the Landed Cost. Since the Landed Cost is no longer available, you will need to enter an AP voucher for the landed cost under Purchasing > Transactions > Transaction Entry.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (