Page Comparison

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)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. 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> 

Bug Fixed

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

1. Bug fixes for Payment Allocation form 

1. Add new tab on Budget Control as (Budget Control Dimension). 

2. Put Validation and Mandatory logic on Budget and Budget Control as well. 

1. Add new Tab "Serial No" on "Serial No Control" window, to generate Serial No Organization wise. 

2. Add new fields "Organization Level" and "Org Column" on Serial No Control Tab. 

Bug Fixed

Bug Fixed

Bug Fixed

1. Create LineTable_ID column on Accounting fact detail for maintaining line posting table 

1. Bug fixes 

2. Improvement 

a) Add Search key column in "Create Line Form" grid.  

b) Default Logic corrected on "Amount Dimension Taxable Amount" field. This field is available on line tab of Invoice (Customer) and Invoice (Vendor).

1. Added new field "Mail Template" on "RfQ" and  "RFQ Topic" window. This functionality is supported by Vienna Advantage Framework (4.1.6.0) 

2. On payment Window, made "Withholding Amount" column as not a copy record and not read only 

1. Added new fields on Request type window to support the notification functionality. This functionality is supported by Vienna Advantage Framework <4.1.1.0> . 

1. Added fields on Withholding, Business Partner, Invoice and Payment for handing "Withholding Tax" into the system. 

2. Added field for auto check functionality on Bank Account Document. This functionality is supported by Vienna Advantage Framework <4.0.8.0>. 

3. Added DB Script for handling back date document reversal and completion. 

1. Added new checkbox "Employee" on "Business Partner" info window. 

2. On Payment Window, Added callout to set Currency on selection of Bank. 

3. Created window named Copy Balances Detail for supporting the Copy balances to accounting schema process sent from module Financial Management<1.0.46.0>. 

1.Bug Fixed

1. On "GL Journal " Window new field introduce "Reversal Date". 

2. On "GL Journal" window new checkbox introduce "Reversal Created". This feature is supported in GL Voucher  version <1.0.20.0> 

1. Added Discount column in C_InvoiceLine table. Applied column Sql on this column 

2.Added new field Discount % on Invoice (Customer), Invoice (Vendor) windows. 

3. Amt Dimension field copy checkbox need to set false. If we are using copy record option system copy value of previous record 

4. Rename "Vendor Name" field to "Name" in Vendor Contact Tab of Vendor master window 

5. Added User Element column on Profit and loss lines