red1.org

[moyses]

Hi Everybody!

I just started working with Compiere 2.51g but and I am facing some problems setting up CashBooks. I think there is a bug or maybe I am just doing something wrong. I apologize for the extension of this post.

For this example I used GardenWorld data.

This is the scenario. On the same Organization (HQ), we have 2 differents stores, both stores supply the products from the same warehouse (HQ Warehouse). Each store should have is own Invoice Serial numbers and in consecuence they should be able to get a separate Cash Journal.

Invoices Serial Number for Store1: 1-12345
Invoices Serial Number for Store2: 2-12345

What I did was to set up to differents CashBooks:

Store1 CashBook
Store2 CashBook

Both CashBooks have HQ organization.

There 2 users:

Mary (Cashier in Store 1)
Barbara (Cashier i Store 2)

Is it possible to indicate in Compiere which Cash Book is used for every user? I mean, I want to be able to Indicate that all of the Mary's POS Sales should be registered in Store1 CashBook and in the same manner all the POS Sales registered by Barbara should go to Store2 CashBook.

So that at the end of the day both can easily verified the sales from that specific day.

I did not found such feature in Compiere.

The manual just indicates that you can change the CashBook used to register the CashJournal movement.

You can make a test:
Create a POS, include some products, select cash as payment rule, click complete. OK now click once again "Cash" button now you can select a different Cash Book (Store1 CashBook). After selecting a different one click ok.

Now go to CashJournal Window, and check the HQ CashJournal for today notice that there are three movements from the same sale
1.- The one created originally when you click complete.
2.- The second is in negative numbers (this was created when you selected a different CashBook).
3.- The third one is incorrect. This entry should go to the Store1 CashBook, but obviously is not.

In conclusion: Should I create a different organization for every store?
If I do this What about the shared Warehouse? Any other workaround for this problem?

Any suggestion would be welcome, thank you very much for your patience. Best Regards

Moisés Quezada
Mexico

[lofx]

Hi!!!

i suggest you try the following;

setup pos profiles, indicating for each user which pos profile would be using and assigning each profile a different cashbook..................
this should do..................(i don not remember the exact name of the window, but it

if not, let me know so that i research a little bit further in this question

hope this helps...............

[moyses]

Hi lofx!

Thank you very much for your suggestion.

I did exactly what you mention. But with no success.

I went to set up POS profiles, tryed to use the POS terminal but was not able to complete an order.

Then I tryed in the Sales Order window but without success.

Once again I appreciate your help.


Best Regards

[lofx]

oh my god!!!!

i am so sorry, i forgot that the pos was not actually working in Compiere, and sales order window currently supports only default cashbook, as far as i know...............

you would need to develop your own custom module or think about using different orgs for each store.

i can provide help here and then for the module, but i warn you it would be hard work....................

sorry....................

[red1]

Meanwhile try investigating different bank accounts, or Cash journals instead of Cash Books..> hmm, what does the User Manual says?...

[moyses]

Thank you very much for all your replys. Lofx and red1 I appreciate a lot your support.

Red1 I read the manual It says something about that you have to change manually every POS transaction in order to select a different Cashbook. But is not working properly. Besides that the clerk will kill me (hehe) if she had to do that all day long.!

I guess I will have to create my own module (growing pains is the name for this forum right??? ) well, that's my second task todo. The first one will be to create the accounting catalog for Mexico.

I have been reading about the skills needed to add functionality to Compiere. Please correct me if I am wrong:

PL/SQL
Java
PATIENCE <---- In huges quantities!

By the way I attended Compiere Advanced Training but... let's make it short, It was not what I was expecting for (the material was a poor set of power point slides). This is where compilo is invaluable!

Any recommended pointer (www prefered) to start learning those skills?

My background? Bachelor Degree in Finance and Accounting, MBA, and IT passionate.

Best Regards

[lofx]

hi moyses!!!!

Red1 and I have been playing with the codes and elements of the app for some time, and basically what you need is patience.

if you are going to develop something for the pos you should take a look at what compiere already has under pos files and data.

basically, compiere pos is working except for the checkout panel to complete the orders and so on. We still haven't had the time to really develop it, but we a fair idea of how to, so you can start messing around with it, make some good questions, and together maybe we will be able to finish it.
All you have to do is load the module here, you will get all the credit and we will all have something to offer to the Open Source community.
that, or waiting until we get the REAL need to use that pos, but there are thousands of things to do first....................

regards,

[red1]

Hi Moyses,
Its nice to hear that u re interested.

1) U dont have to do redundant things such as setting the CashBook. It can be easily done with a simple default setting either in the Table-Column field or a Validation lookup. Or worse case, a short java code in a callout. I will try to look into your Cashbook story later and tell u exactly how. But since u like to learn, this is a good chance. Cmon, give it a try and be stubborn in not giving up till u succeed. I used to solve problems about 4am in the morning.

2) To learn Java, its practice and makng mistakes. Your passion will help u a long way.

3) Your Finance background will be superb. I luv to help u if u can promise to help with the subject matter here together with Lofx.

have a nice day
red1

[moyses]

Hi Red 1!

I am in the process to learn all this Compiere staff trying to disturb not so often to other users. I expect to past this first phase where I don't understand almost nothing

Right now I am trying to understand the whole Compiere Functionality using my previous experience with similars ERPs.

Up to this moment I have found it somewhat complicated, and not so flexible as an example consider the few different paper sizes that compiere has per default.

Ok, ok if you have the knowledge to program in Java and PL/SQL you can do anything you want with it. But for us "normal guys" is not that easy.

Anyway I already have started the project to change the current ERP system that our Company is using to Compiere. Hopefully I will do it.

Of course I expect to be able to help others. Thank you very much for your great help and work that you do on this forum!

Hopefully my english will improve in the process.

[red1]

Hi Moyses,
You and other beginners are very welcome.

My tutorials are designed particularly for non-programemrs in mind. Such as for changing paper sizes or media, that is touched in the Callout.zip tutorial in http://compiere.red1.org/

But i m particularly delighted to hear that u have ERP background, and your frank opinions are also welcome as they can give insights to every1 to improve the system.

Looking forward to more exchanges, and hopefully we all grow to make the world a more productive and learning place.

red1

[trifon]

Hi Moyses,
I made small fix, which I'm willing to contribute to the community.
I hope that it will work, I have tested it, but who knows. The fix is sent to red1, so he will publish it on red1.org soon.

Best regards
_________________
Trifon Trifonov

[red1]

Hi Trifon,
Try posting your note u sent me at the Bug's Galore

I will link your attachments there too.

I hope enthusiasts such as LOFX can test it right away and tell us if its ok. From what i see of the codes it looks like u have a knack of sharing

Later when this is proven, we can search the bugs section of sourceforge to confirm if there is such a bug, and Trifon can do the honour of making known his bugfix there

bravo!
red1