76 Reply by paul

(7 replies, posted in Items and Inventory)

Thank you Braath,

  I now have your changes applied to my system. At first I attempted to apply your patch to my local file (from Sourceforge v.2.4.7,  Build 26.07.2019) and got a "patch does not apply" message, so I manually added your lines as the patch indicates. I'm not smart, so I am sure I didn't do something correctly when trying to apply the patch via git apply.

  Then I didn't see how to apply the copied items at first, but then tabbing through the copy section simply finished your copy command.

  Thank you very much!

  Will your changes be added to the main program download for future installations?

Go to forum: Items and Inventory

77 Topic by paul

(7 replies, posted in Items and Inventory)

When I clone an item that is manufactured, the BOM is not considered if I understand correctly? Am I missing an option that would allow the BOM to also be cloned with costs (and a bonus to bring up the BOM for the new item during cloning for small modifications)? Or could this be considered for a future release?

Go to forum: Items and Inventory

78 Reply by paul

(2 replies, posted in Manufactoring)

Thanks Poncho. I'll have to look into that sometime later. Even when I look at the Status tab of one of the BOM items, it doesn't indicate the reserve. Right now, I'm have a hard time trying to get a report formatted for my small label printer labels for product marking.

Go to forum: Manufactoring

79 Topic by paul

(2 replies, posted in Manufactoring)

When I release an Advanced Work Order, I am looking for the view or report that would show the material, which is on the BOM, as reserved or under the Demand column or somewhere. I would like Quantity Available to indicate the result of this material not being available after I release the work order. I would assume this is how it should work from the wiki:

Wiki wrote:

Manufactured Finished Goods Sequence

    The material is first taken when producing.
    The simple assembling is taken immediately from raw material.
    For the advanced manufacturing this happens during producing.
    Normally we don't use the work in progress as it generally goes from raw material directly to finished goods.
    Of course the material is reserved after the release (Advanced Manufacturing).

Go to forum: Manufactoring

80 Topic by paul

(0 replies, posted in Items and Inventory)

After I add new raw material items and also their costs, I added new manufactured items. I then imported my BOMs from my old system. I was hoping that the importing of the BOMs would update manufactured items standard costs, but item shows no cost.

  If I manufacture the item, standard costs are updated. Is there a way to push the calculated costs from the BOMs to the manufactured item without manufacturing the item? I am thinking about the initial stock entry into the system having no costs when I sell the item (until I manufacture replacement inventory).

  Thanks

Go to forum: Items and Inventory

81 Topic by paul

(1 replies, posted in Items and Inventory)

Is there a view or report available that would show upto all items in inventory showing price, costs, supplier item number, etc? Similar to a spreadsheet. If costs and other fields could be edited within this view, that would be great!

  Thanks,

Go to forum: Items and Inventory

82 Topic by paul

(2 replies, posted in Items and Inventory)

I am finding the Item Adjustments are only addressed as relative to QOH. Is there an option that the quantity entered is absolute?

Go to forum: Items and Inventory

83 Reply by paul

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

OK - I just thought that others may install from the official location before coming across this.

Go to forum: Modules Add-on's

84 Reply by paul

(4 replies, posted in Manufactoring)

Thank you.

Go to forum: Manufactoring

85 Reply by paul

(7 replies, posted in Setup)

OK - I don't know if I should be altering files, nor do I know if this change is a good idea, but in the import_items.php file, at the "function get_supplier_id" portion, I changed this line:

$sql = "SELECT supplier_id FROM ".TB_PREF."suppliers where supp_name = ".db_escape($supplier);

to this:

$sql = "SELECT supplier_id FROM ".TB_PREF."suppliers where supp_name = $supplier";

  And my test file seemed to have imported correctly. Please let me know if this is allowed (for me to change it) and if it is acceptable as far as code is concerned.

  Thank you,

Paul

Go to forum: Setup

86 Reply by paul

(7 replies, posted in Setup)

OK - Maybe this can help. This is my test import file contents:

type,stock_id,dummy,supplier_description,supplier,suppliers_uom,conversion_factor,dummy1,USD,price
BUY,12345,,,MainVendor,Ea,576,,USD,75

It looks like the import extension is requesting the supplier name and also adding "'" (without the quotation marks) around the supplier's name:

...
SELECT * FROM 2_stock_master where stock_id = '12345'
SELECT supplier_id FROM 2_suppliers where supp_name = '"'"MainVendor"'"'
SELECT material_cost FROM 2_stock_master WHERE stock_id = '12345'
...

  (again, without the quotation marks) The request gets the stock_id correctly. I also tried adding quotation marks around the supplier name in my file, but did not help. Anyway to change this issue?

  Thank you...

Go to forum: Setup

87 Reply by paul

(35 replies, posted in Banking and General Ledger)

If I downloaded 2.4.7 from Sourceforge last week or so, how would I make sure I have the latest version because of this change (or, any change)?

Go to forum: Banking and General Ledger

88 Reply by paul

(7 replies, posted in Setup)

Yes - That's the part I am looking at.

  I attempted to make sure I had exact name. I even added a supplier manually to FA so I could export that data to compare. I saved the export, changed a price and tried to import the otherwise same file, but it could not find supplier.

Go to forum: Setup

89 Reply by paul

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

I did install it within FA 2.4.7, but could not checkout the extension until I made the change.

Go to forum: Modules Add-on's

90 Reply by paul

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

Extension: import_transactions v.2.4.0-5
File: hooks.php

Line 7 was:  $this->module_name = 'import_transations';

I believe it should be:

$this->module_name = 'import_transactions';

(added "c" in transactions)

Go to forum: Modules Add-on's

91 Reply by paul

(7 replies, posted in Setup)

Yes - yes. I downloaded those same files. I am looking through import_items.php and am looking at the get_supplier function to try to make sure it's looking at the correct database, table, field, etc. the function returns a 0. I even exported the current data to make sure I understand what I need to input.

Go to forum: Setup

92 Reply by paul

(6 replies, posted in Setup)

Thank you for the reply, apmuthu.

But I believe I found those references prior and they discuss a changing IP address. I do not have a changing IP address. Even though, I commented out the part in session.inc just for a test, but didn't help. Nor did I expect it to, either.

  This is just an annoyance. Not being about to import supplier purchasing price/uom in to inventory much bigger issue at the moment.

  Thank you.

Go to forum: Setup

93 Topic by paul

(7 replies, posted in Setup)

I am using FA v.2.4.7 and the extension to import item data into my setup. So far, I have been able to build and import the items, themselves, and their prices. I am having problems importing purchase data or maybe I misunderstand what it is suppose to do, but I get an error anyways.

  When I import BUY purchasing data, the Standard Unit Cost is updated and is correctly calculated using the imported files unit_conversion information along with the price in the file. The Purchasing Pricing tab does not show the predefined supplier nor did the import operation update existing data (after I manually enter the supplier and outdated pricing (for this test)).

  After I click on Import, I get two green banners toward the top of the page:

Supplier MainVendor not found

and

1. Purchasing Data items added or updated.

  I have even exported the same data, saved and modified this file's pricing and tried to import, but I get same results. If I understand the import code, the supplier field is looking in the "supp_name" column of FA database's suppliers table.

  What am I doing wrong, please?!

  Thank you,

Paul

Go to forum: Setup

94 Topic by paul

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

Hello. I think I found a very small typo in an extension. I have modified my install and wondered what the best way is to update the Extension for others in the future. Should I contact the author or is there a best-way path to submit an update for review/update?

  Thanks,

Paul

Go to forum: Modules Add-on's

95 Reply by paul

(45 replies, posted in Report Bugs here)

Could a cron job be setup to run automatically on the last day of the period (EOM) to produce the IVR? That's how we do it with a different ERP

Go to forum: Report Bugs here

96 Topic by paul

(6 replies, posted in Setup)

I have the Company Login Timeout timer set as high as possible that I am aware of, but it seems there are times that I have to login here and there without a known reason. The browser has not been restarted, allows cookies, same IP address and this doesn't happen all the time, but I have had times where I have had to login within minutes of each other. Other times I can go for a long time (1-2 hours?) before being prompted.

  It happens on both Windows/Firefox and Ubuntu/Firefox.

  Is there another reason that would cause me to enter my login so many times?

  Thanks.

Go to forum: Setup

97 Reply by paul

(3 replies, posted in Accounts Payable)

Thank you for the help. I think as far as I can tell (it's early), either way may solve my issue.

Go to forum: Accounts Payable

98 Topic by paul

(3 replies, posted in Accounts Payable)

Is there a field available to add incoming freight charges to a purchase order?

  Shall I create a Service type item in inventory pointing to a new incoming freight GL account? Or is it better to add the freight charges in the Supplier Invoice screen under the GL Items For This Invoice? I think I would rather have the freight to be listed on the purchase order for PO historical record.

  Same with the occasional paying of taxes - Sometimes it's easier to pay the tax on the one-off vendor purchases.

Go to forum: Accounts Payable

99 Reply by paul

(4 replies, posted in Setup)

Thank you @poncho. I am picking up on that now that you mention it. Still, having a print to possibly read through may give answers before I have the question. Sometimes I think I would rather read an actual page and also to have a reference.

  Thank you

Go to forum: Setup

100 Reply by paul

(4 replies, posted in Setup)

@rafat - Thank you and thanks for your patience.

  I just found your answer in the FAQ, too! Sorry.

  Also, is there a way to export the wiki information to a single PDF file?

Go to forum: Setup