Search options (Page 153 of 246)

It will be difficult to remember everyone's GST number besides they are generally quite long and the drop down select box will become too wide. Better still would be make a short alphabetical code for customers and implement by concatenation.

Check the raw content of any html email successfully received by gmail or yahoo mail and compare it with the mail you send out from FA and see what headers if any are missing and add them in.

Try to use PHPMailer and submit to FA for inclusion when done.

FA uses mail() to send mail and is on the Wiki.

Line 1026 in reporting/includes/pdf_reports.inc:

                        $mail->text($msg . $sender);

can be replaced with:

                        $mail->html($msg . $sender);

if the $msg has html content.

Similar replacement can be done on line 77 in inventory/includes/inventory_db.inc.

Describe what you mean by "look f input parameters". They are listed in reporting/reports_main.php and the reporting/rep708.php does the job.

Add an Attachment is for adding it to the transaction in FA and not to add an attachment to be emailed!

You might want to use SimpleInvoices to manage each project as a client and then get the summary each month into your FA. You might want to try out my fork of it as well.

1. Constants are defined in includes/types.inc
2. config.php has the Global settings
3. #_sys_prefs table has the company specific variables.
4. Form Inputs are accessed by GET and POST variables and may have names similar to table/field names.
5. Functions are present all over the place in various files and can be differently defined in different files.
6. File inclusions can be nested as well.

Don't worry, it is common to get befuddled at first but as you gain experience in inspecting variables at each point in the codebase for each event you will become more familiar. The community is quite helpful but it is better to search the Wiki / Forum for info before defraying scarce voluntary time resources.

Unfortunately, the values are stored in the tables in a disjoint manner. The full values of amount and tax are stored in #_debtor_trans_details. The "net of discount" values are stored in #_debtor_trans - the last line in the Print Invoice takes it's value for INVOICE TOTAL from here.

You will need a completely different SQL linking the tables appropriately to get what you want. Otherwise, it will need to find a place in the Comments field manually entered which is what I assume you are doing now.!

The balances come from a different function. You could however, iterate within the loop using a variable to hold the sum (and the logic of date differences) to achieve what you want.

You have literally opened a can of worms here. Hope FA 2.4 addresses it better. Thanks for stirring up the proverbial hornet's nest and lets see what good comes of it.

You could test out the rep101.php with dimensions and report your findings. I do not see the use of any Dimensions in it.

Use the full original value of the ABC Service Item in the invoice with the cost you would normally charge but use 100% as discount.

Unfortunately, this report has not been coded for excel and hence the choice is not there in the menu.

The simulation of the sql in the function getTransactions() in reporting/rep108.php using the en_US-demo.sql Chart of Accounts is illustrated in the attachment herein - it contains the raw table data and the sql results which includes the CUSTCREDIT entries as well. The Simulation SQL is:

SET @date_due := '2014-09-23';
SET @date_now := '2014-07-25';
SET @debtor_no := 3;
SET @dimension_id := 2; -- Dimension 1
-- SET @dimension2_id := 2; -- Dimension 2

-- Taken from defines in includes/types.inc
-- ST_SALESINVOICE = 10
-- ST_CUSTCREDIT   = 11
-- ST_CUSTDELIVERY = 13


SELECT  dt.*,
        (ov_amount + ov_gst + ov_freight + ov_freight_tax + ov_discount) AS TotalAmount, alloc AS Allocated,
    ((TYPE = 10) AND due_date < @date_now) AS OverDue
FROM 1_debtor_trans dt
WHERE tran_date <= @date_due 
  AND debtor_no = @debtor_no
  AND TYPE <> 13
  AND ABS(ov_amount + ov_gst + ov_freight + ov_freight_tax + ov_discount) > 1e-6
-- if (!$show_also_allocated)
-- AND ABS(ABS(ov_amount + ov_gst + ov_freight + ov_freight_tax + ov_discount) - alloc) > 1e-6
-- Dimension 1
 AND dimension_id = @dimension_id
-- Dimension 2
-- AND dimension2_id = @dimension2_id
ORDER BY tran_date;

FLOAT_COMP_DELTA defined as a FA constant in PHP is used instead of 1e-6 in some places.

You may use the above in any MySQL client and execute them all on your database and check the results.

I see no reason why your output does not conform to what is expected. Please clear your report and js cache and try it again and use appropriate values for the constants defined in the code above on your database and verify the results to see if it matches your output.

The dimension name comes from another table and you will have to alter the sql to join it to that table like:

SELECT ....., d1.name AS D1Name
-- Dimension 2 if used
-- , d2. name A D2Name 
FROM 1_debtor_trans dt 
LEFT JOIN 1_dimensions d1 ON (dt.dimension_id=d1.id)
-- Dimension 2 if used
-- LEFT JOIN 1_dimensions d2 ON (dt.dimension2_id=d2.id)
WHERE ......
ORDER BY tran_date;

Then use the D1Name (and D2Name if appropriate) as desired in the report. Experiment with INNER JOIN instead of LEFT JOIN for the first or both instances as desired.