Skip to content
+1-888-319-3663

EONE BLOG

9 Comments

  1. Peretz Partensky on April 27, 2016 at 6:06 pm

    Lorren,

    Thank you for a very helpful post. I am sure this will be relief for many people trying to overcome exactly this problem. One question:

    If my understanding is correct, the example above assumes that we are applying one Manual Check to one Invoice. How we should modify the source data and script to apply a single Manual Check to multiple Documents?

    Thanks in advance for your answer!

    • Lorren Zemke on April 28, 2016 at 4:00 pm

      Peretz, You are correct, the example assumes there is one source record applied to one invoice. If you need to apply that one source record to multiple documents, then, in the script, you need to be able to loop through your apply to records.

      • Peretz Partensky on April 29, 2016 at 2:06 pm

        Lorren, Thanks for your response! When I loop through to apply to multiple invoices, which data source should I be using for the applications? Specifically, am I able to include one row for each application in the source document, then group on Check Number for the sake of the Manual Check creation, but then access the expanded group within the script? Am I thinking about it the right way? Do you have any documentation on how I would do this? A simple nudge would go a long way, and I’d be happy to share the results with the community, once I figure it out.

        • Pam Robertson on January 9, 2018 at 6:17 pm

          Lorren, I don’t see a reply to Peretz’s question. If we are grouping our source data by check number to create the manual check, can we then access the original, ungrouped individual lines within the script to create the applies?

          • Lorren Zemke on January 10, 2018 at 11:51 am

            Pam,

            With document success task, there is not a way to access the individual ungrouped lines.

            The only option is the ungrouped lines have to be accessed again in some manner. To get around this in one case, I had to get the data out of a SQL table using .NET and looping through those records.



          • Jessica Landeros on February 26, 2021 at 7:16 pm

            I just reviewed Steve Endow’s DLL documentation (as we’re trying to resolve this issue right now.) He noted this in the documentation:

            “If you need to apply a payment to multiple invoices as part of a manual payment import, you will need to write an additional script that accesses the payment application data source (separate from the manual payment data source), retrieves the apply records, and loops through the multiple payment applications for each imported payment.”

            “Alternately, a separate Apply Payments map could be created that reads the payment application data source and uses a script to apply payments to multiple invoices, independent of a payment import. “



  2. Luis Alberto Soto on September 23, 2016 at 2:18 pm

    Hi Lorren,
    I need to know, how can I do to get Precipio.APApply.dll file?
    I mean, is there available for download somewhere. I’m trying to contact with Precipio people, but I have not answer yet.
    is it include with SmartConnect now?
    Regards

  3. Lorren Zemke on September 23, 2016 at 2:41 pm

    Luis,

    The DLL was written by Precipio and they are the only one’s who you can purchase it from. I will contact them to see if maybe they are out of the office.

    Lorren

  4. Thomas Moore on July 17, 2018 at 10:55 am

    I noticed that in the selection “Manual Checks” was selected. Is this also available for mixed batches using “Manual Payments” where some of the payments are EFT and some are checks?

Leave a Comment





RECENT POSTS


Tech Tuesday: Building My First Matrix Report
Overcoming the Top Challenges of Zendesk Integration
Accessing Historical Dynamics GP Data in NetSuite: Using Popdock
Popdock's Top 10 New Features
New Webinar: Getting Started with Matrix Reporting in Popdock

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.