Would it be possible to add a supplier filter to the Inventory Planning Report? Some items are available from multiple suppliers, as set-up in the Purchase Pricing screen of Items and Inventory. I would like to be able to filter the report to only show items available from the selected supplier rather than picking them out of the whole report of all items.
1 04/25/2011 03:10:13 pm
Topic: Inventory Planning Report - Filter By Supplier (1 replies, posted in Reporting)
2 04/25/2011 02:51:41 pm
Re: Oustanding Purchase Orders (5 replies, posted in Items and Inventory)
Joe, this has taken a while to figure out.
Your solution works if a product has been receipted to inventory - it can them be removed from the supplier invoice screen and it reverses out the receipted quantites.
What happened here was that a purchase order was partially receipted. Since I do not back order, there were items remaining that were preventing the POs from closing. I entered the edit screen to edit the PO and remove the items that were not receipted. Apparently when entering the PO edit screen on a receipted PO, it re-sets the qty receipted back to 0. This does not affect the inventory but now the PO shows that nothing has been receipted.
If this happens to anyone else, this can be resolved by receipting everything again then removing the duplicated items from in the supplier invoice screen as Joe has stated above. This removes the duplicated items from inventory and closes the PO. Is this the proper method of handling the cancelled items of partially receipted orders? Is the qty received re-set to zero in the PO edit screen by design or is this a bug?
3 04/25/2011 02:07:46 pm
Re: Item costs are way off (4 replies, posted in Items and Inventory)
Thank you Joe. I figured that whatever has caused this problem will continue to compound and would be a problem forever. I created a new installation with a copy of the original database, then truncated every table that contained transaction data leaving all of the product, customer, supplier and set-up information. In the stock_master table, I zeroed out the last_cost column and updated the material_cost column to reflect current costs of all products. Then in the setup tab and forms set setup I reset everything back to start at 1.
Now, while I still have an active installation to work from - I have begun re-entering every PO, receipt, payment, sale, customer payment etc. in the clean installation. Hopefully it will be completed up to current transactions in a few weeks then the original installation will be removed. Kind of a pain but I would rather fix it now than have it plague me forever.
4 04/18/2011 03:13:46 pm
Topic: Item costs are way off (4 replies, posted in Items and Inventory)
I have noticed that some of the item costs have started showing negative numbers. After searching the forums, it appears that item costs are averaged over a period of time. For some reason, many of my items have become very far off where one item that costs $2.70 is showing $391.87344647187 and another item that costs 0.57 (by the pound) is showing $-1875.1849224543.
The purchase pricing is correct in Items and Inventory and the prices were correct on the purchase orders and supplier invoices.
I am thinking this has to do with the earlier problems with purchase orders (https://frontaccounting.com/punbb/viewtopic.php?id=1859) where receipted items were showing a quantity received of 0. I discovered that editing the back-ordered items on the purchase orders caused the delivered items to return back to zero even though they were in fact delivered and showed correctly in inventory. Since costs are averaged, and there was a problem with quantities, now the averaged costs are way off.
Changing the Standard Cost looks to have corrected the Inventory Valuation Report but what about the GL and COGS? Is there a way to correct these costs without having to start from scratch?
5 01/27/2011 03:16:51 pm
Re: Oustanding Purchase Orders (5 replies, posted in Items and Inventory)
Joe, it is very likely that I may have done something out of order. I am new to accounting software and still learning the flow and functions of everything.
As stated above, the items show on hand and still on order. Is there something I can change directly in the database to set everything as received? The other option is to cancel the orders but would it affect the inventory and stock moves?
6 01/27/2011 02:44:44 am
Re: User Accounts and Sales Persons (2 replies, posted in Setup)
Thank you Joe. So if I use single account for cash sales, there is not a way to pull the sales commission by salesman by the login?
7 01/27/2011 02:38:40 am
Topic: Oustanding Purchase Orders (5 replies, posted in Items and Inventory)
I have some purchase orders in the Outstanding Purchase Orders which have already been received and posted to stock. The grn_items table shows the items are received and inventory shows that everything is in stock. Item movements even shows the transaction but they do not show to be received in Purchase Orders. When checking the item status, it shows the correct quantity on hand but also shows the received amount as still on order.
When viewing the Purchase Order Inquiries, click on # it shows the Deliveries and Invoices but all items show a quantity received of 0 and overdue.
Is there something I am overlooking or that I have done wrong? Will deleting the Received orders from the Purchase orders affect the inventory?
8 01/19/2011 06:56:20 pm
Topic: User Accounts and Sales Persons (2 replies, posted in Setup)
If a user account is added from Setup -> User Accounts Setup and a salesperson is added at Sales -> Sales Persons .. How do you tie the user account to the sales person for tracking sales and commissions?
9 03/01/2010 02:59:58 am
Topic: Item Import from CSV (2 replies, posted in Modules Add-on's)
After installing the item import module (for 2.2) in FA 2.2.5, the Import Items text appears on the Items and Inventory page, but it is not a clickable link. Installed as per instructions in the readme.txt with folder name import_items, and selected the import_items.php for upload then hitting install. I added the access permissions for system administrator, is that the correct role for admin? Searching the forums does not turn up any information on this problem, any other ideas why it is not making an active link?
10 02/25/2010 09:27:44 pm
Re: Tax column alignment and calculation (5 replies, posted in Report Bugs here)
Ah.. now I see. Thank you for the help! I love system and will be donating to the cause.
11 02/25/2010 07:26:37 pm
Re: Tax column alignment and calculation (5 replies, posted in Report Bugs here)
Thank you for your quick response. The next questions is, where do you change this setting? I am not finding anything that refers to tax and price list.
12 02/25/2010 06:37:19 pm
Topic: Tax column alignment and calculation (5 replies, posted in Report Bugs here)
The tax column on all invoices, direct invoice, and quotes have an issue with the tax column. The tax is calculated properly but the column does not line up and it is not added to the order total. See the attached image from a screen shot. Searching the forums does not result in similar issues. How do I solve this problem?