One intercompany sales order, two invoices. Dynamics AX 2012

This one’s really simple, but had me foxed for a few minutes.

The scenario goes like this. You create an intercompany purchase order. The supply company ships and invoices multiple deliveries.

Everything works just fine if you have time to post the purchase order product receipts and invoices before you post the second sales order delivery note / invoice.

As usual I’ve set this up in the Dynamics AX demo hyper-v image. I’ve created and confirmed a simple intercompany purchase order in the DEMF company (the sales order is in the USMF company):

In the supply company I’ve delivered and invoiced the first sales order line.

I need to post a product receipt against the purchase order – and although the Product receipt posting form pre-loads the sales order delivery note number …

… there’s no easy way to set the appropriate partial receipt quantity. I’m just going to use the Lines tab:

Here, I’ve deleted the purchase order line that hasn’t been delivered. Below, I’m just setting the product receipt quantities manually. But I have worked with a company who used intercompany orders extensively and they had a modification on the purchase order that would retrieve a sales order delivery note from the supply company, and set the ‘Receive now’ quantity on the purchase order lines appropriately.

So, now I’m ready to post the purchase order product receipt – and then the invoice:

This [first] purchase order invoice is setup to post correctly – the invoice number, delivery note number, and invoice amounts have all defaulted correctly – all I have to do is click the ‘Post’ button.

I’ll just pop back to the sales order I’ll post the remainder of the sales order delivery, and create another invoice.

When I post the second product receipt on the purchase order the system still defaults the Product receipt delivery note number – and helpfully it’s showing the correct one:

Just to be clear – on the sales order we can see we have two delivery notes:

Anyway – post the purchase order product receipt, and then post the invoice.

Once again the system’s defaulting the Invoice number, Delivery note number and Invoice total:

But as I said in the introduction, the scenario above isn’t actually a realistic one. What happens if you have multiple sales order delivery notes / invoices posted before you receive any products against the purchase order?. In this example I’ve posted three sales order delivery notes:

And three corresponding sales order invoices:

But I haven’t yet done any product receipts on my purchase order. When I start to do product receipts the system defaults one of the delivery note numbers – but it’s not necessarily the one I want:

In this case you have to manually enter the delivery note number (and of course set the appropriate receipt quantities on the Lines tab). Then post the product receipt.

Next we’re going to post the purchase order invoice – and just to reprise, here are the sales order invoices:

Now let’s try to post the invoice for the first sales order delivery note / purchase order product receipt:

Everything has defaulted through correctly – except that the system’s defaulted the wrong sales order invoice number. Posting gives this error:

That’s pretty scary – but fortunately the fix is simplicity itself. All that has gone wrong is that the system’s defaulted the wrong sales order invoice number – let’s try again, and this time, manually set the invoice number to match the quantities / amounts on the purchase order invoice:

Success:

That’s pretty neat.

Advertisements

Hide planned order capacity reservations in Dynamics AX 2012

When we’re looking at production orders, and scheduling routes, we’re going to look at capacity reservations by work centre (resource) or resource group. It’s interesting that these inquiries show capacity reservations from planned production orders as well as production order.

For instance, Organisation administration > Common > Resources > Resource groups > View > Capacity reservations:

Every so often we’re asked if we can just show reservations from production orders.

There are two ways you can accomplish this. One way is to setup master planning so that it doesn’t create capacity reservations for planned production orders. Planned production orders only use the active route to schedule capacity reservations, (and to determine their lead time) inside the capacity time fence. Outside of the capacity time fence the inventory lead time is used as the planned production order lead time, and capacity reservations are not created. So, if you setup your master plan like this:

That’s with Capacity time fence = zero. Run master planning you’ll find that the capacity reservations for planned production orders have disappeared:

Unfortunately, we’ve thrown a baby out with the bath water. Now we can’t use any of the capacity reservation inquires for Rough Cut Capacity Planning. For instance, one of my favourite inquires, Master planning > Inquires > Statistics > Capacity requirement statistics, is now a shadow of its former self. With a capacity time fence of zero you see something like:

Whereas you could be seeing something more useful like:

So let’s try an alternative method.

Create a master plan called ‘NONE’:

I don’t ever intend to run master scheduling on this plan, but just to make it obvious, I’ve set zero time fences on each option, including of course the Capacity time fence.

Now on our resource capacity inquiry our normal plan shows capacity reservations from planned production orders:

But if we just want to see reservations from production orders we simply have to choose the ‘NONE’ plan:

And obviously the same trick works on the capacity load inquiry too:

And the NONE plan:

A pretty good example of “now you see it – now you don’t”.

I headed this blog “… in AX 2012” because I’m pretty sure that this works in all versions of AX 2012 – but when we first tried this (on AX 2009) there was a bug in the Capacity load inquiry form – so if you’re on an old version of AX you might need a fix.