Pcm-ERP

From SoftTopia

Contents 1 About PCM ERP 2 Default account 3 OpenOffice document templates 3.1 Variables 3.1.1 Available variables 3.1.1.1 Database variables 3.1.1.1.1 Project Scope 3.1.1.1.2 Delivery Note Scope 3.1.1.1.3 Invoice Scope 3.1.1.1.4 Orders Scope 3.1.1.1.5 Global Scope

[edit] About PCM ERP

[edit] Default account

At first time we launch PCM-ERP we need user and password. By default admin account is: username: admin password:1234 The admin account is always active and it has all the privileges. But you can not use admin user as a normal user. For example you can not enter timesheets as an admin user. You can change the admin password in app main settings.

[edit] OpenOffice document templates

With PCM-ERP you can create openoffice documents with variables that will be replaced automatically. We have to append .soot to our document extension. Since for example: mydoc.odt will be mydoc.odt.soot. Doing this, the program will recognize .soot files as templates, and we are able to generate a document from it replacing all its variables.

[edit] Variables

Variables in documents goes between [% %]. For example: [%testvariable%] Where testvariable is the name of the variable.

For database variables we have to indicate first the table name followed by '.' and the field name. [%project.name%]

If a variable contains more than one value you can indicate variable index like this:
[%project.name%]0
[%project.name%]1
[%project.name%]2
[%project.name%]3
[%project.name%]4


When index exceeds the variable range it will be replaced for an empty value.

We can also put a filter into variable. The code bellow selects the first name from current project timesheets where workers_email='me@myserver.com': [%project_timesheets(workers_email='me@myserver.com').name%]0

[edit] Available variables

[edit] Database variables

[edit] Project Scope

project	project_assemblies	project_assemblies_articles	project_tasks	project_timesheets	project_deliverynotes	project_deliverynotelines
name creationdatetime description duedate name path ref status objective perfomedproduct requisites	description id name projects_ref	name projects_ref id assemblie_description brand description ref size familyname provider_name quantity price	description duedate name priority projects_ref status workers_email	description idtimesheet startdate stopdate workers_email projects_ref typename hours min	comments creationdate number rmcnum vattype workers_name invoicenumber	description price quantity ref

project_invoices	project_invoicelines	project_customer
comments creationdate number vattype	description price quantity ref	address bank ccc city contactname country cp email idcustomers name nif phone01 phone02 state web projects_ref

[edit] Delivery Note Scope

deliverynote_header	deliverynote_lines	deliverynote_customer
comments creationdate number projects_ref rmcnum vattype workers_name paymentforms_name email groups_name name phone01 phone02 type_name	ref description quantity price projects_ref	address bank ccc city state country cp contactname email name nif phone01 phone02 web

[edit] Invoice Scope

invoice_header	invoice_lines	invoice_customer
comments creationdate number projects_ref vattype paymentforms_id paymentforms_name	description price quantity ref deliverynotenum projects_ref	address bank ccc city state country cp contactname email name nif phone01 phone02 web

[edit] Orders Scope

order_header	order_lines	order_provider
comments creationdate number projects_ref paymentforms_id paymentforms_name	description price quantity ref deliverynotenum projects_ref	address bank ccc city state country cp contactname email name nif phone01 phone02 web

[edit] Global Scope

• timesheets
• customers
• articles
• invoices
• deliverynotes