1,926

(3 replies, posted in Items and Inventory)

Yes, there are some extensions that can import csv items. Look in the setup tab, install/activate extensions.

Joe

There are no problems in the algorithms. Please try your experiments in the Training Co. or the demo.

If it still doesn't work, then please tell me if the customers pricelist is tax included. And which tax Group is set on the branch (does it include any tax rates). And which item tax type the item has.
(total tax). And if the item tax type is exempt for taxes.
As you see there are a lot of possible mistakes to do here as the tax system is very flexible.

/Joe

Yes you can. Check that you have permission to do that in access setup.

/Joe

The deduction is calculated on the full item price without tax. Therefore the item tax is first deducted (if tax is included inprice).

/Joe

Did you have tax included for the customer or was the item tax type different?

Joe

@cristiart

It is not recommended to change the database structure within a minor release. These Changes are subject to consider when releasing a major release such as 2.4.
elax method seems to fix your problem.

/Joe

There is no link between payment and PO. Only to the allocated invoices. This is the reason that if you use FA, then you have to wait for the receival before entering the invoice. There are no receivals to put into the invoice if you try to enter the invoice before the receival arrive.

Then when the invoice is registered you can allocate it from the previous payment.

This is the way you can handle prepayment if you want to use FA.

Joe

I have explained how you can use FA with prepayments. If you cannot find a solution, then I can't help you.

Joe

I have explained how you can use FA with prepayments. If you cannot find a solution, then I can't help you.

Joe

Virshu,

The payment you do is recorded both in the bank account and accounts receivable as well as the general ledger. Everything works as you wish.
Allocation means that you take the initial payment and allocate the invoice(s).

Please try this out on the training company and discuss this with your accountant.

With FA you have no problems with this.

Joe

You will have to Activate these links by entering the Access Setup in Setup tab. You must have administrator privileges to do that. Then activate these links by looking into the role for your user type.

Please also look into the wiki

/Joe

Well, you simple wait until you get your final receival before allocating your initial payment.
When doing your payment you can instead reference the invoice number in the payment memo field.

This is the way I can suggest for you.

/Joe

1,938

(2 replies, posted in Accounts Payable)

By using reference numbers instead of real numbers you can create your own number serie. F.i. starting with charactere FA001 and so on.

In config.php you can choose to use the built in numbers or reference numbers when sending the items to your partner.

    $print_invoice_no = 0;

Setting this 0 value prints the reference number. Setting it to 1 will print the built in numbers.

/Joe

Hello Marc,

It seems that there is some kind of catch 22 here. I haven't heard of this behaviour before and cannot reproduce it.

You can remove the delivered fields in the table purch_order_details in your database. You can use phpMyAdmin for doing that. Look up your database (you can find the database name in the file config_db.php). Look for X_purch_order_details, where the X_ is the prefix of the database.
Look up your Purchase Order No of the records. Set the quantity_received and qty_invoiced to 0.

After these operations you should be able to Cancel the Purchase Order in FrontAccounting.

/Joe

The item description is shown on the printed purchase order. This info is only relevant for the supplier.

Joe

1,941

(5 replies, posted in Wish List)

It is not possible to create users only allowed to see his own data.

Joe

1. Create and send the PO to the supplier.
2. Create a payment to the supplier without allocating anything. Make a memo on the payment, f.i. PO #5. After creating the payment you can make a remittance and send it to the supplier.
3. When the goods are received use the Outstanding po maintenance and create the receival.
4. When the invoice arrive, enter the supplier invoice and select the po receival
5. Select  Allocate supplier payments and credit notes. Select the payment you made before and the invoice to allocate.

Joe

Make a payment to the supplier without allocating any invoices. You may put a memo/comment on the payment regarding the PO. Send a remittance. When goods arrive you enter the receival and when the invoice arrive you enter the invoice and allocate the former payment for the invoice.

/Joe

1,944

(5 replies, posted in Wish List)

No, this not possible in FA. The customer should be able to see this info in his own accounting system.

/Joe

1,945

(9 replies, posted in Report Bugs here)

Have you tried to set up the time-out value in php-ini.

/Joe

It seems that it is already voided. You should now be able to go into Purchase Order Inquiry, select the PO for editing and here you should be able to cancel the PO.

/Joe

1,947

(11 replies, posted in Modules Add-on's)

You can see if it is available from the repository by selecting Setup tab, install/activate extensions.

Decimal places are per user basis.

Joe

Please set the $go_debug flag to 1 in the file config.php. This will usually trap errors. You can also look at the errors.log in the /tmp folder.

You can also search the forum for similar issues. Try the search for, redirect .

If you still have the error, then consider upgrading your php version.

Joe

You can change the timezone in the config.php file.

/Joe