What is the purpose of the PAShipmentExtCost field? One of our projects has 2 RCT #'s for the same item number - one amount is $138.40 and the other is $0.40
On the Purchases Material Inquiry screen, the $.40 is showing and not the $138.40
Accountants are saying "GP is changing numbers" but that of course doesn't make sense. They are 2 different RCT numbers
Any suggestions?
If you know the shipment was actually processed at the correct cost and the POP30310 shows that, so just the PA31102 has the wrong cost on it, then updating it in SQL should be pretty harmless. Especially since there is not physical inventory tied to it. We obviously don't support/recommend updating records directly through SQL especially through a forums post, but as long as you did it in a test company with a copy of live first and verified that all looked good to them there, then I feel it would be safe. It could depend on what other imbalances and what other areas they are seeing as 'incorrect' on the Project because of this. If it gets too involved, it would probably be best to open a support case with us so that we can gather some more information and analyze the full data on the purchase receipt with the issue to be able to recommend the best solution possible.
I hope this helps!
Isaac Olson
Microsoft Support
This is awesome! thank you so much for the information. We don't track inventory - it's really just being purchased for projects. The transactions are historical - I believe the accountants are trying to finalize the Project Accounting info and that's how they're now finding these random issues. Can I fix this in sql?
Hi Deanne,
If the Shipment was entered at the wrong cost, and it has not been invoiced, you could invoice it at the correct cost or you could do a purchase return on it. If it was already invoiced at the wrong cost too, then you would want to do a purchase return on it and rekey it at the correct cost.
If it's an inventoried item, and you already transferred it to the project, then you would need to do a new inventory transfer but select the option of 'Return' for the Transaction Type to take it off of the project, and then you can transfer it back in once you purchase it at the right price.
There can be many factors on the exact steps such as whether the item is inventory tracked or not as well as if the item has been sold/transferred to the project, or if the shipment has been invoiced yet or not.
Thanks!
Isaac Olson
Microsoft Support
Thank you so much! I'm sure it's a user entry issue. Now the next question - is there an easy way to fix this?
The PAShipmentExtCost in the PA31102 should be equal to the EXTDCOST in the POP30310 for the same Receipt Number. You can purchase an item at any cost you want, and then invoice it at another cost. So its possible that they received the item at 2 different costs on 2 different shipments. I would check the Purchase Order Processing Document Inquiry to see if you see the same costs in the Purchasing module for these receipts.
Purchasing >> Inquiry >> Purchase Order Documents
If these are multicurrency shipments then the PAShipmentExtCost is going to be the cost in Functional, where the EXTDCOST is going to be in the originating currency. And another factor could be if they used different units of measure between the 2 different shipments.
select * from PA31102 where PAVIDN = 'XXXXXXXXXXX'
select * from POP30310 where POPRCTNM = 'XXXXXXXXXXX'
To me, a user probably keyed or imported the shipment at the wrong cost. If they are doing their invoices separate from their Shipments the issue may have been corrected by the user entering the proper amount on the invoice which would have created a PPV to correct the cost.
I hope this helps!
Isaac Olson
Microsoft Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148