Forum Replies Created

Page 2 of 4
  • Jo deRuiter

    Member
    February 29, 2024 at 12:32 pm in reply to: AP Manual Payment stuck in WORK status
    Up
    0
    Down
    ::

    Hi Christine.

    It is not uncommon that one transaction of any kind in any batch not post when the rest do. This is because GP will post information it deems viable and kick back transactions that are not.

    The real question is why it is not showing in Batch Recovery.

    The trick when you DO find these in Batch Recovery is to recover the batch, then print the batch edit list which will tell you if anything is wrong with the transaction. When you find what’s wrong you correct that in the transaction(s) and then post.

    Are you sure it is not showing in a batch somewhere in Manual checks or in Purchasing Batches?

  • Jo deRuiter

    Member
    February 29, 2024 at 9:03 am in reply to: AP Manual Payment stuck in WORK status
    Up
    0
    Down
    ::

    Hi Christine!

    You’ll likely need to engage with your GP Admin or Partner to look at this.

    Many times with GP transactions get stuck and you cannot see or fix it in the User Interface and the repair must be done in SQL.

    Without access to SQL to find and look at that transaction we likely can’t help.

    Can you see the manual payment in any batch or see it on the Vendor Inquiry screen?

  • Jo deRuiter

    Member
    February 28, 2024 at 1:59 pm in reply to: Enter Receipt Option in the Bank Transaction Entry
    Up
    0
    Down
    ::

    Hi Tammy:

    Pamela is right, but let me expound on that.

    If you do a Receipt, whether it is in Bank Transactions or in Customer payments then the next step is to go to Financial>Transactions>Bank Transactions and go to Bank Deposits.

    There you can group each individual receipt into the grouping you put on the deposit slip for the bank so that your bank deposit matches to the penny what you said you put on that deposit in GP – you can have multiple checks going to the bank and that’s why this functionality is here – to group the transactions into the deposit you took to the bank.

    Many people in GP2016 and above have their customer receipts going directly into the bank in GP – this is a setting in GP, but this is not true for Bank Transactions so you must do the extra step there.

  • Jo deRuiter

    Member
    February 28, 2024 at 1:53 pm in reply to: Concur to GP Integration Products?
    Up
    0
    Down
    ::

    Hi David.

    Depending on the complexity you can use SmartConnect if you have it. Otherwise, most Concur to GP integration is done through the Wipfli product, though it does have its challenges.

  • Jo deRuiter

    Member
    February 23, 2024 at 9:15 am in reply to: Sales Order Process Automation – Microsoft Dynamics
    Up
    0
    Down
    ::

    Hi Jill:

    You can use SmartConnect to update the document that exists with it’s line items, not sure who said you can’t.

    You will need the Document Type, SOP Number, Customer Number along with the item information in the upload file.

    This is fairly easy to build and if I can help in anyway let me know.

  • Jo deRuiter

    Member
    February 23, 2024 at 9:12 am in reply to: GP Fixed Assets Mass Retirement issue
    Up
    0
    Down
    ::

    Howard,

    That is very interesting, was there any kind of code adding the leading zero?

  • Jo deRuiter

    Member
    February 16, 2024 at 8:13 am in reply to: Sales Posting Journal Manual Invoice error
    Up
    0
    Down
    ::

    Hi Christine!

    This is likely a scenario you will need to engage with your partner or consultant on. They will need to do some data repair in SQL to get this fully fixed.

    Unfortunately you may not be able to even void this in the GP user interface.

    Let us know if you need further help, but on this one we can’t advise unless we could actually see all that hit SQL and where.

  • Jo deRuiter

    Member
    February 13, 2024 at 11:06 am in reply to: Correcting Incorrectly setup Fixed Asset 13 Periods
    Up
    0
    Down
    ::

    Hi David!

    Perfect!

    The Averaging Convention is indeed what determines WHEN the asset starts depreciating.

    And Full Month would depreciate a full month no matter when in the month the asset is acquired. Full Period will look at the Fiscal Calendar setup to see if you have custom periods (i.e. not traditional calendar months) and depreciate based on the number of days in that period.

    I would use Full Month if they do have any custom Fiscal Periods.

  • Up
    0
    Down
    ::

    Hi Blaine,

    This is odd, can you paste in to this thread what the setup you are trying looks like? I’m having no issues setting this up for recurrence when I try it.

    Paste in that screenshot and we may be of more help.

  • Jo deRuiter

    Member
    February 12, 2024 at 9:33 am in reply to: Dates in the Job Queue
    Up
    0
    Down
    ::

    Hi Chris,

    For this one you are likely to need a developer as you cannot enter a date formula there. This has already been submitted to Microsoft as a solution fix, but here is more about it.

    But, this is an issue that does not seem to have a resolution yet.

  • Jo deRuiter

    Member
    February 12, 2024 at 9:20 am in reply to: Batch Posting Issue
    Up
    0
    Down
    ::

    Eddie,

    This error means the voucher number used on one of the transactions already exists in the PM00400 table and you need a new voucher number.

    It could be someone changed the next number in Payables setup and it is now trying to grab already used numbers or someone manually entered an existing voucher number.

    Take a look at the voucher numbers used on the transactions and manually change them in order to post

  • Jo deRuiter

    Member
    February 12, 2024 at 9:15 am in reply to: Financial / GL accounts used in setup
    Up
    0
    Down
    ::

    Hi Devon,

    The script you seek would depend on what modules the company is using. You may need to take the script you found and add to it or subtract from it.

    What module setups are missing from their script?

  • Jo deRuiter

    Member
    February 5, 2024 at 8:18 am in reply to: Dates in the Job Queue
    Up
    0
    Down
    ::

    Hi @chris-warren

    When you are in the Job Queue Entry Card, expand Recurrence toward the bottom of your screen then enable to “Run on X day” and fill in the rest.

  • Jo deRuiter

    Member
    February 29, 2024 at 9:15 am in reply to: Concur to GP Integration Products?
    Up
    0
    Down
    ::

    Hi David,

    The Wipfli product with GP has many issues and in my experience constantly needs to be trouble-shot. Their support is also a little slow. But they are the most popular solution for Concur. I’m not familiar with the Armanino solution, though I’d love to see it. All I know is I’ve built out custom SmartConnect integrations for Concur for several clients in the last few years and it’s not hard – but that really depends on the Concur setup and your understanding of the data – be prepared to setup multi-data-sources and several calculated fields in SC. I believe you know it well enough!

  • Jo deRuiter

    Member
    February 28, 2024 at 2:01 pm in reply to: Sales Order Process Automation – Microsoft Dynamics
    Up
    0
    Down
    ::

    I do have team, just email me at jo.deruiter@aislingdynamics.com

Page 2 of 4

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!