Archives
Contributors
Stock Valuation by LOT
by Kitti Upariphutthiphong - 11:26 - 30 Dec 2021
Follow-Ups
-
Re: Stock Valuation by LOT
Thank you very much.Happy New Year to all OCA members!On Fri, Dec 31, 2021, 08:42 Graeme Gellatly <gdgellatly@gmail.com> wrote:Hi Kitti,I have a module. Its basic usage is to trick FIFO into behaving like actual cost for tracked products.It is well tested on v12, however v14 is only just being deployed.On Fri, Dec 31, 2021 at 4:51 AM Kitti U. <kittiu@ecosoft.co.th> wrote:Yes that would be awesome!On Thu, Dec 30, 2021, 21:12 Jesús Alan Ramos Rodríguez <alan.ramos@jarsa.com> wrote:I have something similar that I make for V13, it's not in OCA but I can make a PR with this module,I have two modules, one that value stock by lot and other that value stock by warehouse.I'm a little busy this days, I can make the PR and give you access to continue the PR to comply with OCA standards if you are OK.El jue., 30 de diciembre de 2021 5:21 a. m., Kitti U. <kittiu@ecosoft.co.th> escribió:Hi Dominque,Thanks for the response. Yes, FIFO in fact not matter much, it is the way to give default LOT that is available by FIFO. I found something similar to my need like this,Your suggestions can help me making such module to OCA, thanks!I want to make sure that OCA don't have anything similar yet.On Thu, Dec 30, 2021 at 5:56 PM Dominique k <dominique.k@elico-corp.com.sg> wrote:Hi Kitti,Here (in Singapore), it is accepted that FIFO should not be by lot because FIFO is an accounting policy, independent from the warehouse operations.And in cases that the users need cost information by lot, e.g. in trading business, with lots of suppliers with various costs for the same product, we added the function to calculate the cost from a lot, by searching the PO that brought the lot in the stock.My two cents, if that helps.DominiqueOn Thu, 30 Dec 2021 at 18:27, Kitti U. <kittiu@ecosoft.co.th> wrote:Dear community,Currently, I am looking for perpetual stock valuation with FIFO method, using LOT.So far, I found out that, even though we already use LOT on stock move (same product, different price by LOT), Odoo, the stock valuation report do not show by LOT, but new average cost.Also, on case Return stock, it also don't use cost by LOT, but the average cost.Are there module in OCA helping out?Many thanks!
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Kitti Upariphutthiphong - 01:51 - 31 Dec 2021 -
Re: Stock Valuation by LOT
Hi Kitti,I have a module. Its basic usage is to trick FIFO into behaving like actual cost for tracked products.It is well tested on v12, however v14 is only just being deployed.On Fri, Dec 31, 2021 at 4:51 AM Kitti U. <kittiu@ecosoft.co.th> wrote:Yes that would be awesome!On Thu, Dec 30, 2021, 21:12 Jesús Alan Ramos Rodríguez <alan.ramos@jarsa.com> wrote:I have something similar that I make for V13, it's not in OCA but I can make a PR with this module,I have two modules, one that value stock by lot and other that value stock by warehouse.I'm a little busy this days, I can make the PR and give you access to continue the PR to comply with OCA standards if you are OK.El jue., 30 de diciembre de 2021 5:21 a. m., Kitti U. <kittiu@ecosoft.co.th> escribió:Hi Dominque,Thanks for the response. Yes, FIFO in fact not matter much, it is the way to give default LOT that is available by FIFO. I found something similar to my need like this,Your suggestions can help me making such module to OCA, thanks!I want to make sure that OCA don't have anything similar yet.On Thu, Dec 30, 2021 at 5:56 PM Dominique k <dominique.k@elico-corp.com.sg> wrote:Hi Kitti,Here (in Singapore), it is accepted that FIFO should not be by lot because FIFO is an accounting policy, independent from the warehouse operations.And in cases that the users need cost information by lot, e.g. in trading business, with lots of suppliers with various costs for the same product, we added the function to calculate the cost from a lot, by searching the PO that brought the lot in the stock.My two cents, if that helps.DominiqueOn Thu, 30 Dec 2021 at 18:27, Kitti U. <kittiu@ecosoft.co.th> wrote:Dear community,Currently, I am looking for perpetual stock valuation with FIFO method, using LOT.So far, I found out that, even though we already use LOT on stock move (same product, different price by LOT), Odoo, the stock valuation report do not show by LOT, but new average cost.Also, on case Return stock, it also don't use cost by LOT, but the average cost.Are there module in OCA helping out?Many thanks!_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Graeme Gellatly - 02:36 - 31 Dec 2021 -
Re: Stock Valuation by LOT
Yes that would be awesome!On Thu, Dec 30, 2021, 21:12 Jesús Alan Ramos Rodríguez <alan.ramos@jarsa.com> wrote:I have something similar that I make for V13, it's not in OCA but I can make a PR with this module,I have two modules, one that value stock by lot and other that value stock by warehouse.I'm a little busy this days, I can make the PR and give you access to continue the PR to comply with OCA standards if you are OK.El jue., 30 de diciembre de 2021 5:21 a. m., Kitti U. <kittiu@ecosoft.co.th> escribió:Hi Dominque,Thanks for the response. Yes, FIFO in fact not matter much, it is the way to give default LOT that is available by FIFO. I found something similar to my need like this,Your suggestions can help me making such module to OCA, thanks!I want to make sure that OCA don't have anything similar yet.On Thu, Dec 30, 2021 at 5:56 PM Dominique k <dominique.k@elico-corp.com.sg> wrote:Hi Kitti,Here (in Singapore), it is accepted that FIFO should not be by lot because FIFO is an accounting policy, independent from the warehouse operations.And in cases that the users need cost information by lot, e.g. in trading business, with lots of suppliers with various costs for the same product, we added the function to calculate the cost from a lot, by searching the PO that brought the lot in the stock.My two cents, if that helps.DominiqueOn Thu, 30 Dec 2021 at 18:27, Kitti U. <kittiu@ecosoft.co.th> wrote:Dear community,Currently, I am looking for perpetual stock valuation with FIFO method, using LOT.So far, I found out that, even though we already use LOT on stock move (same product, different price by LOT), Odoo, the stock valuation report do not show by LOT, but new average cost.Also, on case Return stock, it also don't use cost by LOT, but the average cost.Are there module in OCA helping out?Many thanks!
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Kitti Upariphutthiphong - 04:51 - 30 Dec 2021 -
Re: Stock Valuation by LOT
Hi Dominque,Thanks for the response. Yes, FIFO in fact not matter much, it is the way to give default LOT that is available by FIFO. I found something similar to my need like this,Your suggestions can help me making such module to OCA, thanks!I want to make sure that OCA don't have anything similar yet.On Thu, Dec 30, 2021 at 5:56 PM Dominique k <dominique.k@elico-corp.com.sg> wrote:Hi Kitti,Here (in Singapore), it is accepted that FIFO should not be by lot because FIFO is an accounting policy, independent from the warehouse operations.And in cases that the users need cost information by lot, e.g. in trading business, with lots of suppliers with various costs for the same product, we added the function to calculate the cost from a lot, by searching the PO that brought the lot in the stock.My two cents, if that helps.DominiqueOn Thu, 30 Dec 2021 at 18:27, Kitti U. <kittiu@ecosoft.co.th> wrote:Dear community,Currently, I am looking for perpetual stock valuation with FIFO method, using LOT.So far, I found out that, even though we already use LOT on stock move (same product, different price by LOT), Odoo, the stock valuation report do not show by LOT, but new average cost.Also, on case Return stock, it also don't use cost by LOT, but the average cost.Are there module in OCA helping out?Many thanks!
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Kitti Upariphutthiphong - 12:20 - 30 Dec 2021