Warehouses showing financial value with no physical

(0) Share

Report

Posted on by AJSpooner

Can anyone help, we have AX4 and have financial values in warehouses with no stock remaining. I have tried to create transactions to remove these however when a stock close is performed they reappear. Help what am I doing wrong?

Thanks

I have the same question (0)

All responses (2)

Answers (0)

Grygory.Ivanov 160 on at

Like (0)

Report

Hello AJSpooner,

Can you clarify few things for us please? What your inventory value report shows for different configurations - with and without warehouse breakdown? What is your inventory costing model? Usually inventory (stock) close deals with issue and receipt transactions settling them against each other and marking as closed - that way your inventory value is relieved when you get rid of the inventory. However, there might be cases when, for example, you have a production order that is reported as finished but not ended (or Purchase order received but not invoiced) creating RECEIPT transaction, and have a sales order that is invoiced - creating ISSUE transaction. In that case, system would leave such entries open, and even though the inventory is physically gone, the financial update is still to happen for the financial value of such transactions. That will happen once both transactions are financially closed - the system usually suggests adjustment type of entry during recalculation or inventory close. This might explain what might be causing the value with no stock scenario - but I am not sure if that applicable to your setups.
AJSpooner 5 on at

Like (0)

Report

Hi Grygory

May I thank you for responding and I really appreciate any insight you can give.

It is a fifo item with the following setup

When I run the specify stock value report I get the same figures as my view below with and without warehouse selected.

This report gives the physical value, I can run a stockvaluereport by item group and this gives the financial value as per my view in ax below but it does not give the values at transaction level

I believe however I have managed to match these values by looking at the inventtrans data by taking the costamountposted+costamountadjustment-costamountsettled, looking at all these transactions they appear to have a dateclosed entry but do not balance to zero.

Is there a routine that can be ran by item for AX to check this data and adjust in the current month? We have done a stock close up to September. I believe they should equal 0 when the transaction is closed, I have tried the consistency check but believe this only checks invent trans to invent sum. It is as though the figures in inventrans needs to be recalalcuated and correct the initial error.

Many Thanks

AJ