Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Project Accounting PAShipmentExtCost question (table PA31102)

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?

  • 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

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans