web-erp-developers

[WebERP-developers] multiple days/dates for payment terms (purchase orders and sales orders)

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

Hi for all!
I propose add these modification for table paymentterms (add columns
daysparc2, daysparc3, daysparc4, daysparc5 and daysparc6).

Main reason is for allow purchase orders and sales orders and payments
handle multiples (quota or parcela).

I have made modifications on PaymentTerms.php for handle these new fields
on insert, update and delete (see examples details below).
Now i can calculate not only first days for account pable but 2nd, 3rd etc
"parcelas" like 30days, 60days, 90days not only text on name of conditions
but numbers of days for payment after receive purchase materials and for
sales, general ledger etc.

See main aspect that concept already existing on weberp is preserved
(number of days elapsed or specific day in next month). If someone no need
of feature leave news field with zeros or blank (on screen) of
PaymentTerms.php.

Please help me and validate and comment yours oppinions, concepts, problems
and pieces that will not clue.

regards and thanks for weberp.




 Payment Terms Maintenance
Payment Terms. Term Code Description Following Month On Due After (Days) Days
Quota 2 Days Quota 3 Days Quota 4 Days Quota 5 Days Quota 6 2 30, 45 N/A 30
days 0 0 0 0 0 Edit Delete 20 20 do Próximo Mês N/A 22 days 32 42 52 62 72
Edit Delete 30 30 do Próximo Mês N/A N/A 42 0 0 0 0 Edit Delete 36 30 60
dias N/A 36 days 45 60 70 0 0 Edit Delete 7 7 DIAS CORRIDOS N/A 7 days 37 47
0 0 0 Edit Delete 87 confirmar 87 pagtos N/A 5 days 20 30 40 50 60 Edit
Delete a5 50 dias após a entrega N/A 50 days 60 70 80 90 0 Edit Delete


CREATE TABLE IF NOT EXISTS `paymentterms` (
  `termsindicator` char(2) NOT NULL DEFAULT '',
  `terms` char(40) NOT NULL DEFAULT '',
  `daysbeforedue` smallint(6) NOT NULL DEFAULT '0',
  `dayinfollowingmonth` smallint(6) NOT NULL DEFAULT '0',
  `daysparc2` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 2',
  `daysparc3` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 3',
  `daysparc4` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 4',
  `daysparc5` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 5',
  `daysparc6` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 6',
  PRIMARY KEY (`termsindicator`),
  KEY `DaysBeforeDue` (`daysbeforedue`),
  KEY `DayInFollowingMonth` (`dayinfollowingmonth`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil

Re: [WebERP-developers] multiple days/dates for payment terms (purchase orders and sales orders)

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

Hi Gilbertos,

I wonder about the hard coding of a fixed number of installments. Maybe 
a separate table linked to payment terms that allows any number of 
installments per payment term would be ideal?


Phil

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

On 08/01/14 15:15, gilberto dos santos alves wrote:
> Hi for all!
> I propose add these modification for table paymentterms (add columns 
> daysparc2, daysparc3, daysparc4, daysparc5 and daysparc6).
>
> Main reason is for allow purchase orders and sales orders and payments 
> handle multiples (quota or parcela).
>
> I have made modifications on PaymentTerms.php for handle these new 
> fields on insert, update and delete (see examples details below).
> Now i can calculate not only first days for account pable but 2nd, 3rd 
> etc "parcelas" like 30days, 60days, 90days not only text on name of 
> conditions but numbers of days for payment after receive purchase 
> materials and for sales, general ledger etc.
>
> See main aspect that concept already existing on weberp is preserved 
> (number of days elapsed or specific day in next month). If someone no 
> need of feature leave news field with zeros or blank (on screen) of 
> PaymentTerms.php.
>
> Please help me and validate and comment yours oppinions, concepts, 
> problems and pieces that will not clue.
>
> regards and thanks for weberp.
>
>
>
>
> Payment Terms Maintenance
>
>
>       Payment Terms.
>
> Term Code 	Description 	Following Month On 	Due After (Days) 	Days 
> Quota 2 	Days Quota 3 	Days Quota 4 	Days Quota 5 	Days Quota 6
> 2 	30, 45 	N/A 	30 days 	0 	0 	0 	0 	0 	Edit 	Delete
> 20 	20 do Próximo Mês 	N/A 	22 days 	32 	42 	52 	62 	72 	Edit 	Delete
> 30 	30 do Próximo Mês 	N/A 	N/A 	42 	0 	0 	0 	0 	Edit 	Delete
> 36 	30 60 dias 	N/A 	36 days 	45 	60 	70 	0 	0 	Edit 	Delete
> 7 	7 DIAS CORRIDOS 	N/A 	7 days 	37 	47 	0 	0 	0 	Edit 	Delete
> 87 	confirmar 87 pagtos 	N/A 	5 days 	20 	30 	40 	50 	60 	Edit 	Delete
> a5 	50 dias após a entrega 	N/A 	50 days 	60 	70 	80 	90 	0 	Edit 	Delete
>
>
>
> CREATE TABLE IF NOT EXISTS `paymentterms` (
>   `termsindicator` char(2) NOT NULL DEFAULT '',
>   `terms` char(40) NOT NULL DEFAULT '',
>   `daysbeforedue` smallint(6) NOT NULL DEFAULT '0',
>   `dayinfollowingmonth` smallint(6) NOT NULL DEFAULT '0',
>   `daysparc2` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 2',
>   `daysparc3` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 3',
>   `daysparc4` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 4',
>   `daysparc5` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 5',
>   `daysparc6` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 6',
>   PRIMARY KEY (`termsindicator`),
>   KEY `DaysBeforeDue` (`daysbeforedue`),
>   KEY `DayInFollowingMonth` (`dayinfollowingmonth`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
> -- 
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] multiple days/dates for payment terms (purchase orders and sales orders)

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

i agree. i have made this for "easy/fast way".


2014/1/8 Phil Daintree <ph...@lo...>

>  Hi Gilbertos,
>
> I wonder about the hard coding of a fixed number of installments. Maybe a
> separate table linked to payment terms that allows any number of
> installments per payment term would be ideal?
>
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 08/01/14 15:15, gilberto dos santos alves wrote:
>
> Hi for all!
> I propose add these modification for table paymentterms (add columns
> daysparc2, daysparc3, daysparc4, daysparc5 and daysparc6).
>
>  Main reason is for allow purchase orders and sales orders and payments
> handle multiples (quota or parcela).
>
>  I have made modifications on PaymentTerms.php for handle these new
> fields on insert, update and delete (see examples details below).
> Now i can calculate not only first days for account pable but 2nd, 3rd etc
> "parcelas" like 30days, 60days, 90days not only text on name of conditions
> but numbers of days for payment after receive purchase materials and for
> sales, general ledger etc.
>
>  See main aspect that concept already existing on weberp is preserved
> (number of days elapsed or specific day in next month). If someone no need
> of feature leave news field with zeros or blank (on screen) of
> PaymentTerms.php.
>
>  Please help me and validate and comment yours oppinions, concepts,
> problems and pieces that will not clue.
>
>  regards and thanks for weberp.
>
>
>
>
>   Payment Terms Maintenance
>   Payment Terms.  Term Code Description Following Month On Due After
> (Days) Days Quota 2 Days Quota 3 Days Quota 4 Days Quota 5 Days Quota 6  2 30,
> 45 N/A 30 days 0 0 0 0 0 Edit Delete  20 20 do Próximo Mês N/A 22 days 32
> 42 52 62 72 Edit Delete  30 30 do Próximo Mês N/A N/A 42 0 0 0 0 Edit
> Delete  36 30 60 dias N/A 36 days 45 60 70 0 0 Edit Delete  7 7 DIAS
> CORRIDOS N/A 7 days 37 47 0 0 0 Edit Delete  87 confirmar 87 pagtos N/A 5
> days 20 30 40 50 60 Edit Delete  a5 50 dias após a entrega N/A 50 days 60
> 70 80 90 0 Edit Delete
>
>
>  CREATE TABLE IF NOT EXISTS `paymentterms` (
>   `termsindicator` char(2) NOT NULL DEFAULT '',
>   `terms` char(40) NOT NULL DEFAULT '',
>   `daysbeforedue` smallint(6) NOT NULL DEFAULT '0',
>   `dayinfollowingmonth` smallint(6) NOT NULL DEFAULT '0',
>   `daysparc2` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 2',
>   `daysparc3` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 3',
>   `daysparc4` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 4',
>   `daysparc5` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 5',
>   `daysparc6` smallint(3) NOT NULL DEFAULT '0' COMMENT 'days parcela 6',
>   PRIMARY KEY (`termsindicator`),
>   KEY `DaysBeforeDue` (`daysbeforedue`),
>   KEY `DayInFollowingMonth` (`dayinfollowingmonth`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>
>  --
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&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.98646-5049
sao paulo - sp - brasil