Assetsmanagement/Advanced Asset Management/Special Documents

Several documents must be posted in the ERP:

1. Manual Depreciation
2. Special Depreciation
3. Appreciation
4. Storno Depreciation

This documents will be added through a separate module, that will have a dependency on Advanced Assets module. The DB Prefix will be AAMSD, and the name Advanced Assets Special Documents Just one dependency created to Advanced Assets module.

DB Elements

One New table is required: Name: AAMSD_SpecialDocuments Columns:

• AD_CLIENT_ID (as usual)
• AD_ORG_ID (as usual)
• CREATED (as usual)
• CREATEDBY (as usual)
• UPDATED (as usual)
• UPDATEDBY (as usual)
• AAM_ASSETCARD_ID (foreign key and same definition than AAM_ASSETCARD.AAM_ASSETCARD_ID)
• AAM_ASSET_NO (foreign key and same definition than AAM_ASSET.AAM_ASSETNO)
• AAM_INVENTORY_NO (foreign key and same definition than AAM_ASSET.AAM_INVENTORYNO)
• ASSET_NAME (char(255))
• ASSET_ACCOUNT (foreign key and same definition than C_VALIDCOMBINATION.C_VALIDCOMBINATION_ID)
• DESCRIPTION (char(512))
• AMOUNT (Number)
• C_DOCTYPE_ID (foreign key and same definition than C_DOCTYPE.C_DOCTYPE_ID)
• ACCT_DATE (Date)
• TRX_DATE (Date)

(You can see an example of the next elements in the table GL_Journal)

• DocAction (Button - new process to process the document)
• DocStatus (List - All document status)
• Posted (Button - All posted status)
• Processing (Button)
• Processed (YesNo)

AD Elements

In the path Advanced Assets || Transactions || Assets Movements, a new window has to be created. This window will be used to process and post the special documents. The content of this window is:

• Client - TableDir
• Organization - TableDir
• Asset Number - Textbox (255)
• Asset Name - Textbox (255)
• Asset Account - Search (Account)
• Inventory Number - Textbox (255)
• Text/Description - Textbox (512)
• Movement Amount - Number
• Document Type - Reference List = Manual Depreciation / Special Depreciation / Storno Depreciation / Appreciation
• Booking Date - Date
• Document Date - Date

(You can see an example of the next elements in the table GL_Journal)

• DocAction (Button - new process to process the document)
• DocStatus (List - All document status)
• Posted (Button - All posted status)
• Processing (Button)
• Processed (YesNo)

In the G/L Categories (Financial Management || Accounting || Setup || G/L Category || G/L Category ), a new one must be added:

• Name: Advanced Assets Special Documents
• Category Type: Document

For each of the new document to be created, all this elements must be created:

• New Sequence Number (Financial Management || Accounting || Setup || Document Sequence || Sequence):
  • Name: Name of the document (Manual Depreciation, Appreciation, ...)
  • Description: Same as name
  • Active = 'Y'
  • Auto Numbering = 'Y'
  • Used for record id ='N'
  • Increment By 1
  • Next Assigned Number = 1000000
  • Prefix and Suffix -> Empty
• New Document Category (Reference List C_DocType DocBaseType)
  • Search Key (Name): AAMSD_ST (Storno Depreciation), AAMSD_MD (Manual Depreciation), AAMSD_AP (Appreciation), AAMSD_SD (Special Depreciation)
• New Document Type (Financial Management || Accounting || Setup || Document Type || Document Definition )
  • Sales Transaction: 'N'
  • G/L Category: Special Documents
  • Document Category, Table and Sequence: the one created for that document
  • Rest of values: as set by default when creating a new record in the window.

Posting

Taking as an example the DocGLJournal.java, a new Posting servlet will be created implementing the logic specified in the functional document.