Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

"Error When Importing Excel Data into AR Customer Payment Journal Lines"

(0) ShareShare
ReportReport
Posted on by 61
I am facing an issue when trying to import Excel data into the Accounts Receivable (AR) module's customer payment journal lines. Whenever I attempt this import, I encounter the following error:
 
Error executing code: COM (object), method createFromVariant called with invalid parameters.
Stack trace
(C)//Classes//COM//createFromVariant
(C)//Classes//SysExcelCells//item - line 3
(C)//Forms//LedgerJournalTransCustPaym//Designs//DesignList//ImportCustPayment//Methods//Clicked - line 134
 
The number of arguments provided is different from the number of arguments accepted by the method
This error has been a roadblock in our data import process, and I'm unsure how to resolve it. I'm using Microsoft Dynamics AX r3 and Excel 2016.
 

I would greatly appreciate any insights, suggestions, or solutions from the community regarding this issue. If anyone has encountered a similar error or knows of potential fixes, please share your expertise.

Thank you in advance for your help!

  • pwa Profile Picture
    9 on at
    "Error When Importing Excel Data into AR Customer Payment Journal Lines"
    I agree with Martin.
     
    You may want to verify the COMVariantType and make sure it is a VT_DATE.
    I've had this issue many times in the past, because it's difficult to tell what the type is inside the cell.  (At least for me.)
     
    Paul
  • Martin Dráb Profile Picture
    231,833 Most Valuable Professional on at
    "Error When Importing Excel Data into AR Customer Payment Journal Lines"
    I would continue the debugging by finding the value of row variable and simplified the test case by removing all unrelated code. When knowing that row and column is it about, I would also check the data in the given cell in Excel.
  • Fawad Ahmad Profile Picture
    61 on at
    "Error When Importing Excel Data into AR Customer Payment Journal Lines"
    I am encountering a persistent issue while attempting to import Excel data into the Accounts Receivable (AR) module's customer payment journal lines in Microsoft Dynamics AX 2012 R3. Initially, I was receiving the following error:
    Error executing code: COM (object), method createFromVariant called with invalid parameters.
    Stack trace
    (C)\Classes\COM\createFromVariant
    (C)\Classes\SysExcelCells\item - line 3
    (C)\Forms\LedgerJournalTransCustPaym\Designs\DesignList\ImportCustPayment\Methods\Clicked - line 134

    However, after commenting out the progress bar code and few spaces , the error now occurs on line number 141.
    Show you on image .
    I am using Microsoft Dynamics AX 2012 R3
    Cumulative Update 10    6.3.3000.110    24 Nov 2015   (Current cu version 10 is installed)
  • Fawad Ahmad Profile Picture
    61 on at
    "Error When Importing Excel Data into AR Customer Payment Journal Lines"
  • Martin Dráb Profile Picture
    231,833 Most Valuable Professional on at
    "Error When Importing Excel Data into AR Customer Payment Journal Lines"
    What code is there at line 134? I don't have AX 2012 anymore (I assume you mean AX 2012 R3) and therefore I can't see that. What CU do you have?
     
    Are you able to debug code and see what values are used at the time of the failure?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,001 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,833 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans