web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Copy & Paste Payab...
Microsoft Dynamics GP (Archived)

Copy & Paste Payable Distribution from Excel

(0) ShareShare
ReportReport
Posted on by Mahabub 30

Hi,

For a single invoice from a vendor, I need to allocate expenses to multiple expense accounts. The details, each expense account and their respective amounts, are provided in an excel document. 

Is it possible to copy and paste the distribution (or import it) from an excel (or any other format) file?

Is there an additional addon that I can purchase, other than SmartConnect and Integration Manager, that will accomplish this?

*This post is locked for comments

I have the same question (0)
  • kassab Profile Picture
    kassab 660 on at

    Hi Mahabub,

    Copy and paste from excel feature only exist in the Financial GL general Journal.

    for standard features in the Dynamics GP you can try to create a Macro to do this job.

    hope someone else can assist if there is any additional addon in this area!

    Regards

  • Verified answer
    Mike Bufano Profile Picture
    Mike Bufano 1,484 on at

    There is an ISV product that allows copy and paste for AP.

    www.excelintegrator.com

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    It is possible with the econnect. We do it all day long. You have to have TitaniumGP to paste invoices in. We have invoices that can have 800 rows and have to go to specific patients. 

    In the "purchase" column in the TGP template, I have an IF/SUMIF statement that sums the Dist Debit 1 column if the Document Number is the same. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans