Change of existing Payables Data

  • Change of existing Payables Data

    Posted by Thomas Hill on March 4, 2025 at 6:09 pm

    We are on GP2018. But I saw this oddity when on GP2015. We have three companies. We each have complete access to all three. Primarily I work in the Main Company and the Data Center company, both for payables. My Coworker works primarily in the Catalog company for payables, and receivables for the Main Company and the Catalog.

    We run Smartlist throughout the month in the payables. We save to Excel then upload to our Invoice Register we have in FileMaker Pro. In the Catalog company I do an adjustment to the Credit Card Vendor, after exporting the transactions, to zero it out each month. I use Integration Manager to upload to the Credit Card Vendor in the Main Company to consolidate the transactions.

    During the Month, the Smartlist shows my coworker as the Posted User ID. After I do an adjustment (a single transaction), to zero the vendor. The Smartlist shows that I posted all of the Credit Card transactions through the month. GP changes the transactions Posted User ID.

    Why?

    Thomas Hill replied 1 month, 1 week ago 3 Members · 5 Replies
  • 5 Replies
  • Devon Southall

    Member
    March 6, 2025 at 11:06 am
    Up
    0
    Down
    ::

    What is the name of the Yellow folder that the smartlist is under??

    • Thomas Hill

      Member
      March 7, 2025 at 11:03 am
      Up
      0
      Down
      ::

      I am not sure what “Yellow Folder” means are refers to. This is where it is listed:

  • Amber Bell

    Member
    March 19, 2025 at 1:52 pm
    Up
    0
    Down
    ::

    What type of transaction are you uploading to consolidate?

  • Amber Bell

    Member
    March 19, 2025 at 2:11 pm
    Up
    0
    Down Accepted answer
    ::

    I just finished a test…when I created an AP Invoice under one User ID it showed that User ID as the Posted User ID. When I created a credit memo and applied it to that invoice, the Posted User ID updated to that User ID. I also tested partially applying to the Invoice. In that case, the original User ID stayed.

    My conclusion: That field is updating to the User that was responsible for moving it from the Open Table to the History table. Since you are closing out the balance on the transactions, you are the one moving it to history…so it changes to your name. It might be better named “User Who Wrote the transaction to the current table” vs. User Who Posted.

    • Thomas Hill

      Member
      March 20, 2025 at 2:11 pm
      Up
      0
      Down
      ::

      I appreciate that test and answer. I wish it would live the original user who posted it along and put in a field for LAST USER. Manually I will put them back to the original user.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!