web-erp-developers — Discussion on development of webERP

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

[Phil D. <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 567890
http://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, 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] Dashboard at start up.

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

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.

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

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

*Hi, *
 
       Welcome to feedback problem. 

       I've reviewed what you said. They've been there at lease since
version 4.04.4. 

      Best regards!

      Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/I-can-not-post-Reciepts-of-payments-CustomerReceipt-php-tp4657875p4657882.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

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

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

*Hi, Wertthey,*

          Thank you for your report!

          I've corrected the field name. Please check if the problem solved
or still exists other problem. 

          Thanks and again and sorry for the errors introduced. 

          Best regards!

          Exson CustomerReceipt.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4657881/CustomerReceipt.zip>  



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

Re: [WebERP-developers] PO & Payment.

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

Well a PO may consist of many different deliveries and these are 
referred to as GRNs Goods received notes in webERP. The GRN is then 
allocated to accounts payable invoices. There is not currently a drill 
down on AP invoices to see which GRNs it was paying nor is  there an 
inquiry the other way either to look through a PO to the GRNs and AP 
invoices - although this would be possible.

Phil

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

On 05/12/14 16:25, Michael K wrote:
> Halo,
> is there any way to know or to make report which PO is already paid 
> off in weberp?
>
>
> ------------------------------------------------------------------------------
> 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] PO & Payment.

[Michael K <mic...@gm...>]

Halo,
is there any way to know or to make report which PO is already paid off in
weberp?

[WebERP-developers] debug or develop info included on BOMIndentedReverse.php and BOMIndented.php

[Pablo M. <pm...@lu...>]

In BOMIndentedReverse.php  at line 330 :

 

$pdf->addTextWrap($Xpos,$YPos,90,$FontSize,_(' 12345678901234567890'),
'left');

 

Same in BOMIndented.php

 

Regards

Pablo Martin

 

 

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

[gilberto d. s. a. <gs...@gm...>]

hi. following is weberp 4.11.3 version table for compare. see that columns
also do not exist on 4.11.3.

-- Estrutura da tabela `custbranch`
--
-- weberp-4-11-3
--
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de Dados: `weberp_4_11_3`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `custbranch`
--

CREATE TABLE IF NOT EXISTS `custbranch` (
  `branchcode` varchar(10) NOT NULL DEFAULT '',
  `debtorno` varchar(10) NOT NULL DEFAULT '',
  `brname` varchar(40) NOT NULL DEFAULT '',
  `braddress1` varchar(40) NOT NULL DEFAULT '',
  `braddress2` varchar(40) NOT NULL DEFAULT '',
  `braddress3` varchar(40) NOT NULL DEFAULT '',
  `braddress4` varchar(50) NOT NULL DEFAULT '',
  `braddress5` varchar(20) NOT NULL DEFAULT '',
  `braddress6` varchar(40) NOT NULL DEFAULT '',
  `lat` float(10,6) NOT NULL DEFAULT '0.000000',
  `lng` float(10,6) NOT NULL DEFAULT '0.000000',
  `estdeliverydays` smallint(6) NOT NULL DEFAULT '1',
  `area` char(3) NOT NULL,
  `salesman` varchar(4) NOT NULL DEFAULT '',
  `fwddate` smallint(6) NOT NULL DEFAULT '0',
  `phoneno` varchar(20) NOT NULL DEFAULT '',
  `faxno` varchar(20) NOT NULL DEFAULT '',
  `contactname` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(55) NOT NULL DEFAULT '',
  `defaultlocation` varchar(5) NOT NULL DEFAULT '',
  `taxgroupid` tinyint(4) NOT NULL DEFAULT '1',
  `defaultshipvia` int(11) NOT NULL DEFAULT '1',
  `deliverblind` tinyint(1) DEFAULT '1',
  `disabletrans` tinyint(4) NOT NULL DEFAULT '0',
  `brpostaddr1` varchar(40) NOT NULL DEFAULT '',
  `brpostaddr2` varchar(40) NOT NULL DEFAULT '',
  `brpostaddr3` varchar(40) NOT NULL DEFAULT '',
  `brpostaddr4` varchar(50) NOT NULL DEFAULT '',
  `brpostaddr5` varchar(20) NOT NULL DEFAULT '',
  `brpostaddr6` varchar(40) NOT NULL DEFAULT '',
  `specialinstructions` text NOT NULL,
  `custbranchcode` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`branchcode`,`debtorno`),
  KEY `BrName` (`brname`),
  KEY `DebtorNo` (`debtorno`),
  KEY `Salesman` (`salesman`),
  KEY `Area` (`area`),
  KEY `DefaultLocation` (`defaultlocation`),
  KEY `DefaultShipVia` (`defaultshipvia`),
  KEY `taxgroupid` (`taxgroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Constraints for dumped tables
--

--
-- Limitadores para a tabela `custbranch`
--
ALTER TABLE `custbranch`
  ADD CONSTRAINT `custbranch_ibfk_1` FOREIGN KEY (`debtorno`) REFERENCES
`debtorsmaster` (`debtorno`),
  ADD CONSTRAINT `custbranch_ibfk_2` FOREIGN KEY (`area`) REFERENCES
`areas` (`areacode`),
  ADD CONSTRAINT `custbranch_ibfk_3` FOREIGN KEY (`salesman`) REFERENCES
`salesman` (`salesmancode`),
  ADD CONSTRAINT `custbranch_ibfk_4` FOREIGN KEY (`defaultlocation`)
REFERENCES `locations` (`loccode`),
  ADD CONSTRAINT `custbranch_ibfk_6` FOREIGN KEY (`defaultshipvia`)
REFERENCES `shippers` (`shipper_id`),
  ADD CONSTRAINT `custbranch_ibfk_7` FOREIGN KEY (`taxgroupid`) REFERENCES
`taxgroups` (`taxgroupid`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


2014-12-04 16:13 GMT-02:00 wertthey <jp...@nu...>:

> After I upgraded  from  4.11.0  to 4.11.5.  I have had a few problems
>
> I will try to accurately display them.
>
> When trying to post a payment FROM a client I search on the client and It
> appears as though there is column missing in my table.  it startes that
> there is a column called
>
> custbranch.salesperson which does not exist.   It is called from the page
> CustomerReceipt.php it appears as though there is a custbranch.salesman
> column.
>
> (Note that When I upgraded to 4.11.5 it did not state that there issues
> with
> the update.)
>
>
> <
> http://weberp-accounting.1478800.n4.nabble.com/file/n4657876/SearchCustomerReceipt.jpg
> >
>
>  This is the export of the structure of my table.
>
> -- phpMyAdmin SQL Dump
> -- version 3.4.9
> -- http://www.phpmyadmin.net
> --
> -- Host: localhost
> -- Generation Time: Dec 04, 2014 at 12:18 PM
> -- Server version: 5.5.28
> -- PHP Version: 5.3.10-1ubuntu3.4
>
> SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
> SET time_zone = "+00:00";
>
> --
> -- Database: `weberp`
> --
>
> -- --------------------------------------------------------
>
> --
> -- Table structure for table `custbranch`
> --
>
> CREATE TABLE IF NOT EXISTS `custbranch` (
>   `branchcode` varchar(10) NOT NULL DEFAULT '',
>   `debtorno` varchar(10) NOT NULL DEFAULT '',
>   `brname` varchar(40) NOT NULL DEFAULT '',
>   `braddress1` varchar(40) NOT NULL DEFAULT '',
>   `braddress2` varchar(40) NOT NULL DEFAULT '',
>   `braddress3` varchar(40) NOT NULL DEFAULT '',
>   `braddress4` varchar(50) NOT NULL DEFAULT '',
>   `braddress5` varchar(20) NOT NULL DEFAULT '',
>   `braddress6` varchar(40) NOT NULL DEFAULT '',
>   `lat` float(10,6) NOT NULL,
>   `lng` float(10,6) NOT NULL,
>   `estdeliverydays` smallint(6) NOT NULL DEFAULT '1',
>   `area` char(3) NOT NULL,
>   `salesman` varchar(4) NOT NULL DEFAULT '',
>   `fwddate` smallint(6) NOT NULL DEFAULT '0',
>   `phoneno` varchar(20) NOT NULL DEFAULT '',
>   `faxno` varchar(20) NOT NULL DEFAULT '',
>   `contactname` varchar(30) NOT NULL DEFAULT '',
>   `email` varchar(55) NOT NULL DEFAULT '',
>   `defaultlocation` varchar(5) NOT NULL DEFAULT '',
>   `taxgroupid` tinyint(4) NOT NULL DEFAULT '1',
>   `defaultshipvia` int(11) NOT NULL DEFAULT '1',
>   `deliverblind` tinyint(1) DEFAULT '1',
>   `disabletrans` tinyint(4) NOT NULL DEFAULT '0',
>   `specialinstructions` varchar(40) NOT NULL DEFAULT '',
>   `brpostaddr1` varchar(40) NOT NULL DEFAULT '',
>   `brpostaddr2` varchar(40) NOT NULL DEFAULT '',
>   `brpostaddr3` varchar(40) NOT NULL DEFAULT '',
>   `brpostaddr4` varchar(50) NOT NULL DEFAULT '',
>   `brpostaddr5` varchar(20) NOT NULL DEFAULT '',
>   `brpostaddr6` varchar(40) NOT NULL DEFAULT '',
>   `custbranchcode` varchar(30) NOT NULL DEFAULT '',
>   PRIMARY KEY (`branchcode`,`debtorno`),
>   KEY `BrName` (`brname`),
>   KEY `DebtorNo` (`debtorno`),
>   KEY `Salesman` (`salesman`),
>   KEY `Area` (`area`),
>   KEY `DefaultLocation` (`defaultlocation`),
>   KEY `DefaultShipVia` (`defaultshipvia`),
>   KEY `taxgroupid` (`taxgroupid`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
> --
> -- Constraints for dumped tables
> --
>
> --
> -- Constraints for table `custbranch`
> --
> ALTER TABLE `custbranch`
>   ADD CONSTRAINT `custbranch_ibfk_1` FOREIGN KEY (`debtorno`) REFERENCES
> `debtorsmaster` (`debtorno`),
>   ADD CONSTRAINT `custbranch_ibfk_2` FOREIGN KEY (`area`) REFERENCES
> `areas`
> (`areacode`),
>   ADD CONSTRAINT `custbranch_ibfk_3` FOREIGN KEY (`salesman`) REFERENCES
> `salesman` (`salesmancode`),
>   ADD CONSTRAINT `custbranch_ibfk_4` FOREIGN KEY (`defaultlocation`)
> REFERENCES `locations` (`loccode`),
>   ADD CONSTRAINT `custbranch_ibfk_6` FOREIGN KEY (`defaultshipvia`)
> REFERENCES `shippers` (`shipper_id`),
>   ADD CONSTRAINT `custbranch_ibfk_7` FOREIGN KEY (`taxgroupid`) REFERENCES
> `taxgroups` (`taxgroupid`);
>
>
>
> -----
> 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-tp4657876.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
>



-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil

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

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

After I upgraded  from  4.11.0  to 4.11.5.  I have had a few problems

I will try to accurately display them.

When trying to post a payment FROM a client I search on the client and It
appears as though there is column missing in my table.  it startes that
there is a column called 

custbranch.salesperson which does not exist.   It is called from the page
CustomerReceipt.php it appears as though there is a custbranch.salesman
column.

(Note that When I upgraded to 4.11.5 it did not state that there issues with
the update.)


<http://weberp-accounting.1478800.n4.nabble.com/file/n4657876/SearchCustomerReceipt.jpg> 

 This is the export of the structure of my table. 

-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 04, 2014 at 12:18 PM
-- Server version: 5.5.28
-- PHP Version: 5.3.10-1ubuntu3.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `weberp`
--

-- --------------------------------------------------------

--
-- Table structure for table `custbranch`
--

CREATE TABLE IF NOT EXISTS `custbranch` (
  `branchcode` varchar(10) NOT NULL DEFAULT '',
  `debtorno` varchar(10) NOT NULL DEFAULT '',
  `brname` varchar(40) NOT NULL DEFAULT '',
  `braddress1` varchar(40) NOT NULL DEFAULT '',
  `braddress2` varchar(40) NOT NULL DEFAULT '',
  `braddress3` varchar(40) NOT NULL DEFAULT '',
  `braddress4` varchar(50) NOT NULL DEFAULT '',
  `braddress5` varchar(20) NOT NULL DEFAULT '',
  `braddress6` varchar(40) NOT NULL DEFAULT '',
  `lat` float(10,6) NOT NULL,
  `lng` float(10,6) NOT NULL,
  `estdeliverydays` smallint(6) NOT NULL DEFAULT '1',
  `area` char(3) NOT NULL,
  `salesman` varchar(4) NOT NULL DEFAULT '',
  `fwddate` smallint(6) NOT NULL DEFAULT '0',
  `phoneno` varchar(20) NOT NULL DEFAULT '',
  `faxno` varchar(20) NOT NULL DEFAULT '',
  `contactname` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(55) NOT NULL DEFAULT '',
  `defaultlocation` varchar(5) NOT NULL DEFAULT '',
  `taxgroupid` tinyint(4) NOT NULL DEFAULT '1',
  `defaultshipvia` int(11) NOT NULL DEFAULT '1',
  `deliverblind` tinyint(1) DEFAULT '1',
  `disabletrans` tinyint(4) NOT NULL DEFAULT '0',
  `specialinstructions` varchar(40) NOT NULL DEFAULT '',
  `brpostaddr1` varchar(40) NOT NULL DEFAULT '',
  `brpostaddr2` varchar(40) NOT NULL DEFAULT '',
  `brpostaddr3` varchar(40) NOT NULL DEFAULT '',
  `brpostaddr4` varchar(50) NOT NULL DEFAULT '',
  `brpostaddr5` varchar(20) NOT NULL DEFAULT '',
  `brpostaddr6` varchar(40) NOT NULL DEFAULT '',
  `custbranchcode` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`branchcode`,`debtorno`),
  KEY `BrName` (`brname`),
  KEY `DebtorNo` (`debtorno`),
  KEY `Salesman` (`salesman`),
  KEY `Area` (`area`),
  KEY `DefaultLocation` (`defaultlocation`),
  KEY `DefaultShipVia` (`defaultshipvia`),
  KEY `taxgroupid` (`taxgroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `custbranch`
--
ALTER TABLE `custbranch`
  ADD CONSTRAINT `custbranch_ibfk_1` FOREIGN KEY (`debtorno`) REFERENCES
`debtorsmaster` (`debtorno`),
  ADD CONSTRAINT `custbranch_ibfk_2` FOREIGN KEY (`area`) REFERENCES `areas`
(`areacode`),
  ADD CONSTRAINT `custbranch_ibfk_3` FOREIGN KEY (`salesman`) REFERENCES
`salesman` (`salesmancode`),
  ADD CONSTRAINT `custbranch_ibfk_4` FOREIGN KEY (`defaultlocation`)
REFERENCES `locations` (`loccode`),
  ADD CONSTRAINT `custbranch_ibfk_6` FOREIGN KEY (`defaultshipvia`)
REFERENCES `shippers` (`shipper_id`),
  ADD CONSTRAINT `custbranch_ibfk_7` FOREIGN KEY (`taxgroupid`) REFERENCES
`taxgroups` (`taxgroupid`);



-----
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-tp4657876.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

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

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

After I upgraded  from  4.11.0  to 4.11.5.  I have been having scores of
problems.

I will try to accurately display them.


When trying to post a payment I received.

There is confusing text.  (To enter a payment TO a customer ) (ie. to pay
out a credit note), enter a negative payment amount.

  This was where I Always have entered receiving a Payment FROM a customer.
Also Negative amount.?

<http://weberp-accounting.1478800.n4.nabble.com/file/n4657875/Reciept1.jpg> 





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

Re: [WebERP-developers] Help with "Pan Size"

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

Hi Klaus,

Thank you, very much.

Best regards, Rafael.

2014-11-30 0:25 GMT-06:00 opto <bu...@op...>:

> >In German, Is "pan size"  translated as "rounding quantity" ?
>
> I think it is 'Verpackungseinheit', abbreviated VPE, meaning: how many
> items
> do I have to buy at a time (because they are packaged together or the
> manufacturer just does want it this way).
>
> thanks,
> Klaus
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Help-with-Pan-Size-tp4657859p4657868.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=157005751&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Help with "Pan Size"

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

Hi Exson,

You are welcome.

Best regards, Rafael.

2014-11-30 0:15 GMT-06:00 ExsonQu <hex...@gm...>:

> *Hi, Rafael,*
>
>          Thank you for your nice work! It'll help users for this.
>
>          Best regards!
>
>          Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Help-with-Pan-Size-tp4657859p4657867.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=157005751&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Help with "Pan Size"

[opto <bu...@op...>]

>In German, Is "pan size"  translated as "rounding quantity" ?

I think it is 'Verpackungseinheit', abbreviated VPE, meaning: how many items
do I have to buy at a time (because they are packaged together or the
manufacturer just does want it this way).

thanks,
Klaus



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Help-with-Pan-Size-tp4657859p4657868.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Help with "Pan Size"

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

*Hi, Rafael,*

         Thank you for your nice work! It'll help users for this. 

         Best regards!

         Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Help-with-Pan-Size-tp4657859p4657867.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Help with "Pan Size"

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

Hi all,

I updated stock.php with a mouse-over help text "*Order multiple. It is the
minimum packing quantity.*" for the field "Pan Size".

Also, I updated ManualInventory.html:

*"Pan Size*

*This modifier is sometimes called the order multiple. It is the minimum
packing quantity. It allows you to create planned orders in even multiples.
This is especially useful if you are required by your suppliers to place
orders in specific lot sizes. It is also a useful modifier is you have
established your own production run sizes. This modifier causes MRP to
inflate the required order quantity to an even increment of the pansize
value. As with all modifiers you do need to be careful with this modifier
as its use could lead to excess inventories.*

*In other words if it is most efficient to manufacture an item in batches
of 10 then the pan size would be 10, and MRP would calculate demand in
batches of 10, so would inflate a demand of 17 to 20. For instance, we
purchase some chemical materials which is 25 kg/pack. The pansize means you
have to purchase at least one pack each time."*

In Spanish, one possibility is to translate "pan size" as "lot size" or
"packing size". "Size of the multiple" is math right, but very uncommon.

Thanks. Best regards, Rafael.

2014-11-29 9:00 GMT-06:00 Rafael Chacón <raf...@gm...>:

> Thank you very much Exson!
>
> 2014-11-29 8:59 GMT-06:00 Rafael Chacón <raf...@gm...>:
>
> Hi Klaus:
>>
>> Spanish:
>> "Es el redondeo aplicado a las PO y WO. Se usa para que las órdenes de
>> compra y de producción sean números "cómodos", incrementos de las PO y WO
>> de X en X.
>> Si Pan Size es 10, las cantidades en las PO y WO se redondean al alza a
>> 10. En vez de ordenar 104 pcs, se redondeará a 110."
>>
>> Aprox. translation to English:
>> "It rounding applied to the PO and WO. It is used to purchase and
>> production orders be "comfortable" {practical} numbers, it increases the PO
>> and WO in X multiples {Spanish modism}.
>> If Pan Size is 10, the amounts in the PO and WO are rounded up {ceiled?}
>> to 10. Instead of ordering 104 pcs, it is rounded to 110."
>>
>> In German, Is "pan size"  translated as "rounding quantity" ?
>>
>> Best regards, Rafael.
>>
>> 2014-11-29 2:58 GMT-06:00 opto <bu...@op...>:
>>
>> As I am also unsure what it means - can you also repeat that in English?
>>>
>>> Thanks,  Klaus
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://weberp-accounting.1478800.n4.nabble.com/Help-with-Pan-Size-tp4657859p4657862.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=157005751&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>
>>
>

Re: [WebERP-developers] Help with "Pan Size"

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

Thank you very much Exson!

2014-11-29 8:59 GMT-06:00 Rafael Chacón <raf...@gm...>:

> Hi Klaus:
>
> Spanish:
> "Es el redondeo aplicado a las PO y WO. Se usa para que las órdenes de
> compra y de producción sean números "cómodos", incrementos de las PO y WO
> de X en X.
> Si Pan Size es 10, las cantidades en las PO y WO se redondean al alza a
> 10. En vez de ordenar 104 pcs, se redondeará a 110."
>
> Aprox. translation to English:
> "It rounding applied to the PO and WO. It is used to purchase and
> production orders be "comfortable" {practical} numbers, it increases the PO
> and WO in X multiples {Spanish modism}.
> If Pan Size is 10, the amounts in the PO and WO are rounded up {ceiled?}
> to 10. Instead of ordering 104 pcs, it is rounded to 110."
>
> In German, Is "pan size"  translated as "rounding quantity" ?
>
> Best regards, Rafael.
>
> 2014-11-29 2:58 GMT-06:00 opto <bu...@op...>:
>
> As I am also unsure what it means - can you also repeat that in English?
>>
>> Thanks,  Klaus
>>
>>
>>
>> --
>> View this message in context:
>> http://weberp-accounting.1478800.n4.nabble.com/Help-with-Pan-Size-tp4657859p4657862.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=157005751&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
>

Re: [WebERP-developers] Help with "Pan Size"

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

Hi Klaus:

Spanish:
"Es el redondeo aplicado a las PO y WO. Se usa para que las órdenes de
compra y de producción sean números "cómodos", incrementos de las PO y WO
de X en X.
Si Pan Size es 10, las cantidades en las PO y WO se redondean al alza a 10.
En vez de ordenar 104 pcs, se redondeará a 110."

Aprox. translation to English:
"It rounding applied to the PO and WO. It is used to purchase and
production orders be "comfortable" {practical} numbers, it increases the PO
and WO in X multiples {Spanish modism}.
If Pan Size is 10, the amounts in the PO and WO are rounded up {ceiled?} to
10. Instead of ordering 104 pcs, it is rounded to 110."

In German, Is "pan size"  translated as "rounding quantity" ?

Best regards, Rafael.

2014-11-29 2:58 GMT-06:00 opto <bu...@op...>:

> As I am also unsure what it means - can you also repeat that in English?
>
> Thanks,  Klaus
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Help-with-Pan-Size-tp4657859p4657862.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=157005751&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Help with "Pan Size"

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

*Hi, Rafael,*

        I think PanSize is minimum packing quantity.
        For instance, we purchase some chemical materials which is
25kg/pack. The pansize means you have to purchase at least one pack each
time. 
        And for the packing material, such as inner packing box for LCD
panel, each packing box will have 8 pieces of panel, when we set up a BOM
for it, the bom used quantity should be 1/8. And The packing box used must
at least 1 piece of packing boxes when we calculate material request, for
example, when we calculate material requirements for 9 pieces of panels, it
must be 2 instead of 1.125 pieces packing boxes.If you want to get a correct
result, it must be set PanSize as 1. 
        Just my 2cents.

        Best regards!

       Exson
        
          



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Help-with-Pan-Size-tp4657859p4657863.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Help with "Pan Size"

[opto <bu...@op...>]

As I am also unsure what it means - can you also repeat that in English?

Thanks,  Klaus



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Help-with-Pan-Size-tp4657859p4657862.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Help with "Pan Size"

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

Thank you very much Ricard!

2014-11-28 17:51 GMT-06:00 Pak Ricard <pak...@gm...>:

> Hi Rafael:
>
> Will reply in Spanish, as it will help Rafael to find the exact word he is
> looking for and I'm missing :-)
>
> Es el redondeo aplicado a las PO y WO. Se usa para que las órdenes de
> compra y de producción sean números "cómodos", incrementos de las PO y WO
> de X en X.
>
> Si Pan Size es 10, las cantidades en las PO y WO se redondean al alza a
> 10. En vez de ordenar 104 pcs, se redondeará a 110. No sé el término exacto
> en español, pero el concepto es éste.
>
> Si descubres una palabra española que sirva para el concepto, por favor
> házmelo saber!
>
> Un saludo.
>
> Regards,
> Ricard
>
> 2014-11-28 23:06 GMT+08:00 Rafael Chacón <raf...@gm...>:
>
>> Hello all,
>>
>> In Item Maintenance (Stocks.php?StockID=...) we have the field "Pan Size"
>> (stockmaster.pansize double).
>>
>> I am a Spanish native speaker. This field is translated as "panoramic
>> size" (NO sense). Also, I see other languages ("plate size" --no sense--,
>> and "rounding quantity" --no sense--).
>>
>> Can someone tell me what that field is used for?
>>
>> 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, FREE
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&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=157005751&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Help with "Pan Size"

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

Hi Rafael:

Will reply in Spanish, as it will help Rafael to find the exact word he is
looking for and I'm missing :-)

Es el redondeo aplicado a las PO y WO. Se usa para que las órdenes de
compra y de producción sean números "cómodos", incrementos de las PO y WO
de X en X.

Si Pan Size es 10, las cantidades en las PO y WO se redondean al alza a 10.
En vez de ordenar 104 pcs, se redondeará a 110. No sé el término exacto en
español, pero el concepto es éste.

Si descubres una palabra española que sirva para el concepto, por favor
házmelo saber!

Un saludo.

Regards,
Ricard

2014-11-28 23:06 GMT+08:00 Rafael Chacón <raf...@gm...>:

> Hello all,
>
> In Item Maintenance (Stocks.php?StockID=...) we have the field "Pan Size"
> (stockmaster.pansize double).
>
> I am a Spanish native speaker. This field is translated as "panoramic
> size" (NO sense). Also, I see other languages ("plate size" --no sense--,
> and "rounding quantity" --no sense--).
>
> Can someone tell me what that field is used for?
>
> 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, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

[WebERP-developers] Help with "Pan Size"

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

Hello all,

In Item Maintenance (Stocks.php?StockID=...) we have the field "Pan Size"
(stockmaster.pansize double).

I am a Spanish native speaker. This field is translated as "panoramic size"
(NO sense). Also, I see other languages ("plate size" --no sense--, and
"rounding quantity" --no sense--).

Can someone tell me what that field is used for?

Best regards, Rafael.

Re: [WebERP-developers] SelectCustomer.php only shows Sales Invoice and Credit Note

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

*Hi, Wertthey,*

             It's a bug and only appeared when user's role is a sales
person. It's already fixed in trunk. You can replace it with the attachment
to solve this problem. 

            Best regards!
CustomerInquiry.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4657848/CustomerInquiry.zip>  
            Exson





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/SelectCustomer-php-only-shows-Sales-Invoice-and-Credit-Note-tp4657847p4657848.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Weberp - Different warehouse allocated to each items in the Sales Order

[Arwan <r1g...@gm...>]

http://weberp-accounting.1478800.n4.nabble.com/Sales-orders-and-delivery-from-stock-locations-td4655506.html#a4655508
<http://weberp-accounting.1478800.n4.nabble.com/Sales-orders-and-delivery-from-stock-locations-td4655506.html#a4655508>  

I don't think this can be done at the moment but to change it wouldn't
be that hard. We would have to drop the `fromstkloc` field from the
header to the line, make this changeable in the line script, and then
change the issue sql to pick up that field. I suppose ultimately it
depends on how many people want it done that way, and who has the time
to code it.

Thanks
Tim 



-----
WebTech Resources
Nairobi Kenya
+254 724659244
Email  :in...@we...  
WEB  :weberp.co.ke

--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Weberp-Different-warehouse-allocated-to-each-items-in-the-Sales-Order-tp4657845p4657846.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Z_DeleteInvoice don't clear invoiced_qty correctly

[gilberto d. s. a. <gs...@gm...>]

i am try to reproduce and understand what is going on, before our migration
from 4.11.3 to 4.11.5. thanks.

2014-11-17 20:45 GMT-02:00 Alessandro Saporetti <ADS...@ac...
>:

> latest available on the official web  4.11.5
>
> Il giorno 10/nov/2014, alle ore 22:24, gilberto dos santos alves <
> gs...@gm...> ha scritto:
>
> > please what verstion that you is talking? thanks.
> >
> > 2014-11-07 13:37 GMT-02:00 Alessandro Saporetti <
> ADS...@ac...>:
> > Hi all
> > Z_DeleteInvoice do not clear the qty_invoiced from the invoice to the
> sales order see line 121
> >         $SQL = "UPDATE salesorderdetails SET qtyinvoiced = qtyinvoiced -
> " . $OrderLine['qty'] . “,
> > as  $OrderLine[‘qty’] from stock moves is negative internally it’s
> adding it in reality so at the end of the deletion you end up with
> salesorderdetails.qtyinvoiced doubled instead of cleared.
> > Can i simply change the “-“ with “+” and all is well ? or there is a
> finer point that i don’t get ?
> > thanks all
> > Alessandro Saporetti
> >
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
> >
> >
> > --
> > gilberto dos santos alves
> > +55.11.98646-5049
> > sao paulo - sp - brasil
> >
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Comprehensive Server Monitoring with Site24x7.
> > Monitor 10 servers for $9/Month.
> > Get alerted through email, SMS, voice calls or mobile push notifications.
> > Take corrective actions from your mobile device.
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&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=157005751&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil