Computational Logic of Stock Reconciliation

What is the computational logic of the stock recon procedure if a transaction dated *before* the stock recon is added or cancelled?

I understand that submitting Stock Recon will add or subtract the difference of the stock level at the declared time with the number declared in the Stock Recon CSV.  Will this difference change if a transaction from a prior date is cancelled or added? 

I would think it shouldn't?



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

No, the difference is posted only once. If a transaction is posted before reconciliation date, that does not have any effect in stock reconciliation. We have discussed this internally, concluded not to change reconciliation entry after any back-dated entries. However, we are not very much sure, it is correct or not.

We will love to get the opinion from all other users.

On 18-Aug-2013, at 1:03 PM, lxnow wrote:

transaction



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

No, the difference is posted only once. If a transaction is posted before reconciliation date, that does not have any effect in stock reconciliation. 

By this you mean the difference value that the stock recon form create for an item code does not change, is that accurate? To illustrate:
  1. Item X has inventory fo 20 units 2013-08-17
  2. Stock reconciliation after a physical count ion 2013-08-18 is for 21 units
  3. Stock recon form submitted declares 21 units
  4. In stock ledger, Item X will show a +1 unit due to SR document
  5. Now, if a Delivery Note transaction from 2013-08-16 for 5 units is cancelled, then the inventory of Item X on date 2013-08-17 will become 25 instead of 20 as written in step 1 above
  6. Step 4 does not (and should not in my opinion) change. Hence, the new balance as of 2013-08-18 is 25+1 = 26.


On Sunday, August 18, 2013 3:48:58 PM UTC+8, Nabin Hait wrote:
No, the difference is posted only once. If a transaction is posted before reconciliation date, that does not have any effect in stock reconciliation. We have discussed this internally, concluded not to change reconciliation entry after any back-dated entries. However, we are not very much sure, it is correct or not.

We will love to get the opinion from all other users.

On 18-Aug-2013, at 1:03 PM, lxnow wrote:

transaction



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

Yes, now the system exactly works as per your example.

On 18-Aug-2013, at 1:23 PM, lxnow wrote:

No, the difference is posted only once. If a transaction is posted before reconciliation date, that does not have any effect in stock reconciliation. 

By this you mean the difference value that the stock recon form create for an item code does not change, is that accurate? To illustrate:
  1. Item X has inventory fo 20 units 2013-08-17
  2. Stock reconciliation after a physical count ion 2013-08-18 is for 21 units
  3. Stock recon form submitted declares 21 units
  4. In stock ledger, Item X will show a +1 unit due to SR document
  5. Now, if a Delivery Note transaction from 2013-08-16 for 5 units is cancelled, then the inventory of Item X on date 2013-08-17 will become 25 instead of 20 as written in step 1 above
  6. Step 4 does not (and should not in my opinion) change. Hence, the new balance as of 2013-08-18 is 25+1 = 26.


On Sunday, August 18, 2013 3:48:58 PM UTC+8, Nabin Hait wrote:
No, the difference is posted only once. If a transaction is posted before reconciliation date, that does not have any effect in stock reconciliation. We have discussed this internally, concluded not to change reconciliation entry after any back-dated entries. However, we are not very much sure, it is correct or not.

We will love to get the opinion from all other users.

On 18-Aug-2013, at 1:03 PM, lxnow wrote:

transaction




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

This suits us because we highly discourage and actually disallow back-dating, except for adjustment purposes which requires higher authorization.

So we will not allow new Delivery Notes, Purchase Receipts or Stock Entries to be created in the past. This is to ensure better control.

On Sunday, August 18, 2013 3:57:43 PM UTC+8, Nabin Hait wrote:
Yes, now the system exactly works as per your example.

On 18-Aug-2013, at 1:23 PM, lxnow wrote:

No, the difference is posted only once. If a transaction is posted before reconciliation date, that does not have any effect in stock reconciliation. 

By this you mean the difference value that the stock recon form create for an item code does not change, is that accurate? To illustrate:
  1. Item X has inventory fo 20 units 2013-08-17
  2. Stock reconciliation after a physical count ion 2013-08-18 is for 21 units
  3. Stock recon form submitted declares 21 units
  4. In stock ledger, Item X will show a +1 unit due to SR document
  5. Now, if a Delivery Note transaction from 2013-08-16 for 5 units is cancelled, then the inventory of Item X on date 2013-08-17 will become 25 instead of 20 as written in step 1 above
  6. Step 4 does not (and should not in my opinion) change. Hence, the new balance as of 2013-08-18 is 25+1 = 26.


On Sunday, August 18, 2013 3:48:58 PM UTC+8, Nabin Hait wrote:
No, the difference is posted only once. If a transaction is posted before reconciliation date, that does not have any effect in stock reconciliation. We have discussed this internally, concluded not to change reconciliation entry after any back-dated entries. However, we are not very much sure, it is correct or not.

We will love to get the opinion from all other users.

On 18-Aug-2013, at 1:03 PM, lxnow wrote:

transaction




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.