4,551 Topic by joe

(0 replies, posted in Accounts Receivable)

Dimensions on sales delivery notes, sales invoices and sales credit notes

We now have the option to select a dimension on these documents.
Here is how it works.

If there are 2 levels in company setup, 2 dimension lists are shown with respective types. if 1 level,
only one list and of course if none there is no list shown.

If there are dimension(s) set on a customer these will be set as default in the dimension(s) lists.

If you choose a dimension for your invoice it will overwrite eventually dimension set by item. And the dimension(s)
are saved on the cust_trans table.
To be used when going from delivery to invoice, so there is a match between the 2 links.

These dimension(s) goes to the GL trans. If delivery and there are standard_cost values they will show up on all COGS accounts.

If invoicing the dimensions will go to the SALES accounts, so it is easy to monitor a dimension (project or whatever).

Credit notes goes the other way round. The same procedure but opposite.

Go to forum: Accounts Receivable

4,552 Topic by joe

(31 replies, posted in Accounts Receivable)

Recurrent Invoices

There are two ways of using recurrent invoices. You can either select a group or single customer/branches.

If you are going to use groups, start by creating the groups you want to later put on the branches, Fi. Large, Medium and Small

Go into the branches. If you want any of a custumers branch to belong to a group, mark it and update the branch.

Definition.

You are now ready to make some recurrent invoice definitions, by clicking the 'Recurrent Invoices' in the Sales tab, Maintenance section.

The recurrent invoices uses the Template Orders, that are shown under Template Delivery/Template Invoice.

First enter a Discription of the item. Select the appropriate template. If this should be adressed to a single customer/branch, select a customer and a branch.
If it should be based on a group, set the customer to an empty value and select the group you want to send the recurrent invoices to.

Now it is time to consider the interval of the recurrency. If you select days and set the monthly value to 0, it will be due after every days interval.
If you select a monthly value, it will be sent on a monthly base and if you select a days value it will be due on that day in the month. A value of -1 would be the last day in the previous month. A monthly value of 3 indicated a due every quarter of a year and 12 every year and so on.

The begin date is the date to start the recurrency and end date is the close date of the recurrency.

Create and print the recurrent invoices.

Before creating recurring invoices, check that the price factor in company setup is set. Also check that a sales prices are set in the item sales prices. It must not be zero. If you have foreign customers the price is automatically calculated.
Go to 'Create and Print Recurring Invoices'. The due items are marked and a link 'Create invoices' are there.
Pressing this link creates all the invoices belonging to this group or single customer/branch.
An info line tells you how many invoice-numbers that are created.
There is also a link to Print the Invoices.

That's it. Happy Recurrent Invoicing.

PS. If you need more groups on a customer, create new branches with this different group. Maybe call the branch something similar as the group to easily find it.

Go to forum: Accounts Receivable

4,553 Reply by joe

(7 replies, posted in Accounts Receivable)

In release 2.1 you can put a dimension on the sales document. You can set up a dimension for every shift and let the staff put their staff on the sales document.
This doesn't give you a sales made by a shift particularily, but you can run a P/L report for a single day for a dimension.

/Joe

Go to forum: Accounts Receivable

4,554 Reply by joe

(1 replies, posted in Accounts Receivable)

In release 2.1 you can put a dimension on the sales document. You can set up a dimension for every shift and let the staff put their staff on the sales document.
This doesn't give you a sales made by a shift particularily, but you can run a P/L report for a single day for a dimension.

/Joe

Go to forum: Accounts Receivable

4,555 Reply by joe

(3 replies, posted in FA Modifications)

Hello,
We will prepare for this in 2.1 Beta, so that an inactive field will be available on all master tables, debtor_master, (branch already has one), items, suppliers, accounts, just to mention a few that can have a huge amount of records.
Then we can fix the things during some 2.1.X release.

/Joe

Go to forum: FA Modifications

4,556 Reply by joe

(4 replies, posted in Accounts Payable)

It seems that an auto_increment number in some of the tables is out of sync. Not normal, but.
If you have access to phpMyAdmin on your server, maybe you can look at the next auto_increment number and see if this number is already in use. You should look in the bank_trans table and in the supp_trans table.
Otherwise I have no idea at present.

/Joe

Go to forum: Accounts Payable

4,557 Reply by joe

(3 replies, posted in Wish List)

Well, we will have an internal discussion about that. I can see the idea.

/Joe

Go to forum: Wish List

4,558 Reply by joe

(4 replies, posted in Accounts Payable)

Go into the Bank Account Inquiry and try to find the last bank payment entry. Memorize this number and go back to form setup and have a look again. The next number should be bigger than the one you memorized. I hope you find the problem. Why this has happened? Maybe the number has mistakenly been set back.

/Joe

Go to forum: Accounts Payable

4,559 Reply by joe

(27 replies, posted in Accounts Receivable)

Hello guys,
I understand that you are waiting for this wonderful release smile
We will ship release 2.1 Beta the first week in February on Sourceforge.net, so in 1-2 weeks. We just have to assemble various things.
But expect it do be a little buggy. But most of them have already been taken.

/Joe

Go to forum: Accounts Receivable

4,560 Reply by joe

(3 replies, posted in Wish List)

Would it help if the sales person was selectable from a list on the document (delivere/invoice)?

/Joe

Go to forum: Wish List

4,561 Reply by joe

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

You should start with Purchase order entry and receival. Supplier invoice. Payments to suppliers and finally allocation.
If you don't use the items, you can go directly to supplier invoice and enter GL lines only. Then Payment to suppler and allocation.

/Joe

Go to forum: Modules Add-on's

4,562 Reply by joe

(10 replies, posted in FA Modifications)

The cash invoicing has changed in release 2.1. From 2.1 you simply select cash invoicing in the selector Cash / Delayed in Direct Invoice .
You don't need to set the AR account on the branch to a bank account. Let it be an AR account and the new selector Cash fixes it all.

/Joe

Go to forum: FA Modifications

4,563 Reply by joe

(27 replies, posted in Accounts Receivable)

The cash invoicing has changed in release 2.1. From 2.1 you simply select cash invoicing in the selector Cash / Delayed in Direct Invoice .

/Joe

Go to forum: Accounts Receivable

4,564 Reply by joe

(1 replies, posted in Setup)

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

Go to forum: Setup

4,565 Reply by joe

(10 replies, posted in FA Modifications)

Janusz has a solution to this. He will commit it in a while.

/Joe

Go to forum: FA Modifications

4,566 Reply by joe

(10 replies, posted in FA Modifications)

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

Go to forum: FA Modifications

4,567 Reply by joe

(10 replies, posted in FA Modifications)

I have just tested the cash invoices (with AR set to bank accounts) in customer balances and the debit/credit amount is the same as the allocation and the balance is 0 for these amounts. Was currency involved? It shouldn't really matter. Are you using 2.1 or 2.0.6? The allocation is set immediately when this is a cash invoice/credit note, so this has nothing to do with payments.
This is strange. Tu, can you give me a test scenario?

/Joe

Go to forum: FA Modifications

4,568 Reply by joe

(10 replies, posted in FA Modifications)

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 smile

/Joe

Go to forum: FA Modifications

4,569 Reply by joe

(10 replies, posted in FA Modifications)

I am a little in a hurry just now with other stuff, but if the payment has already been done, then you will need to pay your customer back. But if this is a POS, and you don't want to do that, you can probably use this credit note to allocate future invoices. I hope you understand.
Otherwise we can continue the discussion later.

/Joe

Go to forum: FA Modifications

4,570 Reply by joe

(27 replies, posted in Accounts Receivable)

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

/Joe

Go to forum: Accounts Receivable

4,571 Reply by joe

(7 replies, posted in Setup)

We have plans to ship this end of month, if everything is ok.

/Joe

Go to forum: Setup

4,572 Reply by joe

(10 replies, posted in FA Modifications)

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

Go to forum: FA Modifications

4,573 Reply by joe

(7 replies, posted in Setup)

Hello again,
We have implemented this feature in 2.1 Beta that are going to ship soon. It will work via the edit link when you add a line. Pressing the edit link pops down the line and the description field is editable as well.
This feature is established for all direct sales documents. We have set a limit of 150 characters. It can be increased up to 255 characters if needed.
The document prints are also fixed to handle multiple line descriptions.

Go to forum: Setup

4,574 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,575 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