Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / No transaction exists ...
Microsoft Dynamics AX (Archived)

No transaction exists that can be selected for credit note. AX 2012 R2 Project Credit Note

(0) ShareShare
ReportReport
Posted on by DynamicsAXExplorer 415

Hi,

I created a project. Created a project sales order and performed Confirmation and Packing slip for the Sales Order.

Then Created Invoice Proposal and Invoiced the Project.

Because of some issues we have to perform a Credit note as we did invoice for wrong customer.

So I tried two ways and error on each way are shown below.

1. Opened Project > Navigated to > Invoice Journals > Selected the Invoice Line > Clicked Functions on Top > Clicked "Select For Credit Note".

Then I got this Error : """""No transaction exists that can be selected for credit note.""""

2. Open project > Click Item Tasks on Related Information Tab > Click Sales Orders > Then Click Sell Tab > Click Credit Note > Selected Reason Code as "Error" Then Unchecked "Delete Order Lines"
Then Clicked on Project Invoice Tab > Selected All Transactions > Clicked Ok > Got the Dialog Box popup " This sales Order has been fully Invoiced. Do you want to modify it ?"
Clicked Yes > Got Another Popup > Currency code has been Changed. Sales Order Lines and Charges will be recalculated. (Added snapshot of this below). > Clicked Ok > Then I got below error

Illegal inventory transaction

Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.

at Dynamics.Ax.Application.InventTransInvoice.updateDimensionsFromInvoice(Int64 _transOriginIdFrom, String _invoiceNum, Date _invoiceDate, Int64 _transOriginIdTo) in InventTransInvoice.updateDimensionsFromInvoice.xpp:line 49

at Dynamics.Ax.Application.SalesCopying_CreditNote.Updateinvoicecreditcopy(SalesLine _salesLine, CustVendInvoiceTrans _custVendInvoiceTrans) in SalesCopying_CreditNote.updateInvoiceCreditCopy.xpp:line 33

at Dynamics.Ax.Application.SalesCopying.Copy() in SalesCopying.copy.xpp:line 541

at Dynamics.Ax.Application.SalesCopying_CreditNote.Copy() in SalesCopying_CreditNote.copy.xpp:line 8

at Dynamics.Ax.Application.SalesCopying.copyServer(Object[] _packedSalesOrderCopyingContract, Boolean _isCreditNote) in SalesCopying.copyServer.xpp:line 15

at Dynamics.Ax.Application.SalesCopying.invokeCopyServerIL(Object[] _packedParameters) in SalesCopying.invokeCopyServerIL.xpp:line 17

at SalesCopying::invokeCopyServerIL(Object[] )

at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)

at Dynamics.Ax.Application.SysDictClass.invokeStaticMethod(Object[] _params) in SysDictClass.invokeStaticMethod.xpp:line 26

at SysDictClass::invokeStaticMethod(Object[] )

at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)

at Microsoft.Dynamics.Ax.Xpp.PredefinedFunctions.runAsInvoke(String className, String staticMethodName, Object[] parms, Object[]& exportInfolog)



Qsn: 1. Why I am not able to perform Credit Note? What i should do to perform credit note? Any suggestions?

Qsn 2: Do i have any options other than Creating another salesorder with -ve quantity and performing invoice for Project? 

7444.sd.PNG

*This post is locked for comments

  • Suggested answer
    DynamicsAXExplorer Profile Picture
    DynamicsAXExplorer 415 on at
    RE: No transaction exists that can be selected for credit note. AX 2012 R2 Project Credit Note

    Hi ,

    We are able to figure it out why this is happening for this order.

    After debugging the code from error log as shown above.

    SalesCopying_CreditNote.Updateinvoicecreditcopy   -In this method there is a line of code where its checking Stocked Product or not.

    So when i debugged -  For one of the items its finding it as stocked product  - which is a service item when original sales order is created.

    Looks like one of the users/some process changed the Item model group from Service to Inventory item.

    So when i am trying to perform credit note, its picking it as stocked item and its checking code for inventory transactions and throwing error from this method InventTransInvoice.updateDimensionsFromInvoice.

  • DynamicsAXExplorer Profile Picture
    DynamicsAXExplorer 415 on at
    RE: No transaction exists that can be selected for credit note. AX 2012 R2 Project Credit Note

    @DNAU, 

    Thanks for the info.

    I selected one of the Lines on that Project Sales order. I did what you said. I can see on the Sales Tab > Transaction Status is Invoiced. As per what you should if its one of those 3 statuses, it should show up. But i am not sure why this is not showing up. 

    Also when i keep debugger at the place you mentioned, it didnt hit that breakpoint. And when i debug, its hitting this method [s] \Classes\ProjReverseMarking\getTransFromJournals and its not getting inside any of those while loops as there are no records in any of the tables i guess. 

    Any suggestions?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: No transaction exists that can be selected for credit note. AX 2012 R2 Project Credit Note

    Hi,

    You are on a very old AX version and what you see might the result of a bug that has been fixed in the meantime. So, what you can do is having a look at LCS whether a hotfix exists.

    To get this issue fixed quickly this hotfix won't probably help as it always takes a while to implement, test, use it.

    So the best and probably fastest workaround is what you describe under No 2. Create things manually especially if the wrong project customer has been selected.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: No transaction exists that can be selected for credit note. AX 2012 R2 Project Credit Note

    What is the status of the project item transaction sales record?  It has to be Selected For Credit Note, Invoiced, or Credit Note Proposal to be available for selecting as credit note.

    To find out, right-click the Transaction Id in the item row of interest and select View Details.  In the Item Transactions form that comes up, find and select the row for the transaction of interest (the Transaction Id was not in my grid; seems weird.  Anyway, I personalized it into the grid).  Then activate the Sales tab above the grid and check the Transaction Status.

    PS: To populate the temp table with item transactions to select for credit note, a call is made to ProjReverseMarking::canAddTrans(projItemTransSale.TransStatus), and if the status is not one of the above 3, then the item transaction is not available for selecting for credit note and its not added to the temp table.  If at the end there are no rows in the temp table, the message you received is shown: "No transaction exists that can be selected for credit note".

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans