Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

GP Import Payables Invoices

Posted on by 50

Hello everyone,

I am not sure if Microsoft has released any documentation on the new feature introduced in GP 18.3 called 'Import Payable Invoices ' (transactions > purchasing > import payables invoices).

I can't seem to find anything officially from Microsoft about this new feature, or about the specs of what a valid file needs to look like.

Thanks!

  • jgilker Profile Picture
    jgilker 50 on at
    RE: GP Import Payables Invoices

    Sadly, no.

    I ended up attempting to use GP PowerTools, tracing the SQL procedure to be the following: [PMReadQBOorQFXFileTOPMTrx]

    That procedure parses the QBO file in GP, but sadly, it still didn't help me. We ended up not using this feature due to how poorly this was implemented.
    Microsoft gave a poor response above, no other forum posts are available, the error message is generic, and we decided not to spend more time investigating why this didn't work.

    Sorry I couldn't help more.

  • PattiK323 Profile Picture
    PattiK323 233 on at
    RE: GP Import Payables Invoices

    I have the same question. Did you ever receive an answer?

  • RBDELAMATER Profile Picture
    RBDELAMATER on at
    RE: GP Import Payables Invoices

    I believe these are the 6 fields that are required and limited to in the file to be imported. This only imports the debit amt (expenses) the credit side is the default account in GP.

    ORG                        VENDOR ID

    TRNTYPE                DEBIT Only expenses

    DTPOSTED              XX/XX/XXXX

    REFNUM                   Your description

    NAME                        Name entered in the 'Transaction Type Account Mapping' window in PM Setup

    TRNAMT                    00.00

  • jgilker Profile Picture
    jgilker 50 on at
    RE: GP Import Payables Invoices

    Hello,

    Sadly, we have already reviewed this page, and this document does not list what GP is looking for in the qbo file.

    Using a standard qbo file from our bank, we were unable to import the file.

  • RBDELAMATER Profile Picture
    RBDELAMATER on at
    RE: GP Import Payables Invoices

    Here is a short blog walking through how this works - community.dynamics.com/.../import-credit-card-transactions

  • jgilker Profile Picture
    jgilker 50 on at
    RE: GP Import Payables Invoices

    Hola,

    Doesn't that defeat the purpose of using this new feature / tool?

    The whole purpose is to import a qbo file into GP using this feature.

  • Romryan Profile Picture
    Romryan on at
    RE: GP Import Payables Invoices

    what about Integration Manager, Econnect ,Econnect stored procedures or API or GP Webservice?

  • jgilker Profile Picture
    jgilker 50 on at
    RE: GP Import Payables Invoices

    Hey Lucas,

    Sadly, I have already reviewed this document, but it doesnt not answer my question.

    I am more looking for something like a schema from which GP is referencing, for the xml document that is being imported.

    The reason why I am asking is that we tested this feature out with a QBO file straight from our bank and got numerous import errors relating to the file. All of the setup was already completed in GP, as per the doc you linked.

    Thanks

  • Lucas Reuss Profile Picture
    Lucas Reuss on at
    RE: GP Import Payables Invoices

    Hello and Thank you for your post!

    The feature was titled Copy/Paste Purchasing Transactions and Distributions, which might be why you had some troubles finding the documentation.  The Copy/Paste Purchasing Transactions and Distributions feature was documented in the 18.3 New Feature Blog series and can be found at the link below.

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

    Please let me know if that helps!

    Thank you,

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

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,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans