+ Reply to Thread
Results 1 to 1 of 1

Power Query to be able to create Dynamic Journal entry tables

  1. #1
    Registered User
    Join Date
    02-23-2021
    Location
    Missouri, US
    MS-Off Ver
    365
    Posts
    2

    Question Power Query to be able to create Dynamic Journal entry tables

    The internet hasn't been much help in answering this question, nor has a couple of power query classes I've taken. Is it possible to set up a power query, to take summarized data and manipulate it into a format to upload back into my system for Journal Entries. I would need it to dynamically filter by the current fiscal period I'm in, but also pull previous months, to verify the month total is 0, and if the next month has any data that would need to be posted.

    So the story is, my company uses 2 different systems to keep track of all their data. I have to pull data from E1 sort out a bunch of object account numbers, manipulate it to give me a not only each account balance, but the total balance of all the accounts. I then bring that into a different excel file so I can put all the data into a a format that can be copy and pasted and posted into E1, to make it all 0 in that system. And then reformat that data into another table for the Journal Entry balance transfer into PDI.

    Normally this is done by manual filtering, vlookups, text to columns, and lots and lots of copy and paste.

    I know I might need a date query thing, for the whole dynamic filtering by current period. Also note, as we have no software to speed our processes, we do everything manually, so sometimes I'm making previous month transfers in the middle of the next month. So the query would need to take that into account, Hence I would need to be able to get 3 months of data to look at before the Journal Entries are created. And even after trimming an example down to no more than 20 rows the templates we have are way to big to actually upload. I can post a picture though of what the templates look like for reference.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. new entry in merge power query
    By rosscortb in forum Excel General
    Replies: 1
    Last Post: 04-24-2020, 05:02 AM
  2. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  3. Power Query: Updating a query based on changing tables
    By cheesehead101 in forum Excel General
    Replies: 1
    Last Post: 12-16-2019, 06:54 PM
  4. [SOLVED] Power Query - load to workbook and create query table
    By jaryszek in forum Excel General
    Replies: 1
    Last Post: 12-10-2019, 11:09 AM
  5. Replies: 1
    Last Post: 11-12-2018, 02:46 PM
  6. Replies: 0
    Last Post: 04-06-2017, 03:30 AM
  7. Pivot Tables-To Find Count of Unique(Distinct)User id within the same Journal Entry.
    By Deepthik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2010, 06:09 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1