Re: [WebERP-developers] Location with GLAccount code. Help.

[Pak R. <pak...@gm...>]

Hi Rafael:

You are right, and with these approaches can't be currently controlled in
webERP. I also could use the second scenario, thanks!!!

Regading your qeustion, in Manufactured items, somehow the field
materialcost gets updated with the sum of the costs of all its components,
so checking this "stockmaster.materialcost + stockmaster.labourcost +
stockmaster.overheadcost AS standardcost" should be OK.

Never used Assembly items, so not sure about them.

PS: Everyday I'm more impressed about the things webERP can do and people
do with webERP :-) Also, I realize how deep my ignorance is in a zillion
different fields

Regards,
Ricard

2015-05-08 13:21 GMT+08:00 Rafael Chacón <raf...@gm...>:

> Hi Ricard,
>
> Yes.
>
> For pledged inventory (in Spanish: "inventario pignorado"), it should be
> (because it is a collateral for a loan):
> 1. Physically separated from inventory available to sell or any other
> inventory; and
> 2. Registred in an account different from "Merchandise Inventory" (goods
> available for sale).
> It is usually that those goods are in a controlled warehouse (similar to a
> "bonded warehouse"), because you can not use this inventory. Theoretically
> it is true, but in practice (in some cases) it can differ a little bit
> (e.g. oil barrels: you can income new oil barrels to the controlled
> warehouse and then take out old oil barrels). But always you should have a
> separated control of quantities inside the controlled warehouse and a
> separated account in the register (accounting). See IAS-2, paragraph 36,
> bullet (h).
>
> For goods on consignment, it is similar:
> 1. Physically they are in the distributor's warehouse or store (not
> yours), and
> 2. they belong to you (the distributor --your customer-- has not purchased
> yet).
> Again, it is an inventory that you do not have available to sell, but
> still yours (consignor), so you have to control (register) in an account
> different  from "Merchandise Inventory" (goods available for sale).
> Periodically you (consignor) send a statement to the consignee, stating the
> inventory that should be on the consignee's stores; differences should be
> paid immediately to you. Also, in practice, you can have a little
> differences (e.g. you can sent a client to your client --consignee--).
>
> This is a quick overview. If you need other details, let me know.
>
> Best regards, Rafael.
>
> 2015-05-07 18:50 GMT-06:00 Pak Ricard <pak...@gm...>:
>
> Hi Rafael:
>>
>> I was thinking to do the very same thing few years ago, but desisted
>> because we already have the information of stock value by location in a
>> report.
>>
>> We solved it just setting the locations slightly different according to
>> our business needs, more than physical locations. Much easier than fixing
>> quite a few scripts.
>>
>> If this is not your plan, could you please elaborate a bit more?
>>
>> Regards,
>> Ricard
>>
>> 2015-05-08 7:51 GMT+08:00 Rafael Chacón <raf...@gm...>:
>>
>>> Hi,
>>>
>>> Sometimes it is needed to have general ledger transactions of inventory
>>> transfers to or from a location. For example, a location that is used for
>>> inventory pledged or a place with goods on consignment. In this case, the
>>> location should be related to a ledger account.
>>>
>>> I am working on this (code dowloadable at
>>> http://unstable.verdorama.systems/downloads/Location_with_GLAccount_code.zip
>>> ).
>>>
>>> To do this, a script enters the general ledger account code for this
>>> location in the field "locations.glaccountcode". This account code
>>> overwrites the account codes of inventory categories when a general ledger
>>> transaction related with this location is created. Each time a user does an
>>> inventory transfer from or to a location with a non blank account code, the
>>> system will generate a general ledger transaction (a SysType 16 --Location
>>> Transfer-- transaction).
>>> If you do not need accounting entries for inventory transfers, nor
>>> locations with his own GL account, leave this field in blank.
>>>
>>> HELP:
>>> I take the cost (for the general ledger transactions of inventory
>>> transfers) from "stockmaster.materialcost + stockmaster.labourcost +
>>> stockmaster.overheadcost AS standardcost".
>>> But what's happen with cost for: Assembly (value="A") and Manufactured
>>> (value="M") items ? Is it this correct?
>>>
>>> Any comments are highly appreciated! Thanks in advance!
>>>
>>> Best regards, Rafael.
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> One dashboard for servers and applications across Physical-Virtual-Cloud
>>> Widest out-of-the-box monitoring support with 50+ applications
>>> Performance metrics, stats and reports that give you Actionable Insights
>>> Deep dive visibility with transaction tracing using APM Insight.
>>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> One dashboard for servers and applications across Physical-Virtual-Cloud
>> Widest out-of-the-box monitoring support with 50+ applications
>> Performance metrics, stats and reports that give you Actionable Insights
>> Deep dive visibility with transaction tracing using APM Insight.
>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>