26

(5 replies, posted in Report Bugs here)

Using advanced manufacture I've noticed bugs:

BUG 1 Partial Issue of Component Requirement
--------------------------------------------------------------------------------------------------------------------------------------------------------
I issued 3 units of component to production that requires 5 units of component to produce.
Components issued are not recorded on the work order when viewed or printed.
Conclusion: in this circumstance a work order printed or viewed from Front is not reliable
--------------------------------------------------------------------------------------------------------------------------------------------------------


BUG 2 Incorrect Unit Cost     
--------------------------------------------------------------------------------------------------------------------------------------------------------
The advanced manufacture process takes place in the following steps after making a work order:
a) Release the work order
b) Issue the stock
c) Produce the manufactured item
d) Costs (other than inventory) to be allocated to manufactured item

The process of issuing the stock is duplicated in the process of manufacturing the item.
As a result the cost of the material component of the manufactured item is accounted for twice.
The result of this are

i) An incorrect unit cost is shown in the Inventory Valuation Report.

ii) The value of component stock in the GL is understated (as components are removed x2 from the GL but only once in reality on the shop floor)

iii) The value of the finished item stock in the GL is overstated (as components are included x2 in the GL but only once in reality on the shop floor)

Conclusion:  Advanced manufacturing overstates unit costs
---------------------------------------------------------------------------------------------------------------------------------------------------------

BUG 3 Incorrect Jnl entries to account for incomplete manufacture (Work in Progress) in advanced manufacturing
---------------------------------------------------------------------------------------------------------------------------------------------------------

The advanced manufacture process takes place in the following steps after making a work order:
a) Release the work order
b) Issue the stock
c) Produce the manufactured item
d) Costs (other than inventory) to be allocated to manufactured item

The journal entry passed to issue the stock sends it to GL for finished goods stock instead of GL for work in progress.
If the manufacturing process is not complete finished goods stock can't be updated.

Conclusion:  Front does not reliably show the value of finished goods stock in the GL if there are incomplete work orders.

------------------------------------------------------------------------------------------------------------------------------------------------------
BUG 4 to come - also has to do with partial issue of component stock...the system updates the GL account inventory adjustment (P&L) instead of work in Progress (B/S).

....

Don't know if this is a bug in v 3.2.23 or just in my own installation?

When I delete a line in a journal entry and in an issue to to a work order in advanced manufacturing, the line above the one I want to delete is removed and the line I want to delete is left on the screen.

28

(14 replies, posted in FA Modifications)

Sales of service items don't appear in the Inventory Sales Report (ISR)
This means that if I run the ISR it does not balance to the GL Sales in the Profit and Loss.
It would be better if the ISR included sale of service items so that it balances to the P&L.

29

(17 replies, posted in Report Bugs here)

Thanks Joe - Appreciated
Not knowing how to make the change - can it be in the next modification?
I believe it might be usefull for other users too.

30

(5 replies, posted in Report Bugs here)

Yes the info on the work order is redundant.
But it's there as a result wrong logic I think.
When I try to do advanced manufacture, even tho I know there is stock of components, the system won't let me issue them. This remains a problem

31

(17 replies, posted in Report Bugs here)

When using drill down reports - like the trial balance..
I change the date range to my required range like Jan to March for example and drill down - it's great.
But when I return back the date range has changed to current month and I have to keep re-entering by required date range.
Is there any way that this could be changed so that the drill down reports remember the last date range used?
Don't know if other have same need?
Mark

32

(5 replies, posted in Report Bugs here)

Hi - I think this is a bug in 2.3.23

I have entered stock of components for a manufactured item today - eg 5
I checked the stock levels of these components I can see that there are 5 in stock
I assembled my manufactured item which takes 5 units of the component and updated the Work Order
The work order updated
But when I printed the work order there was a message on the work order that put *** next to each component to indicate insufficient stock. But there was exactly the amount of stock needed.
Is the system putting this error message if the stock level of the component is equal to or less than the qty needed for the work order instead of only putting this error message if the stock level of the component is less than the qty needed for the work order?
Or, maybe the system is checking stock level after the work order and not before the work order?

I tried the same as above after entering 10 more of the components to stock and there was no error message.

--------------------------------------------------------------------------------------------------------------------------------

I then tried the same thing using advanced manufacture.
I can see that I do have exactly enough components on today's date to process the work order but when I try to issue the component stock it get and error message saying insufficient qty on hand.
Even after I enter more components than I need I get the same error message.


Mark

33

(2 replies, posted in Report Bugs here)

Thanks Joe
Appreciated as always.
Reports that are generated with wrong info is serious as we make decisions based on reports from Front.
Glad it's fixed after 8 yrs!
Mark

34

(13 replies, posted in FA Modifications)

Hi
I tried quick entries.
Doesn't work when you need to affect customer and supplier accounts or where the base amount is variable.

Ideally the solution is to have a the Withholding Tax processed at the level of customer and supplier payments like a discount as detailed in earlier posts.  It could be configured in customer/supplier set up where the user could determine the % that should be withheld from the supplier payment or by the customer when he makes his payment and it could be offered as a option when processing customer and supplier payments.

Example:

In customer set up... +Withholding tax to be deducted by customer on payment  ..3..%
                                 +GL Allocation of Withholding Tax Deducted  ....5/2562...   (as selected by user from GL structure)

In customer payment screen...Amount of Discount  $x
                                              Amount of TDS         $x***

*** calculated like discount with reference to customer set up parameters and allocated to selected GL account as per customer set  up. Amount "Auto   filled" but with the option of manual over-ride.         

Sorry to only offer logic not a coded solution.

35

(2 replies, posted in Report Bugs here)

I noticed the following:

When I process a customer payment with today's date it appears in the customer aged analysis in the 30 day column and not the current column.

Tried several times with same result.

Then I processed a customer payment with last month's date.  Instead of showing in the 30 day column in the customer aged analysis it showed in the 60 day column.

Did same test with a payment to supplier with same results as above.

Conclusion: it looks like customer / supplier payments are shown on the customer/supplier aged analysis one aging column too old which means customer/supplier aged analysis report is not always reliable. A fix is needed.

36

(10 replies, posted in Report Bugs here)

ok, thanks

37

(10 replies, posted in Report Bugs here)

will be glad to help test

38

(10 replies, posted in Report Bugs here)

Hi Joe
What I know abt programming is zero!
The only hint I can give is for the routine to work the same way as voiding a direct customer invoice.
The other hint I can give is for things to work consistently - not one way for this and another way for that - but that's not much help for this problem but it's important in the big picture.

39

(10 replies, posted in Report Bugs here)

Hi - it's been a while since I could get back into this bug - error in costed inventory movement report.

I have experimented with the effect of voiding transactions to see if this can cause a difference between GL and Costed Inventory Movement Report (CMIR).  What I found was that voiding a direct sales invoice has equal effect on both GL and CMIR as both the sale and inventory transactions are voided in a single "void".  However voiding a direct purchase invoice also requires voiding the supplier invoice and the associated purchase order delivery - ie two "voids."   If you don't do two voids as described then the GL is right but the CMIR is wrong. 

I often have the problem of the GL stock values and the inventory reports differing.  When they do it is very difficult to find out why - in fact to me it's proved impossible.

Can I suggest that the effect of voiding a direct supplier invoice be the same as voiding a direct customer invoice? 

The goal being to make the user experience of Front better by making it simpler and consistent.

Mark

In my costed inventory movement report I encountered the following:

Opening Stock Value  $347 017
Stock in value            $202 615
Delivery Value            $ 45 453
Closing Stock Value    $591 544

But this does not add up - the arithmetic comes to $504 179.

Also, my Inventory Valuation Report balances to by GL for some inventory categories but not others.


Mark

41

(13 replies, posted in FA Modifications)

Thx. I understand but don't feel that the issue is addressed.
Example to illustrate:

An architect sells services for $1000. He charges $15 Vat on top of this. FA can process these 2 elements.  His customer pays him $970 (1000 less 3%) + $15 Vat = $985. He receives $985 into FA against the customer account.  It looks like the customer still owes him $30 (1000 +15 - 985).  But in reality the customer owes him nothing as the $30 is income tax withheld by the customer from the payment to the architect and paid directly to the tax authority. 

How do I remove the $30 from the customer account and put it in the WHT accrued account?

The ideal solution would be to transfer it there on processing of the customer deposit like we do with a settlement discount which is transferred from customer account to the discount allowed account.  Except in this case it is transferred to WHT accrued account.

42

(13 replies, posted in FA Modifications)

Different to vat which is what you refer to and needs to operate as well as vat

43

(13 replies, posted in FA Modifications)

Adding a facility to process withholding tax (WHT) would greatly improve the usefulness of FA where WHT is applicable - which it is in many places.

In simple concept it would entail coding similar to settlement discount. 

In the same way FA deals with settlement discounts on payments from customers and payments to suppliers, there is an additional, similar type of transaction commonly dealt with by accountants - withholding tax (WHT)

When certain (not all) customers pay me, they are obliged to deduct with-holding tax from the amount they pay me.

For example, I invoice $100 to my customer, and he will pay me $97 and then he will pay the $3 balance to the tax authorities - as a payment of tax on my behalf. 

As far as the customer is concerned his account with me is zero - the $3 should not appear on the statement I send him. 

The accounting for this would be

Dr Bank                                       97
Dr WHT deducted on my behalf      3  (balance sheet receivable account as opposed to the discount allowed GL acc)
Cr Debtors Control                     100 

There is no way I see to account for this in FA at the level of customer payment. 

The ideal solution would be to have, at the level of customer and supplier set up, an option to process withholding tax on customer or supplier payment.

The reverse can happen when I pay certain suppliers.  For example, if I pay my rent I need to deduct 5% tax and pay it to the tax man.

The accounting entry for this would be

Dr Rent                                  100
Cr Bank                                    97
Cr WHt deducted by me              3 (balance sheet payable account - as opposed to the GL acc for discount received)

When I pay the tax man the entry would then be

Dr WHt deducted by me              3
Cr Bank                                      3       


Mark

44

(2 replies, posted in Items and Inventory)

Hi Apmuthu
Is there any way of importing the opening inventory quantities also?
At present the only way I know how is manual inventory adjustments line by line - which can take a long time!
Mark

45

(0 replies, posted in Reporting)

Hi

I'm selling both services and purchased items.
I need to see a list of sales to see what service is being bought by what customer.
When I run the report Inventory Sales Report the service items don't appear on it.
When I run the report Inventory Sales Report For purchased items the product and customer appear - great report!
When I run the report Sales Summary Report I see total sales by customer name (incl services) but not what they bought
When I run the report Item Sales Summary Report I see the items sold (incl services) but not who bought them.
Is there a report that shows sales by product (incl services items) by customer  - like the Inventory sales report does for purchased items? 
It would be great if Inventory sales report could display sales of all types of items sold - incl services.
Is this possible?

Mark

46

(2 replies, posted in Report Bugs here)

Thanks Joe

I don't fully understanding the coding implications but would restricting the GL account to Supplier Control Account when selecting "Supplier" as a payment type from Cash Book payments mean less flexibility for a user?

As an accountant using FA, I find that the GL control accounts often don't balance to the subsidiary ledgers (like debtors, stock, suppliers).  This means lots of wasted time to try find out why.  To me, in my perhaps limited view, it seems better not to provide flexibility that has the potential to create problems. 

From the perspective of a user of FA it really would be better to restrict the GL account selection to Supplier Control Account (in our example) or, if this is not possible, then rather don't post the entry to the supplier account.

Mark

47

(2 replies, posted in Report Bugs here)

I noticed a bug when processing supplier payments through banking and general ledger.
                                                                             ****************************
Here is the scenario:

1. I processed a supplier payment using banking and general ledger payments
2. I selected "pay to supplier" as payment type and then selected the correct supplier
3. By mistake I then selected a GL account called printing and stationery (instead of supplier control account which the system defaults to when I select supplier as the payment type)
4. When I processed this payment Front updated the GL by DR Printing and Stationer and CR Bank and it also updated the supplier account.
5. But it does not update the Supplier Control Account.
6. The problem becomes that that supplier control account and the supplier aged analysis don't balance

The point to note is that it would really help if the user was prevented from changing the allocation from the default Supplier Control Account after selecting the payment as a "Supplier".  Probably the same with payment type as "Customer" 

The overall objective being that there seem to be a number of (subtle) ways to produce the wrong results in Front and closing these loopholes makes Front a better solution. 

Mark

48

(5 replies, posted in Report Bugs here)

Thanks Joe

I experimented a bit and found that unless I press TAB key to move from the date input then the invoice due date does not change.
So, if I don't press TAB but use my mouse to go to the next input field, like say quantity, then the due date does not change.

These sort of things are important - little anomalies that create different results.

Is it possible to change the due date regardless of whether I press tab or use the mouse?

Getting the right info from the system (overdue invoices in this case) shouldn't be dependent on whether a user presses TAB or uses the mouse to move to the next input field. 

Mark

49

(5 replies, posted in Report Bugs here)

The following anomaly was noted in Front:

1. Today (7.11.14) I entered a sales invoice dated 31.10.14
2. The customer payment terms are 10 days from invoice which should in theory be from 31.10.14
3. The due date reflected on the invoice says 17.11.14

Unless the customer knows that it was on 7.11.14 that I raised the invoice, it does not make sense that the invoice dated 31.10.14 with payment terms of 10 days is due on 17.11.14.  He would expect to see that it's due on 09.11.14.

thanks of course I "can", but I can't code sad