Search options (Page 182 of 199)

Yes you are right regarding the relationship. On the download page, documentations, there is an item, Entity Relationsship diagram for 2.0. This presents the database with the master relationships. This is a good start to get that. This combined with the database description on the same page would be of good help for you.
We are going to update this ER diagram and database description for the upcoming release 2.1 as soon as possible.

/joe

wait a minute, I guess I understand what you mean. In the customer balance and the aged customer analysis there are no payments to deduct the cash invoices/credit notes. The records show the amounts without allocations. Yes.
I will have a look into that. This is only for the special case of cash invoices with the AR set to a bank account.

/Joe

Hello again. IF THIS WAS A NORMAL INVOICE.
You cannot credit an allocated invoice in Customer Transactions. You must first unallocate it.
Here is how to unallocate an earlier allocated invoice.
Go to Customers tab. Select 'Allocate Customer Payments or Credit Notes. Select the customer.
Mark the box 'Show settled'. Now the payment is shown with a 0 left to allocate.
Press the allocate link. Look up the invoice that have been allocated with this payment.
Press 'None' in the right column. Press Process.
Now the invoice is unallocated again and the payment is restored.
You can now go into Customer Transactions and Credit the Invoice. 

This credit operation will handle the allocations automatically, and you are left with a payment you can return to the customer or use for future allocations of invoices to the customer.

IF THIS WAS A CASH INVOICE WiTH AR set in customer branch to a bank account, the operations is much easier. You don't have to unallocate, but instead you go directly to 'Customer Credit Notes'. Select the customer and the branch with the AR account set to the bank account. Credit the same item and process. The allocation is done immediately, so everything is settled.
If you look at the GL posting, you will see a credit value from the bank account and that is exactly what the customer should have, right?

I hope you can follow these operations

/Joe

Yes, but the allocation is done immediately, so there should be no exchange variances.

/Joe

Hi,
My recommendation is to issue a credit note instead of voiding. You don't have to send it to the customer if he doesn't need it, but keep it locally for your own records. This way you get all the dates correctly. And this is probably also a more correct way of doing it.

Regards
Joe

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

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

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

/Joe

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

/Joe

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

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.

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