Its Perfect Now.
Thanks @Joe and @apmuthu
Regards.

Thanks @Joe for your action.

However the bug is still there. Earlier it was not subtracting the credited quantity and now it is adding back. Means now the result in Item sales Summary report is like below

102 17inch VGA Monitor 8 (instead of 2)         
103 32MB VGA Card       6       
104 52x CD Drive          10

603

(4 replies, posted in Modules Add-on's)

Hello apmuthu,

Can you please elaborate it? Is there any documentation or support related to SMS integration? Which SMS Gateway Shall I use? Do I need to add any Module/Plugin in Frontaccounting?

Your Response is highly appreciated.

Regards.

*Hello

Hell @joe could you check it further?

No, I choose the Item returned to inventory location.

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

608

(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

624

(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.