Search options (Page 22 of 26)

10/11/2017 07:53:59 pm

The Invoice in FA as a whole is not editable. Specially in case of sales of components (inventory items) it is not recommended to make invoice editable. But in case of sales of Service Items following option shall be considerable.

When we click the EditInvoice Icon on Customer Transaction Inquiry page it shall open following document with following parameters.

http://localhost/bx242/sales/sales_order_entry.php?NewInvoice=72&InvoiceNo=70

Where NewInvoice refers to the Auto Sales Order of the Invoice No 70.

While processing this document the system shall check the InvoiceNo parameter and execute the Void Routine to void the previous invoice.

This Edit option shall be available to 2 type of companies

1. Total Service Based Company. A check can be added in company setup.
2. A Company selling components but has enabled Negative Inventory in Setup.

I couldn't code it completely so if admin can consider it then it will be a good solution to all FA Users

Regards.

10/11/2017 03:57:03 pm

I agree with @apmuthu. I am not very good at php but since the FA code is very simple I could have managed to do some customizations for my need. Unlike I tried to read to code of Recurring Module shared by @cambell but it is too difficult for me to understand unless I am a good user of composer type things. Anyway both of you are very important resource for us

10/10/2017 03:15:59 am

I would disagree for removing the reference field. Without removing the Reference Field the Functionality shall be added to jump to Next Available Reference without notifying user.

Keeping Reference field open sometimes allow users to maintain a different sequence manually maintained specially in case of Invoices.

Like in our area we have a practice that Sales Taxed Invoices must have a separate sequence then Normal Invoices. In such situation we suggest users to manually maintain a sequence for Sales Taxed Invoices and Put that sequence in the Reference Field before Processing the Invoice.

10/09/2017 05:45:04 am

@davidkumi you mean that at any point if the system faces the duplicate reference issue, instead of notifying the user it shall just jump to next available reference?

I am also facing this problem. Most of the time references are working fine but sometimes I am notified that the Reference already in use. In such situation the system shall be smart enough to jump to next reference instead of notifying the user.

This is very important in a case where different data entry operators are punching data on the same form at same time. When two of them will open say Journal Entry Form they will get the Next Available Reference Number and that will be same for both. One of them when process it it will be saved Fine but the other will get message Reference Already In Use.

10/08/2017 06:29:06 pm

Where shall I copy this patch in FA Core to avoid this installation issue?

10/08/2017 06:58:26 am

I need more help over FA Cron Processing so that Auto Create shall work for this module at least.
Thanks in advance.

10/04/2017 03:39:27 am

You mean that in Audit Trail transactions are being recorded under different users with Single User Login ID? How many users do you have? Is that problem affecting your transactions and reports also? Does this problem occurs with a particular User Login or any User Login?

09/30/2017 07:02:23 pm

Although the Error is still showing but Email is sent perfectly. So I assume the problem is solved.

Thanks for your support.

09/30/2017 12:48:27 pm

The error says that included files on Lines 22, 23, 24 and 25 in rep107 couldn't be find.

rep107 is working fine from core FA. So I can't make any changes in this report.

As far as module is concerned I have not made any changes to it. Just copied, installed and activated.

So @cambell if this module is working fine with you then please suggest the solution for me. The only problem is in Auto Sending of Email to Customer when Recurring Invoice is Created.

Also can you please elaborate the functionality behind Auto Create: check in Sales Order Definition.

09/29/2017 05:52:49 pm

I create a Sales Order and then Generated the Invoice against it from the Top Button. The invoice was generated but the rep107 gives following error

include_once(../includes/session.inc): failed to open stream: No such file or directory in file: C:\xampp\htdocs\bx242\reporting\rep107.php at line 22
C:\xampp\htdocs\bx242\reporting\rep107.php:22:    include_once()
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:81:    require_once('C:\xampp\htdocs\bx242\reporting\rep107.php')
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:42:    (SGW_Sales\controller\GenerateRecurring Object)->emailInvoice('23')
C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php:144:    (SGW_Sales\controller\GenerateRecurring Object)->run()
include_once(): Failed opening '../includes/session.inc' for inclusion (include_path='C:\xampp\php\PEAR') in file: C:\xampp\htdocs\bx242\reporting\rep107.php at line 22
C:\xampp\htdocs\bx242\reporting\rep107.php:22:    include_once()
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:81:    require_once('C:\xampp\htdocs\bx242\reporting\rep107.php')
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:42:    (SGW_Sales\controller\GenerateRecurring Object)->emailInvoice('23')
C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php:144:    (SGW_Sales\controller\GenerateRecurring Object)->run()
include_once(../includes/date_functions.inc): failed to open stream: No such file or directory in file: C:\xampp\htdocs\bx242\reporting\rep107.php at line 23
C:\xampp\htdocs\bx242\reporting\rep107.php:23:    include_once()
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:81:    require_once('C:\xampp\htdocs\bx242\reporting\rep107.php')
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:42:    (SGW_Sales\controller\GenerateRecurring Object)->emailInvoice('23')
C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php:144:    (SGW_Sales\controller\GenerateRecurring Object)->run()
include_once(): Failed opening '../includes/date_functions.inc' for inclusion (include_path='C:\xampp\php\PEAR') in file: C:\xampp\htdocs\bx242\reporting\rep107.php at line 23
C:\xampp\htdocs\bx242\reporting\rep107.php:23:    include_once()
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:81:    require_once('C:\xampp\htdocs\bx242\reporting\rep107.php')
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:42:    (SGW_Sales\controller\GenerateRecurring Object)->emailInvoice('23')
C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php:144:    (SGW_Sales\controller\GenerateRecurring Object)->run()
include_once(../includes/data_checks.inc): failed to open stream: No such file or directory in file: C:\xampp\htdocs\bx242\reporting\rep107.php at line 24
C:\xampp\htdocs\bx242\reporting\rep107.php:24:    include_once()
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:81:    require_once('C:\xampp\htdocs\bx242\reporting\rep107.php')
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:42:    (SGW_Sales\controller\GenerateRecurring Object)->emailInvoice('23')
C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php:144:    (SGW_Sales\controller\GenerateRecurring Object)->run()
include_once(): Failed opening '../includes/data_checks.inc' for inclusion (include_path='C:\xampp\php\PEAR') in file: C:\xampp\htdocs\bx242\reporting\rep107.php at line 24
C:\xampp\htdocs\bx242\reporting\rep107.php:24:    include_once()
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:81:    require_once('C:\xampp\htdocs\bx242\reporting\rep107.php')
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:42:    (SGW_Sales\controller\GenerateRecurring Object)->emailInvoice('23')
C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php:144:    (SGW_Sales\controller\GenerateRecurring Object)->run()
include_once(../sales/includes/sales_db.inc): failed to open stream: No such file or directory in file: C:\xampp\htdocs\bx242\reporting\rep107.php at line 25
C:\xampp\htdocs\bx242\reporting\rep107.php:25:    include_once()
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:81:    require_once('C:\xampp\htdocs\bx242\reporting\rep107.php')
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:42:    (SGW_Sales\controller\GenerateRecurring Object)->emailInvoice('23')
C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php:144:    (SGW_Sales\controller\GenerateRecurring Object)->run()
include_once(): Failed opening '../sales/includes/sales_db.inc' for inclusion (include_path='C:\xampp\php\PEAR') in file: C:\xampp\htdocs\bx242\reporting\rep107.php at line 25
C:\xampp\htdocs\bx242\reporting\rep107.php:25:    include_once()
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:81:    require_once('C:\xampp\htdocs\bx242\reporting\rep107.php')
C:\xampp\htdocs\bx242\modules\sgw_sales\includes\controller\GenerateRecurring.php:42:    (SGW_Sales\controller\GenerateRecurring Object)->emailInvoice('23')
C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php:144:    (SGW_Sales\controller\GenerateRecurring Object)->run()

09/29/2017 04:38:59 pm

The Recurring Order has an option Auto Create:

Is this controlled through Cron Job? When and how it is executed.

09/29/2017 03:42:27 am

I need more help on this.

I create a module with hooks.php having the above function _construct()

I have one more file in module cron.php that contains the code to automatically fetch the exchange rate and update the database of the logged in Company if accessed directly.

Now when this cron.php is called through cron job then how this function in hooks.php creates a session with the defined user login and password. Credentials are hardcoded in hooks.php

Please give some guidelines

09/29/2017 03:17:28 am

@Apmuthu I have checked it. It is not giving error but Once merged it shall give some message that customers are now merged etc.

Still I would request to have GL Accounts Merge routine

09/29/2017 03:08:18 am

@Apmuthu your suggestion is optimal to incorporate both situations. While defining Recurring Invoice use can select whether to pick Item price from Prices or From Template Sales Order.

@cambell I got following error when accessing your module after activation

Warning: include_once(C:\xampp\htdocs\bx242\modules\sgw_sales/vendor/autoload.php): failed to open stream: No such file or directory in C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php on line 18

Warning: include_once(): Failed opening 'C:\xampp\htdocs\bx242\modules\sgw_sales/vendor/autoload.php' for inclusion (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php on line 18
Class 'SGW_Sales\controller\GenerateRecurring' not found in C:\xampp\htdocs\bx242\modules\sgw_sales\generate_recurring_invoices.php on line 132

09/28/2017 07:44:31 am

Thanks @Joe I have tested and I think its fixed now.

09/28/2017 05:47:10 am

While Merging Customers I got following error

DATABASE ERROR : An error occured
error code : 1054
error message : Unknown column 'type' in 'where clause'
sql that failed was : DELETE FROM 0_crm_persons WHERE type = 'customer' AND id = (SELECT person_id from 0_crm_contacts WHERE type = 'customer' AND entity_id = 4 LIMIT 1)

09/28/2017 05:38:36 am

Can we have something similar to this like Merge GL Accounts?

09/28/2017 05:34:19 am

I have a hosting business. My standard hosting price is say Rs. 3500 for 2 GB Hosting Package. I have created this Item and set the Item Price in the Prices section to 3500.

While negotiating with a customer I had to offer him the same package for Rs. 3000.

So I created a sales order with the revised price Rs. 3000 and selected that as a template

Then I created Recurring Invoice definition.

When I executed the recurring invoice the Price defined in the Sales Order was ignored and the price defined in the Prices i.e. Rs. 3500 was picked by the system.

@Joe, @apmuthu don't you think that the Prices defined in the price section is a general reference price for the product but the Price defined in the Sales Order Template is specific for this Particular Customer or Group. So System shall pick the specifically defined price OR discount instead of general price definition.

09/22/2017 08:10:10 pm

How are you different from Online Frontaccounting offered by frontaccounting.com itself?

09/22/2017 05:30:55 pm

Hello @Joe, were you able to check it further the problem in rep108 as mentioned above.

09/20/2017 06:28:56 am

Thanks @Joe. But I think your solution has worked for rep101 but not for rep108.

I recorded one AR and AP for a customer through JE. Compare images below

rep101

rep108

There is some problem in Aged Customer Analysis also have a look

Aged Customer Analysis

Similarly we need to screen out the affects in Supplier Balances and Supplier Aged Analysis and If any other area, inquiry or report being affected by JE Transactions for Customers and Suppliers.

Regards

09/19/2017 04:49:25 am

@Joe

Please check some screen shots below

Customer Balances Before JE Transaction

JE Transaction

Customer Balances after JE

You will find that the JE Transaction is appearing on the Credit Side Not on Debit Side because in Code no proper condition defined to handle Customer Debit Or Credit Transactions through JE.

This Problem is also in rep108.

I guess not yet checked that Suppliers Balances must be affecting due to same logical bug.

Hope this helps to understand.

You can login here to check further

fa.boxygen.biz/fa24

id: demo
pass: password

Thanks

09/17/2017 03:02:19 pm

Great @Joe, wonderful
Thanks

09/16/2017 01:34:06 pm

While creating customer if the user has defined Customer Name very different from debtor_ref for e.g

name: AAMIR
debtor_ref: LASANI

and if there are 1000 customers and their naming pattern is similar.

It is very very difficult to search this customer. Because all reports, all inquiries are showing AAMIR while Combo Box is showing LASANI.

Solution:

If the Combo Return from the

function customer_list($name, $selected_id=null, $spec_option=false, $submit_on_change=false,
$show_inactive=false, $editkey = false)

can have two fields in the namefield parameter i.e debtor_ref and name then it will be very helpful for all FA Users.

I request the admin to think over it and commit some changes in the core to incorporate this for both Customers and Suppliers.

Thanks

09/15/2017 11:17:54 am

Now since Transactions to customers can be recorded through Journal Entry also and It can be either Debit Or Credit to customer.

The following code is not sufficient to handle the transactions through Journal Entry

if ($myrow2['type'] == ST_SALESINVOICE || $myrow2['type'] == ST_BANKPAYMENT)
$rep->TextCol(4, 5, $DisplayTotal, -2);
else
$rep->TextCol(5, 6, $DisplayTotal, -2);

Secondly one more thing is that If we Debit the Customer through JE then it appears in the ov_amount column in debtor_trans table as -ve value while if we credit the customer through JE the value appears as +ve value.

Except from the JE all values from any other transaction whether charges or credits appear as +ve value.

rep101 is also affected through JE Transactions. Debit is appearing on Credit Side and Credit is appearing on Debit Side.

Search options (Page 22 of 26)

Posts found: 526 to 550 of 648

526 Topic by boxygen 10/11/2017 07:53:59 pm

Topic: Invoice Editable (23 replies, posted in FA Modifications)

527 Reply by boxygen 10/11/2017 03:57:03 pm

Re: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)

528 Reply by boxygen 10/10/2017 03:15:59 am

Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)

529 Reply by boxygen 10/09/2017 05:45:04 am

Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)

530 Reply by boxygen 10/08/2017 06:29:06 pm

Re: Installation problem (24 replies, posted in Installation)

531 Reply by boxygen 10/08/2017 06:58:26 am

Re: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)

532 Reply by boxygen 10/04/2017 03:39:27 am

Re: front accounting database corruption? (6 replies, posted in Jobs wanted/offered, non-free offers)

533 Reply by boxygen 09/30/2017 07:02:23 pm

Re: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)

534 Reply by boxygen 09/30/2017 12:48:27 pm

Re: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)

535 Reply by boxygen 09/29/2017 05:52:49 pm

Re: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)

536 Reply by boxygen 09/29/2017 04:38:59 pm

Re: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)

537 Reply by boxygen 09/29/2017 03:42:27 am

Re: Cron Job Module (11 replies, posted in Modules Add-on's)

538 Reply by boxygen 09/29/2017 03:17:28 am

Re: How Can I Merge Customers? (16 replies, posted in Accounts Receivable)

539 Reply by boxygen 09/29/2017 03:08:18 am

Re: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)

540 Reply by boxygen 09/28/2017 07:44:31 am

Re: Bug in rep108 (10 replies, posted in Report Bugs here)

541 Reply by boxygen 09/28/2017 05:47:10 am

Re: How Can I Merge Customers? (16 replies, posted in Accounts Receivable)

542 Reply by boxygen 09/28/2017 05:38:36 am

Re: How Can I Merge Customers? (16 replies, posted in Accounts Receivable)

543 Topic by boxygen 09/28/2017 05:34:19 am

Topic: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)

544 Reply by boxygen 09/22/2017 08:10:10 pm

Re: Bring Your FrontAccounting to myERPlink.com (6 replies, posted in Jobs wanted/offered, non-free offers)

545 Reply by boxygen 09/22/2017 05:30:55 pm

Re: Bug in rep108 (10 replies, posted in Report Bugs here)

546 Reply by boxygen 09/20/2017 06:28:56 am

Re: Bug in rep108 (10 replies, posted in Report Bugs here)

547 Reply by boxygen 09/19/2017 04:49:25 am

Re: Bug in rep108 (10 replies, posted in Report Bugs here)

548 Reply by boxygen 09/17/2017 03:02:19 pm

Re: Searching of Customers (3 replies, posted in Reporting)

549 Topic by boxygen 09/16/2017 01:34:06 pm

Topic: Searching of Customers (3 replies, posted in Reporting)

550 Topic by boxygen 09/15/2017 11:17:54 am

Topic: Bug in rep108 (10 replies, posted in Report Bugs here)

Posts found: 526 to 550 of 648