VA Reports (VARPT_)

1. View level changes has been made regarding Purchase Order and Purchase Requisition Print  

1. To simplify the granting of access to various windows, processes, and forms for a specific role. We've enhanced the Right Groups configuration. Instead of manually granting access to individual components for a role, which can be a cumbersome process, users can now associate a right group with a role. This will automatically provide access to all the components included in the right group. 

This enhancement is supported by VIENNA Advantage Standard <1.2.16.0>  

For detailed information about the components under different right groups, please refer to the link: Right Group Configuration

Created right group for the tenant level.

2. Add New DB Script for PostgreSQL for Purchase Order Document Print.

3. Add New Print Format on  Purchase Order Screen for ( Purchase  Order). In Purchase  Order there was one Print button top of the section. The data was fetching All records. And process attached by Purchase Order tab. Process is  PurchaseOrderPrint.

4. Add New Print Format on Requisition Screen for ( Purchase Requisition) . In Requisition window there was one Print button top of the  section . The data was fetching All records. And process attached by  Requisition  tab . Process is  VARPT_PurchaseRequisitionReport. 

5. Added New Crystal Report Named Customer Detail Report to Menu.

1. Query level Changes has been done for PostgreSQL which are given below:- 

Separate SQL statement for creation & drop view for Vendor RMA & Vendor Return has been write for PostgreSQL .  

2. Changes done In PostgreSQL as well as in Oracle SQL also which are given below:

Item_Attribute (when attribute description is blank then it showing this '---')

UPC/EAN_Item (when UPC code is blank Search key should be print it will not dependent).

1. Add New Print Format on  Blanket Purchase Order Screen for ( Blanket Purchase Order Report) . In Blanket Purchase Order window there was one Print button top of the  section . The data was fetching All records. And process attached by  Blanket Purchase Order  tab. Process is  varpt_blanketpurchaseorder_v

2. Add new Print Format on  Blanket Sales Order Screen for ( Blanket Sales Order Report) . In Blanket Sales Order window there was one Print button top of the  section . The data was fetching All records. And process attached by  Blanket Sales Order  tab. Process is  varpt_blanketsalesorder_v

3. Converted Customer RMA Print View SQL for ORACLE, it was available for PostgreSQL. 

RFQ Crystal Report Development and deployed on RFQ Window 

1. Added a new Print Format on GRN Confirmation  Screen for ( GRN Confirmation Report) . In  GRN Confirmation window there was one Print button top of the  section . The data was fetching All records. And process attached by Confirmation tab . Process is  VARPT_GRN_Confirmation_V.

2. Blanket purchase order print  Logo resized  . Process is VARPT_BlanketPurchaseOrderReport .

1. Rebuild the module with updated NuGet Packages to make compatible with Vienna Advantage Framework version 5.0 and above. 

Note:- This version and all future versions of this module will be compatible with Vienna Advantage Framework version 5.0 and above. If you are using Vienna Advantage Framework 4.X.X.X then, do not install this version.  

Module Dependency 

Vienna Advantage Standard (VAS_) <1.0.1.0> 

1. Resolved issue in VARPT_CONVERT_UOM function for PostgreSQL. 

1. Added New DB function to VARPT_CONVERT_UOM. 

2. View level changes in open purchase order report 

Below Reports regarding some change.

1. Made changes in Product column, added Attribute with product with Underscore and if attribute will not be there then product will come without underscore, added new join with m_attributesetinstance Table.

1. Expected Material Receipt Report
2. Product Stock Detail 
3. Receipts not matched to invoices 
4. Cash Journal Consolidate Report 
5. Expected Shipment report 
6. Customer Return Report  
7. Goods Receipt Forecast Report 
8. Open Sales Order Report
9. Stock Available For Shipment Report 
10. Stock Detail 
11. Customer Credit Status Report 
12. Sales Journal Details Report 
13. Sales Order Detail  
14. Sales Order Status Report 
15. Payment Report (Rename the report) 

1. Bug Fixes

1. Made changes in Product column, added Attribute with product with Underscore and if attribute will not be there then product will come without underscore, added new join with m_attributesetinstance Table.

a) Open Purchase Order Report  

b) Purchase Journal Details View  

c) Purchase Order Status Report  

1. Added New Column Qty (Txn UOM) in Report Format and done changes in calculation for Total amount in following Reports:

a) Open Purchase Order

b) Purchase Order Status Report

c) Purchase Journal Details Report

2. Change in Validation for Adjustment parameter in Inventory Adjustment Report

1. Handled query for Postgresql (product name was not showing when there is no attribute) in following reports 

a) Internal Inventory Consumption Report 

b) Inventory Adjustment Report 

c) Purchase Order Status Report 

d) Purchase Journal Details Report 

1. Handled report for Postgre (separate query is created). 

2. Handled lines with FeeAmt in Payment Section

1. Changed Name and Print name of system element used in parameter of Trial Balance Report from C_Account_ID to Account 

1. Dunning Run can be printed from Header also 

2. One view is created - VARPT_DUNNINGENTRYHEAD_V 

3. One report format is created - VARPT_DunningEntryHeadReport 

1. Correction in View query "VARPT_DUNENTRYLINEPAY_V" for the Report VARPT_DunningEntryReport 

1. Added rows on payment section of VARPT_DunningEntryReport - (included data of cash line, GL journal, post dated check from line tab of dunning run window) 

2. Changed labels of Payment No to Document No and Transaction Date to Trx/Statement/Check Date view name - VARPT_DUNENTRYLINEPAY_V  

3. Added condition in query which will restrict to fetch any record without invoice id in first section (Invoice Section), view name - VARPT_DUNNINGENTRYLINE_V  

1. Bug Fixes 

1. Bug Fixes