76 Reply by dvarsani

(30 replies, posted in Wish List)

Hi Joe

There is no Item detail report showing list of items and setup details. Can we please have same type of report.

Many thanks

Go to forum: Wish List

77 Topic by dvarsani

(1 replies, posted in Items and Inventory)

Hi

I'm getting this error when I insert Standard Material Cost Per Unit of an item.

DATABASE ERROR : Cannot add audit info
error code : 1264
error message : Out of range value for column 'trans_no' at row 1
sql that failed was : INSERT INTO audit_trail (type, trans_no, user, fiscal_year, gl_date, description, gl_seq) VALUES('35', '-1',1,3,'2013-02-01','', 0)

Go to forum: Items and Inventory

78 Reply by dvarsani

(32 replies, posted in FA Modifications)

Hi

This is great. Each item is easily manageable and easy to create new item.

Thanks to developers.

Go to forum: FA Modifications

79 Reply by dvarsani

(30 replies, posted in Wish List)

Hi Joe

Both the reports works fine now.

Many thanks for your prompt and hard work.

Go to forum: Wish List

80 Reply by dvarsani

(30 replies, posted in Wish List)

Hi Joe

On Supplier detail report, Physical address displays only first 3 address lines. Is there any way to change this? Also Tax_ID details is blank.

Thanks

Go to forum: Wish List

81 Reply by dvarsani

(3 replies, posted in Installation)

Hi

What do I do with install folder?

Thanks

Go to forum: Installation

82 Reply by dvarsani

(30 replies, posted in Wish List)

Hi Joe

How can I download updated customer detail report. There are few fields on customer detail report which do not show if longer than certain characters. Also this report do not show any more address lines than 4 which I think should be change to auto height.

Many thanks

Go to forum: Wish List

83 Reply by dvarsani

(30 replies, posted in Wish List)

Hi Joe

How can I download updated customer detail report. There are few fields on customer detail report which do not show if longer than certain characters. Also this report do not show any more address lines than 4 which I think should be change to auto height.

Many thanks

Go to forum: Wish List

84 Topic by dvarsani

(3 replies, posted in Installation)

Hi

Can somebody tell me how to apply run patch file to upgrade from 2.3.13 to 2.3.14

Thanks

Go to forum: Installation

85 Reply by dvarsani

(30 replies, posted in Wish List)

Hi Joe

It's working fine in version 2.3.14 but under version 2.3.13, I get an error "Unknown report parameter type:ORIENTATION" on the page top but it actually generates the report when I click display supplier detail listing.

Thanks

Go to forum: Wish List

86 Topic by dvarsani

(2 replies, posted in Reporting)

Hi

I think we desperately need report for Supplier Details (same as Customer Details Listing) showing full address, phone, fax, email, contact name, etc.

Thanks

Go to forum: Reporting

87 Topic by dvarsani

(30 replies, posted in Wish List)

Hi

I think we desperately need report for Supplier Details (same as Customer Details Listing) showing full address, phone, fax, email, contact name, etc.

Thanks

Go to forum: Wish List

88 Reply by dvarsani

(6 replies, posted in Accounts Payable)

Hi Joe

Update has fixed the bug.

Thanks

Go to forum: Accounts Payable

89 Reply by dvarsani

(6 replies, posted in Accounts Payable)

I'm using latest version 2.3.13 and Mysql version 5.5.28

Go to forum: Accounts Payable

90 Topic by dvarsani

(6 replies, posted in Accounts Payable)

Hi

I am getting this error when trying to update supplier.

DATABASE ERROR : The supplier could not be updated
error code : 1366
error message : Incorrect integer value: '' for column 'tax_included' at row 1
sql that failed was : UPDATE suppliers SET supp_name='ADM Milling Ltd', supp_ref='ADM Milling', address='Kingsgate\n1, King Edward Road\nBrentwood, Essex\nCM14 4HG', supp_address='Kingsgate\n1, King Edward Road\nBrentwood, Essex\nCM14 4HG', gst_no='', website='', supp_account_no='', bank_account='', credit_limit=0, dimension_id='0', dimension2_id='0', curr_code='GBP', payment_terms='5', payable_account='13201', purchase_account='', payment_discount_account='20109', notes='', tax_group_id='1', tax_included='' WHERE supplier_id = '2'

Go to forum: Accounts Payable

91 Reply by dvarsani

(13 replies, posted in Wish List)

I agree. Email sent timestamp should be stored in some table for future reference.

Go to forum: Wish List

92 Reply by dvarsani

(8 replies, posted in Accounts Receivable)

Hi

I thought so. I think the switch should be removed as it makes customer setup completely wrong.

Thanks

Go to forum: Accounts Receivable

93 Reply by dvarsani

(8 replies, posted in Accounts Receivable)

Hi Janusz

I created a customer with auto branch creation on. Then I deleted the branch and tried to check the parameter like phone, email, fax, tax group, etc but nothing gets stored at the customer header level. All these are stored at branch level which I think should be stored at header level. After deleting the branch, I created a sales invoice for this customer but the system did not calculate VAT as it didn't find tax group id as it is stored at branch level. It didn't allow me to post sales invoice with message "This customer has no branch defined."

After that trial, I changed config file to not to create auto branch. When you create new customer, there is no option to enter phone, fax, email,etc. There is no option to assign tax group id to this customer. I think this could be a bug.

My suggestion is to store all parameters at head customer level and branches should have their own parameter as they are being stored now. By default, branch should inherit tax group id for head customer id.

Thanks

As per your suggestion, once you have created a customer without a branch, you are not able to

Go to forum: Accounts Receivable

94 Topic by dvarsani

(8 replies, posted in Accounts Receivable)

When I disable to auto create customer branch, I do not get option to enter tax group ID. Is this a bug? Also you can't enter phone, fax, email.

I've been looking at debtor_master table which do not store important parameters for the main customer (a branch of the company should come under the main company header) I think we need information like phone (main company, branch can have their own different number stored in table cust_branch), fax, email, tax group id, default GL accounts, etc at master table level. In can you do not want to have branches for your customer, you really cannot use sales module.

I can't find master/child relation between table crm_persons and either debtor_master or cust_branch.

Go to forum: Accounts Receivable

95 Reply by dvarsani

(3 replies, posted in Report Bugs here)

Hi Joe

This issue got sorted after applying Mercurial 3119 updates.

Thanks

Go to forum: Report Bugs here

96 Reply by dvarsani

(2 replies, posted in Accounts Payable)

This issue got sorted after applying Mercurial 3119 updates.

Go to forum: Accounts Payable

97 Topic by dvarsani

(3 replies, posted in Report Bugs here)

Hi
I've upgraded to V2.3.13 and on my purchase orders I can't get Item Description on the actual purchase order pdf. If I enable item number in config file, I am able to see item number but under description all I can see is "1". If I disable item number in config file, then "1" move from Item Description to Item number. Is there a bug?

Thanks

Go to forum: Report Bugs here

98 Reply by dvarsani

(1 replies, posted in Report Bugs here)

I've just tested Sales module. It is behaving fine.

Go to forum: Report Bugs here

99 Topic by dvarsani

(1 replies, posted in Report Bugs here)

I found a bug in V2.3.13. After creating few purchase orders from different suppliers, I went in the oustanding order to receive them. I received the first order in and when I go to "Entry purchase invoice for this receival", I open "Enter Supplier Invoice" page with the last supplier for whom I had created an purchase order. I should have selected the supplier for whom I had just received in goods and selected to invoice the receival.

Go to forum: Report Bugs here

100 Topic by dvarsani

(2 replies, posted in Accounts Payable)

Hi

I've upgraded to V2.3.13 and on my purchase orders I can't get Item Description on the actual purchase order pdf. If I enable item number in config file, I am able to see item number but under description all I can see is "1". If I disable item number in config file, then "1" move from Item Description to Item number. Is there a bug?

Thanks

Go to forum: Accounts Payable