76 Reply by MarkAndrew

(45 replies, posted in Report Bugs here)

Hi Apmuthu

With all due respect, that's not a solution at all!

1. It's essential that the Inventory Valuation Report is able to be run accurately at any date a user chooses - otherwise this severely limits the usefulness of FA to accountants - who are more often than not reporting on past performance - especially in the context of an audit.

2. If I update unit costs via unit cost adjustments like you suggest, the GL will be adjusted which will make the IVL right but the GL wrong.

3. Then I will have to go and reverse all my temporary adjustments - that is after finding out what I need to adjust in the first place.  That's a big waste of time! 

This is a big flaw! For the benefit of all users it needs to be fixed - which I would gladly attempt to do if I knew how.  Not fixing this puts FA, as an accounting solution, in the "B team" for sure. 

Mark

Go to forum: Report Bugs here

77 Reply by MarkAndrew

(45 replies, posted in Report Bugs here)

Hi Apmuthu,
The fix you provide is for the "Costed Inventory Movement Report" (rep308) but my query was for "Inventory Valuation Report" (rep301). So your commit does not fix the issue with rep301

Go to forum: Report Bugs here

78 Reply by MarkAndrew

(10 replies, posted in Report Bugs here)

The fix worked, tx !!!
Although it is not in the 2.3.21 version. Any plan to update ? tx again

Go to forum: Report Bugs here

79 Reply by MarkAndrew

(2 replies, posted in Items and Inventory)

thanks Joe

Go to forum: Items and Inventory

80 Reply by MarkAndrew

(10 replies, posted in Report Bugs here)

By not ticking the box called "allow negative inventory" in system and general ledger set up I thought that negative inventory would not be allowed, so as not cause "troubles."
But, in the example I gave in previous post, negative inventory was allowed.  Like I've said before, I can't code. Logically speaking, there needs to be a routine in the code that checks today's stock quantity before allowing me to process a back dated delivery or direct invoice that exceeds today's qty and results in negative stock.  As it is now, one thinks that by not ticking allow negative inventory the troubles are avoided, but they are not.

Go to forum: Report Bugs here

81 Topic by MarkAndrew

(10 replies, posted in Report Bugs here)

The following concerning negative inventory was noted:
1. In System and General Ledger Setup, allow negative inventory was not checked to allow negative inventory.
2. Today, qty on hand was 500 units of inventory item, on 25 July there were 1000 units on hand
3. When we backdate a sale to 25 July of 600 units, the sale is processed
4. But as of today's date 100 units of negative stock will appear, despite the fact that we did not allow negative inventory in system and GL set up.
5. No warning was displayed to disallow (or at least alert) the negative balance.

Go to forum: Report Bugs here

82 Reply by MarkAndrew

(45 replies, posted in Report Bugs here)

Thanks Apmuthu

Go to forum: Report Bugs here

83 Topic by MarkAndrew

(2 replies, posted in Items and Inventory)

Hi
How do I limit the number of decimal places displayed to 2 in the unit cost of the Inventory Valuation Report?
Mark

Go to forum: Items and Inventory

84 Reply by MarkAndrew

(45 replies, posted in Report Bugs here)

The Inventory Valuation Report (IVR)is not reliable for looking at stock values at past dates.

If I want to see a list in support of my general ledger stock value as at (for example) 30 June 2014 there is no reliable way of doing so if my unit prices have changed (by virtue of increased supplier costs, differing exchange rates etc) between 30 June 2014 and the day I run the report.
The only time the IVL is guaranteed to be accurate is if it is run for "todays" date.  This is a problem, particularly for audits, as a IVR generated "today" for a past date may not balance to the GL inventory control account as IVR uses latest average unit cost on the date the IVR is run, not the historical average unit cost applicable at the reporting date.

This is a big limitation to using Front, which is a good product.

Go to forum: Report Bugs here

85 Reply by MarkAndrew

(5 replies, posted in Report Bugs here)

thanks Joe.

Go to forum: Report Bugs here

86 Reply by MarkAndrew

(45 replies, posted in Report Bugs here)

Hi Joe
thanks for explanation.
The IVR is not reliable for looking at stock values at past dates.
I understand that prices can be adjusted as you say, but that's not the solution or the point.
Nor is the stock movement from the various number of places you mention.

The point is that if I want to see a list in support of my general ledger stock value as at (for example) 30 June 2014 there is no reliable way of doing so if my unit prices have changed (by virtue of increased supplier costs, differing exchange rates etc) between 30 June 2014 and the day I run the report.

The only time the IVL is guaranteed to be accurate is if it is run for "todays" date.  This is a problem. 

Like the Costed Inventory Movement Report, the Inventory Valuation Report is not always reliable because FA does not link inventory unit costs with dates.  From what I see, it uses latest cost regardless of date of the report I want.

Go to forum: Report Bugs here

87 Reply by MarkAndrew

(5 replies, posted in Report Bugs here)

thanks Joe, however the fact remains that the costed inventory valuation report as it stands can't be relied on.

From my example you can easily see that

1. the opening stock unit cost and therefore stock value in this section of the report is wrong
2.the stock in has no unit cost and therefore stock value in this section of the report is wrong

Surely, standard, system generated reports need to correct?

Mark

Go to forum: Report Bugs here

88 Reply by MarkAndrew

(10 replies, posted in Report Bugs here)

thanks Joe. Appreciated.

Go to forum: Report Bugs here

89 Topic by MarkAndrew

(45 replies, posted in Report Bugs here)

FA 2.3.19 reports following wrong result in the inventory valuation report (IVR)

1. The IVR seems to use the latest ave unit price to value stock.
2. So if, today (12 August) I want to run the 31 July 2014 IVR (which quite a normal thing to want to do), the report will be generated using 31 July quantities but today's unit cost.
3. This means that the IVR cannot be run for any day other than "today" - or it will be wrong if there have been any changes to inventory unit cost between the reporting date and "today."
4. The report needs to select the average cost as at the reporting date, not the actual date it is run.

I'm not a programmer and can't correct this in the code.
But I am an accountant and this is a really big flaw in FA's reporting.
Can this be fixed for the good of the whole FA community?

Go to forum: Report Bugs here

90 Topic by MarkAndrew

(5 replies, posted in Report Bugs here)

The following error is produced in FA2.3.19 : Costed inventory movement account

1. Create a new stock item
2. Adjust 1 unit of stock at $2 on say 12 July 2014 
3. On 12 August 2014 adjust 1 unit of stock at $8
4. Run the costed inventory movement report from 1 August 2014 to 31 August 2014 and this is what you will see the following wrong result.

                          Opening Stock                                Stock in                              Delivery                       Closing Stock 
                     QTY   Rate   Value                 QTY   Rate   Value              QTY   Rate   Value                QTY   Rate   Value
                   
New item        1        5        5                        1       0         0                                                              2       5         10




5. The correct result should be

                          Opening Stock                                Stock in                              Delivery                       Closing Stock 
                     QTY   Rate   Value                 QTY   Rate   Value              QTY   Rate   Value                QTY   Rate   Value
                     
New item        1        2        2                        1       8         8                                                             2       5         10


6. Not being a programmer and unable to check the code, it looks like what is happening is that FA is selecting the last average cost to value opening stock instead of the average at the start of the period for which the report is run.  Then in such a case, it is not picking up the unit cost of the stock added in the report period.

Is it possible to correct this error? It would be in the interests of all FA users to have accurate reports.

Mark

Go to forum: Report Bugs here

91 Topic by MarkAndrew

(10 replies, posted in Report Bugs here)

FA release 2.3.19 produces the following wrong result:

1. Create an inventory item called "unit cost test" (or any name you want)
2. Post an inventory adjustment of 1 unit at a cost of $2 to this new item.
3. Check the inventory valuation report - it will show, as expected, 1 unit at $2 each = Total value of $2
4. Post another inventory adjustment to the new item of 1 unit at $8.
5. Check the inventory valuation report - it will show, as expected, 2 units at $5 each = Total value of $10
6. Now void the second inventory adjustment.
7. Check the inventory valuation report - it will show 1 unit at a cost of minus $237.6784 = Total value of minus$237.6784
8. I would expect to see 1 unit at $2 each = Total value of $2.

Why is this?  I'm not a programmer. I can't go into the code to fix it.
Can this be corrected?

I tried the same thing as above but using supplier invoices instead of inventory journals.  It works correctly.

Go to forum: Report Bugs here

92 Topic by MarkAndrew

(0 replies, posted in Wish List)

When using advanced manufacturing additional items issued to a work order are not allocated to the cost price of manufactured item but are adjusted automatically by the system as Cr Stock, Dr Inventory Count Variance.

However, the system generated journal makes no reference to which work order or stock item it relates to.

The end result is a lot of journals that can't be traced to any work order or stock item.

Can the system generated journal include the reference of work order number and stock item for the audit trail?

Go to forum: Wish List

93 Topic by MarkAndrew

(1 replies, posted in Accounts Receivable)

Hi,

I've noticed that when I run a customer aged analysis, a supplier aged analysis and an inventory valuation report for a date in the past, that the total of the report no longer agrees to the GL control account.

For example - at 31.3.14 customers aged analysis, supplier aged analysis and inventory valuation reports all agreed to GL.
But, when I rerun these reports for 31.3.14 today, they no longer balance to control account at 31.3.14, although they do balance to control account at today's date.

Can FA not generate the mentioned reports retrospectively?

Go to forum: Accounts Receivable

94 Topic by MarkAndrew

(1 replies, posted in Banking and General Ledger)

Hi
I see how to create GL account tags but I don't see how to run reports that use GL account tags.
How do I do run reports using GL account tags?

Go to forum: Banking and General Ledger

95 Reply by MarkAndrew

(31 replies, posted in Accounts Receivable)

Thanks for reply.
Can't get it to work as system uses the same template for each customer in group.
So each customer in group ends up with same product / qty ... however can't see how to sell different product or diff qty of product to each customer in group.

Go to forum: Accounts Receivable

96 Reply by MarkAndrew

(31 replies, posted in Accounts Receivable)

I'm trying to set up recurrent invoices.  Can recurrent invoices be set up for differing amounts for each customer in a group?  Example - school fees are recurrent billings but not each invoice will be the same as some families have one child, other have 3 etc.

Go to forum: Accounts Receivable

97 Reply by MarkAndrew

(14 replies, posted in Setup)

All the points discussed are valid.  However, FA would have better security if it were not possible for multiple logins using the same password.  (I'm not a programmer and have no clue how to make the changes needed to prevent multiple log in using same password)

Go to forum: Setup

98 Reply by MarkAndrew

(14 replies, posted in Setup)

I found this problem too.

It's possible for two users to log into FA with the same password.  Yes, users can have unique passwords but security is improved by not allowing simultaneous log in with the same password.
Other accounting software I know does not allow 2 logins at the same time with same password.

Go to forum: Setup

99 Reply by MarkAndrew

(7 replies, posted in Banking and General Ledger)

Please may I have help with Import Multiple Journal Entry / Deposits / Payments?
Is this a csv import?
If it is, then what is the format of the csv file for each of the above entry types?

(To find the format for inventory items was easy as there is a facility to export to csv which then provides me with the format to import.  It works really well)

Many thanks
Mark

Go to forum: Banking and General Ledger

100 Reply by MarkAndrew

(12 replies, posted in Announcements)

I have encountered the following problem after installing release 2.3.17:

When I enter a "customer payment" of 11 500 for a customer (set up in my home currency) into a bank account (also set up in the home currency) the GL posting is

Dr Bank                          11
Cr Debtors                             11 500
Dr Forex variance    11 489

I have deselected automatic update of forex variances as I though it might make a difference but it does not.

However, when I try post the same payment via "Banking and General Ledger...Payments" the result is as expected:

Dr Bank       11 500
Cr Debtors             11 500

How can I solve this problem.

Mark

Go to forum: Announcements