[Vicki Hillary]

Does anyone have suggestions for Copy/Paste functionality from Excel to Payables?  I know that functionality exists in the G/L, but it looks like we would have to use a 3rd party app for Payables.  Just curious if anyone has found a good option.

Thank you.

——————————
Vicki Hillary
RDV Corporation
Grand Rapids MI
——————————

[Samantha Higdon]

Hi ,

Armanino has additional excel copy paste options.  I’m including the link below.

https://www.resgroup.com/microsoft-dynamics-gp-accounting-software/copy-and-paste-tools

There has also been some talk about the October 2020 release including copy/past functionality for the Payables (link to one such article below).  I’m not sure that’s 100% certain yet.  – can you confirm if this feature made it in the October release?

https://community.dynamics.com/gp/b/azurecurve/posts/what-s-new-in-the-microsoft-dynamics-gp-october-2020-release???

Thanks,

Samantha

——————————
Samantha Higdon ,CPA,CGMA
Consultant
Lagom, LLC
Carmel IN
——————————
——————————————-

[David Gading]

Does this new Copy / Paste work with intercompany invoices?

——————————
David Gading
The Heritage Group
Indianapolis IN
——————————
——————————————-

[Samantha Higdon]

Hi ,

If by the “new” you mean what’s coming out with the latest version of GP, what I’ve read thus far hasn’t explicitly said one way or the other.

What I’ve read has said you can use the excel copy/paste for payables “just like the GL”….and the GL feature doesn’t include intercompany.  confirmed the new payables copy/paste made it into GP so she may be able to confirm if it contains the intercompany feature or not.

If it does not, I believe a few of the other resources/add ins referenced in this thread would address the intercompany payables.??

Thanks,

Samantha

——————————
Samantha Higdon ,CPA,CGMA
Consultant
Lagom, LLC
Carmel IN
——————————
——————————————-

[Christine Boisvert]

Hi Vicki, 

I have used Excel Infinia in the past and it’s very good!

http://www.excelintegrator.com/infinia-integrator-ap/

——————————
Christine Boisvert
Technical Sales / Report Trainer
Vivid Reports
Winnipeg MB
——————————
——————————————-

[Holly Hueston]

Is this the same as or similar to Titanium which we use in our GP for A/P?

——————————
Susan Dickerson
Southern Environmental Law Center
Charlottesville VA
——————————
——————————————-

[Terry Heley]

I’m happy to say and confirm this feature did make it in the October 2020 release, YEAH!!! 🙂
I will have a blog out shortly of all the features that will be included.
Thanks
Terry Heley
Microsoft

——————————
Terry Heley
HR/PR expert
Microsoft
West Fargo ND
——————————
——————————————-

[Vicki Hillary]

Thanks everyone, we will look for it in the October release!

——————————
Vicki Hillary
RDV Corporation
Grand Rapids MI
——————————
——————————————-

[Theresa Rago]

Does anyone have a solution for copy/paste intercompany journal entries?

——————————
Theresa Rago
Manager, Financial Systems
CV Starr & Co, Inc.
New York NY
——————————
——————————————-

[Samantha Higdon]

Hi ,

GP’s native Copy/Paste functionality does not include the intercompany piece, and I don’t believe the release scheduled for October 2020 does either.

However, you can use one of the following solutions for intercompany journal entries:
1.) SmartConnect
2.)Integration Manager
3.) Infinia Integrator? -http://www.excelintegrator.com 

Take a look at those options.  If you have questions, I’m happy to go into more detail on any that strike your fancy.

Thanks,

Samantha

——————————
Samantha Higdon ,CPA,CGMA
Consultant
Lagom, LLC
Carmel IN
——————————
——————————————-

[Barry Crowell]

Hi  

I have used this free Excel copy paste inter-company with several client with no issues.  You can find it here:  https://jamesdlyn.wordpress.com/2015/04/10/gp-paste/

——————————
Barry Crowell
BI/EDW Solution Architect
KTL Solutions, Inc
Frederick MD
——————————
——————————————-

[Christine Polifka]

Hi Everyone, 

That is exciting news to hear! I am glad that GP made this functionality upgrade/update! 

Thank you GP Team,

——————————
Christine Polifka
BIG KAISER Precision Tooling Inc.
Hoffman Estates IL
——————————
——————————————-