ADEMPIERE 392 BOM with costs per elements in BOM

DEMO :
https://www.youtube.com/watch?v=DDu-gqUgwf4



Set up the organization, warehouses, cashbooks,  assets, products (as preventive maintenance with BOM: spare parts oil, filters, types of equipment - as products)
define plants resources and tools and step by step all operations for workflows
with setup times and duration times

Its most important to put products into warehouses/locations storages, using
purchase order, invoices and automatically material receipt form invoices

and invoice is generated automatically for servis- business partners vendor

and material receipt cn be created automaticaly

and finally costs for bom for preventive maintenance service for every 30000 km

ADempiere libero manufacturing give more reports and information for
final users: (using java GUI (applet) on the desktop I was creating more reports

Plans fro MRP (Material requirement planning setup with process Calculate Low level, Create record MRP, regenerative Material plan, Net changes Material Plan and selective material plans and MRP info with MRP information) and CRP (capacity resource planning setup) DRP distribution resource planning setup) and resource loading for one resource(auto mechanic - defined in set up above)

APEX 19.1 remove and install APEX 19.2 on oracle 18 c XE database

its need to log in sys/pass@localhost:1521/xepdb22 as sysdba
from folder where is apex 19.1 install - in my examples /home/oracle/apex
and @apxremove.sql is needed to be executed
When uninstallation of apex 19.2 is completed, I removed apex 19.1 and unzip 19.2 and again connect to oracle database ad sqlplus sys/pass@localhost:1521/xepdb22 and run @apexins sysaux sysaux temp /i/ (I was copy paste folder images from 19.2 to home/oracle and I have renamed this images to only i

Then I was connect again to oracle as sys and run @apex_epg_config /home/oracle
and finally @apxchpwd

All databases schema was in databases, but all workspaces is removed, so its need to create it again and instal exported applications before re-installations from 19.1 to 19.2

ghant cart in apex 4 (implementation ADempiere 342 for spare parts importing and set up virtuemart as web stores)

fig 1 browser need flash install (best chrome)

Fig 2 tabular form as a good option for collect data


try demo:
demo

ADempiere 392 swing GUI
ADempiere scenario:
sales order (quotation) -  convert open proposal(or Quotation) to order-schipments- generate invoices-accounting informations

 Fig 1 GardenAdmin/GardenAdmin

Fig 2 Sales order

Fig 3 New sales order

Fig 4 Sales order line

Fig 5 Sales order status set to PREPARE

Fig 6 Sales order looks

Fig 7 Quote  Convert sales order to standard order

Fig 8 Quote convert completed

 Fig 9 set status

Fig 10 conversion completed

 Fig 11 Create shipments from orders and create invoice from shipments with account posting in general ledger (generate schipmentas process exist in earlier version ADempiere 342s/360/370 as indepentent process/icons)

Fig 12 Shipment (customer) older process is replaced with this one

Fig 13 Generate invoice

Fig 14 Generate invoice (quotation is from 8 10 2019 with date promised 9 10, sales order converted from quotation is 10 10 2019, shipment is from 13 10 2019 and invoice is from 13 10 2019 )

Fig 15 Posted accounting

ADempiere scenario:
sales order (quotation) -  convert open proposal(or Quotation) to order-schipments- generate invoices-accounting informations

Adempiere 391:

Fig 1 Show steps how to create sales order with ADempiere 391, target document set to quotations

Fig 2: When select warehouses, business partner, its need select products from all products and click SAVE button and its important that document status will be PREPARE (in process)

Fig 3 Starting quote process and select sales order with desireded number shown im select lists, and open againgselected sales order to change document to completed

 Fig 4 created order with status COMPLETED

ADempeire 342s:

 scenario as above:
sales order (quotation) -  convert open proposal(or Quotation) to order-schipments- generate invoices-accounting informations

Fig 5 creating sales order and set up quotations

Fig 6 select products (sales order lines)

Fig 7 dont exist in select lists created sales order quotations (process exist but dont work) its need creating kalendar period (last is from 2008 year)

Fig 8 roles and configurations are the same as in ADempiere 391. There is another differences, its more one process CREATING SHIPMENTS exist in ADempiere 342/360/370 but in ADempiere 391 is automaticaly creating invoices

Fig 9 set up kalendar

Fig 10 quote convert can convert quote to standard order

Fig 11 Shipment can be created too

Fig 12 invoice

Fig 21 printing pdf invoice

Fig 22 account posted

ADempiere392 sales order shipment invoice customers payment

ADempiere392 sales order-shipment -invoice customers -payment
workflows

detail steps:

 Fig 1 As log in GardenAdmin/GardenAdmin ist simple demonstration how to build sales order to cash proces in ADempiere version 391  Selected tab sales order

Fig 2  As log in GardenAdmin/GardenAdmin ist simple demonstration how to build sales order to cash proces in ADempiere version 391  Selected tab invoice customers

Fig 2 Shipment customers

Selected tab PAyment Fig 3

select orders

completed

ADempeire 391 zk web client

Its interesting, when is comparation with older version of ADempiere, in version ADempiere 342 its posible creating sales order, but shipment customers give error as folows

select table_name, constraint_name, status, owner
from all_constraints where owner='ADEMPIERE342'
AND CONSTRAINT_NAME='MSHIPPER_MINOUT'

give

TABLE_NAME	CONSTRAINT_NAME	STATUS	OWNER
M_INOUT	MSHIPPER_MINOUT	ENABLED

to jump the constraint error I have disabled key
alter table "M_INOUT" disable constraint
"MSHIPPER_MINOUT"
and next

CCAMPAIGN_MINOUT
 alter table "M_INOUT" disable constraint
"MSHIPPER_MINOUT"
/ 



alter table "M_INOUT" disable constraint
"CCAMPAIGN_MINOUT"
/ 


alter table "M_INOUT" disable constraint
"CACTIVITY_MINOUT"
/ 


alter table "M_INOUT" disable constraint
"CELEMENTVALUEUSER2_MINOUT"
/ 




alter table "M_INOUT" disable constraint
"CELEMENTVALUEUSER1_MINOUT"
/ 


CACTIVITY_MINOUT
CELEMENTVALUEUSER2_MINOUT
CELEMENTVALUEUSER1_MINOUT


and finaly working :)
(old perfect ADempiere 342 version is very simple ERP systems 
with no complexity relations as ADempiere 392 and very good for beginners)

next problem is invoice and payment too, but this is solved in ADempiere 360/370/380/390 ...