1 Topic by maartenvr

(1 replies, posted in Setup)

When I go to Tax Groups, I want to charge tax on shipping.
I have 3 tax groups setup:

1. Canada (General Tax Only)
2. BC (General Tax + Provincial Tax)
3. Exempt.

When I enable tax on shipping for Canada or BC, that works. But then when I select a second one, the first one changes back to "no" automatically.

Not sure if this is functionality, or a bug fix. I can't change this directly in the database either, it gives an error....

What do I need to do?

Go to forum: Setup

2 Reply by maartenvr

(2 replies, posted in Accounts Receivable)

That is not a bad idea, thank you very much for that!

Go to forum: Accounts Receivable

3 Topic by maartenvr

(2 replies, posted in Accounts Receivable)

We are struggling with the order process in FA.

When entering an order, it may not be ready to ship right away. So we do not want to send the order off to the warehouse for picking.

How can we assign an order status to a sales order? We would want to know if it has been printed, if it is picked and ready to ship etc.

Any suggestions?

Go to forum: Accounts Receivable

4 Topic by maartenvr

(1 replies, posted in Jobs wanted/offered, non-free offers)

I need some shipping functionality integrated between FA and Magento. We already use CartSpan to get the orders into FA which works great. Just need to get shipping integrated.

I have posted this as a project on Elance.

Go to forum: Jobs wanted/offered, non-free offers

5 Topic by maartenvr

(2 replies, posted in Reporting)

We just ran FA for the first month in November, and we just looked through the profit and loss statement.
for the most part, all looks good, but we do not see the inventory purchases we made, therefore the Calculated Return is overstated.

How do we get this onto the report?

Go to forum: Reporting

6 Topic by maartenvr

(1 replies, posted in Jobs wanted/offered, non-free offers)

We started running FA as of November 1st. Many of out transactions are imported from Magento using CartSpan (works awesome)

We need a go-to person for any issues we may run into. Someone who can troubleshoot within about 24 hours (preferably right away but I understand that is not possible)

We have FA installed on a VPS.

We also need the PO and Invoice forms modified right away.

Please contact me with your hourly rate, FA experience and maybe also Magento experience if you have it.
Prefer some references as well. I don't foresee this being a lot of hours, but it is important when it is needed.

Go to forum: Jobs wanted/offered, non-free offers

7 Reply by maartenvr

(3 replies, posted in Report Bugs here)

I don't have any extensions installed. I am not sure about the transaction type.

This error continued for a little while, but I was doing something wrong in the first place. We receive payment before shipment with many of our orders. I was trying to allocate the payment to an order, which does not work.

I will keep monitoring this to see if it happens again!

Go to forum: Report Bugs here

8 Topic by maartenvr

(3 replies, posted in Report Bugs here)

I created a customer payment. When I go to allocate, I get the following error.

DATABASE ERROR : no debtor trans found for given params
sql that failed was : SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.curr_code, cust.tax_id, com.memo_,bank_act,1_bank_accounts.bank_name, 1_bank_accounts.bank_account_name, 1_bank_accounts.account_type AS BankTransType, 1_bank_accounts.bank_curr_code, 1_bank_trans.amount as bank_amount FROM 1_debtor_trans trans LEFT JOIN 1_comments com ON trans.type=com.type AND trans.trans_no=com.id LEFT JOIN 1_shippers ON 1_shippers.shipper_id=trans.ship_via, 1_debtors_master cust, 1_bank_trans, 1_bank_accounts WHERE trans.trans_no='26' AND trans.type='12' AND trans.debtor_no=cust.debtor_no AND 1_bank_trans.trans_no ='26' AND 1_bank_trans.type=12 AND 1_bank_trans.amount != 0 AND 1_bank_accounts.id=1_bank_trans.bank_act

Go to forum: Report Bugs here