You’re offline. This is a read only version of the page.
Dear All,
When i post POP-Receiving transactions in foreign currency, the record is inserted in MC020103 table but, the fields RATETPID, EXGTBLID, XCHGRATE and EXCHDATE are not getting updated. When i pass payable transaction in foreign currency these fields are updated with correct values.
FYI : GP10-SP3
Thanks in Advance
Akbar Khan
*This post is locked for comments
This was a know issue and should have been repaired in a Service Pack.
Her was the response and solution obtained at the time.
We have documented this issue and reported it to our development team so that it may be addressed in a future product release (SP4, July time frame).
Although I don’t have a date as to when this issue will be resolved, I have added your company’s name and authorized phone number to the Bug.
The more Customers and Partners that we have assigned to a bug, the more likely it is to be moved up in priority as well.
We have come up with a trigger that should work to ensure that the MC020103 table gets updated for invoices from Purchase Order Processing.
Since the currency information does get populated correctly on the Purchase Order Processing side (POP30300 table), we have created a trigger on the POP30300 table that updates the MC020103 table.
Listed below are three scripts: the first script will show you the invoices that currently have incorrect exchange rate information; the second script will correct the missing exchange table ID and exchange rate information on the invoices so that you can pay these invoices off; and the third script is the trigger that gets put on the POP30300 table which should correct the issue going forward until a permanent fix is available.
--select
select a.RATETPID, a.EXGTBLID, a.XCHGRATE, b.VCHRNMBR, c.POPRCTNM, c.VNDDOCNM from MC020103 a join PM20000 b on a.VCHRNMBR = b.VCHRNMBR join POP30300 c on b.DOCNUMBR = c.VNDDOCNM
--update all records
update a
set a.RATETPID = c.RATETPID, a.EXGTBLID = c.EXGTBLID, a.XCHGRATE = c.XCHGRATE from MC020103 a join PM20000 b on a.VCHRNMBR = b.VCHRNMBR join POP30300 c on b.DOCNUMBR = c.VNDDOCNM Where a.RATETPID = '' and a.EXGTBLID = ''
--Create Trigger
Create Trigger PAPOUpdateMC on POP30300
AFTER INSERT
AS Update a
set a.RATETPID = c.RATETPID, a.EXGTBLID = c.EXGTBLID, a.XCHGRATE = c.XCHGRATE from MC020103 a join PM20000 b on
a.VCHRNMBR = b.VCHRNMBR
join POP30300 c on
b.DOCNUMBR = c.VNDDOCNM
Where a.RATETPID = '' and a.EXGTBLID = ''
Go
PO receiving without invoice matching does not updte AP, i havent check the table yet but I see no problem in enttering MCM transactions whether match or unmatch invoices. did you encounter errors from GP window in this scenario?
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (