Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Auto-Invoice based on upon GP Receipt Number

Posted on by Microsoft Employee

Has anyone been successful inside GP making a modification to allow Enter/Match in the Purchasing Module by receipt number?  Our company would like modify the Select Purchase Order Items window to create a PO Invoice based on one, or many, PO Receipt lines that have not been previously invoiced.  This is not currently one of the options in this window.

The ideal would be to look up by vendor by receipt number, and then auto-invoice once we verify the correct line items appear.

Our company has many lengthy POs of hundreds of line items where the vendor ships multiple receipts against the same PO items, and then sends multiple invoices to us on a 1to1 basis with these individual receipts.  GP groups these receipts on the Enter/Match screens, as if assuming a vendor would group for invoicing purposes.  This does not happen with our vendors.  Multiple receipts of the same item, therefore multiple invoices of the same item against the same PO.

 

Our lives would be much improved by an option, or work around, to Auto-Invoice based on upon GP RECEIPT NUMBER.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto-Invoice based on upon GP Receipt Number

    Nice post

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto-Invoice based on upon GP Receipt Number

    Nice post

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Auto-Invoice based on upon GP Receipt Number

    Aside from customization to Dynamics GP, this sounds like an excellent candidate for SmartConnect with their Excel Add-in tool.  You could pull the detailed list of receipts, quantities and costs into a spreadsheet allowing a user to update the data in a true matching process, then push that data in detail back into GP.  If user intervention is not required, then SmartConnect or just eConnect and SSIS might get the job done.

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Auto-Invoice based on upon GP Receipt Number

    NBG, this can be develop. If you are interested PM me or email me.

  • mm123 Profile Picture
    mm123 2,535 on at
    RE: Auto-Invoice based on upon GP Receipt Number

    Hello NBG, We have received a similar request from our customer, Planning to go with the custom solution to address their specific requirements. If you are interested in custom solution, Please drop an email to learn. 

    samr(at)expsoltech(dot)com

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans