Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
minimum bank account setup, help please
03-10-2017, 04:19 AM (This post was last modified: 03-11-2017 03:18 PM by dalescott.)
Post: #1
minimum bank account setup, help please
Hi, can anyone please explain the absolute minimum bank account configuration required in order to pay a PO?

I think I might lose my mind before I figure out what I'm doing wrong. I'm trying to demo how webERP could be used within an engineering department for product lifecycle management (creating and managing internal part numbers including purchase information, and access drawings and other documents in the knowledge base), as well as *basic* purchasing and manufacturing. However, webERP will NOT be used to run the company, the exiting system (likely QuickBooks) will be used for the actual financials. The engineering department team will do most of their purchasing for prototype builds using an engineering department credit card, which is settled monthly following the employee expense report process.

The engineering department will use webERP to manage internal part numbers (and associated vendor and OEM part numbers), create BOMs and manage building prototypes. They will use webERP to generate an order list for the parts needed to build a prototype based on a BOM, track stock on hand and on order, and generate a pick list for the prototype build (removing the parts from stock). Production manufacturing will be done by a third-party contract manufacturer, and only part numbers for finished goods will be created in the company financial system (i.e. QuickBooks).

The first part (parts/items, BOMs, purchase data, and the Knowledge Base) was easy, and so was issuing a PO, receiving goods against the PO and creating a vendor invoice, but I can't for the life of me figure out what's wrong with my bank accounts. I've tried comparing my configuration with both the build-in demo company as well as the demo on weberp.org, but I don't see anything that stands out.

Please see the screenshots in a a work-in-progress blog post.

Many thanks in advance!
Dale

http://www.dalescott.net
Visit this user's website Find all posts by this user
Quote this message in a reply
03-10-2017, 04:35 AM
Post: #2
RE: minimum bank account setup, help please
First question would be are you sure you have the authorisation to use the bank account?

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
03-10-2017, 08:33 AM
Post: #3
RE: minimum bank account setup, help please
Nice documentation for purchasing cycle :-) I'll link this in the wiki if I may?

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
03-10-2017, 06:14 PM (This post was last modified: 03-11-2017 03:19 PM by dalescott.)
Post: #4
RE: minimum bank account setup, help please
@Tim, I'm not sure what you mean. My login has role System Administrator, which I first thought would be enough to do anything but I did have to separately add PO authorization ($10K), nothing else though. Where do I configure access to the bank account? Fwiw, I used the default chart of accounts, but I'm not sure if I setup the accounts correctly in the company preferences (I tried to be consistent with the demo and manual, but confess I didn't really know what I was doing).

@Phil, I'm glad you liked the tutorial. I want to finish the purchasing post, then go back to the PLM post and add an ECO process, and finally a new post showing how to purchase from a BOM (and create swim-lane process charts for the activities, just like SAP docs ;-)). You're welcome to link to the posts from the wiki. Would you prefer to have the content actually in the wiki? I would be happy to send you a copy of the content (text and screenshots), then you're not dependent on my blog.

Fyi, the next post (after completing everything already started) will be on manufacturing, then I'd like to get back to figuring out a process for project management.

Thanks for your help, I really appreciate it.

Cheers,
Dale

http://www.dalescott.net
Visit this user's website Find all posts by this user
Quote this message in a reply
03-10-2017, 06:50 PM
Post: #5
RE: minimum bank account setup, help please
Dale, under the general ledger / maintenance menu there is an option for "Bank Account Authorised Users". Use this to add authorisation for your user on that bank account.

Thanks
Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
03-11-2017, 01:19 AM (This post was last modified: 03-11-2017 01:30 AM by dalescott.)
Post: #6
RE: minimum bank account setup, help please
Woo hoo! I added authorization for myself to all the bank accounts. Thanks Tim. Back to finishing the post....

By the way, I accidentally first tried accessing Main > General Ledger > Maintenance > GL Account Authorised Users, and get this error: "The security settings on your account do not permit you to access this function". I also tried using the "admin" user (that was created during install) and get the same error. Is this correct?

Thanks,
Dale

http://www.dalescott.net
Visit this user's website Find all posts by this user
Quote this message in a reply
03-11-2017, 01:47 AM
Post: #7
RE: minimum bank account setup, help please
For some reason the security settings for that script haven't been setup for your installation. Try the following SQL:

INSERT INTO `scripts` VALUES ('BankAccountUsers.php',15,'Maintains table bankaccountusers (Authorized users to work with a bank account in webERP)');

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
03-11-2017, 10:48 AM
Post: #8
RE: minimum bank account setup, help please
Yes - might be better in the manual itself if you could email me the html and screen shots.
Thanks

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
03-11-2017, 12:18 PM (This post was last modified: 03-11-2017 03:17 PM by dalescott.)
Post: #9
RE: minimum bank account setup, help please
Hi Tim, I'm not sure that's the problem. I looked at the scripts table and it already seems to already have an entry for BankAccountUsers.php (with pagesecurity = 15).

Is it possible I didn't perform some configuration step? Is there a general process you would recommend to start debugging? More pragmatically, is it likely I will need to access Main > General Ledger > Maintenance > GL Account Authorised Users for what I'm doing now?

[Image: hDpqQLv.png]

@phil, where would you put the content from blog posts in the manual? (existing section? new section?) Is the manual developed in the project together with the code? Could I do the work and submit a patch? I would still want direction for where to put the content, but I'd be interested in working through the submit process.

Cheers,
Dale

http://www.dalescott.net
Visit this user's website Find all posts by this user
Quote this message in a reply
03-12-2017, 07:48 AM
Post: #10
RE: minimum bank account setup, help please
Yes the manual is in the SVN repository with the code.
I'd just stick it in the relevant section. If you could build into the existing html scripts that would be exceptional!
See
webERP/doc/Manual/PurchaseOrdering,html
webERP/doc/Manual/AccountsPayable,html
or possibly a new script PurchasingWalkThrough.html
that is linked within these two above might be better to keep it as it is.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)