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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Dealing with SOP and aggregated invoice data

(0) ShareShare
ReportReport
Posted on by 130

This may be outside the scope of the GP forum, but we are currently seeking a solution to a fairly specific issue:

-We receive detail for invoices via detailed spreadsheet.  We aggregate data in excel to create invoices for the customer, import to GP for the purposes of using the RM function and Financial Reporting.

As a financial services company, we want to implement a tool that will help in keeping the invoice at a high level for our customer, but keeping the detail data intact--this may mean there are multiple levels of aggregation we may need to see.  Almost as if we would need to group customers or sales line items.  Additionally, what we are looking for is a system that will basically allow us to create billing templates, as in recurring billing, but the amounts are never the same from month to month and based not on inventory or cost, but other financial measures such as an average daily balance.

Do you have any suggestions for add-ons, modules or am I potentially missing GP functionality that exists?

 

Thanks!

*This post is locked for comments

I have the same question (0)
  • Mike Smith Profile Picture
    6,840 on at

    Hi Derek,

    I'm not aware of a 3rd party product that can handle this as I haven't had a requirement for this.  I would recommend working with your GP partner to explore a possible customization that allows GP to integrate with your financial software solution.  GP has the ability for recurring orders for a subscription based model, but this seems to work best if the transactions are fairly consistent.  If an integration existed between the two systems to create a new GP invoice each month based on the underlying data, would a "parent order" be necessary?  From here, you could use a number of Invoice creation tools (I prefer Accountable's Forms Printer, but there are many others) that will allow you to aggregate the data based on the reporting tool's "grouping" capabilities.  Another option that I've used for subscription type scenarios are several invoices and then using a highly modified statement to provide the aggregated data.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans