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) / Can I import a PM Invo...
Microsoft Dynamics GP (Archived)

Can I import a PM Invoice/Credit Memo with line items?

(0) ShareShare
ReportReport
Posted on by Greg Kujawa 583

I have access to several GP add-ons, such as VSTools, Integration Manager, and eConnect. Although far as I've seen I cannot seem to find an automated method to import in PM transactions with underlying line item detail. The goal is to take a text file I've exported from a third party system and port it into GP as either PM invoices or credit memos depending if the line items are a positive or negative quantity value.

Looking at eConnect samples as well as sample IM objects all I see are methods to created PM transactions with summary-level data, without line items. If it is possible to accomplish this please point me in the right direction, as I'd prefer something that doesn't involve the enduser going into GP and pulling down some menu function I've created through VSTools. A quick batch file pointing to an IM or eConnect routine would make things more automated.

Thanks!

 

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    You need to have two tables to import, one with the document headers (invoice header data) and the second with line item data.

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Greg, if you were to do this using the GP user interface, instead of importing it, where would you do this?  What GP window(s)?

    The reason I am asking is that typically, in the Payables Management module (PM), there is no such concept as 'line items'.  So unless I am misunderstanding what you are asking, this is just not possible in GP.

    However, perhaps you mean that you want to import Purchase Order Processing (POP) transactions - those do have line items and when posted will, in turn, create transactions in the Payables module.

  • Suggested answer
    CU15051155-0 Profile Picture
    CU15051155-0 262 on at

    You cannot have line items for PM Invoices and credit memo. Its only like a summary level.

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
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans