web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] long description translation

[<ph...@lo...>]

I wasn't thinking it would be that difficult... we don't need a new 
table do we?
Why can't we use the existing table and just add a field for the 
translated long description ... applying similar logic for the 
translation was we do for the short description?

Phil

On 2014-12-17 13:58, Rafael Chacón wrote:
> Hi Ricard,
> 
> I will be glad to commit changes for short and long description
> translation. but I need help from PHP programmers. I explain myself:
> 
> * We use a new table (not an exist table):
>  CREATE TABLE IF NOT EXISTS `stockdescription` (
>    `stockid` varchar(20) NOT NULL DEFAULT '' COMMENT 'Item code',
>    `language` varchar(10) NOT NULL DEFAULT '' COMMENT 'Item language
> code',
>    `short` varchar(50) DEFAULT NULL COMMENT 'Item short description',
>    `long` text COMMENT 'Item long description',
>    PRIMARY KEY (`stockid`,`language`)
>  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item descriptions';
> 
> This is for: (1) "Hot add" to a working copy of webERP and "secure
> backup" of old operation; (2) compatibility with a Joomla extension
> e-Cart;"Minor" speed and readability (?).
> 
> --> To commit changes, Do we use a new table or modify an existing
> one?
> 
> * We have to modify several scripts (e.g. Stocks.php,
> PrintCustTrans.php, PrintCustTransportrait.php, etc.). When there is
> no description in the selected language, he have two code branches:
> 
> (1) "Fall back" to system language (defined in ~/config.php,
> $DefaultLanguage = 'xx_XX.utf8';). If is null or empty, _('Not
> available'). Useful when we forgot to setup a translation; but
> customer sees a description in other language.
> 
> (2) Directly sets to _('Not available'). A little bit faster, but no
> information is shown to the customer (only "not available").
> 
> --> To commit changes, Do we use code with or without the "fall back"
> to system language?
> 
> * Input window for long description translation.
>  It is recommended to have "side-by-side" long description
> translations, but in this case it is a big and uncomfortable window.
> 
> --> Ideas? Suggestions?
> 
> Best regards, Rafael.
> 
> Hi Rafael:
> 
> i'm also needing the short and long description to use on the shop
> online. It would be great if you could commit (or send via email) the
> work done to maintain the translations of long descriptions in webERP.
> I could help finish it :-)
> 
> Regards,
> Ricard
> 
> 2014-12-17 14:00 GMT+08:00 Rafael Chacón
> <raf...@gm...>:
> 
>> Hi,
>> 
>> I am working with stockdescription table for translation of short
>> and long description to use in a e-cart. It is not fully tested and
>> the main problem is the usability (easy to maintain the
>> translations).
>> Also, the field unit of mesure needs translation, except for unit
>> of mesure symbols (m, m2, L, kg, ...).
>> 
>> Best regards, Rafael.
>> El 16/12/2014 23:02, "Phil Daintree" <ph...@lo...>
>> escribió:
>> 
>> I have not coded that, but no reason why we couldn't add a text
>> field to stockdescriptiontranslations for longdescriptiontranslation
>> and add in a field to the stock form to allow the field to be
>> translated to the maintained language(s)
>> 

Re: [WebERP-developers] long description translation

[Rafael C. <raf...@gm...>]

Hi Ricard,

I will be glad to commit changes for short and long description
translation. but I need help from PHP programmers. I explain myself:

* We use a new table (not an exist table):
CREATE TABLE IF NOT EXISTS `stockdescription` (
  `stockid` varchar(20) NOT NULL DEFAULT '' COMMENT 'Item code',
  `language` varchar(10) NOT NULL DEFAULT '' COMMENT 'Item language code',
  `short` varchar(50) DEFAULT NULL COMMENT 'Item short description',
  `long` text COMMENT 'Item long description',
  PRIMARY KEY (`stockid`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item descriptions';

This is for: (1) "Hot add" to a working copy of webERP and "secure backup"
of old operation; (2) compatibility with a Joomla extension e-Cart;"Minor"
speed and readability (?).

--> To commit changes, Do we use a new table or modify an existing one?

* We have to modify several scripts (e.g. Stocks.php, PrintCustTrans.php,
PrintCustTransportrait.php, etc.). When there is no description in the
selected language, he have two code branches:

(1) "Fall back" to system language (defined in ~/config.php,
$DefaultLanguage = 'xx_XX.utf8';). If is null or empty, _('Not available').
Useful when we forgot to setup a translation; but customer sees a
description in other language.

(2) Directly sets to _('Not available'). A little bit faster, but no
information is shown to the customer (only "not available").

--> To commit changes, Do we use code with or without the "fall back" to
system language?

* Input window for long description translation.
It is recommended to have "side-by-side" long description translations, but
in this case it is a big and uncomfortable window.

--> Ideas? Suggestions?

Best regards, Rafael.

Hi Rafael:

i'm also needing the short and long description to use on the shop online.
It would be great if you could commit (or send via email) the work done to
maintain the translations of long descriptions in webERP. I could help
finish it :-)

Regards,
Ricard

2014-12-17 14:00 GMT+08:00 Rafael Chacón <raf...@gm...>:
>
> Hi,
>
> I am working with stockdescription table for translation of short and long
> description to use in a e-cart. It is not fully tested and the main problem
> is the usability  (easy to maintain the translations).
> Also, the field unit of mesure needs translation, except for unit of
> mesure symbols (m, m2, L, kg, ...).
>
> Best regards,  Rafael.
> El 16/12/2014 23:02, "Phil Daintree" <ph...@lo...> escribió:
>
>  I have not coded that, but no reason why we couldn't add a text field to
>> stockdescriptiontranslations for longdescriptiontranslation and add in a
>> field to the stock form to allow the field to be translated to the
>> maintained language(s)
>>
>> Phil
>>
>> Phil Daintree
>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>>
>> On 17/12/14 16:28, Pak Ricard wrote:
>>
>> Hi all:
>>
>>  We want to use the translation description feature, but as far as I see
>> it only maintains the translation of the stockmaster.description field, not
>> the longdescription.
>>
>>  Is there a way to maintain the translated versions of longdescriptions
>> as well?
>>
>>  Regards,
>> Ricard
>>
>>
>> ------------------------------------------------------------------------------
>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
>> with Interactivity, Sharing, Native Excel Exports, App Integration & more
>> Get technology previously reserved for billion-dollar corporations, FREEhttp://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>>
>>
>>
>> _______________________________________________
>> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
>> with Interactivity, Sharing, Native Excel Exports, App Integration & more
>> Get technology previously reserved for billion-dollar corporations, FREE
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] long description translation

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

Hi Rafael:

i'm also needing the short and long description to use on the shop online.
It would be great if you could commit (or send via email) the work done to
maintain the translations of long descriptions in webERP. I could help
finish it :-)

Regards,
Ricard

2014-12-17 14:00 GMT+08:00 Rafael Chacón <raf...@gm...>:
>
> Hi,
>
> I am working with stockdescription table for translation of short and long
> description to use in a e-cart. It is not fully tested and the main problem
> is the usability  (easy to maintain the translations).
> Also, the field unit of mesure needs translation, except for unit of
> mesure symbols (m, m2, L, kg, ...).
>
> Best regards,  Rafael.
> El 16/12/2014 23:02, "Phil Daintree" <ph...@lo...> escribió:
>
>  I have not coded that, but no reason why we couldn't add a text field to
>> stockdescriptiontranslations for longdescriptiontranslation and add in a
>> field to the stock form to allow the field to be translated to the
>> maintained language(s)
>>
>> Phil
>>
>> Phil Daintree
>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>>
>> On 17/12/14 16:28, Pak Ricard wrote:
>>
>> Hi all:
>>
>>  We want to use the translation description feature, but as far as I see
>> it only maintains the translation of the stockmaster.description field, not
>> the longdescription.
>>
>>  Is there a way to maintain the translated versions of longdescriptions
>> as well?
>>
>>  Regards,
>> Ricard
>>
>>
>> ------------------------------------------------------------------------------
>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
>> with Interactivity, Sharing, Native Excel Exports, App Integration & more
>> Get technology previously reserved for billion-dollar corporations, FREEhttp://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>>
>>
>>
>> _______________________________________________
>> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
>> with Interactivity, Sharing, Native Excel Exports, App Integration & more
>> Get technology previously reserved for billion-dollar corporations, FREE
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] long description translation

[Rafael C. <raf...@gm...>]

Hi,

I am working with stockdescription table for translation of short and long
description to use in a e-cart. It is not fully tested and the main problem
is the usability  (easy to maintain the translations).
Also, the field unit of mesure needs translation, except for unit of mesure
symbols (m, m2, L, kg, ...).

Best regards,  Rafael.
El 16/12/2014 23:02, "Phil Daintree" <ph...@lo...> escribió:

>  I have not coded that, but no reason why we couldn't add a text field to
> stockdescriptiontranslations for longdescriptiontranslation and add in a
> field to the stock form to allow the field to be translated to the
> maintained language(s)
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 17/12/14 16:28, Pak Ricard wrote:
>
> Hi all:
>
>  We want to use the translation description feature, but as far as I see
> it only maintains the translation of the stockmaster.description field, not
> the longdescription.
>
>  Is there a way to maintain the translated versions of longdescriptions
> as well?
>
>  Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREEhttp://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] long description translation

[Phil D. <ph...@lo...>]

I have not coded that, but no reason why we couldn't add a text field to 
stockdescriptiontranslations for longdescriptiontranslation and add in a 
field to the stock form to allow the field to be translated to the 
maintained language(s)

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 17/12/14 16:28, Pak Ricard wrote:
> Hi all:
>
> We want to use the translation description feature, but as far as I 
> see it only maintains the translation of the stockmaster.description 
> field, not the longdescription.
>
> Is there a way to maintain the translated versions of longdescriptions 
> as well?
>
> Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[WebERP-developers] long description translation

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

Hi all:

We want to use the translation description feature, but as far as I see it
only maintains the translation of the stockmaster.description field, not
the longdescription.

Is there a way to maintain the translated versions of longdescriptions as
well?

Regards,
Ricard

Re: [WebERP-developers] Who moved the stock?

[ExsonQu <hex...@gm...>]

*Hi, Richard,*

           Thank you for your nice work. 
           Best regards!

           Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Who-moved-the-stock-tp4657900p4657903.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Who moved the stock?

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

Hi all:

Was not that hard :-)
Commited  in commit 7021. Being quite a few files, please double check in
case I missed something.


Regards,
Ricard

2014-12-14 7:00 GMT+08:00 Phil Daintree <ph...@lo...>:
>
>  I like the sound of 2 too. But yep more work - but more generic and I am
> pretty sure as soon as you coded 1 a requirement might come up for who
> processed an invoice... credit note, adjustment etc etc.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 13/12/14 22:19, Pak Ricard wrote:
>
> Hi all:
>
>  We face the need to know "Who moved the stock", in an easy and
> final-user-friendly way (in normal scripts), so we need something besides
> the audit trail, aimed to system admins not for stock managers.
>
>  The solution should imply the addition of the userid field somewhere,
> and so far I see 2 options:
>
>  1) add the userid in locationtransfers table, at reception time. We
> would then know who received the items. The "where" and the "when" are
> already answered by recloc and recdate fields.
>
>    - Pros: it's a very limited change in webERP
>     - Cons: we miss some other kind of movements
>
>
>  2) add the userid in stockmoves table. It is a wider change in webERP
> but would allow us to control all stock movements, not only the location
> transfers.
>
>    - Pros: it's system wide, we will know for every step, who moved the
>    stock.
>     - Cons: a lot of scripts would need revision.
>    - Also, in case of "sales invoice" movements we already know the "who
>    sold the items", the saleperson recorded in the salesorder, but not who
>    recorded that information in webERP (might be the same or not, depending on
>    each webERP configuration.). With this new field we can know that.
>
>
>  Both solutions solve my problem, but I can code the option 2 if the
> majority agrees, as I see it a better option. Besides the coding, I see no
> side effect problem.
>
>  A quick search and we have around 41 INSERT INTO stockmoves that would
> need modification, and probably the StockMovements.php script.
>
>  Does it make any sense to the community? Anything I'm overlooking?
>
>  Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREEhttp://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Who moved the stock?

[Phil D. <ph...@lo...>]

I like the sound of 2 too. But yep more work - but more generic and I am 
pretty sure as soon as you coded 1 a requirement might come up for who 
processed an invoice... credit note, adjustment etc etc.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 13/12/14 22:19, Pak Ricard wrote:
> Hi all:
>
> We face the need to know "Who moved the stock", in an easy and 
> final-user-friendly way (in normal scripts), so we need something 
> besides the audit trail, aimed to system admins not for stock managers.
>
> The solution should imply the addition of the userid field somewhere, 
> and so far I see 2 options:
>
> 1) add the userid in locationtransfers table, at reception time. We 
> would then know who received the items. The "where" and the "when" are 
> already answered by recloc and recdate fields.
>
>   * Pros: it's a very limited change in webERP
>   * Cons: we miss some other kind of movements
>
>
> 2) add the userid in stockmoves table. It is a wider change in webERP 
> but would allow us to control all stock movements, not only the 
> location transfers.
>
>   * Pros: it's system wide, we will know for every step, who moved the
>     stock.
>   * Cons: a lot of scripts would need revision.
>   * Also, in case of "sales invoice" movements we already know the
>     "who sold the items", the saleperson recorded in the salesorder,
>     but not who recorded that information in webERP (might be the same
>     or not, depending on each webERP configuration.). With this new
>     field we can know that.
>
>
> Both solutions solve my problem, but I can code the option 2 if the 
> majority agrees, as I see it a better option. Besides the coding, I 
> see no side effect problem.
>
> A quick search and we have around 41 INSERT INTO stockmoves that would 
> need modification, and probably the StockMovements.php script.
>
> Does it make any sense to the community? Anything I'm overlooking?
>
> Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[WebERP-developers] Who moved the stock?

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

Hi all:

We face the need to know "Who moved the stock", in an easy and
final-user-friendly way (in normal scripts), so we need something besides
the audit trail, aimed to system admins not for stock managers.

The solution should imply the addition of the userid field somewhere, and
so far I see 2 options:

1) add the userid in locationtransfers table, at reception time. We would
then know who received the items. The "where" and the "when" are already
answered by recloc and recdate fields.

   - Pros: it's a very limited change in webERP
   - Cons: we miss some other kind of movements


2) add the userid in stockmoves table. It is a wider change in webERP but
would allow us to control all stock movements, not only the location
transfers.

   - Pros: it's system wide, we will know for every step, who moved the
   stock.
   - Cons: a lot of scripts would need revision.
   - Also, in case of "sales invoice" movements we already know the "who
   sold the items", the saleperson recorded in the salesorder, but not who
   recorded that information in webERP (might be the same or not, depending on
   each webERP configuration.). With this new field we can know that.


Both solutions solve my problem, but I can code the option 2 if the
majority agrees, as I see it a better option. Besides the coding, I see no
side effect problem.

A quick search and we have around 41 INSERT INTO stockmoves that would need
modification, and probably the StockMovements.php script.

Does it make any sense to the community? Anything I'm overlooking?

Regards,
Ricard

[WebERP-developers] Float accuracy problem

[ExsonQu <hex...@gm...>]

*Dear all,*
 
         I've encountered several cases about float accuracy problem myself
and report from webERP Chinese community. 

         It causes some number like 0.9999999999999 or 1.000000000000001
stored in webERP locstock quantity field. This will lead to invoice cannot
be issued due to negative stock quantity, or some display '-0.00' quantity
about stock status, and sales orders not completed problem. 

         There is a article for the float accuracy problem here 
http://stackoverflow.com/questions/14587290/can-i-rely-on-php-php-ini-precision-workaround-for-floating-point-issue
<http://stackoverflow.com/questions/14587290/can-i-rely-on-php-php-ini-precision-workaround-for-floating-point-issue>  

         I believe it's necessary to fix this problem since it'll lead some
strange behavior. 

         Thanks and best regards!
         
         Exson 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Float-accuracy-problem-tp4657899.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Do we need a new feature for confirm delivery?

[ExsonQu <hex...@gm...>]

*Hi, Rafael,*

        Thank you very much!

        I'll study it before I go ahead.

        Best regards!

        Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Do-we-need-a-new-feature-for-confirm-delivery-tp4657890p4657898.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Do we need a new feature for confirm delivery?

[Rafael C. <raf...@gm...>]

Hi Exson,

Sorry by the delay, I was translating...

For the Freight "N/A" ('gift'), I do not have to a service item; and I
direct-purchase the freight (without purchase order). I enter the income in
the invoice. I enter the expense in Suppliers > Enter a Suppliers Invoice >
General Ledger.

Except for the "small carriers" (Payment Terms = cash), I controlled the
payments to suppliers with Suppliers > Supplier Account Inquiry. Now I use
dashboard.php (to control suppliers, customers, etc.)

My operation (feel free to ask):

* In Main Menu > Setup > Receivables/Payables Setup > Shippers I have
(shipper manners instead of real shippers, but the result is the same):

Shipper ID    Shipper Name
1     N/A ("Do not apply": free shipping or customer pick-ups the goods)
2     Express local
3     Transporte local (local transport like trucks, etc.)
4     Correo básico (surface mail --local and international--)
5     EMS courier (express mail: DHL, Fedex, etc. --only international--)

* In Suppliers, I have some carriers: DHL, mail postal-office, local truck
carriers (like "taxi carga" = men with a truck-to-hire), taxi-drivers,
moto-drivers, ...

* I do the calculus in a manual way. This is because, for the same
destination, depending on the shipping option selected by the customer, the
price is different: from surface-mail 1to2 weeks (cheep freight), to
"Express" (0,75to4 hours --as a "pizza-delivery"-- the most expensive
freight). Comment: my country is very small.

* In accounting, I have  two accounts for freight in Sales Revenues and
Expenses section: "income by sales freight" (receivables from customers)
and "expenses by sales freight" (payables to suppliers).

My goals:
+ By difference between accounts "income by sales freight" and "expenses by
sales freight" in Sales Revenues and Expenses section, I know if the
freight operation is sustainable. Comment: Freight is not my main business,
so I am happy if income equals expenses (usually there is a very little
net-profit).
+ By selecting fields with gltrans.narrative like debtorsmaster.debtorno .
" -" . "%" (I use the VAT number without hyphens as the customer number
--field debtorsmaster.debtorno--), I get a "like Income statement" for a
customer. Sort-descending all "like Income statement" by its "like net
profit", I get a customer priority list beginning with the "star customers"
--the "whale curve"--. Comment: Probably it is better to define a tag
("cost-centre") by customer, or to create an "activity" field in gltrans,
but php with a select can do this job.

Personal comment: I am looking for
(1) Each customer has a "positive" "like net profit".
(2) Freight income from "not-star" customers pays freight expenses. Here,
my experience is that "not-star" customers (people who are in the bottom of
the priority list) are annoying asking for free freight (it is better to do
not waste time discussing with them), so I look the "like net profit" for
this specific customer.

Best regards, Rafael.


2014-12-08 3:37 GMT-06:00 ExsonQu <hex...@gm...>:

> *Hi, Rafael,*
>
>           For the Freight 'gift', do you have to set up a service item and
> purchasing it?
>
>           And when it's become a routine operation, how do you control the
> payments for the suppliers?
>
>          Does this operation really make sense?
>
>          Best regards!
>
>          Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Do-we-need-a-new-feature-for-confirm-delivery-tp4657890p4657896.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Do we need a new feature for confirm delivery?

[ExsonQu <hex...@gm...>]

*Hi, Rafael,*

          For the Freight 'gift', do you have to set up a service item and
purchasing it?

          And when it's become a routine operation, how do you control the
payments for the suppliers?

         Does this operation really make sense?

         Best regards!

         Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Do-we-need-a-new-feature-for-confirm-delivery-tp4657890p4657896.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] CustomerAllocations.php is not displaying all the payments waiting to be allocated

[wertthey <jp...@nu...>]

Sorry that is embarrassing.   Thanks for the clarification.  



-----
Using weberp since 2004, Thanks for all your hard work!
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/CustomerAllocations-php-is-not-displaying-all-the-payments-waiting-to-be-allocated-tp4657888p4657895.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Do we need a new feature for confirm delivery?

[Rafael C. <raf...@gm...>]

You are welcome!
El 07/12/2014 20:40, "ExsonQu" <hex...@gm...> escribió:

> *Hi, Rafael,*
>
>            Thank you for your great idea!
>
>            It's wonderful!
>
>            Best regards!
>
>            Exson
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Do-we-need-a-new-feature-for-confirm-delivery-tp4657890p4657893.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Do we need a new feature for confirm delivery?

[ExsonQu <hex...@gm...>]

*Hi, Rafael,*

           Thank you for your great idea!

           It's wonderful!

           Best regards!

           Exson
         



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Do-we-need-a-new-feature-for-confirm-delivery-tp4657890p4657893.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Dashboard at start up.

[Rafael C. <raf...@gm...>]

Hi Phil,

Thank you, very much.

Best regards, Rafael.

2014-12-05 22:12 GMT-06:00 Phil Daintree <ph...@lo...>:

>  Well in session.inc we have a line
>
>
> if ($FirstLogin AND !$SupplierLogin AND !$CustomerLogin AND
> $_SESSION['ShowDashboard']==1) {
>     header('Location: ' . $PathPrefix .'Dashboard.php');
> }
>
>
> So only if it is the first login and it is not a supplier or customer
> login and the system parameter for ShowDashboard is set to on....
>
> One issue I am not sure we have coded the ShowDashboard in system
> parameters. I am actually wondering if this should be a user flag in
> www_users table so that only users with the ShowDashboard comes up.
>
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 06/12/14 15:02, Rafael Chacón wrote:
>
>  Hi,
>
>  Sorry for the question, but I need help...
>
> In webERP 4.11.5, we have a Dashboard at start-up, but in webERP 4.12 we
> do not have it.
>
>  How to setup a Dashboard at start-up like in 4.11.5 ?
>
>  Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREEhttp://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Do we need a new feature for confirm delivery?

[Rafael C. <raf...@gm...>]

Hi Exson,

I do not know if this case could help you:

Sometimes, I have to "gift" a spare to a customer. In this case, I include
the item in the invoice with a 100% discount, and I proceed as usual.

Also, sometimes I have to "gift" the freight to a customer. In this case, I
have the carrier "N/A" (not apply) as Freight/Shipper Method with price
zero.

In both cases, they have cost (but no price).

Best regards, Rafael.

2014-12-07 19:26 GMT-06:00 ExsonQu <hex...@gm...>:

> *Dear all,*
>
>             I've noticed that when we sale items in zero price, it's not
> handled specially in accounting. I'm going to add a feature to handle this:
>
>              1. add a account selection feature in company preference.
>              2. When we delivery samples free of charges to customers,
> we'll
> debit this account such as sales expenses and credit the COGS.
>
>              And the freight charge in goods sold, it'll charge customers
> and recovery the freight charge in Freight charge account. But sometime,
> the
> charge is not paid by customers. If we face this situation, we have to
> debit
> the Freight charge account, debit TaxAuth account and Credit account
> payable. And update suppliertrans table to record this.
>             Does this make sense?
>
>            Any comments are highly appreciated.
>
>            Best regards!
>
>            Exson
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Do-we-need-a-new-feature-for-confirm-delivery-tp4657890.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[WebERP-developers] Do we need a new feature for confirm delivery?

[ExsonQu <hex...@gm...>]

*Dear all,*

            I've noticed that when we sale items in zero price, it's not
handled specially in accounting. I'm going to add a feature to handle this:

             1. add a account selection feature in company preference. 
             2. When we delivery samples free of charges to customers, we'll
debit this account such as sales expenses and credit the COGS. 

             And the freight charge in goods sold, it'll charge customers
and recovery the freight charge in Freight charge account. But sometime, the
charge is not paid by customers. If we face this situation, we have to debit
the Freight charge account, debit TaxAuth account and Credit account
payable. And update suppliertrans table to record this. 
            Does this make sense?

           Any comments are highly appreciated. 

           Best regards!

           Exson





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Do-we-need-a-new-feature-for-confirm-delivery-tp4657890.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] CustomerAllocations.php is not displaying all the payments waiting to be allocated

[ExsonQu <hex...@gm...>]

*Hi, Wertthey,*

        I think you've made a mistake to set the users' account. You've must
had set the role as a salesman. webERP has a tighten control for the sale
man now. Sales only can check their own customers' data. If you do not need
this control, you can set the "not a salesperson only login".

        Best regards!

       Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/CustomerAllocations-php-is-not-displaying-all-the-payments-waiting-to-be-allocated-tp4657888p4657889.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] CustomerAllocations.php is not displaying all the payments waiting to be allocated

[wertthey <jp...@nu...>]

When looking at the CustomerAllocations.php page in 4.11.0, I could see all
the allocations possible to address ( I had about 30 of them from many
different clients) .  After upgrade it appears as though I only see the
allocations possible for the last customer in my data about 4. By last
client I mean the last alpha numeric customer that I can allocate for is WLT
if that helps. 

So before

11/09/14 RChacon: Adds gettext() to line 402 of CustomerAllocations.php.
Reported by Harald.

it seems to be working.



-----
Using weberp since 2004, Thanks for all your hard work!
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/CustomerAllocations-php-is-not-displaying-all-the-payments-waiting-to-be-allocated-tp4657888.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] I can not post Reciepts of payments CustomerReceipt.php

[wertthey <jp...@nu...>]

Ok, I do think that the wording in wrong, unless I am missing something.  I
always viewed this as.....This is to note that the customer has paid, this
is a payment from the customer, Correct?  Maybe I am wrong.



-----
Using weberp since 2004, Thanks for all your hard work!
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/I-can-not-post-Reciepts-of-payments-CustomerReceipt-php-tp4657875p4657887.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] (no subject)

[Albert <ak...@gm...>]

ㄚ__ㄨ

Re: [WebERP-developers] CustomerReceipt.php issue seems like the tables was not updated after upgrade.

[wertthey <jp...@nu...>]

Thanks *gsavix* for double checking what I was seeing. I had some issues
during the upgrade years ago to 4.01 which I had to do a lot of
modifications to correct my upgrade and was quietly wondering if this was a
lingering issue. 



-----
Using weberp since 2004
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/CustomerReceipt-php-issue-seems-like-the-tables-was-not-updated-after-upgrade-tp4657876p4657885.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.