Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SL AP Voucher Import A...
Finance | Project Operations, Human Resources, ...
Answered

SL AP Voucher Import Assistant

(0) ShareShare
ReportReport
Posted on by Mark E 6,405

I have a site using the AP Voucher Import Assistant that was downloaded from PartnerSource.  Has worked well for them over the years (SL2015 & Excel 2013 32-bit).  Another site expressed interest in using it, so I copied the working Excel file over to their environment (also SL 2015 & Excel 2013 32-bit).  On the new site, the Import Vouchers code fails with the "Class not Registered" error when firing the code sivTB.Login (ServerName, SystemDB, CpnyID, UserID, "").  Both use Windows Authentication for SL.  Things I have verified:

  • Object Model is registered in SL Registration
  • There are no MISSING References in the VB Project

Anything obvious I am missing?

  • Verified answer
    Mark E Profile Picture
    Mark E 6,405 on at
    RE: SL AP Voucher Import Assistant

    Resolved this issue with the findings from my other related post on Excel/Object Model integration.

    community.dynamics.com/.../runtime-error-429-when-connecting-to-sl2015-cu2-from-32bit-excel

  • Mark E Profile Picture
    Mark E 6,405 on at
    RE: SL AP Voucher Import Assistant

    So I have been doing some error trapping with this file and other Excel based Object Model examples I have found.  They all seem to fail on the "Set sivTB = New SIVToolbar" code.  I did some searching, and found this article related to SL7, where a HF was later delivered.  Wondering if this similar issue is related to SL 2015 CU2 and later.  I do have the AP Voucher import tool working on one SL 2015 install, but it might be CU1.

    [View:https://microsoft.public.solomon.narkive.com/gNdgwb8k/excel-vba-integration-with-solomon-object-model-in-dynamics-sl-7-0:750:50]

  • Mark E Profile Picture
    Mark E 6,405 on at
    RE: SL AP Voucher Import Assistant

    OK.  I can understand where these might not be updated, but is there no longer any way to use Excel for Object Model integration?  All the documentation I can find is quite old.  Would appreciate knowing if there is current documentation on Object Model integration support.

    Thanks.

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SL AP Voucher Import Assistant

    Hello,

    myself and a co worker tested the voucher import on 2015cu2 and 2018cu2, we both got various login errors (2015), Error 6 and assertion failures in 2018. So my guess is that it doesn't work in those versions...We don't get any class not registered errors..Only excel 2013 worked for me otherwise the worksheets were all disabled.

    I probably can guess that these won't be updated .

    Best Regards,

    Jana MacDonald

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SL AP Voucher Import Assistant

    Hello Mark E,

    I've never used and really didn't know such a tool exists, since SL has "transaction import"

    I will check with other agents to see if they've had any experience with the tool.

    Best Regards,

    Jana MacDonald

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans