Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Oversettled Inventory Transactions after closing

85 views
Skip to first unread message

AQL

unread,
Jan 28, 2010, 7:51:01 AM1/28/10
to
Hello all,

All the stock is valued by Weighted average cost date and we have run the
inventory closing routine on AX4 SP2 with hotfix (4.0.2503.636)

After that some surprising stock values appeared for a few items: positive
quantities (hundreds) and negative values (thousands of euros).

As we were working on a copy of the production environment, we restored the
data, made manual settlements to those items using the standard functions and
run inventory closing again. The second time, the itens kept the positive
quantities but the negative values was even higher (millions).

Looking into the inventrans we have found that all these items have at least
one transaction with
1) positive quantity settled > positive quantity or
2) negative quantity settled < negative quantity

As far as I understand this should never happen... Have you ever experienced
this? All suggestions are welcome...

Best regards,
--
AQL

Eddie Josling

unread,
Jan 28, 2010, 10:31:01 AM1/28/10
to
Hi, I assume that you are referring to financial values (posted quantities)?
Just for clarity, do you see this by inventory dimension, for all or both?
What is the settings regarding physical values on the model group(s)?

Eddie

AQL

unread,
Jan 28, 2010, 2:02:06 PM1/28/10
to
Hi Eddie,

Yes I am refering to the financial values provided by the "Status>Stock
Value" report. We have positive quantities and negative value after the
closing.

All invent. model group have - and always have had - the "include physical
value" option off. (not sure if that is what you wanted).

The values are visible both on total and per stock dimension. We do not
calculate the average cost price per stock dimension.

Besides that we have thousands of itens and this oversettlement is hapening
in just a few cases (raw materials mostly). Off course that the diference
value is already very high and will problably influence the cost of the
finished products.

We have detected the inventory transaction oversettlement in those itens -
which is also detected by the consistency check tool - but we have been
unable to correct that (still working on that).

Have you ever found a situation like that oversettlement?

Thanks for your help!
--
AQL

Eddie Josling

unread,
Feb 1, 2010, 8:35:01 AM2/1/10
to
Hi
As far as the postive qty's and negative values are concern, I have only
seen this in a standard (fixed receipt price) cost environment - as this can
easily happen. I'm also not aware of a situation where a "over settlement"
occurred on inventory transactions.

My questions:
1. This over settlements - does this occur during one close or as a result
of multiple closes?
2. Do you use any marking?
3. You've mentioned that you have made manual settlements to those
transactions - how?
4. If you look at the settlements for this particular item, what is the
settlement type?

Sorry for all the questions, but I'm trying to replicate this but thus far
did not succeed. I would really like to know why this can happen...

Eddie

Eddie Josling

unread,
Feb 15, 2010, 1:35:01 AM2/15/10
to
Hi

Since the last post, I actually investigated a similar problem at a live
site. In their instance, we experienced the same scenario as you have
explained and by investigation, I found two things:
1. As we cancelled recalcs and closing, we encountered a error saying:
"Could not delete a weighted average inventory closing transaction on item on
[date]". We found this to be Ax bug and MS provided a hotfix as well as a
job to delete these. This was because oversettlements occur on these
transactions.
2. I believe also that some of these positive qty, negative financial values
was occurring as a direct result of the "Include physical value" setting on
the model group. As the client has fairly long production lead times, many
production orders are still open, but the goods are shipped (transferred) and
then sold. We found evidence that by combining the negative financial values
(posted qty and value) with the positive physical values lead to some
inflated ave costs, thus creating inflated issue costs.

We will be testing this fix today. If we can provide me with your e-mail
address I can forward you the reply from MS, alternatively you can have a
look on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4).

Eddie

johnnyshen

unread,
Mar 9, 2010, 10:57:13 PM3/9/10
to
Hi Eddie,

Thanks for your good information. Could you please check the article number KB 9651215 as I could not find in partnersource?

Best regards,
Johnny

Eddie Josling wrote:

HiSince the last post, I actually investigated a similar problem at a livesite.
15-Feb-10

Hi

Since the last post, I actually investigated a similar problem at a live
site. In their instance, we experienced the same scenario as you have
explained and by investigation, I found two things:
1. As we cancelled recalcs and closing, we encountered a error saying:
"Could not delete a weighted average inventory closing transaction on item on
[date]". We found this to be Ax bug and MS provided a hotfix as well as a
job to delete these. This was because oversettlements occur on these
transactions.
2. I believe also that some of these positive qty, negative financial values
was occurring as a direct result of the "Include physical value" setting on
the model group. As the client has fairly long production lead times, many
production orders are still open, but the goods are shipped (transferred) and
then sold. We found evidence that by combining the negative financial values
(posted qty and value) with the positive physical values lead to some
inflated ave costs, thus creating inflated issue costs.

We will be testing this fix today. If we can provide me with your e-mail
address I can forward you the reply from MS, alternatively you can have a
look on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4).

Eddie

"Eddie Josling" wrote:

Previous Posts In This Thread:

On Thursday, January 28, 2010 7:51 AM
AQL wrote:

Oversettled Inventory Transactions after closing
Hello all,

All the stock is valued by Weighted average cost date and we have run the
inventory closing routine on AX4 SP2 with hotfix (4.0.2503.636)

After that some surprising stock values appeared for a few items: positive
quantities (hundreds) and negative values (thousands of euros).

As we were working on a copy of the production environment, we restored the
data, made manual settlements to those items using the standard functions and
run inventory closing again. The second time, the itens kept the positive
quantities but the negative values was even higher (millions).

Looking into the inventrans we have found that all these items have at least
one transaction with
1) positive quantity settled > positive quantity or
2) negative quantity settled < negative quantity

As far as I understand this should never happen... Have you ever experienced
this? All suggestions are welcome...

Best regards,
--
AQL

On Thursday, January 28, 2010 10:31 AM
Eddie Josling wrote:

Hi, I assume that you are referring to financial values (posted quantities)?
Hi, I assume that you are referring to financial values (posted quantities)?
Just for clarity, do you see this by inventory dimension, for all or both?
What is the settings regarding physical values on the model group(s)?

Eddie

"AQL" wrote:

On Thursday, January 28, 2010 2:02 PM
AQL wrote:

Hi Eddie,Yes I am refering to the financial values provided by the
Hi Eddie,

Yes I am refering to the financial values provided by the "Status>Stock
Value" report. We have positive quantities and negative value after the
closing.

All invent. model group have - and always have had - the "include physical
value" option off. (not sure if that is what you wanted).

The values are visible both on total and per stock dimension. We do not
calculate the average cost price per stock dimension.

Besides that we have thousands of itens and this oversettlement is hapening
in just a few cases (raw materials mostly). Off course that the diference
value is already very high and will problably influence the cost of the
finished products.

We have detected the inventory transaction oversettlement in those itens -
which is also detected by the consistency check tool - but we have been
unable to correct that (still working on that).

Have you ever found a situation like that oversettlement?

Thanks for your help!
--
AQL


"Eddie Josling" wrote:

On Monday, February 01, 2010 8:35 AM
Eddie Josling wrote:

HiAs far as the postive qty's and negative values are concern, I have onlyseen


Hi
As far as the postive qty's and negative values are concern, I have only
seen this in a standard (fixed receipt price) cost environment - as this can

easily happen. I am also not aware of a situation where a "over settlement"
occurred on inventory transactions.

My questions:
1. This over settlements - does this occur during one close or as a result
of multiple closes?
2. Do you use any marking?
3. You've mentioned that you have made manual settlements to those
transactions - how?
4. If you look at the settlements for this particular item, what is the
settlement type?

Sorry for all the questions, but I am trying to replicate this but thus far


did not succeed. I would really like to know why this can happen...

Eddie

"AQL" wrote:

On Monday, February 15, 2010 1:35 AM
Eddie Josling wrote:

HiSince the last post, I actually investigated a similar problem at a livesite.
Hi

Since the last post, I actually investigated a similar problem at a live
site. In their instance, we experienced the same scenario as you have
explained and by investigation, I found two things:
1. As we cancelled recalcs and closing, we encountered a error saying:
"Could not delete a weighted average inventory closing transaction on item on
[date]". We found this to be Ax bug and MS provided a hotfix as well as a
job to delete these. This was because oversettlements occur on these
transactions.
2. I believe also that some of these positive qty, negative financial values
was occurring as a direct result of the "Include physical value" setting on
the model group. As the client has fairly long production lead times, many
production orders are still open, but the goods are shipped (transferred) and
then sold. We found evidence that by combining the negative financial values
(posted qty and value) with the positive physical values lead to some
inflated ave costs, thus creating inflated issue costs.

We will be testing this fix today. If we can provide me with your e-mail
address I can forward you the reply from MS, alternatively you can have a
look on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4).

Eddie

"Eddie Josling" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
What's New for Developers in SharePoint 2010 Object Model?
http://www.eggheadcafe.com/tutorials/aspnet/84e8403e-a25c-49b7-a0d8-3e2773fa29b5/whats-new-for-developers.aspx

johnnyshen

unread,
Mar 9, 2010, 11:02:56 PM3/9/10
to
Hi Eddie,

I could not find on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4). Could you please help to check the number and give a link for that information. Thanks.

Best regards,
Johnny

Eddie Josling wrote:

HiSince the last post, I actually investigated a similar problem at a livesite.
15-Feb-10

Hi

Since the last post, I actually investigated a similar problem at a live
site. In their instance, we experienced the same scenario as you have
explained and by investigation, I found two things:
1. As we cancelled recalcs and closing, we encountered a error saying:
"Could not delete a weighted average inventory closing transaction on item on
[date]". We found this to be Ax bug and MS provided a hotfix as well as a
job to delete these. This was because oversettlements occur on these
transactions.
2. I believe also that some of these positive qty, negative financial values
was occurring as a direct result of the "Include physical value" setting on
the model group. As the client has fairly long production lead times, many
production orders are still open, but the goods are shipped (transferred) and
then sold. We found evidence that by combining the negative financial values
(posted qty and value) with the positive physical values lead to some
inflated ave costs, thus creating inflated issue costs.

We will be testing this fix today. If we can provide me with your e-mail
address I can forward you the reply from MS, alternatively you can have a
look on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4).

Eddie

"Eddie Josling" wrote:

Previous Posts In This Thread:

On Thursday, January 28, 2010 7:51 AM
AQL wrote:

Oversettled Inventory Transactions after closing

Hello all,

All the stock is valued by Weighted average cost date and we have run the
inventory closing routine on AX4 SP2 with hotfix (4.0.2503.636)

After that some surprising stock values appeared for a few items: positive
quantities (hundreds) and negative values (thousands of euros).

As we were working on a copy of the production environment, we restored the
data, made manual settlements to those items using the standard functions and
run inventory closing again. The second time, the itens kept the positive
quantities but the negative values was even higher (millions).

Looking into the inventrans we have found that all these items have at least
one transaction with
1) positive quantity settled > positive quantity or
2) negative quantity settled < negative quantity

As far as I understand this should never happen... Have you ever experienced
this? All suggestions are welcome...

Best regards,
--
AQL

On Thursday, January 28, 2010 10:31 AM
Eddie Josling wrote:

Hi, I assume that you are referring to financial values (posted quantities)?
Hi, I assume that you are referring to financial values (posted quantities)?
Just for clarity, do you see this by inventory dimension, for all or both?
What is the settings regarding physical values on the model group(s)?

Eddie

"AQL" wrote:

On Thursday, January 28, 2010 2:02 PM
AQL wrote:

Hi Eddie,Yes I am refering to the financial values provided by the
Hi Eddie,

Yes I am refering to the financial values provided by the "Status>Stock
Value" report. We have positive quantities and negative value after the
closing.

All invent. model group have - and always have had - the "include physical
value" option off. (not sure if that is what you wanted).

The values are visible both on total and per stock dimension. We do not
calculate the average cost price per stock dimension.

Besides that we have thousands of itens and this oversettlement is hapening
in just a few cases (raw materials mostly). Off course that the diference
value is already very high and will problably influence the cost of the
finished products.

We have detected the inventory transaction oversettlement in those itens -
which is also detected by the consistency check tool - but we have been
unable to correct that (still working on that).

Have you ever found a situation like that oversettlement?

Thanks for your help!
--
AQL


"Eddie Josling" wrote:

On Monday, February 01, 2010 8:35 AM
Eddie Josling wrote:

HiAs far as the postive qty's and negative values are concern, I have onlyseen


Hi
As far as the postive qty's and negative values are concern, I have only
seen this in a standard (fixed receipt price) cost environment - as this can

easily happen. I am also not aware of a situation where a "over settlement"
occurred on inventory transactions.

My questions:
1. This over settlements - does this occur during one close or as a result
of multiple closes?
2. Do you use any marking?
3. You've mentioned that you have made manual settlements to those
transactions - how?
4. If you look at the settlements for this particular item, what is the
settlement type?

Sorry for all the questions, but I am trying to replicate this but thus far


did not succeed. I would really like to know why this can happen...

Eddie

"AQL" wrote:

On Monday, February 15, 2010 1:35 AM
Eddie Josling wrote:

HiSince the last post, I actually investigated a similar problem at a livesite.
Hi

Since the last post, I actually investigated a similar problem at a live
site. In their instance, we experienced the same scenario as you have
explained and by investigation, I found two things:
1. As we cancelled recalcs and closing, we encountered a error saying:
"Could not delete a weighted average inventory closing transaction on item on
[date]". We found this to be Ax bug and MS provided a hotfix as well as a
job to delete these. This was because oversettlements occur on these
transactions.
2. I believe also that some of these positive qty, negative financial values
was occurring as a direct result of the "Include physical value" setting on
the model group. As the client has fairly long production lead times, many
production orders are still open, but the goods are shipped (transferred) and
then sold. We found evidence that by combining the negative financial values
(posted qty and value) with the positive physical values lead to some
inflated ave costs, thus creating inflated issue costs.

We will be testing this fix today. If we can provide me with your e-mail
address I can forward you the reply from MS, alternatively you can have a
look on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4).

Eddie

"Eddie Josling" wrote:

On Tuesday, March 09, 2010 10:57 PM
johnny shen wrote:

Could not find the KB article 9651215 for AX4
Hi Eddie,

Thanks for your good information. Could you please check the article number KB 9651215 as I could not find in partnersource?

Best regards,
Johnny

On Tuesday, March 09, 2010 11:00 PM
johnny shen wrote:

Could not find the KB 9651215 for AX4
Hi Eddie,

I could not find the number of KB ARTICLE 9651215 on partnersource and customersource, could you please help check or give me link on that KB information. Thanks a lot.

Best regards,
Johnny


Submitted via EggHeadCafe - Software Developer Portal of Choice

Join Lists with LINQ - SharePoint 2010
http://www.eggheadcafe.com/tutorials/aspnet/b0c1cd0d-fe82-444e-a16e-7d3fb7d38eca/join-lists-with-linq--sh.aspx

johnnyshen

unread,
Mar 9, 2010, 11:00:59 PM3/9/10
to
Hi Eddie,

I could not find the number of KB ARTICLE 9651215 on partnersource and customersource, could you please help check or give me link on that KB information. Thanks a lot.

Best regards,
Johnny

Eddie Josling wrote:

HiSince the last post, I actually investigated a similar problem at a livesite.
15-Feb-10

Hi

Since the last post, I actually investigated a similar problem at a live
site. In their instance, we experienced the same scenario as you have
explained and by investigation, I found two things:
1. As we cancelled recalcs and closing, we encountered a error saying:
"Could not delete a weighted average inventory closing transaction on item on
[date]". We found this to be Ax bug and MS provided a hotfix as well as a
job to delete these. This was because oversettlements occur on these
transactions.
2. I believe also that some of these positive qty, negative financial values
was occurring as a direct result of the "Include physical value" setting on
the model group. As the client has fairly long production lead times, many
production orders are still open, but the goods are shipped (transferred) and
then sold. We found evidence that by combining the negative financial values
(posted qty and value) with the positive physical values lead to some
inflated ave costs, thus creating inflated issue costs.

We will be testing this fix today. If we can provide me with your e-mail
address I can forward you the reply from MS, alternatively you can have a
look on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4).

Eddie

"Eddie Josling" wrote:

Previous Posts In This Thread:

On Thursday, January 28, 2010 7:51 AM
AQL wrote:

Oversettled Inventory Transactions after closing

Hello all,

All the stock is valued by Weighted average cost date and we have run the
inventory closing routine on AX4 SP2 with hotfix (4.0.2503.636)

After that some surprising stock values appeared for a few items: positive
quantities (hundreds) and negative values (thousands of euros).

As we were working on a copy of the production environment, we restored the
data, made manual settlements to those items using the standard functions and
run inventory closing again. The second time, the itens kept the positive
quantities but the negative values was even higher (millions).

Looking into the inventrans we have found that all these items have at least
one transaction with
1) positive quantity settled > positive quantity or
2) negative quantity settled < negative quantity

As far as I understand this should never happen... Have you ever experienced
this? All suggestions are welcome...

Best regards,
--
AQL

On Thursday, January 28, 2010 10:31 AM
Eddie Josling wrote:

Hi, I assume that you are referring to financial values (posted quantities)?
Hi, I assume that you are referring to financial values (posted quantities)?
Just for clarity, do you see this by inventory dimension, for all or both?
What is the settings regarding physical values on the model group(s)?

Eddie

"AQL" wrote:

On Thursday, January 28, 2010 2:02 PM
AQL wrote:

Hi Eddie,Yes I am refering to the financial values provided by the
Hi Eddie,

Yes I am refering to the financial values provided by the "Status>Stock
Value" report. We have positive quantities and negative value after the
closing.

All invent. model group have - and always have had - the "include physical
value" option off. (not sure if that is what you wanted).

The values are visible both on total and per stock dimension. We do not
calculate the average cost price per stock dimension.

Besides that we have thousands of itens and this oversettlement is hapening
in just a few cases (raw materials mostly). Off course that the diference
value is already very high and will problably influence the cost of the
finished products.

We have detected the inventory transaction oversettlement in those itens -
which is also detected by the consistency check tool - but we have been
unable to correct that (still working on that).

Have you ever found a situation like that oversettlement?

Thanks for your help!
--
AQL


"Eddie Josling" wrote:

On Monday, February 01, 2010 8:35 AM
Eddie Josling wrote:

HiAs far as the postive qty's and negative values are concern, I have onlyseen


Hi
As far as the postive qty's and negative values are concern, I have only
seen this in a standard (fixed receipt price) cost environment - as this can

easily happen. I am also not aware of a situation where a "over settlement"
occurred on inventory transactions.

My questions:
1. This over settlements - does this occur during one close or as a result
of multiple closes?
2. Do you use any marking?
3. You've mentioned that you have made manual settlements to those
transactions - how?
4. If you look at the settlements for this particular item, what is the
settlement type?

Sorry for all the questions, but I am trying to replicate this but thus far


did not succeed. I would really like to know why this can happen...

Eddie

"AQL" wrote:

On Monday, February 15, 2010 1:35 AM
Eddie Josling wrote:

HiSince the last post, I actually investigated a similar problem at a livesite.
Hi

Since the last post, I actually investigated a similar problem at a live
site. In their instance, we experienced the same scenario as you have
explained and by investigation, I found two things:
1. As we cancelled recalcs and closing, we encountered a error saying:
"Could not delete a weighted average inventory closing transaction on item on
[date]". We found this to be Ax bug and MS provided a hotfix as well as a
job to delete these. This was because oversettlements occur on these
transactions.
2. I believe also that some of these positive qty, negative financial values
was occurring as a direct result of the "Include physical value" setting on
the model group. As the client has fairly long production lead times, many
production orders are still open, but the goods are shipped (transferred) and
then sold. We found evidence that by combining the negative financial values
(posted qty and value) with the positive physical values lead to some
inflated ave costs, thus creating inflated issue costs.

We will be testing this fix today. If we can provide me with your e-mail
address I can forward you the reply from MS, alternatively you can have a
look on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4).

Eddie

"Eddie Josling" wrote:

On Tuesday, March 09, 2010 10:57 PM
johnny shen wrote:

Could not find the KB article 9651215 for AX4
Hi Eddie,

Thanks for your good information. Could you please check the article number KB 9651215 as I could not find in partnersource?

Best regards,
Johnny


Submitted via EggHeadCafe - Software Developer Portal of Choice

BizTalk Configure and Send SMTP Mail Based on Message Within an Orchestration
http://www.eggheadcafe.com/tutorials/aspnet/4e9e7c92-1279-4fdb-8631-a2f309a021c2/biztalk-configure-and-sen.aspx

kaylee

unread,
May 15, 2010, 1:21:23 PM5/15/10
to
toyyoytyo tri

"Eddie Josling" <EddieJ...@discussions.microsoft.com> wrote in message
news:65D2B329-EB6C-4D7A...@microsoft.com...

Michael Furness

unread,
Apr 28, 2011, 7:53:04 AM4/28/11
to
Eddie, I am looking at this forum as well as the knowledge base article on Microsoft and I can't seem to find the job to delete these items. All the knowledge base article says to run in the consistency check but this does not delete the weighted average transactions that should have been deleted previously.

> On Thursday, January 28, 2010 7:51 AM AQL wrote:

> Hello all,
>
> All the stock is valued by Weighted average cost date and we have run the
> inventory closing routine on AX4 SP2 with hotfix (4.0.2503.636)
>
> After that some surprising stock values appeared for a few items: positive
> quantities (hundreds) and negative values (thousands of euros).
>
> As we were working on a copy of the production environment, we restored the
> data, made manual settlements to those items using the standard functions and
> run inventory closing again. The second time, the itens kept the positive
> quantities but the negative values was even higher (millions).
>
> Looking into the inventrans we have found that all these items have at least
> one transaction with
> 1) positive quantity settled > positive quantity or
> 2) negative quantity settled < negative quantity
>
> As far as I understand this should never happen... Have you ever experienced
> this? All suggestions are welcome...
>
> Best regards,
> --
> AQL


>> On Thursday, January 28, 2010 10:31 AM Eddie Josling wrote:

>> Hi, I assume that you are referring to financial values (posted quantities)?
>> Just for clarity, do you see this by inventory dimension, for all or both?
>> What is the settings regarding physical values on the model group(s)?
>>
>> Eddie
>>
>> "AQL" wrote:


>>> On Thursday, January 28, 2010 2:02 PM AQL wrote:

>>> Hi Eddie,
>>>
>>> Yes I am refering to the financial values provided by the "Status>Stock
>>> Value" report. We have positive quantities and negative value after the
>>> closing.
>>>
>>> All invent. model group have - and always have had - the "include physical
>>> value" option off. (not sure if that is what you wanted).
>>>
>>> The values are visible both on total and per stock dimension. We do not
>>> calculate the average cost price per stock dimension.
>>>
>>> Besides that we have thousands of itens and this oversettlement is hapening
>>> in just a few cases (raw materials mostly). Off course that the diference
>>> value is already very high and will problably influence the cost of the
>>> finished products.
>>>
>>> We have detected the inventory transaction oversettlement in those itens -
>>> which is also detected by the consistency check tool - but we have been
>>> unable to correct that (still working on that).
>>>
>>> Have you ever found a situation like that oversettlement?
>>>
>>> Thanks for your help!
>>> --
>>> AQL
>>>
>>>
>>> "Eddie Josling" wrote:


>>>> On Monday, February 01, 2010 8:35 AM Eddie Josling wrote:

>>>> Hi
>>>> As far as the postive qty's and negative values are concern, I have only
>>>> seen this in a standard (fixed receipt price) cost environment - as this can

>>>> easily happen. I am also not aware of a situation where a "over settlement"


>>>> occurred on inventory transactions.
>>>>
>>>> My questions:
>>>> 1. This over settlements - does this occur during one close or as a result
>>>> of multiple closes?
>>>> 2. Do you use any marking?
>>>> 3. You've mentioned that you have made manual settlements to those
>>>> transactions - how?
>>>> 4. If you look at the settlements for this particular item, what is the
>>>> settlement type?
>>>>

>>>> Sorry for all the questions, but I am trying to replicate this but thus far


>>>> did not succeed. I would really like to know why this can happen...
>>>>
>>>> Eddie
>>>>
>>>>
>>>>
>>>> "AQL" wrote:


>>>>> On Monday, February 15, 2010 1:35 AM Eddie Josling wrote:

>>>>> Hi
>>>>>
>>>>> Since the last post, I actually investigated a similar problem at a live
>>>>> site. In their instance, we experienced the same scenario as you have
>>>>> explained and by investigation, I found two things:
>>>>> 1. As we cancelled recalcs and closing, we encountered a error saying:
>>>>> "Could not delete a weighted average inventory closing transaction on item on
>>>>> [date]". We found this to be Ax bug and MS provided a hotfix as well as a
>>>>> job to delete these. This was because oversettlements occur on these
>>>>> transactions.
>>>>> 2. I believe also that some of these positive qty, negative financial values
>>>>> was occurring as a direct result of the "Include physical value" setting on
>>>>> the model group. As the client has fairly long production lead times, many
>>>>> production orders are still open, but the goods are shipped (transferred) and
>>>>> then sold. We found evidence that by combining the negative financial values
>>>>> (posted qty and value) with the positive physical values lead to some
>>>>> inflated ave costs, thus creating inflated issue costs.
>>>>>
>>>>> We will be testing this fix today. If we can provide me with your e-mail
>>>>> address I can forward you the reply from MS, alternatively you can have a
>>>>> look on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4).
>>>>>
>>>>> Eddie
>>>>>
>>>>> "Eddie Josling" wrote:


>>>>>> On Tuesday, March 09, 2010 10:57 PM johnny shen wrote:

>>>>>> Hi Eddie,
>>>>>>
>>>>>>
>>>>>>
>>>>>> Thanks for your good information. Could you please check the article number KB 9651215 as I could not find in partnersource?
>>>>>>
>>>>>>
>>>>>>
>>>>>> Best regards,
>>>>>>
>>>>>> Johnny

>>>>>>> On Tuesday, March 09, 2010 11:00 PM johnny shen wrote:

>>>>>>> Hi Eddie,
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> I could not find the number of KB ARTICLE 9651215 on partnersource and customersource, could you please help check or give me link on that KB information. Thanks a lot.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Best regards,
>>>>>>>
>>>>>>> Johnny


>>>>>>>> On Tuesday, March 09, 2010 11:02 PM johnny shen wrote:

>>>>>>>> Hi Eddie,
>>>>>>>>
>>>>>>>>
>>>>>>>>

>>>>>>>> I could not find on partnersource for KB article 973239 (ax2009) or 9651215 (ax 4). Could you please help to check the number and give a link for that information. Thanks.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Best regards,
>>>>>>>>
>>>>>>>> Johnny


>>>>>>>>> On Saturday, May 15, 2010 1:21 PM kaylee wrote:

>>>>>>>>> toyyoytyo tri

0 new messages