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

[Pak R. <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
>
>