VA Upgrade 4 (VIS_)

1. Added two fields Product Group and Product Consideration On Inventory Revaluation Header.

2. Added Product Group field on Product Category Header 

Inventory Revaluation Window

1. Revalue Accounting Schema Tab added on Inventory Revaluation Window. 

2. Added few fields on Revaluation line window. 

1. Window – Matched Invoices 

Tab – Matched Invoice

Created new column as "QueueQty" and "ConsumedQty" 

2. Window – Costing Info 

Tab – Cost Detail 

Created new column as "InvoiceQty"   

1. Window – Product 

Tab – Product Header 

Created new column as "IsFOCItem" 

1. Created Inventory Revaluation Window with Inventory Revaluation  and Revaluation Line Tab  

2. Created LOV IR for Movement Type and Revaluation Line Field  In Transactions Tab of Product Window

1. Window – Physical Inventory 

Tab – Inventory Line 

Created new column with name as "PriceCost" 

2. Window – Production 

Tab – production Line 

Created new column as "IsCostCalculated",

“IsReservedCostCalculated“

3. Scripts for hide Process from the Menu - Rectify Posted

Records 

Asset Window >Asset Tab

1. Created Actual In-Service Date field. 

2. Added Default logic on In-Service Date field.

1. Script for Job Auto Run Config - change Tenant from System to IdeasIncAdmin for "Imported data Completion" and "Costing calculation"  record. 

2. Window - Accounting Schema  
make the display false whose prefix starts with "VACTWZ" 

1. Window -  AP Invoice  

Tab - Invoice Line 

Field- Ref_InvoiceOrg_ID, Ref_InvoiceLineOrg_ID,

TotalCOGSAdjustment, TotalInventoryAdjustment

2. Window – Product Costs

Tab – Cost Queue Transaction
Field – C_InvoiceLine_ID 

1. Add new field "WhereClause" on AD_Tree window. 

2. Added new field "Cash Book" on Organization Unit window. 

1. Added new parameter "To Date" on Imported Report Completion Process. 

1. Added new windows "Survey" and "Survey Response" to display Questionnaire/Checklist on windows. 

2. Partner Relation Window:  

Display: Pay-From Address, Remit-To Address 

1. Added display logic on" Region" tab "Country" window. 

2. Marked "Country Has Region" for Malaysia Country. 

3. Added  14 regions for Malaysia. 

4. Window: Business Partner 

Tab: Customer 

a. Marked the tab as read-only and set tab level. 

1. Created new field "IsCostError" and "CostError Detail" on respective table  

M_ProductionLine , C_InvoiceLine, M_Movementline, M_InventoryLine, M_InoutLine 

2. On product Window -> Transaction Tab 

Created new field as "M_CostElement_ID", "CostingLevel", "ProductApproxCost", "Product Cost" 

3. Product Costs Window -> cost Element Detail Tab 

Created new field as "movement date" 

4. Created new field as "movement date" 

M_InoutLineMA, M_InventoryLineMA, M_MovementLineMA , M_ProductionLineMA 

5. Created new field as "M_TranscationTo_id" on M_MovementLineMA   

1. Window: Purchase Order  

Tab: Order Line 

Created new field as PricePerUnit (Virtual Column) which will show the price of the product per Unit (Base UOM) 

1. Product Costs Window 

Tab – Cost Queue 

Column – Created new column as MovementDate. 

1. Change Validation on "Cash Line Transaction" on Cash Line.  

(Previously, after selection of Cash Line Transaction, selected record was not showing in list) 

2.On Cash Journal, Increase length of "Document No" from 10 to 30. 

3. Customer master : Set Tab level on all tabs. 

4. AP Invoice: Zoom window was not set on "Vendor Contact field", it lead to User window on Zoom. Now, it will zoom to Vendor Master window. 

5. On Customer Return: Once Customer RMA is selected, the Business Partner field should be read only so that the user cannot change the Business Partner.

6. On Customer Return: Once Customer RMA is selected, the Business Partner field should be read only so that the user cannot change the Business Partner.

1. Table: AD_Client 

Column: PLClosing (This Column is used to specify the Profit & Loss Closing will be applicable based on Legal entity organization or Individual Organization). 

2. Changed validation on below column 

Table: C_ProfitLoss 

Column: AD_Org_ID 

Validation: PLClosing (It will display Organizations based on Profit  & Loss Closing setting selected on Tenant)

1. Table:  R_RequestAction 

Add new column:  Result 

2. Table: C_Payment 

Column: AD_OrgTrx_ID 

Validation: Applied Org Unit validation on below column 

(AD_Org Trx Org Units) 

1. Add New Column in Table – C_Country 

New Column added – AD_Image_ID 

1. Window – Bank Statement

Tab – Bank Statement Line

Column-

a) TrxAmt (Applied Callout Code)

b) C_Tax_ID (Applied Validation – filter tax based on

Organization) 

2. Window : Requisition 

Tab: Requisition Line 

Table: M_RequisitionLine 

Column: 

a) QtyReserved: Added new column to maintain

Ordered Qty for Requisition. 

3. Table: C_AllocationHdr 

Mark Records  Deleteable as false 

1. Mark "Display Identifier" as True for reference key - AD_Org (Trx) 

2. Update DB Scripts "orderdiscount" for PostgreSQL 

3. DB script to apply unique constraint on M_SerialNoCtl (Name and AD_Client_ID) 

Window : Requisition 

Tab: Requisition  

Table: M_Requisition 

Column: 

1. AD_OrgTrx_ID: correct validation typecast for "legal Entity Org" column (on PostgreSQL link data was not displaying under the transaction organization field due to typecasting issue)

1. Window: Cash Journal , Tab : Cash Line 

Table C_CashLine 

Column:  

C_Invoice: Bind Validation (Do not show hold payment Invoices)

2. Window : AP Invoice , AR Invoice  

Tab: Invoice 

Field 

Representitive: correct spelling Representative 

Apply Discount: Correct comment and description 

3. In Case of R-Activate SO, If Invoice is not generated, User can change the Unit Price/Price Entered and List Price. But if invoice is raised then it should not allow to change the price. 

4. In Case Asset is selected on Invoice Line, Product and Charge field should be read only. 

5. Done change in description for Re-Activate List reference in DocAction. 

6. Added Data validation on SalesRep_ID under C_Invoice to show Active users. 

1. Window : Payment  

Tab:  Payment

Table : C_Payment 

a) Mark payment Amount and Payment amount after withholding as Read Only when Provisional Invoice reference is selected 

b) On Provisional Invoice, apply validation as Paid Provisional Invoice not to be shown 

Tab : Pay Allocate 

Read Only Logic : Provisional Invoice = 0 

2. Window : Provisional Invoice 

Tab : Provisional Invoice 

Field : C_ConversionType_ID – make it mandatory UI 

Above DB changes supported to VIENNA Advantage Framework_4.8.5.0 

Provisional Invoice Enhancement 

1. Created New Window with the name as "Provisional Invoice" 

2. Window : AP Invoice 

Header – C_ProvisionalInvoice_ID 

Line – C_ProvisionalLine_ID 

1. Window : Matched Invoice

Created new columns for handling Provisional Invoice 

AvailableStock,InvoicedAmount, ProvisionalInvPrice, CurrenctCostPrice, POPrice, IsSOTrx, IsReturnTrx, PriceDifferencePIPO, PriceDifferenceAPPI, PriceDifferenceAPPO, C_ProvisionalInvoiceLine_ID 

2. Window : Match Purchase Order 

Created new columns for handling Provisional Invoice 

AvailableStock, CurrenctCostPrice, POPrice, PriceDifference, IsSOTrx, IsReturnTrx 

3. Window : Payment>> Tab: Payment>> Table: C_Payment 

a) Create new column as "C_ProvisionalInvoice_ID" which will be read only when Invoice / Order / Charge / any entry available on Allocate tab 

b) Apply Read Only logic on respective column which will display when Provisional Invoice not selected on Payment C_invoice_ID , C_Order_ID, C_Charge_ID 

4. Window : Inventory Use  

5. Tab:  Inventory Line  

6. Table : M_InventoryLine 

7. New Columns/Fields added(Trx Organisation) 

Window : Invoice (Vendor) 

Invoice-Line – make Updatable as True for C_Tax_ID 

1. Window : Balance Aggregation 

1) Applied validation on Tenant and Organization 

2) Marked Tenant as read-only 

3) Description Mandatory UI 

2. Window : Invoice (Vendor) 

Invoice / Invoice-Line – Create new field as "Warehouse" which will be displayed when Treat as discount to be true on selected Document Type. 

1. Window:Team Forecast>> Tab:Forecast >>Table:C_Forecast: 

New Columns/Fields added(Trx Organisation,Activity,Campaign,Project,User List 1,User List 2)

2. Window: Master Forecast>> Tab:Forecast >>Table:C_MasterForecast: 

New Columns/Fields added(Trx Organisation,Activity,Campaign,Project,User List 1,User List 2) 

3. Window :Tax Exemption Reason >> Tab: Tax Exemption Reason >> Table: C_TaxExemptReason  

Felds/Columns : New Columns Added(Name,value,IsDefault,Description)   

4. Window : SalesOrder >> Tab: Orderline >> Table: C_OrderLine  

Fields/Columns :

1) New coulumns Added(IsTaxExempt,Tax Exemption

Reason)

2) 2)Tax Exemption Reason : Display logic Applied 

5. Window : SalesQuatation >> Tab: >>Quatation Line >> Table: C_OrderLine 

Fields/Columns :

1)New Columns Added(IsTaxExempt,Tax Exemption

Reason)

2)Tax Exemption Reason : Display logic Applied 

6. Window : purchase order >> Tab: >>PO Line >> Table: C_OrderLine 

Fields/Columns :

1)New Column Added(IsTaxExempt,Tax Exemption

Reason)

2) 2)Tax Exemption Reason : Display logic Applied 

7. Window : AR Invoice >> Tab: >>Quatation Line >> Table: C_InvoiceLine 

Fields/Columns :

1)New Column Added(IsTaxExempt,Tax Exemption

Reason)

2) 2)Tax Exemption Reason : Display logic Applied  

8. Window : AP Invoice >> Tab: >>Quatation Line >> Table: C_InvoiceLine 

Fields/Columns :

1)New Column Added(IsTaxExempt,Tax Exemption

Reason)

2)Tax Exemption Reason : Display logic Applied 

9. Window : Tax Rate >> Tab: >>Tax >> Table: C_Tax 

Fields/Columns :

1)New Column Added(Tax Exemption Reason) 

2)Tax Exemption Reason :  Data validation applied

3)Tax Exemption Reason : Display logic Applied 

1.Window : Prospect >> Tab: User  

Felds/Columns : Added Full Name and Last Name fields and Rename "First Name"  

2. Window : Lead >> Tab: Lead  

Fields/Columns : First Name and LastName : Added callouts 

3. Window : Lead >> Tab: User  

Fields/Columns : Full Name : Added virtual column 

4. Window : Service Contract>> Tab: contract 

Felds/Columns : Set Mandatory UI  True To "Bill_Locaton_ID"  Column 

Invoice Info 

1) Apply Inner Join with Invoice Schedule for picking data, because system generated one schedule at least into system. 

2) Deactivate Open Balance Column from the Info Window, because Schedule amount itself as Open Amount. 

3) Rename Grand Total with Schedule Amount 

4) Change the SQL Condition for Schedule Amount / Converted Amount. 

5) Showed Hold Payment Checkbox into Grid from Invoice Schedule 

6) Rename Paid checkbox as Invoice Paid 

1. Window - Cash Journal window 

Tab - Cash Journal line 

Field – Transfer Type -- Change validation (record was not filtering record based on Payment Type) 

1. Remove the Callout "AmountCurrencyType" from Payment window on column  

a) C_BPartner_ID 

b) AsOnDate

c) C_Invoice_ID 

d) C_Order_ID 

2. Create new column on GL Journal as "ConditionalFlag" for optimization 

3. Handled case of copy record on Production window. 

4. Added new Fields IsOverrideAutoCheck on Payment tab of Payment window 

5. Added new Fields Charge and UOM on Requisition line tab of Purchase order 

6. Added callout on Charge field on Requisition Line. 

7. Added new Field Round off Line Tax Amount on Client Window. 

Added Tab level for Blanket PO and Blanket SO windows. 

On Accounting Fact Details Report , Organization Parameter added validation to exclude Organization Units. 

1. Changed Validation on From Container and To Container column on Movement Line. 

2. Added new field Entity Type on Currency window. 

1. Added new Field "Re-activation" on Profit & Loss Window 

2. Quick Search Change : Budget_Opportunity : Add Info Column Planned Amt and Hide column Total Amt 

3. Make C_ConversionType_ID column as Read Only – updated script for this on for Bank Statement Line Tab on Banking Journal Window 

Window : Organization Unit 

a) Tab : Organization Units Info (Make the "Insert"

checkbox as false)

Window : Bank >> Tab: Bank Account >> Table: C_BankAccount 

a) Write DB script to Update Validation  at AD_Org_ID

Column

Window : Payment >> Allocate Tab  

  a) Applied Display Logic on Allocate Tab on Payment

Window

1. Window: Accounting Fact detail --> Table : Fact_Acct

create new column as  

a) AD_Window_ID (screen) 

1.Window : Bank >> Tab: Account >>Table: C_BankAccount 
Create new validation BankAccount_Organization and bind it on AD_Org_ID column 

2.Table: C_Order/C_Invoice 

Create new Column as "ConditionalFlag" which will be used to bypass constraints whenever required based on LOV value 

- DB Changes for Team Forecast/ Master Forecast 

Banking Journal Changes 

-Set Displayed false for  ''Bank Match Statement'' button field to hide the field from the Banking Journal window. 

- Currency Rate Type editable for All transaction – read Only logic. 

- Account Date will be Read only for every transaction – Removed read Only logic. 

Table : GL_Journal  

Column  

- GL_Budget_ID: Apply mandatory logic when posting type is Budget then it become mandatory 

1.Added script for function currencyrate() for PostgreSQL database. 

2. Added script for function Invoiceopenasofdate() for PostgreSQL database. 

1. DB changes for Advance Budgeting and Costing Module 

1. Did DB Changes on Team Forecast, Master Forecast and Opportunity windows

2. Team and Master window sequencing 

3. Window: Product 

Tab : Bill Of Materials 

New Fields:  Attribute Set Instance

1. Service Contract window related changes 

Window: Service Contract 

Tab : Service Contract 

New Fields:  ContractType, IsApproved 

Window: Invoice 

Tab : Invoice 

New Fields:  ServiceContract 

2.Window – GL Journal,  Tab – GL Journal Line  

Field – Project  ->  Apply validation which will show

only project

->  Zoom – Project Window 

DB Scripts for PostgreSQL function : getgldimensionvalue 

1. Window : Production 

New Tab : Material policy 

Procedure : Checkforfuturerecord 

1.Update Combination length from 60 to 255 characters on Account Combination window 

2.Bind Period Closing Process 

3.Help and comments updated for windows 

1.Product Costs Window : 

a) Added 1 column  - ActualQty on M_CostQueue Tab 

b) Added new tab "M_CostQueueTransaction" which is child of Cost Queue Tab 

2.Window: Budget Activation 

Tab : Budget Activation 

New Fields:  BudgetBreachPercent 

3.Window : Purchase Order 

Tab : Purchase Order 

New Fields : IsBudgetBreach (Added),IsBudgetBreachApproved (Added)

4.Window : Requisition 

Tab : Requisition 

New Field : IsBudgetBreach (Added),IsBudgetBreachApproved (Added)

5.Process: Generate PO from Sales Order (Changes) 

New Field: C_RefBPartner_ID (Added) 

DBSchema 

1.Window: Project Type Name Changed Project Templates  

Tab: Header and New Tab Added Standard Task Line 

2.Window: Project 

Tab: Project, Phase, Task, Task Line 

Fields: Rename Project Type to Project Template 

Added new read only logic on Standard Phase Field.

1. Resolved issue coming on Live related to PostgreSQL function. 

1. Changes constraint type on Line History on Order Line column from Restrict to Cascade 

2. Weekday changes in payment term screen. 

3. Script changes in module entry. 

DBSchema

1. Window: Document Type 
Tab: Document Type

Fields :  1. Difference Document 

2. Confirmation Document 

3. Scrap Document

2. Window: Move Confirmation 
Tab: Confirmation 

Fields :  Document Type 

Tab: Line 

Fields :  UOM 

3. Window: Ship/Receipt Confirmation 
Tab: Confirmation 

Fields :  Document Type 

Tab: Line 

Fields :  UOM 

4. Data 

DocBaseType (Move Confirmation, Ship/Receipt Confirmation) 

Document Type (Move Confirmation, Ship/Receipt Confirmation) 

1. Bug fixed for PostgreSQL of payment term enhancement 

1. Payment Term > Payment Term tab ->Rename 'Net Day' to 'Week day' and added new field 'Week offset'.   

2. AR Invoice/AP Invoice > Invoice header -> Added new field 'Due Date' field. 

3. Opportunity > Opportunity Line tab - > Added new field 'UOM'. 

1. Customer Master –>  Location Tab ->  Increase the size of Name field to 500 chars 

2. Update PaymentTermDiscount function  

3. On Cash journal -> handled when Cash type as Invoice for PostgreSQL 

1. Mark IsCopy False for Posted button on GL journal Window 

1.Hide Role from Login User tab of Employee Master. 

1. Bug Fixes 

2. Database Changes for POS Order document type 

1.Database Changes for Revenue Recognition window as well on Invoice Line 

1. DB scripts updated for check future date record in PostgreSQL  

2. Drop DocBaseType column from GL category  

1. Handled UOM Conversion Report 

1. Added Script for some functions to support PostgreSQL.  

1. Added Validation on 'Year' column of 'Profit and Loss' window, based on selected calendar on Organization. 

1. On Allocation Header, create Conversion Date column. 

2. On Allocation Line, create reference column of Invoice and its Schedule, Payment and Cash Journal. 

3.On Cash Journal Line, Added Payment Type as Payment Return and Receipt Return which will show when cash type is Business Partner.

4.Change in respective function: alloccashavailable, C_CashLine_V, AllocPaymentAvailable, InvoiceOpenAsOfDate, InvoiceOpenAsOfDateNew, invoiceopen_new  

1. Window –Dunning Run  Tab – Line Table – C_DunningRunLine : Updated  Read Only Logic  on columns C_Invoice_ID, C_Payment_ID, GL_JournalLine_ID, C_CashLine_ID  

2. Add Parameter  Include PDC  to Process Create Dunning Run 

3. Window –Dunning Run  Tab – Line Table – C_DunningRunLine 

Add New Fileds : Cash Journal Line , GL Journal Line  

4. Apply Mandatory Logic on InvoiceReference Column of C_Invoice :IsSOTrx='N' 

5. Create Parameter DocType in Process C_CommissionRun_Process and Bind Validation(Active, created in * org and document organization, base type Ap invoice and expense checkbox true.) 

6. Create Parameter C_DocType_ID on M_Inout_CreateInvoice Process . Bind the validation. 

7.Change the label of InvoiceDocumentNo parameter to Invoice Reference on M_Inout_CreateInvoiceProcess. 

8. Added DB Scripts, which will mark document no and value as non Mandatory UI for those records having Entity Type not equal to Other Customization.

1. Introduced "Cross Currency Rate" calculation feature. For user manual click here. This functionality is supported by Vienna Advantage Framework <4.2.39.0> 

2. Introduced organization wise period control. For user manual click here. This functionality is supported by Vienna Advantage Framework <4.2.39.0> 

3. Bug Fixes.

1. Make Discount, Write-Off, Over/Under amount on payment window set as read only when invoice schedule reference not found 

2. Bug fixes for Payment Allocation form