1 Reply by doitashimashite

(9 replies, posted in Accounts Payable)

I agree. Provided that something like that would be implemented in FA, I think this could greatly benefit the handling of PO's. It would at least save time that you would otherwise need to spend finding the cheapest supplier for the article(s) you're going to order. (That is, in case you work with multiple suppliers for a certain article.)

Go to forum: Accounts Payable

2 Reply by doitashimashite

(9 replies, posted in Accounts Payable)

I would prefer FA to show me the current purchasing price, instead of the historical price based on past PO's.

Go to forum: Accounts Payable

3 Reply by doitashimashite

(9 replies, posted in Accounts Payable)

In the current version of FA, is the above sketched workflow possible?

Go to forum: Accounts Payable

4 Reply by doitashimashite

(2 replies, posted in Items and Inventory)

I don't have a real solution but maybe a workaround: if every comma in your item descriptions is followed by a space, you can do the following:

- in a text editor, open the csv file and replace string pattern ", " with "##"
- import the csv file in excel. This will look alright after importing
- in excel, replace every occurrence of "##' with ", "

In order to export back from excel to FA, do the same in reverse order. It's a hassle but it should work.

Go to forum: Items and Inventory

5 Reply by doitashimashite

(9 replies, posted in Accounts Payable)

apmuthu, that is exactly what I mean.

Go to forum: Accounts Payable

6 Reply by doitashimashite

(4 replies, posted in Wish List)

Of course! My bad. Thanks.

Go to forum: Wish List

7 Reply by doitashimashite

(5 replies, posted in Reporting)

Did you try Sales / Inquiries and Reports / Customer and Sales Reports / Salesman Listing (under Reports For Class: Customer)?

Go to forum: Reporting

8 Reply by doitashimashite

(8 replies, posted in Report Bugs here)

No problem here. Which version are you using? I tested with v 2.3.15.

Go to forum: Report Bugs here

9 Reply by doitashimashite

(4 replies, posted in Wish List)

apmuthu wrote:

where is the reminder function?

"Setup / Miscellaneous / Reminder Setup"

It comes with the extension "Company Dashboard".

Go to forum: Wish List

10 Reply by doitashimashite

(3 replies, posted in Setup)

That should be no problem. There is a module called "Import of CSV formatted Items" under "Items and Inventory". So if you could export the items from the till into csv format (using a spreadsheet program f.e.) then FrontAccounting should be able to import them easily.

Go to forum: Setup

11 Topic by doitashimashite

(4 replies, posted in Wish List)

Wouldn't it be nice if we could extend this option in config.php

    /* email stock location if order below reorder-level */
    /* Remember to set an email on the Location(s). */
    $loc_notification = 0;

to the "Reminder" function?

Go to forum: Wish List

12 Topic by doitashimashite

(9 replies, posted in Accounts Payable)

Let's take item nr. 1001 as an example. I can purchase this item from 5 different suppliers:

Supplier A: $ 0.90 / piece
Supplier B: $ 9.90 / dozen
Supplier C: $ 5.28 / box of six
Supplier D: $ 86 / per 100
Supplier E: € 650 / per 1.000

It would be nice if the Purchase Order Entry would offer an option like this:

First enter the item code.
Then show me a list of suppliers for this item, price according to "Purchasing Pricing", and price per piece (to our UOM and currency).
Then let me change the order of the list to (f.e.) cheapest supplier (per our UOM) on top.
Then let me place a Purchase Order for this supplier.

In this case, the list would look like this:

Item: 1001         (1001 - Paint can)

Supplier          Price            Currency             Supplier's Unit             Supplier's Description          Price (our UOM/our currency)
B                    9.90            USD                    per dozen                    Paint can (12)                     0.825
E                 650.00            EUR                    1.000                         Paint can 1.000 pc               0.858
D                  86.00            USD                    100                            Paint can /100 pcs               0.860
C                    5.28            USD                    box of 6                      Paint can, 6 in box               0.880
A                    0.90            USD                    a piece                        Paint can                            0.900

As far as I can see, FA doesn't support this workflow. Or does it?

Go to forum: Accounts Payable

13 Reply by doitashimashite

(11 replies, posted in Setup)

Setup / Install/activate extensions / select your company / deactivate Requisitions / Update
then activate Requisitions again & problem solved!

Rene

DotNM wrote:

Hi all,

I'm relatively new to FrontAccounting and am looking at it for accounting for a small non-profit organization I'm involved with.  I downloaded and installed it successfully.  I also downloaded the Requisitions Module through the Install/Activate Extensions screen but it seems to not work.  When I click on Requisition Entries, I get the following message:

DATABASE ERROR : could not get all requisitions
error code : 1146
error message : Table 'front.0_requisitions' doesn't exist
sql that failed was : SELECT * FROM 0_requisitions WHERE (completed = 0) AND !inactive

Clicking Requisition Allocations gives this error:

DATABASE ERROR : could not get all requisition_details
error code : 1146
error message : Table 'front.0_requisition_details' doesn't exist
sql that failed was : SELECT * FROM 0_item_codes ic INNER JOIN 0_requisition_details rd ON ic.item_code = rd.item_code INNER JOIN 0_requisitions r ON rd.requisition_id = r.requisition_id LEFT JOIN 0_suppliers s ON rd.supplier_id = s.supplier_id WHERE (r.completed = 1) AND (rd.lpo_id = 0) ORDER BY r.requisition_id

Does anyone know how to fix the error and get the Requisitions Module operational?

Thanks in advance!

Go to forum: Setup