301 Reply by tom

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

This is strange.

In my order import I use add_to_order() (sales/includes/ui/sales_order_ui.inc)

If I import an order with a Description that has a " in it I end up with

16" Plate Glass Blank

And if I enter the sales order by hand I get

16" Plate Glass Blank

Here is my code

include($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/includes/ui.inc");
include_once($path_to_root . "/includes/data_checks.inc");
include_once($path_to_root . "/sales/includes/db/branches_db.inc");
include_once($path_to_root . "/sales/includes/db/customers_db.inc");
include_once($path_to_root . "/sales/includes/db/sales_order_db.inc");
include_once($path_to_root . "/sales/includes/cart_class.inc");
include_once($path_to_root . "/sales/includes/ui/sales_order_ui.inc");

$cart = new Cart(30); // New Sales Order
        $cart->customer_id = $customer['debtor_no'];
        $cart->customer_currency = $customer['curr_code'];
        $cart->Branch = $branch['branch_code'];
        $cart->cust_ref = "osC Order # $oID";
        $cart->Comments = $comments;
        $cart->document_date = Today();
        // $_POST['OrderDate'] = $cart->document_date;
        $cart->sales_type = $customer['sales_type'];
        $cart->ship_via = $branch['default_ship_via'];
        $cart->deliver_to = $branch['br_name'];
        $cart->delivery_address = $branch['br_address'];
        $cart->phone = $branch['phone'];
        $cart->email = $branch['email'];
        $cart->freight_cost = $order_total['value'];
        $cart->Location = $branch['default_location'];
        $cart->due_date = Today();
        $sql = "SELECT * FROM orders_products WHERE orders_id = $oID";
        $result = mysql_query($sql, $osc);
        $lines = array();
        while ($prod = mysql_fetch_assoc($result)) {
            add_to_order($cart, $prod['products_model'], $prod['products_quantity'], $prod['products_price'], $customer['pymt_discount']);
        }
        mysql_free_result($result);
        // print_r($cart);
        $order_no = add_sales_order($cart);
        display_notification("Added Order Number $order_no");

What is funny, When I call add_to_order I do not pass the description, it gets pulled from the FA db.

confusing...

tom

Go to forum: Modules Add-on's

302 Reply by tom

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

I have not seen any problems, I am just anticipating real life.

Since osCommerce computes Taxes and displays them to the customer and then
later FA has to re-compute taxes based on what is actually delivered.

I am worried about telling the customer the taxes are $x and then FA computing them to be $y

Based on the GL accounts we will send $y to the government, people tend to get upset if we collect one total and pay a different total.
(I think you can get fined if you Under pay taxes... over paying is usually not a problem!)

tom

Go to forum: Modules Add-on's

303 Reply by tom

(6 replies, posted in Installation)

When are email supposed to be sent?

In the code I saw emails can be send to a Inevntory Location email address.. it also looked like there was a flag to enable/disable it.

More details please!

tom

Go to forum: Installation

304 Topic by tom

(1 replies, posted in Report Bugs here)

The demo data and new data (en_US-demo.sql  en_US-new.sql ) should be updated to have a default fiscal year of 2009

tom

Go to forum: Report Bugs here

305 Reply by tom

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

I have cleaned things up a bit.

I also expanded the item_import to support Sales Kits and Foreign Item Codes.

I am going to put together the modules and get them uploaded.
I stop at Sales Orders at the moment.

Go to forum: Modules Add-on's

306 Topic by tom

(1 replies, posted in Report Bugs here)

Order #     Customer     Branch     Comments

The 'Comments' column displays Customer Order Reference, not the SO comments

Verified by looking at view_sales_order.php

tom

Go to forum: Report Bugs here

307 Reply by tom

(40 replies, posted in Report Bugs here)

Is it company 0?

If it is not the Training company then you will need to edit the SQL

UPDATE 0_debtors_master, 0_company SET 0_debtors_master.curr_code=0_company.curr_default;

changes all 4 of the "0_" to "3_" or whatever to match the company number of your company.

When using phpAdmin how many companies do you see?

Bunch of 0_ tables, followed by a bunch of 1_ tables, etc

tom

Go to forum: Report Bugs here

308 Reply by tom

(4 replies, posted in Manufactoring)

I figured out how to do what I need.

I define the Bulk Item I stock on the shelves with units I use (lbs) and enough decimal places to account for all my needs.
(In my case 1lb, 1/2lb, 1/4lb) 1.00

So I buy it in 50 lb buckets and sell in 0.25 increments
(I use a Work Order to convert from 1 bucket purchased to 50lbs of stock)

I then can use sales kit of the BULK item and the quantity input looks up the units used for the BULK and allows the proper number of decimal places.

The problem I had was not allowing decimal places on the Bulk item, once I added those it all made sense

tom

Go to forum: Manufactoring

309 Reply by tom

(26 replies, posted in Setup)

I think he was referring to using Google to find articles on how to get sendmail working with php.

FA calls the PHP functions to send mail and they will work only if your php and system (sendmail, etc) are set up properly.

tom

Go to forum: Setup

310 Topic by tom

(5 replies, posted in Items and Inventory)

Is it a bug that you can create a Sales Kit with the same alias as an existing Stock_ID?

I'm using FA 2.1.2

tom

Go to forum: Items and Inventory

311 Reply by tom

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

Well I have imported my first Sales Order!

Now I need to clean up the error checking and use proper FA notification messages

I really think I will try going the Direct Invoice route, because I think that is the only way I will be able to verify that osCommerce and FA computed the same taxes!

Can not collect one amount of taxes and report another!
The government does not like that!

tom

Go to forum: Modules Add-on's

312 Reply by tom

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

I ported the Customer Import into the osCommerce module, but when I started looking at the Item Import it occurred to me that item import has too many special cases to do it automatically.

On to Order Import!

First I'll make a Sales Order and I may have an option to act like 'Direct Invoice'

Go to forum: Modules Add-on's

313 Reply by tom

(12 replies, posted in Accounts Receivable)

Henry wrote:

Sounds good.  Let me know if you'd like help testing when you're ready.

I am working on osCommerce specific code right now.

It may be 'easy' to convert to read your data source... if I write clean enough code smile

Go to forum: Accounts Receivable

314 Reply by tom

(12 replies, posted in Accounts Receivable)

Yes it is a bit different, but once you have a sales order in the system a few simple clicks and it is ready to ship...
Those clicks may be easily automated...

We'll see how helpful my code is, once I am done smile

I take things one small step at a time...

at the rate things are going I expect to have something of interest in a few weeks.

tom

Go to forum: Accounts Receivable

315 Reply by tom

(12 replies, posted in Accounts Receivable)

joe wrote:

You can also follow a member of the community, tom. He is planning to do this with osCommerse. Eventually he sees this topic, otherwise ask him directly.
/Joe

Yikes! smile

hat I am working on is taking osCommerce Orders (I guess it does look a lot like an Invoice) and importing them into a FA Sales Order.

Once it is a SO then FA can take over...

What online shopping system are you using?

tom

Go to forum: Accounts Receivable

316 Reply by tom

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

joe wrote:

Hello tom,
BTW. tom, I guess you had a proposal for changing the install script to handle empty chart of accounts, using en_US-new.sql instead of the demo one.
I didn't like the idea in the form you suggested, but we could do it your way with a GET parameter, f.i. install/?accounts=new.
What do you say to that?

/Joe

How about an EXPERT mode button that adds a GET parameter, they we would consider any number of additional options for advanced installers?

That could be of some use to the other problem I am looking at...

tom

Go to forum: Modules Add-on's

317 Reply by tom

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

joe wrote:

Hello tom,

Yes, according to the table structure it must be unique. While you never see the customer number, it would be difficult to separate them if not.

/Joe

My problem is that osCommerce uses the Email Address as unique, not a person's name.

Could you consider the problems associated with having the name not Unique?

I was considering changing 'customer_list_row' to include the email address in the pull-down text to aid in choosing WHICH 'John Doe' you wanted.

change line 403 of includes/ui/ui_lists.inc

$sql = "SELECT debtor_no, IF(email = NULL, name, CONCAT(name, ' (', email, ')')), curr_code FROM ".TB_PREF."debtors_master ";

That should cover the majority of the places you might need to pick between two people with the same name.

The other alternative would be to use a nickname for one of them, but if it is not a nickname they actually USE, it would be confusing.

I'd suggest making the email address unique, but that may cause bigger problems for cases where email is not used... (if any)

Yes I know I could make a hack in my copy of the code, but I want to make sure any modules I provide can be used easily with out
too many (any?) additional changes to the base code.

Maybe there is another solution that you can think of that fits better within FA...
I am just looking for the best long term solutions...

tom

Go to forum: Modules Add-on's

318 Reply by tom

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

Here's a FA DB question.

Does the debtors_master.name need to be unique?

osComerce uses the email address as being unique.

Tom

Go to forum: Modules Add-on's

319 Reply by tom

(14 replies, posted in Accounts Receivable)

Base for auto price calculations:    

That was it, thanks

Go to forum: Accounts Receivable

320 Reply by tom

(8 replies, posted in Installation)

It would really be great if there was a choice at install time.

Since the superuser is only part of the First company created, it would be nice if there was a Create Tables option that did not include any demo data.

Or should I say no transactions.

A number of things can not be deleted once there are some transactions, that makes it hard to start a new company.

tom

Go to forum: Installation

321 Reply by tom

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

Yes I have seen that, but since each upgrade may (will likely?) require db changes it would be a good safeguard for cases where a company was overlooked.

$version says what version the code is and a db entry tells you what version the db has been updated to.

They could be the same value so that when $version != $row['version'] then we need to warn user that the db may need to be upgraded.

tom

Go to forum: Modules Add-on's

322 Reply by tom

(14 replies, posted in Accounts Receivable)

I am running ver 2.1.1 and in sales order entry the Prices are not updating when I select an item or change price lists

I do have JavaScript enabled

could it be a config setting?

I do have 'Show Item code' enabled

tom

Go to forum: Accounts Receivable

323 Reply by tom

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

Is there a field in the database that indicates the release version?

That will be helpful to add-on modules to see if they work or not...

tom

Go to forum: Modules Add-on's

324 Reply by tom

(15 replies, posted in Items and Inventory)

Ok, upon looking at things closer, it appears that Item Codes (or Foreign Item Codes) are used to translate a UPC/Barcode (aka Foreign code) into a stock item.

I see the quantity is used as a case quantity of the Stock Item we work with.

Are entries in the item_codes table required?

Why is item_code == stock_id in item_codes?
I expected item_code to be a foreign id, not a stock id.

tom

Go to forum: Items and Inventory

325 Reply by tom

(15 replies, posted in Items and Inventory)

I see stock_matster and item_codes

Why do they both have category_id?

Since item_codes.id is the key what is the meaning of a specific stock_id appearing more than once? Will they have different category_id's?

Also there is a Quantity field, isn't the quantity of a given item determined by looking it up in Stock_Moves as menti0ned above?

I would like to update items_import, but will need to understand what needs to be done in very simple terms.

I may be able to take initial stock quantities at the same time, but I think that is a secondary step at th moment...

tom

Go to forum: Items and Inventory