Search options (Page 158 of 247)

You probably need to do a Direct Invoice which generates the Sales Order as well.

Look at line 44 in sales/create_recurrent_invoices.php

    $doc->Comments .= sprintf(_("Recurrent Invoice covers period %s - %s."), $from, add_days($to, -1));

The above file is called only in line 38 of applications/customers.php - lines 37-38:

        $this->add_rapp_function(0, _("&Create and Print Recurrent Invoices"),
            "sales/create_recurrent_invoices.php?", 'SA_SALESINVOICE', MENU_TRANSACTION);

which is just the menu entry to create and print  Recurrent Invoices.

Chat can be a link to some chat application or web-service placed inside any theme's top menu portion (header).

@joe: How would we go about using the Foreign Item Code as a Bin Location? Must we somehow manually edit the item_codes table to make such foreign code entries have their is_foreign field as 0 instead of the default 1? It would also have to set it's Quantity field to 1 and possibly prevent it from inundating the sales invoice item drop down boxes as duplicates of their parent items.

Here is a sample set of transactions sql results on the training database:

-- Items and Inventory => Items => Add New Item
-- On Adding Item001
INSERT INTO `1_item_codes` VALUES 
('6', 'Item001', 'Item001', 'Test Item 001', '1', '1', '0', '0');
INSERT INTO `1_loc_stock` VALUES 
('DEF', 'Item001', '0');
INSERT INTO `1_stock_master` VALUES 
('Item001', '1', '1', 'Test Item 001', '', 'each', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

-- Items and Inventory => Foreign Item Codes => Add New Foreign Item
-- On Adding 2 Foreign Item Codes for newly added item
INSERT INTO `1_item_codes` VALUES
('7', '2154658', 'Item001', 'Foreign Item Code of Test Item 001', '1', '45', '1', '0'),
('8', '32568', 'Item001', 'Foreign Item Code for Next Test Item 001', '4', '14', '1', '0');

-- Items and Inventory => Sales Pricing => Add New Sales Price
-- Added Sales Prices
INSERT INTO `1_prices` VALUES
('5', 'Item001', '1', 'USD', '3'),
('6', 'Item001', '2', 'USD', '2.5');

Attached is the screenshot of a direct invoice entry in progress.

Adding foreign codes form has a Category field for the item - must we allow such a field to introduce ambiguity with that in the parent Item? This will make for the same stock_id having different category_id in the item_codes table!

Replace the users.password field value with a known one like "5f4dcc3b5aa765d61d8327deb882cf99" and use the string "password" to login.

The users.user_id field has the username.

Use appropriate table prefix as needed.

Such information in FA 2.3.x can be stored as part of the stock_master.long_description field and used as in the Wiki Article on Bin Locations.

In FA 2.4, a separate field in the stock_master table to provide for BinLocation would be useful.

"JavaScript Intention Power Pack" is not part of standard FrontAccounting. Unless proper context is provided, assistance would be impossible.