1.6.3.0 | Mar 27, 2025 | Enhancement Re-Costing Calculation: The system provides a setting on the Tenant Screen labeled "Invoice Re-cost on GRN Date." When this setting is enabled and the user recalculates the Goods Receipt Note (GRN) cost, the system will retroactively adjust the Invoice Cost, Landed Cost, or Discount Cost based on the GRN date. Costing:
When a Goods Receipt Note (GRN) record is created with an AP invoice reference, the system will calculate the GRN cost using the invoice price. Previously, the system used either the current cost from the product cost or the price from the purchase price list. Matched Invoice: The system includes a field labeled "Is PO Costing Method." This field will be marked as true when the costing method associated with the product is either Average PO, Weighted Average PO, or Last PO.
DB Changes Note–Need only those Business Partner having Representative and Employee Checkbox true.
Window- VAS_Commission
Tab- Commission
Fields- Business Partner
Description – Change the reference key on Column C_BPartner_ID and apply validation that Representative and Employee Checkbox true. Note–Product Category & Prospect Ctaegory Should not be auto filled and need to be null .
Window- VAS_Commission
Tab- Commission Line
Fields- Business Partner Category , Product Category
Description – change the default logic to –1 on both fields. Window: VAS_GLBudget
Tab: Budget, Budget Control, Budget Control Dimension
Note: Mark Single view, Multiview, Card View checkbox as true also set New record as Single View and Default View as Multiview. Window: VAS_BudgetControl
Tab: Budget Activation, Budget Control Dimension
Note: Mark Single view, Multiview, Card View checkbox as true also set New record as Single View and Default View as Multiview. Note–Need to add navigation buttons and labels(tab name) on Organization window.
Window- Organization
Tab- All
Fields- Label , Organization Info, Organization Translation , Organization Assignment , Sales Office , Sales Office Translation
Description – Add new field Label on every tab and organization Info, Organization Translation , Organization Assignment , Sales Office , Sales Office Translation- navigation buttons on header tab. Note–Need to add navigation button and labels(tab name) on Brand Master window.
Window- VAS_BrandMaster
Tab- Brand , Assigned Products
Fields- Label , Assigned Product
Description – Add new field Label on each tab and Assigned Products navigation button on header tab. Note - Invoice Re-cost on GRN Date field on Tenant screen for the Costing
Window - Tenant
Tab - Tenant
Field - Invoice Re-cost on GRN Date
Description – Added new field Invoice Re-cost on GRN Date on Tenant window for the Costing Note - Is PO Costing Method field on Matched Invoice screen for the Posting
Window - VAS_MatchedInvoices
Tab - Match Invoice
Field - Is PO Costing Method
Description – Added new field Is PO Costing Method on Matched Invoice screen for the Posting Note – Created Fields on Request and all Request window.
Window – VAS_AllRequests, VAS_Request
Tab - Assigned Request, Updates
Fields - User Feedback, Like Count and Dislike Count
Description – Added new field User Feedback on Request and all request header tab Assigned Request and Like Count and Dislike Count fields on Updates tab of request and all request window.
|
1.6.2.0 | Feb 24, 2025 | Enhancement: DevOps ID:6101 – Order Amount Summary Tab: A new tab panel has been added to the Sales Order and Purchase Order screens to display Order Amount Summary information, including the total order amount and tax amount. This enhancement provides users with a quick and clear financial overview, improving visibility and decision-making in sales and procurement processes. Total Receivable / Payable Widget on Invoice Screen:
The Total Receivables/Payable widget provides a real-time overview of the total outstanding amounts as of today, based on the specified due date on Invoice Schedule. It includes the grand total of Accounts Receivable / Payable invoices, except Expense Invoices and considers both Completed and Closed records. The receivables / Payable are categorized into aging buckets, helping businesses track overdue payments and manage collections effectively.
Aging Buckets & Calculation Method
0-30 Days: Includes invoices with a due date from today and the past 29 days. The total is calculated by adding the AR/AP Invoice Amount and subtracting the AR/AP Credit Memo Amount.
31-60 Days: Covers invoices with a due date between 31 to 60 days ago. The total is determined using the same calculation method: AR/AP Invoice Amount - AR/AP Credit Memo Amount.
61-90 Days: Includes invoices with a due date from 61 to 90 days ago. The outstanding amount is calculated by adding the AR/AP Invoice Amount and subtracting the AR/AP Credit Memo Amount.
91-120 Days: Captures invoices with a due date from 91 to 120 days ago, using the same formula for calculation.
Older than 120 Days: Includes all invoices older than 120 days from today. The total outstanding amount is derived by adding the AR/AP Invoice Amount and subtracting the AR/AP Credit Memo Amount. Top 5 Customer / Vendor Widget on Invoice Screen: This widget displays customer and vendor data based on the Date Invoiced, ranking customers according to the grand total of Accounts Receivable/Payable invoices within the selected date range. Only Completed or Closed AR/AP invoices are considered in the ranking to ensure accuracy. Additionally, if an AR/AP Credit Memo has been issued, its amount is deducted from the corresponding AR/AP invoice. Purchase / Receivable State of Widget on Invoice Screen: Created Widget to show Amount of different states like - Overdue: Displays the total amount of invoices whose due dates have passed. Due Soon: Shows the total amount of invoices that are approaching their due dates. New: Summarizes the total amount of invoices created in the current month. Drafted: Displays the sum of the grand totals for all drafted invoices after withholding adjustments. In Progress: Shows the sum of the grand totals for all invoices currently in progress, adjusted for withholdings. Unmatched: Displays the total amount of invoices marked with the "IsHoldPayment" checkbox. Disputed: Shows the total amount of invoices where the "Is In Dispute" checkbox is checked. Unallocated Receipt: Shows the total amount of invoices which are not allocated with payment.
Expected Invoices Widget on Invoice Screen: This widget provides a real-time overview of Sales/Purchase Order amounts that have not yet been invoiced. Additionally, it displays the Delivery Order/Goods Receipt Note amounts associated with Sales/Purchase Orders for which an Accounts Receivable / Payable Invoice has not been created, ensuring visibility into Delivery / GRN that are yet to be billed.
The widget presents amounts in the respective transaction currency, maintaining financial accuracy across multiple currencies. Users can also drill down into specific records to access detailed information about corresponding invoices and orders. Purchases (Chart) on Invoice Screen: The "Purchases " chart displays the Purchases for both the current year and the previous year. By default, the chart shows the period as per the Tenant calendar. Users can also change the period of calendar through series tab of Dashboard screen. If user binds any calendar there, then the chart will filter the data as per that calendar period Top 10 Highest Selling Products Widget: A new widget has been added to the Product Master window that displays the Top 10 Highest Selling Products based on the quantity sold per month. This feature provides users with valuable insights into product performance, helping in inventory management and sales strategy optimization. Top 10 Lowest Selling Products Widget: A new widget has been added to the Product Master window that displays the Top 10 Lowest Selling Products based on the quantity sold per month. This feature provides users with valuable insights into product performance, helping in inventory management and sales strategy optimization. Expected Fulfilments Widget on Delivery Order Screen: A new widget has been added to the Delivery Order Screen to display details of Expected Fulfilments. This feature allows users to view expected fulfilments, select an order, and generate the corresponding delivery order efficiently. It enhances visibility and streamlines the order processing workflow. Due Fulfilments Widget on Delivery Order Screen: A new widget has been added to the Delivery Order Screen to display details of Due Fulfilments. This feature allows users to view pending fulfilments, select an order, and generate the corresponding delivery order efficiently. It enhances visibility and streamlines the order processing workflow. Expected Orders Widget on GRN Screen: A new widget has been added to the GRN (Goods Receipt Note) Screen to display details of Expected Orders. This feature enables users to view upcoming orders, select an order, and generate the delivery order seamlessly, improving efficiency in order processing and inventory management. Due Orders Widget on GRN Screen: A new widget has been added to the GRN (Goods Receipt Note) Screen that displays details of Due Orders. This feature allows users to view pending orders, select an order, and generate the delivery order, enhancing order tracking and processing efficiency. Pending Customer RMA Orders Widget: A new widget has been added to the Customer Return Screen that displays details of pending Customer RMA (Return Merchandise Authorization) orders. Users can conveniently view pending RMAs, select an order, and generate a Customer Return directly from the screen. This enhancement improves return processing efficiency and streamlines order management. Pending Vendor RMA Orders Widget: A new widget has been added to the Vendor Return Screen that displays details of pending Vendor RMA (Return Merchandise Authorization) orders. Users can easily view pending RMAs, select an order, and generate a Vendor Return directly from the screen. This enhancement simplifies return processing and improves vendor order management. Expected Transfers Widget: A new widget has been added to the Material Transfer Screen that displays details of expected transfers. Users can conveniently view upcoming material transfers, select a Requisition, and generate a Material Transfer directly from the screen. This enhancement improves inventory movement efficiency and streamlines transfer operations. Pending Transfers Widget: A new widget has been added to the Material Transfer Screen that displays details of pending transfers. Users can easily view pending transfer requests, select a Requisition, and generate a Material Transfer directly from the screen. This enhancement optimizes inventory movement and streamlines transfer processing. Open Quotations Widget: A new widget has been added to the Sales Quotation Screen that displays details of Open Quotations. Users can easily view and select a Quotation to generate a Sales Order directly from the screen. This enhancement streamlines the sales process, improving efficiency and order management. Credit Limit Utilization Widget: Added a new widget on the Customer Master Screen that displays the credit limit utilization details of the customer. "Create Line from Cart" Button: A new "Create Line from Cart" button has been added to the following screens: Inventory Count Internal Use Sales Order Purchase Order Requisition Inventory Move Vendor Return Customer Return
This feature allows users to easily insert line items by selecting cart lines from the form, improving efficiency and reducing manual data entry across multiple processes. Bank Balance Widget on Payment / Banking Journal Screen: This widget displays the current balance of your account in real time, providing you with an instant overview of your available funds. Cash Flow Forecast Widget on Payment Screen: This widget provides a structured view of projected cash inflows and outflows, divided into Payments and Receipts sections. It aggregates the total amounts for Accounts Payable/Receivable invoices, credit memos, expense invoices, and orders with due dates in the current month. To ensure accurate forecasting, the widget subtracts credit memo amounts from both sections and excludes order amounts if corresponding invoices have already been created.
All data is displayed in the base currency, with values automatically converted using the current exchange rate. Users can apply filters to analyze cash flow trends over different periods, including monthly, quarterly, or six-month views. Expected Receipt / Payment Widget on Payment Screen: This widget provides a structured view of scheduled payments and receipts, displaying invoices and orders with their schedule due dates. It categorizes Expected Payments (AP invoices, credit memos, purchase orders, and expense invoices) and Expected Receipts (AR invoices, credit memos, sales orders, and expense invoices), with positive or negative values based on transaction type. The widget includes currency details, allows users to drill down into specific records, and offers filters for refined views by invoice type, financial period, business partner, or date range. Monthly Average Bank Balance Widget on Payment Screen:
This widget provides a consolidated view of total Accounts Payable (AP) and Accounts Receivable (AR) payments, automatically adjusting for credit memo amounts by subtracting them from each side.
When no specific bank account is selected, the system aggregates all bank payments and displays the total in the base currency. However, if a user selects a specific bank account, the widget adjusts to show the total payment amount in the currency of the selected bank account. Cashbook Balance Widget on Cash Journal Screen: This widget shows the available cash in your cashbook. Cash Movement Chart on Cash Journal Screen: This widget presents a chart with two bars: receipts and payments. It consolidates data from all cashbooks, showing cash payments and receipts for each month of the financial year. The receipt bar represents amounts for cash receipts and payment return transactions, while the payment bar shows amounts for cash payments and receipt return transactions. Top 10 Cash Expense Chart on Cash Journal: This chart is a dynamic donut chart that displays the top 10 most expensive cash-type charges recorded in the cash journal for the financial year. It only includes Cash Type as "charge" with a payment type of "Payment." Financial Data Insights Widget on Home Screen:
Created Widget to get finance data insights which will show the insights of finance team. Top 10 Expense Widget on Home Screen: This widget displays data for accounts classified as expense type with a posting type of Actual. It retrieves information from the ledger account details within the base accounting schema. The total amount for each expense is calculated as Debit minus Credit, providing a clear overview of the highest expenses incurred. Users can apply various filters such as This Fiscal Year, Previous Month, or Last 6 Months to customize data views. Income & Expense Widget on Home Screen: This widget presents data for accounts categorized as expense or revenue with a posting type of Actual. It retrieves information from the ledger account details within the base accounting schema. The total amount for expenses is calculated as Debit minus Credit, while revenue is calculated as Credit minus Debit. Additionally, the widget calculates monthly profit by subtracting total expenses from total revenue. Users can apply various filters, including This Year, Previous Financial Year, Last 6 Months, and Last 12 Months, to tailor data views for in-depth financial analysis. Schedule Detail Tab Panel on Invoice Screens: A Tab Panel has been created within the Accounts Receivable/Payable Invoices to display invoice schedule details. This panel presents key information such as Due Amount, Due Date, and Payment Method for each scheduled payment. When a user clicks on a schedule entry, the system display associated payment details, including Document Number, Accounting Date, Check Number, and Check Date (if applicable). Additionally, the panel provides a payment status, indicating whether the schedule is Paid or Unpaid. Backdated Inventory: Previously, the system did not allow the creation or reversal of transaction entries for a backdated period if a future-dated transaction existed. Now, it permits such actions, except for future-dated Inventory Count transactions. Costing: The system enhances costing functionality by allowing users to record consumption transactions without requiring stock insertion. It maintains the expected landed cost value on the Goods Receipt Note (GRN) when applicable.
Additionally, the system tracks Landed Cost, Posting Cost, and Product Cost within the Product Transaction tab. Now, the system automatically creates entries for AP Invoices, Landed Costs, and Treat as Discounts under the Product Transaction tab.
A Cost Queue entry is only generated when the costing method is set to LIFO or FIFO. When creating a Cost Queue entry, the system assigns the movement date of the transaction as the Cost Queue date, including the current timestamp.
Furthermore, the system provides an option on Tenant to process customer returns using either the Delivery Order cost or the Current Cost, ensuring flexibility in cost management.
Bug Fixes: DevOps ID: 6160, 6161
Changes done on RFQ Reactivate Process, Any existing responses associated with the RFQ will be deleted if found during reactivation. Changes done on Publish & Invite Process on RFQ tab for sending the invite to vendor whose status is other than recommended.
Bug Id: 6192 - On Payment Allocate Tab- Earlier System was not allowing users to select Invoice of other currency which is selected on Payment Header on Allocate Tab Now Handled the issue and now user can select invoice other than header currency and the amount will, also be converted according to it.
DB Changes: Window restructuring – Create new window which is replica of RMA-Customer window DB Changes
Window-VAS_CustomerRMA
Tab-RMA, RMA Lines, Invoice Tax
Note-Created window, Tabs, fields and header panel Development - Window restructuring – Create new window which is replica of Vendor RMA window DB Changes
Window-VAS_VendorRMA
Tab-RMA, RMA Lines, Invoice Tax
Note-Created window, Tabs, fields and header panel Note–Added Default filter of these mentioned screen.
Window- VAS_PurchaseOrder
Tab- Purchase Order
Fields- Vendor, Date Ordered, Warehouse, Document Status, Product Window- VAS_InternalUseInventory
Tab- Inventory Use
Fields-Warehouse, Movement Date, Document Status, Product Window- VAS_APInvoice
Tab- Invoice
Fields-Vendor, Invoice Reference, Invoice Date, Payment Method, Document Status Window- VAS_DeliveryOrder
Tab- Delivery order
Fields-Sales Order, Customer, warehouse, Movement Date, Tracking No, Shipper, Document status Window- VAS_ARReceipt
Tab- AR Receipt
Fields-Customer, Invoice, Bank Account, Payment Amount, Currency, Document Status, Allocated Amount, Reconciled
|