Discussion:
Inventory Closing AX2009
(too old to reply)
M.Ismail
2009-05-26 08:04:07 UTC
Permalink
Dear All,

Regarding the inventory closing AX2009, We face the following issue:

After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.

After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items.

After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions.

Inventory Module Group setup is: Weight Avarage

Include Physical Value: Not Selected.

Attached the infolog for "Undeleted Weight Average Transaction".

Your feedback is highly appreciated.

Thanks & Best Regards,
Mohd
Eng. Tareq Sabri
2009-09-06 10:48:02 UTC
Permalink
Dear All,

I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items.
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions.
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction".
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
M.Ismail
2009-09-07 11:05:01 UTC
Permalink
Hi Tareq,

Can you mention the infolog details and if that happened while closing or
while cancellation.

Regards,

Mohamed Ismail
Post by M.Ismail
Dear All,
I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items.
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions.
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction".
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
Eng. Tareq Sabri
2009-09-07 11:26:01 UTC
Permalink
This is the massege coming after the closing

(Unit cost price 0.02 can be wrong as the transaction cannot be fully
settled.)
Post by M.Ismail
Hi Tareq,
Can you mention the infolog details and if that happened while closing or
while cancellation.
Regards,
Mohamed Ismail
Post by M.Ismail
Dear All,
I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items.
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions.
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction".
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
virawan
2009-09-08 07:44:18 UTC
Permalink
Hi Tareq,

This is normal, since you have receipt transaction which is not
financial update, so your issued transaction is not fully settle yet,
until your receipt transaction is financial update.

Regards,

Victor.

On Sep 7, 6:26 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
This is the massege coming after the closing
(Unit cost price 0.02 can be wrong as the transaction cannot be fully
settled.)
Post by M.Ismail
Hi Tareq,
Can you mention the infolog details and if that happened while closing or
while cancellation.
Regards,
Mohamed Ismail
Post by M.Ismail
Dear All,
I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items.
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions.
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction".
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
Eng. Tareq Sabri
2009-09-08 14:13:01 UTC
Permalink
Hi Virawan,

Although I make sure that all the transactions are financially updated, but
when I run the open quantities report it shows some items with open quantity
but no refernce (i.e. nither Purchase nor Proidcution orders).
What you suggest regarding this issue?
Please advice,
Thanks
Post by M.Ismail
Hi Tareq,
This is normal, since you have receipt transaction which is not
financial update, so your issued transaction is not fully settle yet,
until your receipt transaction is financial update.
Regards,
Victor.
On Sep 7, 6:26 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
This is the massege coming after the closing
(Unit cost price 0.02 can be wrong as the transaction cannot be fully
settled.)
Post by M.Ismail
Hi Tareq,
Can you mention the infolog details and if that happened while closing or
while cancellation.
Regards,
Mohamed Ismail
Post by M.Ismail
Dear All,
I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items.
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions.
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction".
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
virawan
2009-09-09 07:28:16 UTC
Permalink
Hi Tareq,

Do you upload some transaction into the table?

Thanks.
Regards,

Victor.

On Sep 8, 9:13 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
Hi Virawan,
Although I make sure that all the transactions are financially updated, but
when I run the open quantities report it shows some items with open quantity
but no refernce (i.e. nither Purchase nor Proidcution orders).
What you suggest regarding this issue?
Please advice,
Thanks
Post by M.Ismail
Hi Tareq,
This is normal, since you have receipt transaction which is not
financial update, so your issued transaction is not fully settle yet,
until your receipt transaction is financial update.
Regards,
Victor.
On Sep 7, 6:26 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
This is the massege coming after the closing
(Unit cost price 0.02 can be wrong as the transaction cannot be fully
settled.)
Post by M.Ismail
Hi Tareq,
Can you mention the infolog details and if that happened while closing or
while cancellation.
Regards,
Mohamed Ismail
Post by M.Ismail
Dear All,
I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items.
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions.
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction".
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
Eng. Tareq Sabri
2009-09-09 08:33:02 UTC
Permalink
Which Table you mean, invent table? yes we did for the stock opening balance
on the item movement journal
Post by M.Ismail
Hi Tareq,
Do you upload some transaction into the table?
Thanks.
Regards,
Victor.
On Sep 8, 9:13 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
Hi Virawan,
Although I make sure that all the transactions are financially updated, but
when I run the open quantities report it shows some items with open quantity
but no refernce (i.e. nither Purchase nor Proidcution orders).
What you suggest regarding this issue?
Please advice,
Thanks
Post by M.Ismail
Hi Tareq,
This is normal, since you have receipt transaction which is not
financial update, so your issued transaction is not fully settle yet,
until your receipt transaction is financial update.
Regards,
Victor.
On Sep 7, 6:26 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
This is the massege coming after the closing
(Unit cost price 0.02 can be wrong as the transaction cannot be fully
settled.)
Post by M.Ismail
Hi Tareq,
Can you mention the infolog details and if that happened while closing or
while cancellation.
Regards,
Mohamed Ismail
Post by M.Ismail
Dear All,
I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items..
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions..
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction"..
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
Eng. Tareq Sabri
2009-09-09 08:37:01 UTC
Permalink
Sorry I meant invent journal trans
Post by Eng. Tareq Sabri
Which Table you mean, invent table? yes we did for the stock opening balance
on the item movement journal
Post by M.Ismail
Hi Tareq,
Do you upload some transaction into the table?
Thanks.
Regards,
Victor.
On Sep 8, 9:13 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
Hi Virawan,
Although I make sure that all the transactions are financially updated, but
when I run the open quantities report it shows some items with open quantity
but no refernce (i.e. nither Purchase nor Proidcution orders).
What you suggest regarding this issue?
Please advice,
Thanks
Post by M.Ismail
Hi Tareq,
This is normal, since you have receipt transaction which is not
financial update, so your issued transaction is not fully settle yet,
until your receipt transaction is financial update.
Regards,
Victor.
On Sep 7, 6:26 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
This is the massege coming after the closing
(Unit cost price 0.02 can be wrong as the transaction cannot be fully
settled.)
Post by M.Ismail
Hi Tareq,
Can you mention the infolog details and if that happened while closing or
while cancellation.
Regards,
Mohamed Ismail
Post by M.Ismail
Dear All,
I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items..
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions..
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction"..
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
virawan
2009-09-10 09:10:27 UTC
Permalink
But if from invent journal trans, the status will surely become
purchased.
This mean, received only from purchase order.

Maybe you can search which packing slip that is not invoiced yet.
Thanks.

Victor.

On Sep 9, 3:37 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
Sorry I meant invent journal trans
Post by Eng. Tareq Sabri
Which Table you mean, invent table? yes we did for the stock opening balance
on the item movement journal
Post by M.Ismail
Hi Tareq,
Do you upload some transaction into the table?
Thanks.
Regards,
Victor.
On Sep 8, 9:13 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
Hi Virawan,
Although I make sure that all the transactions are financially updated, but
when I run the open quantities report it shows some items with open quantity
but no refernce (i.e. nither Purchase nor Proidcution orders).
What you suggest regarding this issue?
Please advice,
Thanks
Post by M.Ismail
Hi Tareq,
This is normal, since you have receipt transaction which is not
financial update, so your issued transaction is not fully settle yet,
until your receipt transaction is financial update.
Regards,
Victor.
On Sep 7, 6:26 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
This is the massege coming after the closing
(Unit cost price 0.02 can be wrong as the transaction cannot be fully
settled.)
Post by M.Ismail
Hi Tareq,
Can you mention the infolog details and if that happened while closing or
while cancellation.
Regards,
Mohamed Ismail
Post by M.Ismail
Dear All,
I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking.
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items..
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions..
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction"..
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
M.Ismail
2009-09-11 09:38:01 UTC
Permalink
Hi Tareq,

The possible reasons for that message could be:
The Open financial Receipts Qty less than the Open issue transactions for
the closing period, that could happened if for example the closing date is
31-08-2009 and the Purchase invoice date 01-09-2009 and Sales invoice date is
31-08-2009.

OR if you enabled "Allow physical negative inventory", so the unsettled
issue transactions exceed the open financial receipts during the closing
period.

The other reason could be the "Marking", for example you could have open
financial receipt transactions (invoiced Purchase order) but Marked with
other sales order (not delivered yet), the closing will not be able to use
that purchase transaction to settle the open issue transactions.

I hope that will help you..

Regards,

Mohamed Ismail
00966543586921
Post by virawan
But if from invent journal trans, the status will surely become
purchased.
This mean, received only from purchase order.
Maybe you can search which packing slip that is not invoiced yet.
Thanks.
Victor.
On Sep 9, 3:37 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
Sorry I meant invent journal trans
Post by Eng. Tareq Sabri
Which Table you mean, invent table? yes we did for the stock opening balance
on the item movement journal
Post by M.Ismail
Hi Tareq,
Do you upload some transaction into the table?
Thanks.
Regards,
Victor.
On Sep 8, 9:13 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
Hi Virawan,
Although I make sure that all the transactions are financially updated, but
when I run the open quantities report it shows some items with open quantity
but no refernce (i.e. nither Purchase nor Proidcution orders).
What you suggest regarding this issue?
Please advice,
Thanks
Post by M.Ismail
Hi Tareq,
This is normal, since you have receipt transaction which is not
financial update, so your issued transaction is not fully settle yet,
until your receipt transaction is financial update.
Regards,
Victor.
On Sep 7, 6:26 pm, Eng. Tareq Sabri
Post by Eng. Tareq Sabri
This is the massege coming after the closing
(Unit cost price 0.02 can be wrong as the transaction cannot be fully
settled.)
Post by M.Ismail
Hi Tareq,
Can you mention the infolog details and if that happened while closing or
while cancellation.
Regards,
Mohamed Ismail
Post by M.Ismail
Dear All,
I am also facing the same infolog for the unsettelted tansactions please help.
Post by M.Ismail
Dear All,
After the inventory closing has finished, Infolog for the unsettled
transactions has been generated mainly because of Marking..
After cancellation of the Closing, the log shows that the system couldn't
delete the weight average inventory transactions for some items..
After Removing Marking from that items transactions and run the inventory
closing again, the log still includes unsettled transactions for the items
that the system couldn't delete the weight average transactions..
Inventory Module Group setup is: Weight Avarage
Include Physical Value: Not Selected.
Attached the infolog for "Undeleted Weight Average Transaction"..
Your feedback is highly appreciated.
Thanks & Best Regards,
Mohd
Loading...