Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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.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?
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".
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.
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.
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.
Business Applications communities