4,576 Reply by joe

(7 replies, posted in Setup)

When you start a document, f.i. a direct invoice, there is a built in search fascility to find the correct item records, so there are no room for an entrybox for placing your own text, but!

If you start with a direct delivery and use the standard item with the standard text and after processing the delivery go to invoice against sales delivery, you can override the item text and it will remain on the record. The same if you start with a sales order, then you can correct the text on the delivery and so on.

/Joe

Go to forum: Setup

4,577 Reply by joe

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

Just go to tab 'Suppliers' and select ''Allocate Supplier Payments and Credit Notes'. Select your payment and start allocation of the Invoices.
When there are now more left on the Payment you process your allocations. That's it. Then you can print the cheque again and you will see that there are references on the slips of the invoices etc.

/Joe

Go to forum: Modules Add-on's

4,578 Reply by joe

(7 replies, posted in Setup)

Your observation is correct. We have no so called free lines to enter only with a price.
But you can set these services up as, yes, service and there will be no inventory handling on them. You can name the item units in a suitable way. You can always override the prices as you probably already know.

/Joe

Go to forum: Setup

4,579 Reply by joe

(14 replies, posted in Accounts Receivable)

All the customer/supplier transactions have a field for allocations to keep track of the remainder. Even payments can have a remainder for more allocations. This is what the allocation fields are used for. A transaction can all have one or more allocations and there are specific tables to hold the history. The allocation field on the transactions is an accumulator of all this history.

Generally speaking:
For invoices: The allocation field is what has been paid on that invoice.
For credit notes and payments: The allocation field is what has been used of the credit notes or payments for allocations of other invoices.

/Joe

Go to forum: Accounts Receivable

4,580 Reply by joe

(5 replies, posted in Accounts Payable)

You can void the supplier invoice in the Setup tab, Void a Transaction. Then you can start all over again. But remember to setup your taxes and GL accounts before invoicing smile

/Joe

Go to forum: Accounts Payable

4,581 Reply by joe

(1 replies, posted in Items and Inventory)

Hello,
First you set up all you taxes in the Setup tab, Taxes section. Then you combine all the different Tax setup in the Tax Groups section.
Then you go into Item Tax Types and creates some Item Tax Types. Eventually remove some tax exempts (manufacturing or so). In your situation don't mark any exemptions.
Now you can set the Tax Group on your Customer Branches. Chose the right one for the branch. If a customer has different taxes, create a new branch and set another Tax Group on this and so on.

So you see, the Tax Group on the branch overrides the Item Tax Type (if no exemptions).

FA should be flexible enough to handle all situations.

/Joe

Go to forum: Items and Inventory

4,582 Reply by joe

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

I guess you forgot to do some allocation(s) for the payment before printing the cheques.

/Joe

Go to forum: Modules Add-on's

4,583 Reply by joe

(14 replies, posted in Accounts Receivable)

Hello,
When you read a customer/supplier balance, you see the values in either charges or credits column. The right most column (Outstanding) gives you what the customer ows you. The 'Allocated' column is just a mirror of how much of the absulute value that has been allocated.

/Joe

Go to forum: Accounts Receivable

4,584 Reply by joe

(27 replies, posted in Banking and General Ledger)

My advise is when closeing fiscal year you should create an account (the last one of the expense accounts) and call Year End Result (or something like that). After you have done your depreciations and other year end posting you should create an income statement to see the calculated return.
This calculated return value should then be posted in debit on the newly created account and credited Retained Earnings account (counterwards if the calculated return is a loss).
If you later want an income statement for the closed year, the calculated return will be 0, but you will have the year result in the Year End Result account.

/Joe

Go to forum: Banking and General Ledger

4,585 Reply by joe

(3 replies, posted in Setup)

I am not sure if I understand your question right? Did you use the Automatic install process? Have you created a new company? Are the company/0 and company/1 folders writable? Please give some more information.

/Joe

Go to forum: Setup

4,586 Reply by joe

(2 replies, posted in Items and Inventory)

One solution would be to export all the company by company backup.

There is a freeware program called 'Replace'em, I guess it was named. Google the internet. There might be other similar free tools.

Here you can make a list of strings with old strings (item codes) and replacement strings (new item codes). This will only work if there are differences between all the original strings and the new strings. Remember also to use exact match.

Then you can run a replacement of all the values.

When you are ready and the created script looks correct, you can upload and restore the company again.

Because there are key constraints on the item_code in many places it is rather difficult to create a script to handle this.

The procedure above will work and you are sure you get all the values correct.

/Joe
BTW. Remenber to backup your company with another script before you begin, should it go wrong.

Go to forum: Items and Inventory

4,587 Reply by joe

(15 replies, posted in FA Modifications)

The CVS repository for unstable 2.1 is now updated with Bank Reconciliation. I will ask Janusz to upload this to Demo 2.1 unstable.
Here is how it works according to hugerobot:

1. Select the account you want to reconcile.
2. Get your bank statement (from the bank)
3. The first time you reconcile you will need to enter a reconcile date and a start balance... 
   Or 0 for the start balance if it is actually a new account.
4. Enter the end balance from the statement
5. Check entries that match the entries from your bank statement
6. If all entries match, 'Difference' should be 0. If it is, you are done and you 
   have reconciled your account for the period.
7. Click reconcile to record the reconciliation.
8. All checked items are recorded as reconciled in the bank_trans table and the ending balance
   and reconciled date is recorded for that account in the bank_accounts table.
9. The next time you reconcile against a bank statement, the ending balance from the last 
   reconciliation is automatically used as the starting balance for this reconciliation..    
   You enter the ending balance for this reconciliation and repeat steps 5-8

/Joe

Go to forum: FA Modifications

4,588 Reply by joe

(15 replies, posted in FA Modifications)

Yes, I detected that. The beginning and ending balance was not updated into the table bank_accounts.
The file you copied from was from release 2.0.6, therefore I had to change the file a bit. I also eliminated some warnings. But it doesn't matter. This is only minor things, so please resend the file as you have it and I will extract the changes into the 2.1 file.
I think this is nice work, Rob.

/Joe

Go to forum: FA Modifications

4,589 Reply by joe

(15 replies, posted in FA Modifications)

Thank you very much Rob, I will start immediately fixing it into the core source at 2.1 unstable.

/Joe

Go to forum: FA Modifications

4,590 Reply by joe

(15 replies, posted in FA Modifications)

Hello again hugerobot. I like your persistence smile
When you explain this it makes sense.
Please continue with the job you have started, and please try to not do it complicated. We try to use the KISS (keep it simple st....). I guess you know that expression, right? smile. We will then incorporate it in the program core.
We were planning to ship release 2.1 beta next week, but we are willing to wait for this wonderful thing. Do you  think you can have it finished next week? We will not stress you, just curiousity.

/Joe

Go to forum: FA Modifications

4,591 Reply by joe

(3 replies, posted in Wish List)

In release 2.1 you can define Quick Entries for doing this. Look at the demo 2.1 unstable (link on the frontpage).

/Joe

Go to forum: Wish List

4,592 Reply by joe

(1 replies, posted in Wish List)

NO, there are no plans to extend the quick entries at present, but maybe in the future, when 2.1 has been released and tested.

/Joe

Go to forum: Wish List

4,593 Reply by joe

(1 replies, posted in Dimensions)

No, this is not possible. But you can always write a special module that does that. Look on the Download Modules for how to do this.

/Joe

Go to forum: Dimensions

4,594 Reply by joe

(15 replies, posted in FA Modifications)

Your ambition is very much appreciated. I cannot tell you, what is going wrong here, without seeing all the file, but if I understand you right, you want a column in the bank inquiry with checkboxes, to mark the transactions as reconciled, right?
In version 2.1, I think this could be included in the bank inquiry. We will then have to add a field in the bank_trans table, reconciled.
And when users click this column, the transaction should be updated with a mark.
I guess this would be the best way of doing it, right?

/Joe

Go to forum: FA Modifications

4,595 Reply by joe

(12 replies, posted in Accounts Payable)

Hello again,
We have now decided to follow your advice, btsui, and have implemented a period search in release 2.1. Default is 30 days back, but you can extend/change the search period.
The CVS repository for unstable is updated, and Janusz will update the demo 2.1 ASAP so you can see this issue working.
You can still credit the supplier invoices one by one in the supplier transactions. If you know the invoice number this is still more safe to use and you get the allocation done at once.

/Joe

Go to forum: Accounts Payable

4,596 Reply by joe

(5 replies, posted in Dimensions)

By setting the sales account to another sales account in the branch accounts you can follow the sales of this account. But if you want to follow the results (purchase) etc. of a branch you should consider using a dimension instead.
In our next release, 2.1, you can put a dimension on the sales documents (delivery and invoice) and this way you will get the purchase (delivery notes) and the sales (sales invoice) for this dimension as well.
As you know many of the General Ledger reports can be filtered by dimensions, so you get results for your dimensions.

/Joe

Go to forum: Dimensions

4,597 Reply by joe

(12 replies, posted in Accounts Payable)

Oh yes, I understand your issue.
In release 2.1 you will just have to credit the supplier invoices one by one in the supplier transactions. This is very fast and the allocations are done at once too. This is how we have solved this problem if you have too many invoice lines from a supplier when using the normal Supplier Credit Notes, you can just take them one by one in the supplier transactions.

/Joe

Go to forum: Accounts Payable

4,598 Reply by joe

(4 replies, posted in Setup)

You can have as many dimensions as you like, but you can only have a maximum of 2 on the same transaction line. See above for how to use them.

/Joe

Go to forum: Setup

4,599 Reply by joe

(12 replies, posted in Accounts Payable)

This issue has been solved in release 2.1 unstable (not ready for release yet). It has been solved in the same way that on the customer side.
In the customer transactions you have an option to 'Credit This' for all the invoices that are not fully allocated.
The same option has been implemented in supplier transactions.

/Joe
I will ask Janusz to update demo 2.1 with this, so you can see for yourself.

Go to forum: Accounts Payable

4,600 Reply by joe

(12 replies, posted in Accounts Payable)

I understand your problem. At present we have no solution to this. We will, however, have a look into this.

/Joe

Go to forum: Accounts Payable