Moving Average Cost Issue

  • Question
  • Updated 3 years ago
  • Answered
Moving average calculates incorrect price if the Order has been Re-opened and submitted.
On reopen purchase order qty shows zero (un-stocked) but the average price ignores that.
Pl see image.

Photo of sanjay

sanjay

  • 63 Posts
  • 1 Reply Like
  • disheartened

Posted 5 years ago

Photo of Amy

Amy

  • 221 Posts
  • 14 Reply Likes
Hi Sanjay,

I tried to reproduce the issue you're seeing, but when I created an order with 75 units of items at $6.75 each, and then reopen and process the order again, the cost would stay as $6.75. In the third row where you've processed PO-SG-000024 a second time, is the unit cost $6.75, or is it something lower?
Photo of sanjay

sanjay

  • 63 Posts
  • 1 Reply Like
Hi Amy,
Thanks for your reply.
The price was not changed manually, nothing was changed. The order was reopened, only to set the payment date which was incorrect earlier.
As you can see the cost after in the 3rd line is the moving average but the calculation is wrong.
We had actually reopened around 60 orders to redo the payment date so I am now worried.
Pl help.
Photo of Amy

Amy

  • 221 Posts
  • 14 Reply Likes
Hi Sanjay,

Hmm... unfortunately I can't seem to reproduce what you're seeing (see attached screenshot). Can you send us an email to support@inflowinventory.com and attach a backup of your database. It's probably too large to email, so try putting it into a ZIP file (by right clicking it and selecting Send To Compressed ZIP folder or using a program like WinRAR). If it's still too large to email, please use a file transfer service like yousendit.com or sendspace.com.

Photo of Christina Jones

Christina Jones

  • 5 Posts
  • 0 Reply Likes
I am having this exact problem - I had to go back and redo payment dates on a bunch of orders, and had the same problem. Was there a solution to this?
Photo of Siobhan

Siobhan, Official Rep

  • 5342 Posts
  • 190 Reply Likes
Hi Christina,

I'm so sorry to hear that you're having trouble! As Amy mentioned above we weren't able to reproduce the trouble that Sanjay was having. Unfortunately I see no record of the issue outside of this thread, which suggests that the issue was either dealt with via telephone or Sanjay discovered another reason for the issue.

To that end, we would have to take a direct look at your inventory and why that might be causing problems in order to provide any more detail on solutions. Can you send us an email to support@inflowinventory.com and attach a backup of your database. It's probably too large to email, so try putting it into a ZIP file (by right clicking it and selecting Send To Compressed ZIP folder or using a program like WinRAR). If it's still too large to email, please use a file transfer service like yousendit.com or sendspace.com?

Thank you!
Photo of dhodgdonD

dhodgdon

  • 11 Posts
  • 0 Reply Likes
I am also having an issue like this. Any resolution?
Photo of Siobhan

Siobhan, Official Rep

  • 5342 Posts
  • 190 Reply Likes
Hi there

I'm sorry to hear that you're having trouble! As I mentioned in my post above we weren't able to replicate the problem. Can you give us any more details about the trouble you're experiencing? When do you see this occur? Are you able to replicate it often? If so, what steps are you taking?

In addition to this information it would be helpful to have a look at your database, if possible would you mind following the instructions in the second half of my posting above to send us a copy of your database?

Thank you!
Photo of dhodgdonD

dhodgdon

  • 11 Posts
  • 0 Reply Likes
I believe I have found a piece of the puzzle. It appears if I sell all of items of one part number out of stock and complete the order, then go back and re-open the order, those items are put back in stock and the moving average changes to $0. There may be more to this issue, but that is what I just saw.
Photo of Stephen

Stephen, Official Rep

  • 1435 Posts
  • 94 Reply Likes
Hi,

Yes, the way that it should work is that when you re-open a Purchase Order, it does the negative transaction... e.g. if you added 75 units at $6.50 each, it'll subtract out 75 units at $6.50 each when you re-open the order. If you've done other transactions in between there, the average cost may not be the same as it originally was. Then when you complete the order again it would put the items back in at the new cost.
Photo of dhodgdonD

dhodgdon

  • 11 Posts
  • 0 Reply Likes
I am talking about re-opening Sales Orders, Not Purchase Orders. It looks like when a sales order is re-opened, the items on that order are restocked at $0. This seems like a problem.
Photo of Stephen

Stephen, Official Rep

  • 1435 Posts
  • 94 Reply Likes
Hi,

Ah, thanks for clarifying. When you re-open a sales order, it would restock the items at the cost that was recorded at the time the Sales Order was completed. If the costs were not set up at that point, then it would use the $0 for restocking -- that could definitely throw off the calculations.