The primary VAT rate in Ireland moved from 21% to 23% at the end of 2011.

Any advice would be greatly appreciated.

I have not completed all invoice entry for 2011, in fact I'm quite a bit behind on it! However, I have 2012 transactions that are being entered (currently with the wrong VAT being applied).

How should I handle this?
Do I simply change the existing 21% rate to 23%? If so I presume I need to close out 2011 first, right?
Do I create a new VAT rate leaving the old one in place and switch customers to using the new one?

Thanks for any suggestions ...

Gareth.

I'm already using FA for one business that deals with manufactured goods, however the work orders are handled in a separate system. I'm thinking about using FA for a second company and doing the manufacturing in FA.

Already I see a couple of things I would like to change and I'd like some feedback before I start mucking about in the code!

The company prepares and delivers food (catering). Here is the workflow:

Sales Order is placed for items that need to be prepared, thus are not in stock.
From the line items on the sales order Work Orders are required.

Should there be multiple items on a Work Order?
I'm not convinced this is necessary and may cause complications. On the other hand the pattern of Work Order against Sales Order (just like Delivery against Sales Order) could be used if a Work Order did have multiple lines.

Assuming the current situation of one item per work order; I'm thinking about a check box on the line items in the sales_order_entry grid that would cause automatic creation of the work orders for checked items when the order is placed or updated.
Alternative is a button on the line items in view_sales_order.php although this is not the UI model throughout the system.
What about adding a button to each line in stock_status.php? This would have the effect of aggregating the order lines from different orders and creating a single work order for the total required.
Anyone got an idea?

Once a Work Order is Released I need to be able to print it, including the BOM as a job ticket to be used in the kitchen. This would effectively turn the BOM into a recipe with specific ingredient quantities, helping with portion control (thus cost). It seems like this is just creation of a print function akin to that in invoices, sales orders, etc.

Anything obvious I'm missing?

Thanks,

Gareth.

3

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

Please post it wherever it might help. The pattern should help anyone that wants to continue.

4

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

I've attached the first pass at a soap interface. It is only a start and implements only the direct sales invoice workflow - cause that's all I need for now! However, it may be of use as a starting point for anyone that needs to integrate with FrontAccounting.

Put the soap folder from the zip file into your install folder (e.g. http://yourdomain/account). Connect to http://yourdomain/account/soap/soap.php?wsdl and you're off and running.

Remove the .txt from the end of the attachment. The forum is not liking the .zip extension.

5

(5 replies, posted in Report Bugs here)

In case someone else runs into this. I ended up using this to correct the values in the database:

UPDATE `frontaccount`.`1_trans_tax_details` ttd
SET net_amount = -net_amount, amount = -amount
WHERE trans_type=20 AND amount < 0;

6

(5 replies, posted in Report Bugs here)

Thanks Joe.

Please confirm that they should be +ve values in the database so I can write some bad SQL to change them!

Gareth.

7

(5 replies, posted in Report Bugs here)

It seems that when the purchase is for actual stock items that have a PO and then are invoiced everything works fine.
However when I do the following it seems the value is entered in the trans_tax_details as a negative which doesn't seem to be correct:

Open Purchases>Enter Supplier Invoice
Use a Quick Entry to put two lines into the invoice the first of which is tax and the second the service, etc.
Post the invoice.

The AP and GL entries are correct including the tax entries so no problem there. However the trans_tax_details entry will be -[tax amount] whereas for an item-based (rather than GL Item) invoice the trans_tax_details entry will be +[tax amount].

8

(5 replies, posted in Report Bugs here)

Both the Tax Inquiry and the Tax Report are behaving oddly. I'm expecting I've done something wrong so I'm putting it here rather than in Mantis. I'm expecting that the following inquiry for January 2010 should show a Net Payable amount of 903.64 - 488.99 = 414.65, i.e the difference. For some reason it is showing both values as positive and thus it's telling me to pay too much tax.

Has anyone seen this before?

from:          to:          Show
Type    Description    Amount    Outputs/Inputs
VAT IE 21%    Charged on sales (Output Tax):    903.64    4,303.05
VAT IE 21%    Paid on purchases (Input Tax):    488.99    2,328.52
VAT IE 21%    Net payable or collectible:    1,392.63   
Total payable or refund:    1,392.63   

Thanks,

Gareth.

By the way it is correct in the GL. Only the report and inquiry are wrong.

9

(0 replies, posted in Wish List)

Sort of like Quick Entries help with repeated tasks, I find I am routinely looking for certain date ranges in reports and also in the Inquiry forms, e.g. Supplier Transaction Inquiry. So, I would like to be able to store a set of date ranges, each with a label that would appear in a dropdown list on the Inquiry and Report pages:

e.g. To create a Date Range I would enter three fields:
Label: Q1 2010
Start: 01/01/2010
End: 31/03/2010

Label: Q2 2010
Start: 01/04/2010
End: 30/06/2010

Then to use them the dropdown on the Inquiry and Report pages would have just the labels:

Q1 2010
Q2 2010

Just a nice-to-have if anyone is bored and in need of ideas!

Gareth.

10

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

I've started working on a SOAP web service primarily so I can post Direct Sales Invoices and Payments from a custom online store. I'm using the underlying transactions that sales_order_entry.php?NewInvoice=0 uses.

Has anyone worked on this already? I don't want to reinvent the wheel - especially given I'm a C# geek not a PHP one!

Gareth.

11

(3 replies, posted in Report Bugs here)

I just got the same error just now with 2.2.11. Did this ever get figured out or did it just go away?

****Disregard - taking MySQL down from strict to sql-mode="" sorted it out!