Hi I want t insert a query in sales_order_entry.php file
that if total of Current balance and sales invoice is less than -500 then form should display a error and if balance is min than max than -500 then it will alow to submit.

I have created an array which is showing customer current balance before submitting a form. ( $bal )
Example:

if (($bal - $_SESSION['Items']->get_items_total()) < '-500') {
        display_error("Customer balance can not be less than -500.");
        return false;
       
    }
I used this code in sales_order_entry.php at line 438 just like this---------------

if ($_SESSION['Items']->get_items_total() < 0) {
        display_error("Bill total amount cannot be less than zero.");
        return false;
       
    }
       
    return true;

Pls help me how to write this code and where to paste it.......

i am not as good as you are thinking.
if possible then can you pls provide me exact codes and where i need to fit them......

thanks........

Ok i understand but tell me how to display this pic in direct invoice page
which code and where to insert

We can create a new blob column under 0_debtors_master table to store images.....

Hi,

I want to display customer picture on the direct invoice page.

Pls help me how to do that...........

Hi,

I want a email and print option after every deposit just like after sale invoice we have.

Pls help me how to do that......

Hi,

I have done the $msg part i have just replace the "" $subject "" to "" $this->formData['document_amount'] "" and got the invoice amount instead of subject now i will design the mail text.

Now pls tell me how to automatically send this email pls tell me pls...............

Hi actually i am not good in php. But pls help me that how can default email will be send automatically after any invoice without clicking on email link.
Pls tell me the exact code and where i need to place that or any other process pls tell me in detail i am not a developer.

I just want to send email automatically after every invoice.

Which code i need to add for sending total invoice amount please tell me the code.

Pls tell me how to do that or which code(link) i should add in cron jobs.

Thanks apmuthu for reply

I have already done that but i just want to disable the drop down list it should show search option only and will not chsnge to dropdown list after search submit.

Thanks Joe, Its working  perfectly

Thanks joe,
I think it should auto check ref no before posting and change that according to the current status. just like tran_no .

Pls reply this post also I need this urgently because I new to this I an going to apply this as soon as possible but these are my mandatory requirement please help me. Tell me any code and where I need to put that.

https://frontaccounting.com/punbb/viewtopic.php?id=3793

Hi,

I want that whenever a direct invoice submitted an email will send automatically to customer without clicking on email link.
Please tellme how to do that.

I also want to send invoice amount and customer current balance as a html text along with " Attached you will find  Invoice No. # " text.

Thanks ..

or

I have created a table named "balace_report in database which contains customer id no, name and their balance ( column names are id,name,balance)

I want balance field to be with "Attached you will find  Invoice No" in email

I found the file "pfdr_eport.inc" which contains code what to send in email. please tell me how send balance coloumn.

Hi I am using 2.3.14 but still I am having same problem "The entered reference is already in use."

How to resolve this problem..............

I am using 3 users for sales at the same time

Thanks Elax,

But when I add 500 to Sales -> manage customer -> credit limit, it just increase the balance of user to 500 but not limiting the negative balance to 500.
should I use ant specific bank account for this

Hi,

I want to limit the customer to do not have negative balance more than -$500. sale will not process beyond -500.

If possible cani set different max negative values for different customers.

Please Reply

Hi

when we place a direct invoice a dropdown list appears to select customers, and after pressing space a search box appears to enter customer id.

1. I dont want that drop down field, i only want search field.
2. and search field should display customer details only when i enter exact customer id it should not guess wrong customer means search cretaria should be "=" not "Like"

Please help me to do this............