Differences between revisions 1 and 8 (spanning 7 versions)
⇤ ← Revision 1 as of 2006-07-12 06:35:19 →
Size: 927
Editor: FayezMoussa
Comment:
← Revision 8 as of 2013-09-18 06:09:33 → ⇥
Size: 1558
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
(Update demo data)
Line 10: Line 11:
 dateroll [-d numDays|-v] [-?]  dateroll [-d numDays|-v] [-t dd/mm/yy] [-?]
Line 13: Line 14:
         -t Maximum date to be applied in dd/mm/yy format
Line 14: Line 16:
%> dateroll -d 365 -v %> dateroll -d 365 -v -t 31/01/09
Line 17: Line 19:
It traverses through the transaction file {{{tran.dat}}} and adds the number of days specified to any non zero dates found. It ignores any transaction with the EXTN flag on it. It traverses through the transaction file {{{tran.dat}}} and adds the number of days specified to any non zero dates found. If date calculated is higher than the Maximum date passed on with -t switch then maximum date will apply. It ignores any transaction with the EXTN flag on it.
Line 22: Line 24:
On the debtor record, last invoice({{{lastinv}}}) is updated. On the debtor record, last invoice({{{lastinv}}}) and last payment({{{lastpay}}}) are updated.
Line 24: Line 26:
On the creditor record, last transactions({{{last_tran}}}) is updated. On the creditor record, last transaction({{{last_tran}}}) is updated.

Once the program has finished running, {{{recalc_salesa}}} must be run to recalculate the sales analysis.

Once that is done, the period end dates in {{{glcont}}}, {{{gencont}}} and {{{pedaad}}} must be updated manually.

A reindex,{{{trrein}}}, should be run to reindex by date and by master file.

Finally, {{{recalc_salesa}}}, should be run to recalculate the sales analysis.

Date rolling utility

(Update demo data)

The utility dateroll can be used to roll the date forwards or backwards in a company.

Currently, the program must be compiled under debug sql mode to run correctly. 

%> dateroll -?
Usage:
 dateroll [-d numDays|-v] [-t dd/mm/yy] [-?]
         -d Specify the number of days to roll transactions
         -v Verbose mode
         -t Maximum date to be applied in dd/mm/yy format
         -? Print this help
%> dateroll -d 365 -v -t 31/01/09

It traverses through the transaction file tran.dat and adds the number of days specified to any non zero dates found. If date calculated is higher than the Maximum date passed on with -t switch then maximum date will apply. It ignores any transaction with the EXTN flag on it.

The program also goes through the stock record, the debtor record and the creditor record. On the stock record, last movement(lastmov) and last purchase(lpdate) fields are updated.

On the debtor record, last invoice(lastinv) and last payment(lastpay) are updated.

On the creditor record, last transaction(last_tran) is updated.

Once the program has finished running, recalc_salesa must be run to recalculate the sales analysis.

Once that is done, the period end dates in glcont, gencont and pedaad must be updated manually.

A reindex,trrein, should be run to reindex by date and by master file.

Finally, recalc_salesa, should be run to recalculate the sales analysis.

DateRoll (last edited 2013-09-18 06:09:33 by localhost)