Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FIFO/LIFO Queue is [] in Stock Ledger Invariant Check for all transactions #42223

Open
toofun666 opened this issue Jul 8, 2024 · 1 comment
Labels

Comments

@toofun666
Copy link
Contributor

Information about bug

FIFO/LIFO Queue is [] in Stock Ledger Invariant Check for all transactions. The code exists for FIFO/LIFO Queue posting but it does not work. Let us remove this if it is not used or it is irrelevant or let us address this. We are now in an uncertain state for Item Valuations thus we do not know if we are posting the right COGS or not.

Module

accounts, stock, buying, selling

Version

ERPNext: v15.29.2 (version-15)
Frappe Framework: v15.33.3 (version-15)

Installation method

easy-install

Relevant log output / Stack trace / Full Error Message.

Stock Ledger Entry	Posting Date	Posting Time	Creation	Voucher Type	Voucher No	Batch	Serial and Batch Bundle	Batchwise Valuation	Qty Change	Incoming Rate	Consumption Rate	(A) Qty After Transaction	(B) Expected Qty After Transaction	A - B	FIFO/LIFO Queue	(C) Total Qty in Queue	A - C	(D) Balance Stock Value	(E) Balance Stock Value in Queue	D - E	(F) Change in Stock Value	(G) Sum of Change in Stock Value	G - D	(H) Change in Stock Value (FIFO Queue)	H - F	(I) Valuation Rate	(J) Valuation Rate as per FIFO	I - J	(K) Valuation = Value (D) ÷ Qty (A)	I - K
b0ea0fd9db	2020-12-14	11:44:11	2024-07-08 11:44:43	Purchase Receipt	PREC-RET-00372		SABB-00000367		500	23,8272		500	500	0	[]	0	500	11913,6	0	11913,6	11913,6	11913,6	0			23,8272			23,8272	0
111c3d16ab	2020-12-31	11:45:01	2024-07-08 11:46:18	Stock Entry	STE-01086		SABB-00000368		-1	0	23,83	499	499	0	[]	0	499	11889,77	0	11889,77	-23,83	11889,77	0	0	23,83	23,8272			23,82719439	5,61122E-06
@toofun666 toofun666 added the bug label Jul 8, 2024
@maveezmh
Copy link

@toofun666 FIfo and LIFO Queue works only if default valuation method in the stock settings is set to FIFO and LIFO.

image

it wont work if the setting is set to moving Average

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants