Search options (Page 6 of 15)

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

How does it fail?

When you go to Setup->Software Upgrade what do you see?

Under

Well, after looking around it looks like the Sales Reports -> Price Listing report is pretty close to what I need.

I like the GP% but would like to add an optional cost column.

But the Gross Profit is based upon the Material Cost (running  average)

If I have some large cost changes (which I have, one Rare Earth Material I rely upon has increased 5x-6x in the last year)
I would like to reset the average material_cost (stock_master) to actual cost.

I am thinking of a simple module that clears all material_cost and recomputes material_cost based on foriegn item_codes
and manufacturing BOM's

I could then re-run the Price Listing and check the GP to see what prices need to be adjusted.

The nice part is the report can be loaded in excel if needed...

Now... (finally a question)

Will updating the material cost to actual cost have any serious negative impact from an accounting point of view?
(like violate any Accounting 101 concepts)

or is it maybe just a Good Idea?

tom
ps. I also notice that last_cost is updated, but all of my actual_cost fields are 0, is that normal? Is actual_cost no longer used?
pps. actual_cost is only referenced in One place... read only... includes/ui/items_cart.inc   the constructor for class line_item

How can developers request values for modules they create?

Maybe set a range for local use and any others need to be allocated by the core development team?

tom