In order to veiw this bug login at fa.boxygen.biz/fa2325

id: demouser
pass: 123456

Check the Item Sales Summary Report of September 2016. It will show something belo

102 17inch VGA Monitor 5         
103 32MB VGA Card       6       
104 52x CD Drive          10

While If you check the Inventory Sales Report of September 2016. It will show something like below

102 17inch VGA Monitor 2         
103 32MB VGA Card       6       
104 52x CD Drive          10

The 3 Quantity of VGA Monitor was Credited (Returned) but it is not reflecting in Item Sales Summary REport

627

(2 replies, posted in Wish List)

Is it possible to restrict Frontaccounting access from a Static IP Address?

Hello I have installed the cash flow extension. It is activated but I couldn't find any link where to access it.

A thought later came to my mind that if we fix up this logical bug then it may result into another logical bug and that is Negative Inventory.

So the best solution is to get the invoice void and then create again. This is a lengthy process but it will maintain integrity.

I found that my server is limiting all emails if the email address defined in the company setup is not from the domain hosted on the same server.

I did one modification in the line 47 of /reporting/includes/class.mail.inc and my problem got solved

boxygen wrote:

//        $this->header = "From: $name <$mail>\n"; Modified by Faisal to enable sending email by domain boxygen.biz
        $this->header = "From: $name <mail@boxygen.biz>\n";
        $this->header .= "Reply-To: <$mail>"."\n";

I replaced the Line 47 with next two lines.

Finally I could explain you. Joe a little correction is that it is not in Sales Invoice but Supplier Invoices.

Normally in routine case a Direct Invoice is created first and GRN is Auto Created.

In case of auto GRN my suggestion is that it shall be voided automatically just like it is done in Sales Module where if Direct Invoice is voided the related Auto Delivery Note is automatically voided.

However if GRN was made manually and then it is converted into Supplier Invoice later then it shall be left for manual decision to delete GRN also with invoice or not.

This is my suggestion.

I Just want to Rephrase the Logical Bug issue with a Graphical presentation

Please View this

http://fa.boxygen.biz/fa2325/FABug.pdf

Suggested Solution:

1. Either there should be an option to change the Date and Dimension of related Delivery NOte if we are changing the date and dimension of Invoice

2. OR the Date and Dimension of related Delivery Note shall be changed automatically so that the GL Date of Costs of Goods Sold is same as the GL Date of Sales.

You can access this at fa.boxygen.biz/fa2325

username: aeronvista
pass: usayed2005

I hope I could have clearly stated my point.

@Joe, you can reproduce this error here on a fresh installation of FA2.3.25.

Before you Login View this screen shot

http://prnt.sc/bwx3l3

Click below to login

http://fa.boxygen.biz/fa2325/purchasing/supplier_invoice.php?AddedID=9

Username: aeronvista
pass: usayed2005

After you Login Please

1. Click View this Invoice
Under the 3rd Column name Dimension you will find No Value but it should have "PNG Job NO 2" as defined in the above screen shot.

2. Click View the General Entry of this invoice
Under the 3rd Column named Dimension you will find value "PNG Job No2" in Second Row.

I hope its clear.

@Apmuthu, i think you have mixed up Supplier Invoices with Direct Invoice. The problem I am reporting is of Supplier Invoice in which a Direct GL entry can be passed against as supplier. While in Direct Invoice Inventory Item needs to be selected.

Regards.

@apmuthu the 3rd Field (Dimension Column) Value is null in the lower table in Supplier Invoice View. Please check it carefully.

When we void a Direct Invoice (Purchases Module) the related GRN is not voided automatically. It is needed to be voided manually.

Please view the following two images

http://prnt.sc/bwsarq (Supplier Invoice)

http://prnt.sc/bwsam2 (Journal Entry of Supplier Invoice)

You can see that the Dimension is appearing in Journal Entry View but not in Supplier Invoice View.

boxygen wrote:

I then checked my server whether it is limiting emails or not but I found that emails are going perfectly from my server

http://my.boxygen.biz/test-email/index.html

The above is the email testing.

With the above small script it is checked that server is not limiting emails due to smtp authentication. It is a simple email program with php mail function and going through perfectly on the same server and domain.

I am unable to send Invoice through email

http://fa.boxygen.biz/fa2325/sales/customer_invoice.php?UpdatedID=19

Username: aeronvista
pass: usayed2005

click email invoice and you will find the error message. This is the fresh installation of FA2.3.25

Can anyone help me with the solution of this? How can I find the reason of this error?

I then checked my server whether it is limiting emails or not but I found that emails are going perfectly from my server

http://my.boxygen.biz/test-email/index.html

The above is the email testing.

Is that core changes being implemented in 2.4 RC1?

I don't want to edit the tables directly .

What I want to know that In case of Editing Direct Invoice date or dimension the date and dimension of auto generated delivery note be changed . is that possible to work out in the given structure of FA?

share the link of the demo with credentials

643

(12 replies, posted in Announcements)

Thanks kvvaradha

How can I upload the Excel Salary Sheet in FA?

How can I get the Full Version of HRM that I could see in your demo? Can I pay something to get it?

Sitting in June i need to create a back dated invoice of April. While creating invoice I forgot to set the date and processed invoice. The Delivery note is automatically created. Later I realized my mistake and corrected the date of invoice but that change is not affected on Delivery note and the GL Entry of Deivery Note.

Means Sales is credited now in April while its cost is Debited in June.

Another Problem in current dated invoice is that while processing invoice I selected by mistake a wrong Dimension. After invoice is processed I corrected the mistake in Invoice but that correction of dimension is not affected on Delivery Note. Hence Sales is Credited to One Dimension while its Cost is Debited to another dimension.

The Delivery note is not editable so we can't make these corrections in Delivery note or its GL Entry.

Any solution to this is highly appreciated.

It is working fine with me also.

I think your browser is blocking pop ups. In Chorme at right corner of address bar a Red cross appears if the pop up of pdf is blocked.

I tried to view the Demo in my mobile but It is not opening as Responsive. What shall I do?

I am using Samsung S3

Date Picker is returning different date formats on different systems may be fetching from the system date. If the date format returned by Date Picker is different from what defined in Preferences then it is not fetching the correct query results and given date error on payments and receipts.

Date Picker shall always return the same date format as defined in User Preferences to make it independent of System Date.

How can this issue be solved.

I would request senior members to check whether this change has no adverse impact on any other feature.

Ok Finally I got the reason of this bug. The hidden text and the select had the same names and the hidden text values were passing in the arguments. So I just renamed the hidden text name.

Below is the code component that I changed on gl\manage\bank_accounts.php on Line 160

start_table(TABLESTYLE2);

if ($selected_id != -1)
{
  if ($Mode == 'Edit') {   
    $myrow = get_bank_account($selected_id);

    $_POST['account_code'] = $myrow["account_code"];
    $_POST['account_type'] = $myrow["account_type"];
    $_POST['bank_name']  = $myrow["bank_name"];
    $_POST['bank_account_name']  = $myrow["bank_account_name"];
    $_POST['bank_account_number'] = $myrow["bank_account_number"];
    $_POST['bank_address'] = $myrow["bank_address"];
    $_POST['BankAccountCurrency'] = $myrow["bank_curr_code"];
    $_POST['dflt_curr_act'] = $myrow["dflt_curr_act"];
  }
    hidden('selected_id', $selected_id);
    hidden('account_code');
    hidden('account_type');
    hidden('BankAccountCurrency-hidden', $_POST['BankAccountCurrency']);    //Bug removed by Faisal on Line 160
    set_focus('bank_account_name');
}

If i create a new Bank Account with any Currency. Just after creation I realized a mistake that the Currency was wrongly selected and I need to change the currency from USD to CAD (for e.g.) then this change is not accepted by FA. I tried this in FA 2.3.25 but same problem.