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