Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

"GP Data Files"

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi:

An end user would like to export "GP Data Files" dated July 2019 for a third party, so that that third party can open them and see financial information and create reports. 

Other than by providing a backup file (.bak) from July 2019, would the best thing be to export such data from SmartList where the transaction date is 07/31/2019?

Specifically, the end user wants to save the data files to a flash drive at the server where GP runs.

Thank you!

John

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: "GP Data Files"

    As Richard pointed out, providing them with a BAK file would be overkill and they would likely not know where to start with, especially if they have zero knowledge of GP table structures.

    I'd simply use the built-in SQL views to provide them with GL transactions dated between a specific range of dates. If you have the SSRS or Excel reports deployed, then it's even easier as everything is in place already. If not, you could simply use the SQL view "GL Transactions" to pull the data from within any Excel workbook.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: "GP Data Files"

    If all they want is historical financial(GL)  you can use either SSMS, or the Excel Reports or Smartlist to dump data out to a csv file. The next question what fields do they want? A straight dump will give them more than they want. If you can provide a list of the required fields we can provide a script to use to extract that data.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: "GP Data Files"

    John I think the answer to this starts with 'what format the other user wants'

    If the other user wants SQL data, then BAK is the best.

    If the other user wants EXCEL then Smartlist.  

    Also depends on how much data you are talking about.

    Hope this points in some small way toward a solution for 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans