Anyone out there has a solution?

Otherwise have to resort to shortening the description to below 50 characters - 7000+ items sad

i mean for each item description - it works fine for Sales Order / Invoice. Same item as being entered as PO to be sent to supplier has been shortened to 50 characters.

am using comments for shipping instructions / payment advise details.

how do u make the print  showing description more than 50 characters?

it's on sales/view/view_invoice.php

This morning, all invoices seems not showing upon clicking. However, sales orders are still accessible. Pls advise

Let's wait for apmuthu magical guides.... he may have some outta this world views wink
I even wanted to have extra classifications - sales leads, etc

there is a field in debtor_master table named company where i used to extract the country for a mini CRM i developed for my client using FA as their accounting system.

How to add country field in the form without disrupting the flow?

Does anyone notice that x_debtors_master field country is empty?

9

(2 replies, posted in Reporting)

Found it.

By altering the rep301.php line 160

change the $dec to 2

10

(2 replies, posted in Reporting)

Morning Guys

How do I alter the valuation figures to show only up to 2 decimal instead of current?

Pls advise.

How do I add currency symbol at Invoice top Total --> Total in USD or Total in HKD

I have browse thru the header.inc and rep107

Is there a solution to this requirement? Many times staff fumble to detect client's contact number as it is not stated on the invoice printout.

Under 0_sales_orders, there are order_no, trans_type, debtor_no

Type 30 = sales?
How to identify all sales _orders that are being invoiced as one?

Under 0_debtor_trans, there are trans_no, debtor_no, type, order_

Type 10 = sales customer invoice (trans_no)
Type 12 = payment received for sales customer invoice (trans_no)
Type 13 - sales customer order (trans_no)

How does one know when by sql where type='13', the appropriate inv number can be obtained, to identify all related delivery order for that invoice? numerous delivery orders are Batch processed to generate an invoice.

Pls advise

increased to 3000, invoice generated. issue resolved

increase to 2000, restart apache, logout / login and tried. similar results.
memory_limit 150MB
max_execution_time 30s

I checked the error_log and produce this result
PHP Warning:  Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini. in Unknown on line 0

Is there a limit of Search Not Invoiced Deliveries that can be batch converted to Invoice?

I have this scenario - 46 Search Not Invoiced Deliveries - selected, Hit Batch, goes to this Screen :Issue Batch Invoice for Delivery Notes

Click Process Invoice but nothing happens except page refresh.

*Other Search Not Invoiced Deliveries with about 10 Search Not Invoiced Deliveries works without a problem.

any clues?

19

(5 replies, posted in Reporting)

Is it possible to create another comment2, populate the #_sales_orders.comment2 and have it output on invoices?
This is where the comment2 being placed top at the header, serving as Attn : xxxx (as client's unique request to have it entered during invoice creation)

20

(5 replies, posted in Reporting)

Thank you for the detailed insights on the above issues.

Invoice memo field - same as Invoice comments ?

21

(5 replies, posted in Reporting)

Anyone care to share page numbering for invoices, Page a of b?
where a is current page
and b is total pages

22

(0 replies, posted in Setup)

pls advise on the differences? can use on ipad?

I have invoices to create that require inclusion of reference number / purchase orders number.
Noticed that under credit invoices, the Customer Reference 'can be used' to accommodate it.

However, for Cash Sales ( where customers paid up before shipping ), there is no Customer Reference textbox.

Please advise the alternatives / possibilities available.

even by using javascript to read-off the current date (month/year) and concatenating them?
or can it be manually adjusted every month end to 0001/MMYY

FrontAccounting gurus,

I am having unresolved issues on the invoicing numbers as per below.

Assuming this month is Nov 2014, I would like to have it 1411-0001, 1411-0002, 1411-0003.... followed by December 2014, as 1412-0001, 1412-0002, so on...

How do i get around it?