You will need a manual intervention on periodic basis by monitoring the customer from ageing report and blocking them off from the add and manage customer setup page with Credit Status option set as "No more work until payment received"
26 05/19/2022 07:43:52 am
Re: Alert when Customer Debt has risen to a certain Amount (1 replies, posted in Setup)
27 05/19/2022 07:40:37 am
Re: my customer is my supplier (7 replies, posted in Banking and General Ledger)
1. I am managing it by creating Customer, Supplier and a separate GL account (with the same name), and map the customer/ supplier to this separate GL account instead of default A/R and A/P.
2. I have created a separate GL group and classified all the customer under it.
3. Since step 1 is bit difficult and have chance of user mistakes so i further did a bit customization on the "Add GL account" form (gl_accounts.php) to have two checkboxes for customer/supplier, once the user checks them it automatically creates customer/suppliers along with the GL account and map them to a their individual GL account, this simplifies the step 1 for user.
4. This way all the entries(sales,purchases) of the customer/suppliers are consolidated into the FA's default GL Account transaction report (by filtering the group as created in step 2)
I know the above method is still a way around as the individual modular reports of AR/AP will be useless, but it will still give the user the consolidates figures at-least from the GL. There should me more efficient method of flaging the related parties and quering both sup_trans and debtor_tran tables for the consolidated figures but that approach will require a major change across all AR/AP reports and inquiries.
28 05/18/2022 11:28:01 am
Re: Return of a Delivery Note (2 replies, posted in Accounts Receivable)
1. I understand credit note can not be made, because the goods are not invoiced yet, but you can post the credit note with qty only and set the rate to zero, this will take it back to inventory and keep the inventory logs in movement(with disturbing the the customer ledger).
2. Or else make a positive inventory adjustment and mention customer name in the memo for the record.
The above case is based on the assumption that goods will not be redelivered, if its a replacement case than you might need to amend the qty in SO for the second delivery and adjust it later on the final month end invoicing
29 05/14/2022 04:13:57 pm
Re: GL Account Inquiry-Dimension 1 keep stop responsive when search record (1 replies, posted in Dimensions)
General ledger inquiry and some other inquiries like inventory (which are not on grid/db_pager), may get unresponsive if the data increases.
How much data do you have in the selected range? try reducing the date range and see if something shows up
You can try tweaking/optimizing your mysql or load time settings in php.ini
30 05/14/2022 04:05:55 pm
Re: Blank backups (1 replies, posted in Installation)
the user you entered in the config_db should have access to the database, can you check the permissions of the folder company/x/backup. This directory should be writable.
31 05/12/2022 05:02:22 pm
Re: Inventory adjustments (2 replies, posted in Items and Inventory)
1. Why use JE? Why not make a stock inward either by inventory adjustment or a supplier bill of all the items
2 Than post a sales invoice, either a consolidated one totaling all the item sold in a day, or posting multiple invoices(depending on the volume of transactions)
3. JE will not make a stock outward of the inventory as you suggested in your question
32 05/12/2022 04:54:50 pm
Re: Banking - Payments (5 replies, posted in Banking and General Ledger)
You can NOT have multiple debits/credits in the payment/deposits cart, whatever GL account you select in the payment will go DEBIT and in Deposit the cart GL accounts will go CREDIT, you can use Journal Entry if you need to post debit and credit as a contra effect.
33 05/12/2022 04:49:55 pm
Re: How to add shipping to sales invoices (4 replies, posted in Items and Inventory)
I guess baxterdmutt is refering to posting the liability part of the shipping, if the shipping is done by company's own sources than the default shipping revenue on the invoice is OK, but if the company is just charging as cost-to-cost and the delivery is done by a third party vendor than there are two options - create a separate bill/jv OR use a shipping service item and link it with a supplier (GL based not modular) so that liability will be posted on the go
34 05/10/2022 05:58:56 pm
Re: Why we need separate Category and location for Fixed Assets ? (1 replies, posted in Fixed Assets)
yes right, for locations i think same inventory locations could have been used for fixed assets, as assets are already flagged F in stock master, so there would not have any problem in filtering for reports/inquiries but for categories i think its useful to keep it separate as it gives better management and handling of the following:
1 .Category wise separate GL mapping for assets
2. Avoid mixing of assets categories in inventory reports dropdowns
3. Avoid chances of erroneously categorizing assets into inventory categories by user(on the setup form) etc
35 05/08/2022 06:37:31 pm
Re: How to add shipping to sales invoices (4 replies, posted in Items and Inventory)
There is no direct posting for shipping liability on Sales invoice, you can do the following:
1. Create a supplier invoice or a JV after posting the Sales.
2. OR else create a service item and link it with a GL account and use that as supplier (instead of Supplier module) in this way liability will be auto posted on Direct Invoice
A/R 10,000 DR
Sales 9,000 CR
Shipping Supplier 1000 CR (this account will be linked in the service item)
36 05/06/2022 08:57:15 pm
Re: How to process Fixed Assets multiple quantity ? (5 replies, posted in Fixed Assets)
Yes cron based automatic depreciation is a good idea.
37 05/06/2022 08:51:16 pm
Re: What is the use of parent class in Fixed Assets class ? (4 replies, posted in Fixed Assets)
Yes if you referring to the parent class ID, i canot find any use in reports or even dropdowns. If you want to create multiple child under one parent class for categorization visibility in drop down (like Automobile(Parent)-4 wheeler(child)-2 wheeler(child)) system does not allows.
38 05/06/2022 05:43:39 pm
Re: Exchange in Payment AR module (2 replies, posted in Accounts Receivable)
The Exchange gain/loss entries are automatically booked and posted into the variance GL in FA once you allocate the payment to the invoice (both in Sales and Purchase module). Kindly check if you have allocated the payment to the relevant invoice?
39 05/06/2022 05:39:47 pm
Re: What is the use of parent class in Fixed Assets class ? (4 replies, posted in Fixed Assets)
Class setup form in Fixed module is used to setup the basic depreciation rate for different categories of FAs(e.g for Building 5% for IT equipment 40% etc ). It fetches the dep. rate while you are creating a new FA item(In Declining and Straight line method).
40 05/06/2022 05:34:34 pm
Re: How to process Fixed Assets multiple quantity ? (5 replies, posted in Fixed Assets)
Yes i believe the quantity is locked on the Fixed asset purchase form so that depreciation can be calculated separately for each item. Another thing i faced in Fixed Asset is how to add opening balances of accumulated depreciation?. Say from the starting date of the software you have a Vehicle which has a historical cost of 1000,000 and accumulated depreciation of 200,000 making the WDV @ 800,000.
I hope these two will be added in core FA in the future, but meanwhile i did a way around by amending following
1. Used the Inventory adjustment form for adding FA Items, allowed FA items by removing mb_flag F restriction, (or alternatively create a new form for FA adjustment and linked in the FA module.)
2. Gave an accumulated depreciation box in the IA cart for storing the opening values (and did the GL linking accordingly)
41 05/06/2022 05:16:47 pm
Re: No Place order button in new Purchase order entry. (2 replies, posted in Reporting)
Have you added something in the cart? Place Order appears once we load at least one item in the cart
42 04/28/2022 09:01:04 pm
Re: Error in the "Inventory Valuation Report" (8 replies, posted in Reporting)
Standard cost of these items have gone negative, could be multiple reasons you have to check the individual movement of these items and see from which GRN or IA onward it was gone negative.
43 04/23/2022 02:28:53 pm
Re: Unable to access data after php upgrade. (12 replies, posted in Setup)
1. Seems like you using a shared hosting, try writing the following in your .htaccess this will support php 5.6
<IfModule mime_module>
AddHandler application/x-httpd-ea-php56___lsphp .php .php5 .phtml
</IfModule>
2. or else ask your hosting provider to downgrade the php version for you.
44 04/21/2022 11:49:15 pm
Re: Select deliveries on dimensions (4 replies, posted in Dimensions)
If you are selected the dimension while posting the delivery note, you can filter data under that dimension from the GL Inquiry page (gl_account_inquiry.php)
45 04/21/2022 11:46:17 pm
Re: Daily Sales Report (1 replies, posted in Reporting)
You can use the Inventory Sales Report (rep304) in the inventory section and use the dates accordingly to fetch the desired data
46 04/21/2022 03:21:22 pm
Re: Supplier invoice shows overdue (5 replies, posted in Items and Inventory)
Is the payment properly allocated to the invoice? kindly check the allocations.
In the DB you can further check in the debtor_trans table and see if the alloc column is filled
secondly supp_allocations table deals with the allocation of payment with the invoices
47 04/21/2022 03:17:45 pm
Re: FA WITH AUTOCOMPLETE DOWNLOAD (36 replies, posted in FA Modifications)
@anoopmb
If any value with & is selected in the dropdown, after clicking on it the selected value turns into &
so i have changed the typer.value = selectedoption.innerHTML; to typer.value = selectedoption.innerText;
in the following:
selectedoption.innerHTML = selectedoption.innerHTML.replace(/ /gi, ' ');
typer.setAttribute("value", selectedoption.innerHTML);
// typer.value = selectedoption.innerHTML;
typer.value = selectedoption.innerText;
var hidden = document.createElement('INPUT');
I also added the following regex in the typer.onblur
+ selval = selval.replace(/&/gi, '&');
here is the updated code:
typer.onblur = function (event) {
if (optgropc != 1) {
pop("none");
optgropc = 0;
if (typer.value == null || typer.value == '' || typer.value != selectedoption.innerHTML) {
var selval = selectedoption.innerHTML;
+ selval = selval.replace(/&/gi, '&');
selval = selval.replace(/\<u\>/ig, '');
selval = selval.replace(/\<\/u\>/ig, '');
selval = selval.replace(/ /gi, ' ');
typer.value = selval;
hidden.value = selectedvalue;
48 04/21/2022 03:16:13 pm
Re: Reference auto changing to Legacy (2 replies, posted in Report Bugs here)
Yes it happens with me aswell. Sometime when in the new month when we change the date, the reference field does not gets updated. I thought its may be due to slow internet at the user end