I sent it, let me know if you got it.

52

(2 replies, posted in FA Modifications)

I think as a start country should would be a standard just a one field liner or a drop down to select from customizable by the user. For instance there would be a set up for countries in the set up section and I would add to it the countries I need. So that when I add/update customers / or suppliers i would choose a country from that list.

City and Provinces/State (if applicable), postal/zip/area code can be a little tricky since it varies from country to country.

Maybe if should be included anyways and if its blank it just wouldn't be included as part of the query or invoice.

53

(2 replies, posted in FA Modifications)

I know FA is currently designed for general and multinational use which is why the address aspect of the system is just one field, but it would be good to eventually have fields for Country, and Province/State (if applicable), and City. Reason is for reporting flexibilities in the future. Let's say I wanted to track sales by city, state, country for example.

Thanks

Hey guys, I got the chequing module working. Basically plugs right and works right into the RC2 release. If you guys are interested in having it I can email / send it to you in hopes perhaps you can use / expand it as part of future releases.

Let me know

Is there a way to include a credit note as part of a payment allocation? What i'm trying to do is to include the credit note as part of the discount on a payment.

For example: I owe 480 to the supplier but got a credit for 80 due to whatever. So I pay 400 and discount 80. I would then allocate the payment to invoices that make up the original 480 but I would also like to include a credit note for the 80 discounted on the payment. In the supplier payment view, right now is shows -80 left to allocate but it references to nothing since there is no way to allocate that discount. Is there a way around this some other way?

Ideally here is what i'm trying to accomplish:

Payment: 400, Discount 80

Supplier Invoice 1 amount 200
Supplier Invoice 2 amount 280
Supplier Credit Note amount 80

Total allocated: 480
Left to allocate : 0

Instead of Left to allocate -80

Thanks

This could be just me not understanding the logic, i'm not sure but an improvement in the ways it shows the current and 0-30, 31-60, 61+ could be better shown as follows:

Let's say we had 300$ - 60 days overdue, $200 of an invoiced as been payed that was originally within the 0-30 days overdue stage, and there is a 100 in current 'non' overdue invoices. The total balance would for a particular customer/supplier would be 400

Instead of:

Current    0-30    31-60     over 60    balance

600           -200     300         0               400

A better way to show it would be:

Current    0-30    31-60     over 60    balance

100           0         300         0               400

* Current to me shows what receivables/payables that are not yet due, while the 0-30, 31-60, over 60 shows what is actually due to pay or received starting with 0-30 days overdue.

57

(3 replies, posted in Items and Inventory)

Would be cool if we can search by Name as well instead of just item code.

I'm currently working on this right now, basically its going to be its own separate module that issues 'cheque' numbers to a given payment (whether it is bank payment or supplier payment). This way, not much is changed to FA's current payment process and trunk code.  A cheque no is referenced to an existing processed payment transaction. Cheque numbers will be unique with a check_config table keeping reference of the check numbers.

It would also have to keep track of which bank chequing account the cheque is referenced to. An additional table called check_ref would be used to keep the issued cheque references to which payment transaction. Once a check is issued to a payment transaction, it can then be printed. I still have to figure out this part out. I will keep you posted. Basically i'll look at how the reports are printed and go from there. There's many standards of Cheques out there, right now i'm just creating one that follows the CPA standard (canadian). But I can see future work in having some kind of margin and output setup for individual customizable needs.

Yah I notice it was part of the account set up. For future implementation, would be good to make it tax group instead of tax type? Since an account could have multiple combinations of Taxes.

Here's the scenario. I have a supplier who I purchase inventory from and I have a supplier/vendor who I pay my bills. Each require an invoice created so that it goes into the payable to which a payment is later done.

I have a vendor/supplier called Phone Company with a payable account of Accounts Payable and purchase account : 5067 Phone Company, and discount account: 5067 Phone Company. The vendor also charges GST (5%) and PST (5%). So naturally a group tax is chosen for this.

When I create an invoice for this Phone Company, I basically just by pass the Received Items Charged on this Invoice section since it's not applicable, and go straight to the GL items for this invoice and choose the 5067 Phone Company (which is an expense account) and put the amount that is on the invoice. The only problem is after going back to the supplier invoice entry section. the Group tax is not applied to the subtotal of the phone company GL line.

Not sure if this is an oversight or is there a reason behind why Tax would not be applied here.

ok great, I will patch what I need to do for now. But will there be any plans in the near future to have Cheque features? I think it will certainly get alot of North American type companies on board

Hi guys, what's the best way to add additional modules / add-ons without affecting much of the core system code?

I want to add a customized cheque printing module which tracks cheque no as well but I don't want to change much of the core code too much since I want to continue to update the system to latest CVS. I will gladly share the module once I get it working.

My goal is to be able to make payments by checks, recording not only the reference sequence but also a check no sequence. Both for PO payments by checks as well as Bill Payments all referencing the chequing sequence. Ex : 1000, 1001, etc. I will also have the ability to print on a pre-stock cheque by PDF with two stubs.

Any direction on what the best approach is would be great.

63

(0 replies, posted in Wish List)

I've been assessing your software for awhile and I just realized that there is no check audit or printing options. I think this is a must feature to have since its a pretty standard function of accounting to have the ability to pay bills / expenses with checks.

I think Checks should have its own payment type, with a  Cheque No Sequence. Since alot of times Checks needs to be traced and audited so it would be good to make this field a requirement for Check type payments and used in sequence.

Sorry guys, I think everything is fine... Was just confused on what the Purchases actually represents. I guess what I was trying to accomplish is to get some type of 'Cash payed to Supplier' type purchase and realize the only way to really accomplish this is to factor in the beginning and end inventory amount + purchases to get the actual COGS amount. A manual process but I don't see any way around it... unless someone else can share light on this matter?

Understood, however what about the Purchasing Account when we get the supplier invoice? Should the Expense Purchase Account be Debited at this point as well? Debiting Stock is a for sure thing after an invoice, but should we not be tracking the purchasing expense as well and debiting its invoice. I don't see how you could do it I guess with GL. It's obviously has to come from somewhere to balance the two sides.

Cause if I look at my balance sheet, I would want to know in my Expense column the total C.O.G.S, which one of the expense account being the Purchases which should reflect how much I have purchased during the year. If it's only RECORDED during a sales order transaction, then the only way to determine the exact Purchased expenses is to reference it with the look at the Inventory amount that is left...

Is this the best way to get the actual current purchases C.O.G.S?

I'm a little confused behind the logic of how the GL for the purchases account works. Usually this account is recorded in concurrent with when a PO invoice... With a credit going to accounts payable and debits going to the Inventory for the amount set out on the PO. But what about Purchases account? Should this account not also be debitted with the same amount going into inventory as well? Reason is, when we do a balance sheet to be able to calculate the the C.O.G.S wouldn't we need the exact purchases expense of what is currently purchased within the year?

How does the Purchases (C.O.G.S) account relate to the dispatching of a SO? Shouldn't it just be a straight Credit to the inventory and debit to the sales account and not have to touch the Purchases Account? Since this was already delt with when a PO invoice was created for the purchase in the first place?

Do I make any sense at all? smile

Is there any way to unreceived a PO that was already received. We should be able to go to Purchase Order Inquiry and perhaps have a cancel link beside it for POs that have already been received into inventory or something to that nature?

68

(13 replies, posted in Wish List)

i'm not looking for reading interfaces yet per say, although would be nice for the future. I was just talking about having a custom extra field in when adding new inventory, cause I have UPC codes on the products and would like to put the code as reference with the item in the system. Would be neat to have a barcode converter. Is it possible to add custom fields to inventory other than having to do it through hardcode?

69

(4 replies, posted in Setup)

ah ok sorta was confused cause it was a mandatory account link and I wasn't able to remove the payroll account from the GL due to this.

I have another question. In regards to Sales Exchange Variances Account. Not sure how this plays out? Is this due to currency exchanges during sales transactions?

70

(4 replies, posted in Setup)

I have a question in regards to the preliminary System and GL setup. I'm not sure what payroll account is for exactly and how it ties in with what transaction. We don't use payroll as part of our system so have no need for it other than setting up a GL account for it for manual journal entry later on.

71

(13 replies, posted in Wish List)

Yes I have unique skus that  I would like to have for inventory as well.