Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Instructions for Copy/Paste Purchasing Distribution from excel

(0) ShareShare
ReportReport
Posted on by 15

I am needing some guidance in pasting a somewhat large excel file into Purchasing Distribution and (1) how do I upload descriptions within my entry and (2) how to properly input information on the Purchasing transactions fields without getting error message relating to allocations between the two input screens..

Janean Brown

Science Museum Oklahoma

Categories:
  • Suggested answer
    RE: Instructions for Copy/Paste Purchasing Distribution from excel

    Thank you!  That is exactly what I was looking to find!  I appreciate you!  

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,141 on at
    RE: Instructions for Copy/Paste Purchasing Distribution from excel

    Here is what I successfully pasted that worked for description/distribution reference:

    Column order for  Transaction Entry Paste:button:

    Description
    Purchases
    Trade Discount
    Freight
    Misc.

    Column order for Distribution Entry Paste button:

    Distribution Reference
    GL Account
    Distribution Type
    Debit
    Credit
  • Suggested answer
    RE: Instructions for Copy/Paste Purchasing Distribution from excel

    Thank you for the information but I am looking for the required fields in this order to copy paste correctly within the Purchasing module/Distributions button that breaks down the allocation of the AP entry..   I can paste the required fields within the distribution screen but I cannot seem to get the descriptions to upload/paste in.  When I close/save the screen, I get an error message because my distribution amounts do no equal my purchase amount (on the transaction entry screen).  I have tried several combinations, no purchase amount, the purchase amount entered but then I have to delete the defaulted information within the distribution screen and then I can paste it within but then I get the error message.  So my issues are two parts (1) eliminating the distribution allocation error messages and (2) how to upload/paste the description fields within the distribution screen.   I hope this makes more sense and I would appreciate any assistance!

    Janean Brown

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,141 on at
    RE: Instructions for Copy/Paste Purchasing Distribution from excel

    Are you referring to this enhancement in GP 18.3?

    Microsoft Dynamics GP Fall 2020 - Copy and Paste Purchasing Transactions and Distributions - Microsoft Dynamics GP Community

    There is a comment that mentions loading Distribution Description.  I don't understand what you mean by "allocations between the two input screens".  Are you possibly referring to Distribution Types?  You will need to match those to the amounts entered on the transaction entry window.

    [Disclaimer:  I haven't actually used this feature in GP 18.3.  We have long-recommended Copy/Paste Between Excel and Microsoft Dynamics GP | TitaniumGP for our clients who are looking for Excel-based integrations.]

  • Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Instructions for Copy/Paste Purchasing Distribution from excel

    Hello,

    I am guessing that you are using some sort of customization or add-on for this as Microsoft Dynamics GP does not have a feature to copy/paste distributions in the the Purchasing window.  I hope you were able to find assistance with whoever supports that functionality.

    Thanks,

    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