Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Project Accounting PAShipmentExtCost question (table PA31102)

(0) ShareShare
ReportReport
Posted on by 250

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?

Categories:
  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Project Accounting PAShipmentExtCost question (table PA31102)

    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

  • Deanne CWCO Profile Picture
    Deanne CWCO 250 on at
    RE: Project Accounting PAShipmentExtCost question (table PA31102)

    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?

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Project Accounting PAShipmentExtCost question (table PA31102)

    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

  • Deanne CWCO Profile Picture
    Deanne CWCO 250 on at
    RE: Project Accounting PAShipmentExtCost question (table PA31102)

    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?

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Project Accounting PAShipmentExtCost question (table PA31102)

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans