MARKED TRANSACTION IN OPEN QUANTITY REPORT (INVENTORY CLOSING PROCEDURE)

Finance and Operations/AX User Forum
1

Hi All,

As a part of the inventory closing procedure, i run the open quantities report. There is one item on the report with specification as ‘MARKED TRANSACTION’ with a reference to an open Purchase Order. What does it mean? I checked the PO and the item line that the report is referring to is already invoiced.

Thanks to those who would help.

Heylin

2

Does anyone knows what MARKED TRANSACTION in this scenario means?

3

Is it a direct delivery meaning the sales and purchase costs are directly linked? This is termed as a marked delivery, not sure if it is in the inventory close.

4

Hi Adam

This is not a direct delivery.

Heylin

5

Then you need to look at the transaction and its source and any demand being pulled on it along with item group settings, dimension group settings and try to figure out why it is flagged as it is.

6

Heylin,

Have you found the answer to your question yet? I just ran into that specification on the open quantity report - and I am going to close the month tonight.

Thanks,

Hank

7

Hi Hank,

Have you checked the PO with that specification? Is it invoiced already?

8

Yes, I did. Some of the specifications have a related PO listed on the report but some are just one line with the item only. In all cases the PO has been invoiced.

I saw another blog mentioning that the Marked Transaction specification can show up because a closing has run between a marked receipt and the issue transaction. That seems to be the case with most (but not all) of the items with that specification on our Open Quantity report.

For example, one item was brought in on a PO, was sold on a Sales Order and then returned using a credit note on the Sales Order all in August. Then the item was returned to the vendor on a PO in January, two days after the month-end closing ran. Have you seen similar results in your case?

I am moving our production data into a test evironment to see if there are any problems with closing when items are specified as Marked Transactions. Did you face any issues?

Thanks for the reply!

9

Can you share that blog URL ?

10

It actually was referring to AX 4.0 but it looks like it may be applicable to 2009 as well.

Here is the URL: http://msdn.microsoft.com/en-us/library/aa571536(v=ax.10).aspx

The reference to Marked Transactions is in the third paragraph.