1

(7 replies, posted in Installation)

yep, even the computer due to frustration

2

(7 replies, posted in Installation)

I did that but i still kept getting the error message

3

(7 replies, posted in Installation)

Someone please help me out

4

(7 replies, posted in Installation)

Hi,

I tried installing version 2.3.9 and encountered the following problem OpenSSL PHP extension have to be enabled to use extension repository system. I enabled OpenSSL PHP on my php.ini file and restarted apache several times and even the computer without much luck.

what else needs to be done?

Thanks in advance.

Marvin

what are the login details for FA on http://fa2.iron.from.pl?

6

(9 replies, posted in Reporting)

oh..i was so worried!

i just encountered an error un deleting an installed module

Parse error: syntax error, unexpected ')' in E:\Apache2\www\plot\modules\installed_modules.php on line 9

8

(9 replies, posted in Reporting)

this is what im getting

%PDF-1.3
3 0 obj
<</Type /Page
/Parent 1 0 R
/MediaBox [0 0 595.28 841.89]
/Resources 2 0 R
/Contents 4 0 R>>
endobj
4 0 obj
<</Filter /FlateDecode /Length 806>>
stream
xœµ—]OÛ0†ïû+Ž´ Xê $N¸+¬tcÚ†ÖÜLÀEÖ˜’)MPš±_?·ù:n˜µ‘š¶¶à9¯ÏyíãÇð.Õó ®oÕG¢ž™z–£³Æ(s è¦Ñˆ¼öèöëã?P„~ÿ>±úÏ=ßÛ~ ˆØ~¬F.AÃlóÈ4`;Åû©7 ûLäVI„jÞ…( ë£ùæá!Ke    gqç ¹>¾…è² Hµ€ÍTh$ z Ô¾&›ÕOY¦p^ÜÝI    ³²x”åZ ‹˜‹´ÓtðŠ…ÛE»*Ó¼‚o›
>Ä•<5`Ó!œÐ1%cFH ÊwJ„‰ö&UˆŸ‹8»/Ö•yJ|ÖQ/ҵ—6ò È*êµËÇ{à*9¬IÎÍÑdQ¥¿åͱ…¡€“d•æéº*ãª(Í“äõ. æ‰5Ç lïsµ<è°í¾¶¡a'Yf.“ùï|S–2_<Ù ‰°íai‹•„EÇ ŒÇÄ~˜«x) î1Ûã]0Š ÷fØïÜ𠩤¯MTÆù¢§i!™ˆûÎ'¸í2 2>$n$R9óœ0Ô¨ç÷q¹Dýðhè«ZÊ$ L ®Çœ0Ð jSª¶PÉÄÄÝÄw\¡aU‹\Wqž¤ùrÿR0pngzÂ5Ó×ÃÞôê>AÍ]ï®ãúµÊ/Ó \ȲJ³ô º4˜; Ã?Oç j õ… Ú ñBQŽè¡ëôÉà@‡«øi%ójO×{Ó    ¡&@12>&¡ÞÖ^Ïå"tB_ã
BNÙ†3ຮû&\ Ç õÄ* ë;|ÊéBZð¢sfÁˆÇ\ 6h7&æz6ìEk n`Ó^ˆkÇ^$ÜçR+zëôrÿ-M†èœ[0â1aÑd˜X4âºVŠ&Øî¬A\Köú¥]d Öëá® ìCÚÿš‹Š*ÎL’OĶ—c$=a6Ò߶&D¶Óšø3Š ¦-/"{/–—èå%}yŸ¹ÎZq/º×LýˆI@¯» Uã„m¨·q&Ût‚®Ø¦0ùE'xêVŒœÐ wNý‘7šÄ
endstream
endobj
1 0 obj
<</Type /Pages
/Kids [3 0 R ]
/Count 1
>>
endobj
5 0 obj
<</Type /OCG /Name (print)
/Usage <</Print <</PrintState /ON>> /View <</ViewState /OFF>>>>>>
endobj
6 0 obj
<</Type /OCG /Name (view)
/Usage <</Print <</PrintState /OFF>> /View <</ViewState /ON>>>>>>
endobj
7 0 obj
<</Type /Font
/BaseFont /Helvetica
/Subtype /Type1
/Encoding /WinAnsiEncoding
>>
endobj
8 0 obj
<</Type /Font
/BaseFont /Helvetica-Bold
/Subtype /Type1
/Encoding /WinAnsiEncoding
>>
endobj
9 0 obj
<</Type /Font
/BaseFont /Helvetica-Oblique
/Subtype /Type1
/Encoding /WinAnsiEncoding
>>
endobj
2 0 obj
<<
/ProcSet [/PDF /Text /ImageB /ImageC /ImageI]
/Font <<
/F1 7 0 R
/F2 8 0 R
/F3 9 0 R
>>
/XObject <<
>>
/Properties <</OC1 5 0 R /OC2 6 0 R>>
/ExtGState <<
>>
>>
endobj
10 0 obj
<<
/Title (Supplier Balances)
/Author (Kahawa Yetu 1.0.1)
/Subject (Supplier Balances)
/Creator (PlugIT - http://www.plugit.net)
/Producer (TCPDF 4.0.017_PHP4 \(http://www.tcpdf.org\))
/CreationDate (D:20081001120732)
/ModDate (D:20081001120732)
>>
endobj
11 0 obj
<<
/Type /Catalog
/Pages 1 0 R
/OpenAction [3 0 R /FitH null]
/PageLayout /SinglePage
/PageMode /UseNone
/Lang /en_US
/ViewerPreferences<<
/Direction /L2R
>>
/OCProperties <</OCGs [5 0 R 6 0 R] /D <</ON [5 0 R] /OFF [6 0 R] /AS [<</Event /Print /OCGs [5 0 R 6 0 R] /Category [/Print]>> <</Event /View /OCGs [5 0 R 6 0 R] /Category [/View]>>]>>>>
>>
endobj
xref
0 12
0000000000 65535 f
0000000993 00000 n
0000001566 00000 n
0000000009 00000 n
0000000117 00000 n
0000001050 00000 n
0000001158 00000 n
0000001265 00000 n
0000001361 00000 n
0000001462 00000 n
0000001745 00000 n
0000002010 00000 n
trailer
<<
/Size 12
/Root 11 0 R
/Info 10 0 R
>>
startxref
2375
%%EOF

9

(9 replies, posted in Reporting)

another error just occured on copying the files into the repgen folder. the reports are not working.

10

(9 replies, posted in Reporting)

i have figured out the error. the module installation did not copy files into the repgen folder so on coping the rest of the files manualy, it worked

11

(9 replies, posted in Reporting)

this is strange, it says

require_once(repgen_const.inc) [function.require-once]: failed to open stream: No such file or directory in file: E:\Apache2\www\plot\modules\repgen\repgen_select.php at line 37
require_once() [function.require]: Failed opening required 'repgen_const.inc' (include_path='.;C:\php5\pear') in E:\Apache2\www\plot\modules\repgen\repgen_select.php on line 37

but the file exists in that location

12

(9 replies, posted in Reporting)

checked the database after installing the database and looks like it dint run the sql on installation.

ran the query and created the table xx_reports but that dint solve the problem either

13

(9 replies, posted in Reporting)

I just installed the repgen2 on my FA and i get a blank page when i try to access the page. What could be the error. here's my working enviroment.


FA version 2.0.1
Apache/2.0.63 (Win32)
PHP/5.2.6
Mysql 5.0.51a

i hit a snag in the above adventure so i'll look into it later..now, i need to implement a loan management module which will allow the co-operatives to give their members crop picking advances(loans) for buying farm implements. i just need a quick guide on how i can go about it...any help will be appreciated

15

(11 replies, posted in Accounts Receivable)

still testing, will post any errors i come accross

and also, i want to remove the branch functionality without damaging the application because the members do not have branches. i'm already thankful for all the advise and pointers

the search customer list is already checked but still cannot search. i did not understnad the F4 key part, care to be more layman?

18

(2 replies, posted in Accounts Receivable)

Thank You Itronics, it's worked

19

(11 replies, posted in Accounts Receivable)

I'll faithfully do so. Thank you joe for your prompt responses. i've just encountered an issue with the balance sheet. let me just try again before i post

the balance sheet is fine...

thanks, it worked. now i have another problem. the society has 2000 members so scrolling down the list to get member number 2000 will not be fun for sure. how can i convert the drop down to be editable so that the data entry clerk can type the member number and it automatically gets the details same as it was implemented in the Purchase Order Entry?

21

(2 replies, posted in Accounts Receivable)

i encountered another error on opening Customer Allocations

DATABASE ERROR : Cannot retreive debtor transactions
error code : 1052
error message : Column 'type' in where clause is ambiguous
sql that failed was : SELECT 0_debtor_trans.*, ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total, 0_debtors_master.name AS DebtorName, 0_debtors_master.address, 0_debtors_master.curr_code, 0_debtor_trans.version , round(ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount-alloc,6) <= 0 AS settled FROM 0_debtor_trans, 0_debtors_master WHERE 0_debtor_trans.debtor_no=0_debtors_master.debtor_no AND (type=12 OR type=11 OR type=2) AND (0_debtor_trans.ov_amount > 0) AND (round(ov_amount+ov_gst+ov_freight+ov_freight_tax-ov_discount-alloc,6) > 0) AND 0_debtor_trans.debtor_no = 8 ORDER BY trans_no

22

(11 replies, posted in Accounts Receivable)

seems to have worked but then there's another error,

DATABASE ERROR : The debtor transaction record could not be inserted
error code : 1366
error message : Incorrect integer value: '' for column 'ship_via' at row 1
sql that failed was : INSERT INTO 0_debtor_trans ( trans_no, type, debtor_no, branch_code, tran_date, due_date, reference, tpe, order_, ov_amount, ov_discount, ov_gst, ov_freight, ov_freight_tax, rate, ship_via, alloc, trans_link ) VALUES (10, 12, '8', '10', '2008/09/25', '0000-00-00', '9', '0', 0, 6500000, '0', 0, '0', 0, 1, '', 0, '0')

corrected this by changing $ship_via="" to $ship_via=0 on line 89

it worked, thanks alot...

24

(11 replies, posted in Accounts Receivable)

no luck itronics, below  is the error that i get.

DATABASE ERROR : The debtor transaction record could not be inserted
error code : 1292
error message : Incorrect date value: '20//' for column 'due_date' at row 1
sql that failed was : INSERT INTO 0_debtor_trans ( trans_no, type, debtor_no, branch_code, tran_date, due_date, reference, tpe, order_, ov_amount, ov_discount, ov_gst, ov_freight, ov_freight_tax, rate, ship_via, alloc, trans_link ) VALUES (10, 12, '6', '9', '2008/09/24', '20//', '9', '0', 0, 6500000, '0', 0, '0', 0, 1, '', 0, '0')


does this $SQLDueDate = date2sql($due_date); on line 89 affect the default value by setting it to  '20//' and would commenting that line affect any other part of the application?

We're using FA to manage a coffee planters co-operative society in Africa in a bid to ensure effective accounting of the societies.

We have tried a lot to adapt it to their accounting methods which has not been as hard thanks to clean coding standards used by the FA development team. The society has two different types of customers, the members themselves and the marketers of the milled coffee in the international market.

What method do i need to edit so that i can be able to select only members or customers or suppliers when i go to enter a Bank Account Payment Entry assuming I've edited the debtors_master to include a field which specifies the type of customer.