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"

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.

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

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

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

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

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.

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

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

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)

Yes cron based automatic depreciation is a good idea.

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.

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?

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

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)

Have you added something in the cart? Place Order appears once we load at least one item in the cart

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.

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.

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

(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

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

@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;

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