Dynamics Community Forum Thread Details

Dealing with SOP and aggregated invoice data

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!

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.

Quick Links

Leaderboard