Updating Sales Order SalesType from "Journal" to "Order" via AIF

(0) Share

Report

Posted on by Community Member

Hello!

I am using an inbound AIF port to submit sales orders from our customer portal. Until these orders have been confirmed by sales staff, they sit in AX as "journal" type.

However, I am currently unable to update these orders through the AIF into full Sales Orders.

Here's an example update request - you can see I am only updating the SalesType field:

<soap:Envelope xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:wsdl="schemas.microsoft.com/.../services" xmlns:soap="schemas.xmlsoap.org/.../envelope">
	<soap:Body>
		<wsdl:SalesOrderServiceUpdateRequest>
			<EntityKeyList xmlns="schemas.microsoft.com/.../EntityKeyList">
				<EntityKey xmlns="schemas.microsoft.com/.../EntityKey">
					<KeyData>
						<KeyField>
							<Field>SalesId</Field>
							<Value>SO00000701</Value>
						</KeyField>
					</KeyData>
				</EntityKey>
			</EntityKeyList>
			<SalesOrder xmlns="schemas.microsoft.com/.../SalesOrder">
				<SalesTable class="entity" action="update">
					<_DocumentHash>c41d3f24ee53eca811402fa6b8129b82</_DocumentHash>
					<SalesType>Sales</SalesType>
				</SalesTable>
			</SalesOrder>
		</wsdl:SalesOrderServiceUpdateRequest>
	</soap:Body>
</soap:Envelope>

The Inbound document is received but nothing is updated. I have successfully updated other fields, but cannot update the SalesType field.

Just for posterity's sake - I manually updated an example order to Sales Order in the AX GUI and also attempted to change it to Journal type using AIF - and received the same result. No go.

What am I missing?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Mea_ 60,284 on at

Like (1)

Report

Hey ERiley,

If you already have another SO with same CustAccount and PurchOrderFormNum AIF will set order type to journal.

Also if SO invoice account is not equal to customer invoice account AIF will update SO type to journal.

You can put breakpoint in AxdSalesOrder.prepareSalesTable() to see if you are hitting this conditions.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ievgen,

Would that still apply if I am trying to **update** an existing order? I am not trying to create a new one with the same info, simply update in place.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Yep, from update or create.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I can swap the SalesType in the GUI without a problem, though.

And it doesn't let me update the PO # along with the order type because any request containing SalesType fails.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

This logic exists only for AIF. Did you check if you have another order that meet criteria I described in previous post ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I updated to a completely random PO # and tried again, same result :(

The Fields CustAccount and InvoiceAccount are also the same (they match).

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

You always can try to debug :)

technet.microsoft.com/.../jj710372.aspx

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

For anyone else attempting this, DON'T.

There's apparently a very good reason that AX doesn't readily allow the transition of orders from Journal to Sales orders without other processing.

We found a workaround to make this transition happen based on another field and a batch job, but when we did so it only updated the type in the order header (which meant the lines could not be worked on in the warehouse). It also did not create the necessary inventory transactions to reserve or allocate inventory.

Figure out a different way to hold orders if you need to.

We changed to using the "MCROrderStopped" parameter.

Was this reply helpful? Yes No

Community site session details

Updating Sales Order SalesType from "Journal" to "Order" via AIF

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Updating Sales Order SalesType from "Journal" to "Order" via AIF

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates