1 Topic by stildalf

(1 replies, posted in Report Bugs here)

Hi Guys,

Not sure if this is just a warning and what it's effects are - found it by accident while solving another issue.

FA 2.3.2 with $go_debug = 2; in config.php I get the following on every "main" app page. (Sales, Purchases, Items, etc...)

Undefined index: package in file: /var/www/acc.5x5/includes/hooks.inc at line 197

Undefined index: package in file: /var/www/acc.5x5/includes/access_levels.inc at line 263

Going to a particular view within an app (say New Sales Order Entry) then show the hooks.inc warning only, not the access_levels.inc.

Can I safely ignore these, or should I be looking to solve something?

Go to forum: Report Bugs here

2 Reply by stildalf

(2 replies, posted in Installation)

Thanks Janusz,

You sent me looking in the right direction.

Seemed strange because I was deffinately using a system admin account.

I reverted to backed-up 2.2.5 app. Checked all the System Administration boxes under Setup > Access Setup for the System Admin Role. Then re-attempted the 2.3.2 upgrade and all went smoothly. Not sure why I would've had those unchecked.

Thanks again for the prompt response, top-notch as usual.

Go to forum: Installation

3 Topic by stildalf

(2 replies, posted in Installation)

I'm having some issues upgrading a 2.2.5 installation to 2.3.2.

I copied all the files, overwriting old ones.  Copied config.default.php to config.php. Checked config_db.php  still has company arrays.

When I log into first company with admin account I get the following message:

Access to application has been blocked until database upgrade is completed by system administrator.

When I then click on Setup tab I'm kicked back to logon screen. Can't get to Setup -> Software Upgrade.

Enabled $go_debug = 1; in config.php and I then get the following after admin log in:

Undefined index: package in file: /var/www/acc.5x5/includes/hooks.inc at line 197

Undefined index: package in file: /var/www/acc.5x5/includes/access_levels.inc at line 263

Access to application has been blocked until database upgrade is completed by system administrator.

Looking at the line numbers in the code for the mentioned files indicate both being foreach($array as $value) constructs.

Running PHP Version 5.2.6-1+lenny4

Anybody have some ideas to assist?

Go to forum: Installation

4 Reply by stildalf

(3 replies, posted in Installation)

Thanks Janusz,

Just wanted to make sure.

Go to forum: Installation

5 Topic by stildalf

(3 replies, posted in Installation)

Is there any OS specific config settings needing a change when moving a working installation from a windows to linux host? (besides db config obviously)

Everything seems to be running fine, but I recall a Windows/Linux checkbox during initial install.

/Stildalf

Go to forum: Installation

6 Reply by stildalf

(6 replies, posted in FA Modifications)

I can second that statement. The most responsive dev team I've come across. And a code base that is logically structured and easy to follow.

Well done guys and keep it up!
/Stildalf

Go to forum: FA Modifications

7 Reply by stildalf

(16 replies, posted in Items and Inventory)

Hi All,

I've made a change to this script to fix a problem when creating a new Item Category on item import. Script used to only specify category name and the category could then not be seen or edited by viewing 'Items and Inventory'->'Item Categories'.

Script now updates the following fields for the created Category: Tax Type, GL Accounts, Units & Item Type (Item/Service/Manufactured).

I just don't know where to post the updated file. Should I post it on Mantis? (Don't thinks so...)

Go to forum: Items and Inventory

8 Reply by stildalf

(7 replies, posted in Accounts Receivable)

Thanks Joe,

I would just like to commend the Devs for their active involvement. A refreshing outlook that is very encouraging to someone pretty new to FA.

Well Done!

/Stildalf

Go to forum: Accounts Receivable

9 Reply by stildalf

(7 replies, posted in Accounts Receivable)

Confirmed.

Material_cost value is updated after processing a GRN.

Go to forum: Accounts Receivable

10 Reply by stildalf

(7 replies, posted in Accounts Receivable)

Thanks Joe,

Then my assumption was correct.

I have however found a scenario where creating a service item, posting a GRN and suppliers invoice, then Direct Invoice of the same service item does post to the GL inventory account in the auto generated Delivery Note. This behavior is evident in 2.2.4 and 2.2.5.   In 2.2.3 the service item behaves as it should in the above scenario, ie. no GL inventory posts.

/Stildalf

Go to forum: Accounts Receivable

11 Topic by stildalf

(7 replies, posted in Accounts Receivable)

FA 2.2.5

Am I correct in assuming that when Delivering/Direct Invoice of service items that no GL postings should be made to inventory accounts? Perhaps I've mis-configured something but whatever I try I can't seem to avoid a delivery of a service item posting to inventory.

On the receiving side things look ok. No inventory posts are made upon GRN.

Also, if I deliver a service item before receiving it then, because the stock_master material_cost is zero for the item, no inventory posts are made upon delivery. The minute this item is first received (material_cost updated) then deliverd it seems to produce my problem.

Both the Item Catogory and the Item itself is setup as a service item.

On a side note. When creating a new Service type Item Catogory, despite only being able to edit the Sales and COGS accounts, once the catogory is saved the other account fields are populated with the company default values for Inventory, Inventory Adjustments & Assembly. Is this not perhaps a little confusing, when those fields should theoretically be empty?

Go to forum: Accounts Receivable

12 Reply by stildalf

(10 replies, posted in Items and Inventory)

I see a problem:

Compare Test2 with Test4.

In Test2, after having received and issued the item - we sit with a value of 80 in the Cost of Sales account. (As it should be)

In Test4, after having first issued and then received - we sit with a value of 80 in the Inventory account. (Shouldn' be there - must be in Cost of Sales)

smile

Go to forum: Items and Inventory

13 Reply by stildalf

(10 replies, posted in Items and Inventory)

Sorry Joe, my terminology is obviously a bit misleading.

My GRV implies a GRN and posted Supplier Invoice.
My Invoice imples a Customer Invoice (and obviously Delivery Note).

I suppose I should ask this: how does FA handle Pre-invoicing ie. Customer Invoice of an item before Supplier Invoice of the same item?

Go to forum: Items and Inventory

14 Topic by stildalf

(10 replies, posted in Items and Inventory)

Hi all,

Bear with me on this one, it might be a confusing post to illustrate the problem but perhaps someone can shed some light. Also, sorry for the image urls, forum doesn't cater for tables structures well and my img tag seems to be off.

Here's the scenario:
Inspect GL postings of the same set of transactions posted in different order on a single, purchase type, stock item. Basically I was varying the order of supplier invoice (GRV) to direct customer invoice (invoice) and looking at the affects on the GL. Emphasis being on C.O.G.S. vs Inventory.

The tests was run on Version 2.2.3 Build 12.01.2010 and a clean (no transactions) db restore was done before each test. "Allow Negative Inventory" was enabled in "System and General GL Setup".

Test1: GRV then Invoice (Without setting Std Cost)
No problems here. Cost of Sales and Inventory reflect the correct figures.

Test2: GRV then Invoice (Std Cost set to 80)
No difference from Test1. Cost of Sales and Inventory reflect the correct figures.

Test3: Invoice then GRV (Without setting Std Cost)
Problem here. Inventory hasn't been moved to Cost of Sales.

Test4: Invoice then GRV (Std Cost set to 80)
Problem here. Inventory was moved with original Delivery Note, but reversed again with "Cost. diff" on GRV.


So it seems "Cost. Diff" gets applied in the wrong situation. Had it been applied in Test3 and not Test4 then both would have had the correct end result. Or am I totally missing the point here?

Jacques

Go to forum: Items and Inventory

15 Reply by stildalf

(16 replies, posted in Items and Inventory)

Once again, thumbs up to everyone putting in the time over here. smile

Stildalf

Go to forum: Items and Inventory

16 Reply by stildalf

(16 replies, posted in Items and Inventory)

Hey Tom,

Noticed from module downloads section "CSV Importing - Advanced (Release 2.0.X only)". Gues this won't work in 2.2.3 then. Do you know how much work it might take to get it to work for 2.2.3? How far apart are the data structures from 2.0.x to 2.2.x?

I'm new to FA, a whole 2 days in actually. Loving it by the way. I have quite a few years of experience developing on Axapta/DynamicsAX for a bunch of clients and was looking for something way simpler to run a small IT support and development firm - pretty sure I've found it in FA. (Well done to all involved!) For sure I'll start digging under the hood soon and would love to assist where I can, when I can.

Go to forum: Items and Inventory