Ayaz Ahmed

Drill-down You can go to more specific information with drill-down feature after running a report.

RECEIVING THE PRODUCTS A receipt of inventory is recorded as a "Material Receipt". DR Product Asset (Current Asset) 100 CR Not Invoiced Receipts (Current Liability) 100 RECEIPT OF THE PURCHASE INVOICE A booking of Invoice (Vendor) is recorded as a “Invoice (Vendor)” DR Inventory Clearing (COGS) 100 DR Tax Due (Current Liability) 17 CR Accounts Payable (Current Liability) 175 MATCHING THE PURCHASE INVOICE Automated document as we book invoice against of material receipt DR Not Invoiced Receipts (Current Liability) 100 CR Inventory Clearing (COGS) 100 PAYMENT AGAINST INVOICE DR Payment Selection 175 CR Check-in-Transfer 175 ALLOCATION Adempiere Automatically Create allocation entry if we have paid against invoice. If paid in advance then we have to allocate invoice manually. DR Accounts Payable 175 CR Payment selection 175

This is closely related to database, it is kind of metadata of the database tables and columns translated to Adempiere “object” notation. Tables Case sensitive If the table has an ID it must be exact case with the table name (i.e. CUST_MyTable – the column id must be named exactly CUST_MyTable_ID) View – to define the table definition as view, views are not synchronized in database You can use it also to make a table read-only Data Access Level – Used for defining the default access for roles Maintain Change Log – when selected all changes to this table are logged in AD_ChangeLog table – it doesn't matter if the role is logged or not Window – define the window to enable zoom functionality. Also you can define a different zoom window for purchase process (PO Window). Records deleteable – to allow/disable deletion of records in database High Volume - indicates if a search screen will display as opposed to a pick list for selecting records from this table. Crea

Check the tables names in windows You need to include all mandatory columns. No need to get names for the _ID columns – Adempiere does it automatically You can create the view on “SQL Process” window Always review the references of the columns in Adempiere

The Window, Tab & Field Window defines the presentation (GUI) of tables and columns within each window. Transaction windows just show items created/updated last 24 hours or pending (user can select to show more with history button) Window Tab Level: Top = 0 (The master), level 1 entries are dependent on level 0, level 2 on level 1, and so on Link Column: The foreign key to link with the parent – it needs to be defined here if the table has more than one parent Tab Field Group: New functionality -> Collapse, Horizontal tab, label New functionality (still beta) -> master/detail Field The Field Tab defines the Fields displayed within a tab. If the Sequence is negative, the record are ordered descending. Note that the name, description and help is automatically synchronized if centrally maintained.

Type Description Account Account Element Amount Number with 4 decimals Assignment Resource Assignment Binary Binary Data Button Command Button - starts a process Color Color element Costs+Prices Costs + Prices (minimum currency precision, but if exists more) Date Date mm/dd/yyyy Date+Time Date with time FileName Local File FilePath Local File Path ID 10 Digit Identifier Image Binary Image Data Integer 10 Digit numeric List Reference List Location (Address) Location/Address Locator (WH) Warehouse Locator Data type Memo Large Text Editor - Character String up to 2000 characters Number Float Number Printer Name Product Attribute Product Attribute Quantity Quantity data type RowID Row ID D