Search options (Page 3 of 12)

Gee like that is not blatant advertising, are we stupid?

Chris,

How about the osc_import?

The way I use it is when I have new orders I can log into FA and do a few clicks and tell it to import new customers
and import new orders and then I continue with FA as normal.

There is also options to verify item code and prices and price update FA->osc

tom
ex-osC core developer

You can define  your own units for each inventory item.

I maintain bulk inventory in LBS of which I 'manufacture' bags of 1/4, 1/2, 3/4 and 1LB, so it sounds a lot like what they need.

I buy things in 50lbs or 20kg buckets and use the purchasing pricing and UOM conversion to restock myself.

tom

It almost sounds like a second setting would really be needed.

DECIMAL_PLACES_INTERNAL (accounting use) and DECIMAL_PLACES_EXTERNAL (seen by customers)

The problem is that at some point you need to actually round from 3 places to 2 places so that when you deal with
the ledger you never have partial pennies, invoices and payments need to be exact.

These 3 decimal place costed items, do you often sell 1 or 2?

sounds like money... are you dealing with 1/8ths?

tom

What do you do to 'refresh' the screen?

That was fixed already: http://mantis.frontaccounting.com/view.php?id=960

Here are the changes:

tom@tom:~$ diff ./Downloads/doctext.inc ./newfa/frontaccounting/reporting/includes/doctext.inc
156,157c156
<             $this->formData['document_number'] = $print_invoice_no == 0 && isset($this->formData['reference'])
<                 ? $this->formData['reference'] : $this->formData['order_no'];
---
>             $this->formData['document_number'] = $this->formData['order_no'];
tom@tom:~$

< are new lines
> are old

tom

I have no doubt that the solution works, what modules do I need to install in order to test it on my test system and my databases?

I see some generic modules (FrontAccounting SOAP Web Service API and FrontAccounting LDAP Conector API)  at the FA 2.3 download site,
but nothing that is targeted to osCommerce.

Maybe the remaining part is that cron job you mention that is unreleased and likely non-GPL?

Tom

How can I install and test your solution?

It sounds quite comprehensive.

What is the oscommerce contribution called?
Have you submitted the FA module to Joe or Janusz?

If not I encourage you to do so, since both projects are GPL

Tom

Try Sales->Customer Transactions

It defaults to ALL CUSTOMERS

Maybe instead of putting All Customers at the Top of the list we could put it at the Bottom,
this was after someone enters a search we will either default to the first entry or ALL if no matches we found

Does it make sense now?

tom

It looks like you are missing a column:

ITEM;ITEM_CODE;STOCK_ID;Description;Category;units;dummy;MB_FLAG;Currency;Price;

Where Item_Code = STOCK_ID of the item.

You have the STOCK_ID missing

I think for the most part ITEM_CODE == STOCK_ID, these are used in the 'item_codes' table

Also line 52 of import_items.php has a problem it should be:

function get_dimension_by_name($name) {
    if ($name == '') return 0;

it was

    if ($name = '') return 0;

If you are using dimensions, it seems that the 'dummy' field before MB_FLAG is where you can put a dimension

Let me know if this fixes you up

tom

I set it to 30 :

    /* Save Report selections (a value > 0 means days to save. 0 = no save) */
        $save_report_selections = 30;

but the pull down selections stay at the defaults...

Here are they headers I get, I see the cookie data, but it is not being
recognized as a cookie

http://www.gotgrit.com/admin/fa23/reporting/reports_main.php?JsHttpRequest=0-xml

POST /admin/fa23/reporting/reports_main.php?JsHttpRequest=0-xml HTTP/1.1

Host: www.gotgrit.com

User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.16) Gecko/20110701 Iceweasel/3.5.16 (like Firefox/3.5.16)

Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

Accept-Language: en-us,en;q=0.5

Accept-Encoding: gzip,deflate

Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7

Keep-Alive: 300

Connection: keep-alive

Content-Type: application/octet-stream; charset=UTF-8

Referer: http://www.gotgrit.com/admin/fa23/reporting/reports_main.php?Class=0

Content-Length: 165

Cookie: osCAdminID=1376b6670caf3b3e93f55ce65b1352; osCsid=3327e28d2e6e08425773892ec6319; FA11ff01cdb0d50479fa1a3c3a5d808b3=2aa40a80dd5e76989240261260a8

Authorization: Basic xxxxxxxx

Pragma: no-cache

Cache-Control: no-cache

Rep303=Display%3A%20Stock%20Check%20Sheets&REP_ID=303&PARAM_0=-1&PARAM_1=&PARAM_2=0&PARAM_3=0&PARAM_4=1&PARAM_5=1&PARAM_6=&PARAM_7=0&Class=2&_random=357859.914609811

HTTP/1.1 200 OK

I tried a different report and it did the same thing

tom

The FORCE UPGRADE may not be the best thing to do.

Restore you db from the backup prior to the upgrade (Where it says Partial 1/4) and see if you still have a "0_company" table

I had to drop that table first.

Drop the table, run backup again and then try the upgrade.

If you don't have a company table then read this thread for other suggestions

Tom