@joe: Thanks for the commit.
2,151 12/23/2017 01:46:48 pm
Re: Invalid Edit Session error and fix (2 replies, posted in Accounts Receivable)
2,152 12/23/2017 12:52:14 pm
Re: new report (21 replies, posted in Reporting)
Which report are you referring to?
2,154 12/23/2017 12:07:53 pm
Re: Cash Sale Invoice. How to: (27 replies, posted in Accounts Receivable)
They are not redundant entries. They only appear so because they are named so. The customer is a different entity and the payment receipts go into a bankable account.
Following every unique assist request will help avoid requests in future on similar lines and fill the self service knowledgebase. It may also throw up errors or suggest improvements that will benefit the community at large when settled.
2,155 12/23/2017 12:04:20 pm
Re: new report (21 replies, posted in Reporting)
Do not choose to select any Sales Area - then all Sales Areas will be selected - that is for no filter on Sales Areas.
2,156 12/23/2017 12:03:08 pm
Re: The journal must balance (debits equal to credits) (8 replies, posted in Accounts Payable)
Provide screenshot of what you did while entering the JE.
2,157 12/23/2017 12:01:06 pm
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
Examples of meta_forward() usage are here where the get variables are overwritten.
Which of the 5 lines calling the meta_forward() constructs did you comment out?
2,158 12/23/2017 11:28:04 am
Re: purchase invoice tax (7 replies, posted in Reporting)
Whilst the Purchase Order Tax is temporary, the Tax on the Purchase Invoice is permanent. The Inventory Purchase Report - rep306.php can be extended to show the tax on each item. The effective sql used there is:
SELECT item.category_id
, category.description AS cat_description
, item.stock_id
, item.description
, item.inactive
, move.loc_code
, supplier.supplier_id
, supplier.supp_name AS supplier_name
, move.tran_date
, move.qty AS qty
, move.price
FROM 1_stock_moves move
LEFT JOIN 0_supp_trans credit ON credit.trans_no=move.trans_no AND credit.type=move.type
LEFT JOIN 0_grn_batch grn ON grn.id=move.trans_no AND 25=move.type
LEFT JOIN 0_suppliers supplier ON IFNULL(grn.supplier_id, credit.supplier_id)=supplier.supplier_id
INNER JOIN 0_stock_master item ON item.stock_id=move.stock_id
INNER JOIN 0_stock_category category ON item.category_id=category.category_id
WHERE (move.type=25 OR move.type=21)
AND (item.mb_flag='B' OR item.mb_flag='M');
-- ST_SUPPRECEIVE = 25
-- ST_SUPPCREDIT = 21
The 0_supp_trans.ov_gst is expected to contain the tax.
2,159 12/23/2017 07:56:00 am
Re: purchase invoice tax (7 replies, posted in Reporting)
Tax is available for invoicing. I meant about Tax being listed in a report.
2,160 12/23/2017 06:15:50 am
Re: Cannot download repo index file. (3 replies, posted in Reporting)
Check if the exchange rate urls are manually accessible.
2,161 12/23/2017 04:41:16 am
Re: purchase invoice tax (7 replies, posted in Reporting)
Only rep209 - Print Purchase Orders - shows Tax on Purchases.
A Print Purchases Listing is needed - both summary and detail.
The function get_po() defined in reporting/rep209.php uses an sql that has the field tax_included twice with no aliases to differentiate them on fetching them into an array - which one will supercede for it?
The table purchase_orders and the table suppliers both have the field tax_included.
The currently effective sql before filtration and additional columns in get_po() is:
SELECT po.*
, supplier.supp_name
, supplier.supp_account_no
-- , supplier.tax_included
, supplier.gst_no AS tax_id
, supplier.curr_code
, supplier.payment_terms
, loc.location_name
, supplier.address
, supplier.contact
, supplier.tax_group_id
FROM 1_purch_orders po
INNER JOIN 1_suppliers supplier ON (po.supplier_id = supplier.supplier_id)
INNER JOIN 1_locations loc ON (loc.loc_code = po.into_stock_location);
@joe: FA without Purchase Tax reporting is really handicapped.
2,162 12/23/2017 04:35:31 am
Re: Cash Sale Invoice. How to: (27 replies, posted in Accounts Receivable)
The concept here is that the GL Account for Cash is different from the Customer Cash Account where all cash customers get billed. Since it is immediate cash, the tracking of Accounts Receivable is not necessary but needed for turnover / transaction listing.
2,163 12/22/2017 08:30:01 pm
Re: Credit Card Sale (16 replies, posted in Accounts Receivable)
Any modifications to the code in the current scripts without altering db schema will entail hardcoding for a specific install with account names / types and ids and that will not be generic. Both Cash and Credit Card are of Cash Type as far as the Payment Terms classification is concerned and that is why the simplified entry form gets displayed. If English is the only language to be used, then hardcoding to see if the word "Cash" is present in the name of the description of the Payment Terms can be attempted. The ramifications of the default POS being different from the one in the user's table will have to be studied. There could be several credit card merchant accounts in one installation where this would fail. Appending the account code to the last part of the Payment Terms description is the only way out for now.
@joe: what say you?
2,164 12/22/2017 08:20:07 pm
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Actually, the Sales Invoices import was coded later and old PHP's graceful degradation based on loose type acceptance is no longer available.
Try this version now.
2,165 12/22/2017 07:59:23 pm
Re: Credit Card Sale (16 replies, posted in Accounts Receivable)
The ERD is now on the Wiki.
2,166 12/22/2017 07:25:01 pm
Re: Credit Card Sale (16 replies, posted in Accounts Receivable)
Wiki updated.
2,167 12/22/2017 06:47:14 pm
Re: Credit Card Sale (16 replies, posted in Accounts Receivable)
Line 580 in sales/includes/ui/sales_order_ui.inc:
label_row(_("Cash account:"), $order->pos['bank_account_name']);
is responsible for the choice of account. It comes from the field sales_pos.pos_account which is looked up on the field bank_accounts.id whose corresponding field bank_accounts.account_code is the account to which the money flows. The field bank_accounts.bank_account_name is what gets displayed.
The POS is fixed in the users table and hence it this that ultimately determines the hardcoded value of the cash account! Hence, create a user and assign the Credit Card POS and link it to the Credit Card Cash Type account and login as that user to perform such transactions.
2,168 12/22/2017 06:37:18 pm
Topic: Invalid Edit Session error and fix (2 replies, posted in Accounts Receivable)
When we first login to FA, there is no $_SESSION[$cartname] available.
When we then choose Sales => Direct Sales Invoice and then we change the payment terms first we get the error:
This edit session has been abandoned by opening sales document in another browser tab. You cannot edit more than one sales document at once.
The fix is to change line 49 in sales/includes/sales_ui.inc:
if ((!isset($SysPrefs->no_check_edit_conflicts) || $SysPrefs->no_check_edit_conflicts==0) && $cart_id && $cart_id != $_SESSION[$cartname]->cart_id) {
to
if ((!isset($SysPrefs->no_check_edit_conflicts) || $SysPrefs->no_check_edit_conflicts==0) && $cart_id && isset($_SESSION[$cartname]) && $cart_id != $_SESSION[$cartname]->cart_id) {
2,169 12/22/2017 06:05:22 pm
Re: Credit Card Sale (16 replies, posted in Accounts Receivable)
The issue here is to make the hardcoded Petty Cash Account as a dropdown set of bank accounts for Cash term sales documents. Otherwise, should a default hardcoded account to receive payments into be set in the Payment Terms for Cash Type using an extra field?
2,170 12/22/2017 04:36:08 pm
Re: Credit Card Sale (16 replies, posted in Accounts Receivable)
Setup => payment Terms => create new payment terms as Cash type but name it credit card. make an account code similar to cash and call it credit card. Make it a bank account - your merchant bank account.
It appears that the first non default cash type of account in the bank accounts gets hard coded in creating a direct invoice.
Quick Entries as in this post may be useful.
@joe: What is the correct way to make a "Cash" sale (Payment Terms) for a credit card transaction.
2,172 12/22/2017 04:12:02 pm
Re: how i can make the Tax calculate exactly? (3 replies, posted in Reporting)
Tax is set to be included in your price so 5000 * 0.05 / 1.05 = 238.10 SR. Setting it to be Tax Excluded will result in 250 SR = 5000 * 0.05. This setting is in Sales => Sales Types => Tax Incl (checkbox).
2,173 12/22/2017 03:38:37 pm
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
Then it should be a browser and version issue / OS issue.
2,174 12/22/2017 03:32:06 pm
Re: new report (21 replies, posted in Reporting)
Unzip into modules folder and a subfolder called rep_customer_ledger will get created. Now in your default company (generally company #0) go to Setup => Install/Update Extensions and "Install" the extension rep_customer_ledger. Then in the top dropdown box, choose Activate for target company and tick checkbox there. Logout and now login to your target company. Read the wiki.
2,175 12/22/2017 03:27:58 pm
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
Does the Ajax work for the Item field?