RazorERP PRD Build, 28112024

RazorERP PRD Build, 28112024

image-20241129-154906.png

New Software Build Report (PRD build, 28112024) 

This list includes the highlights of some of the key features and fixes that are included in the latest build.

Release date: November 28, 2024

Identifier

Issue / Request

Resolution/Change

23295

( ! ) Changes to the Inbound Order Settlement API ( ! )

Changed calculation of the fields "lotPrice", "lotPriceType", "subtotal". Field values are calculated based on Inbound Price. Added fields "lotPriceOutbound", "lotPriceTypeOutbound", "subtotalOutbound". Field values are calculated based on Outbound Price.

Changes have been made to the following methods:

GET /api/v1/InboundOrder/{id}/received-lots
GET /api/v1/InboundOrder/settlement/lots
GET /api/v1/InboundOrder/{recyclingOrderId}/lots
GET /api/v1/outbound-order/{id}/loaded-lots
GET /api/v1/outbound-order/settlement/lots
GET /api/v1/Lot/received GET /api/v1/Lot/{id}
GET /api/v1/Lot/all GET /api/v1/Lot/by-auto-name/{autoName}
GET /api/v1/de-manufacturing/job/{jobId}/available-lots
GET /api/v1/de-manufacturing/job/{jobId}/search-by-auto-name/{autoName}

Also added “IsSelectedInOutboundOrderSettlement” field which displays the value of lot selection (Apply) on OutboundOrder Settlement.

22863

( ! ) API Lookup Symbol ( ! )

Fixed + sign processing in URI path segment for APIs. The main problem is that IIS replaces encoded special characters from url path. We decided to duplicate existing endpoints to work with parameters from query instead from path. This will not break existing integrations, the old endpoints will continue to function as before, but for customers with special characters in name or code it is better to use new endpoints.

23220

"Status of a Purchase Order has changed” notification bug

Corrected the issue with snippets for “Purchase Order Status Change” email template.

23190

Disposition Character limit 

image-20241129-162813.png

 

4000 is the total number of characters including hidden html tags and text design elements. The actual allowed number of characters is ~3900.

When converting characters to words, a maximum of ~600 words is allowed.

23169

Adding a Source type to Sales orders

Added Mercari as source type for sales orders.

23160

Hard Drive Management Report does not match Basic Audit Report

Fixed, now the original hard drive lot and order will be shown on Hard Drive Management.

23147

Reference Number not generating on Notification Email (Inbound Order has been created)

Fixed, reference number should now be showing on the notification email.

23132

Weight/Quantity is not accurately reflected on the PO

Fixed, User profile is stored now in distributed redis cache. Changes of UOM on user profile page on web erp applied to web part (settlement page) and reports from designer.

23116

Recycling Detailed Breakout Report

Added Settlement Date and Reference 1 field on Recycling Detailed Breakout Report .

23102

Development Request - Hard Drive Report

Added HDD Type and HDD status on data source.

23094

Add Sales and Purchase terms to the CRM accounts grid and its export view

Fixed display of Terms when applied type changes in System Settings. The changed Term will appear as disabled select option and will be removed from select on save if other option is selected. Terms validation in Customer API was improved, now we cannot set SO Terms to Customer PO Terms and vice versa.

23086

Label Designer New Wizard Template 

 

image-20241129-162933.png

 

62mm x 29mm label has been added to Wizard for all entity types.

23043

Add AR and AP listing methods to the API

PaidInvoiceDto was extended with invoiceConsolidatedId and invoiceConsolidatedName. paidAmount property is converted to foreign currency (in the example it is CAD). homeCurrencyPaidAmount is a property that contains amount in home currency (in the example it is USD). state filter parameter was renamed to activeState in both AR and AP endpoints. The default parameter value for activeState was changed to ActiveOrInactive (was Active) in both AR and AP endpoints.

23028

SORT JOB List view is missing all the input information

Fixed, this was an old bug related to incorrect use of the IsDeleted flag from the table for shredder inputs.

23025

Shipping Prices Inaccuracies

Updated the version of the 4DPayments SDK Shipping library.

23020

SOAP to REST and now our shipping estimate rates are off

Rates has been fixed and should be showing correctly when REST API is used.

23016

Internal Comments

Added the column Internal Comments and added the hover tooltip function.

22989

FedEx Integration - Estimated Shipping Rate is missing

Updated the version of the 4DPayments SDK Shipping library.

22988

New Portal Issue - “The Client Portal Permission Section with id 16 should also be set, because the child is a set.” Error

Fixed this problem by disabling Asset Vision -> Grid Columns option.

22942

Implement Client portal PW complexity Requirements 

 

image-20241129-162956.png

 

The requirement is that the password should be 8-24 characters long and should include all of: upper-case, lower-case and digit characters.

22921

Issues with Adding Freight Tag

On the tags page first row was not returned due to mismatch calculations of row number and start row number. This was fixed now all rows are returns.

22911

LOT ID filter for Sales Feeds using Incorrect LOT ID

 

image-20241129-163010.png

 

the Lot Id is assigned automatically for merged lots and is different from the Lot number, instead we added new field lot #

22907

Create AUTO price rules page

image-20241129-163049.png
image-20241129-163145.png

The new functionality was implemented. Can be reached from the settings menu.

22901

Hard Drive Management -- Incorrect Erasure Date 

 

image-20241129-163443.png

 

The problem with showing erasure date was fixed.

22892

Order Notifications to Customer

image-20241129-163456.png

The notification configuration page has been changed. Notification sets can be assigned customers.
Notification sets with assigned customers are not considered default and can be active.
Notification sets without assigned customers are considered to be default, one of them can be active.
When sending a notification, if the notification has an entity customer identifier, then the notification set assigned to this customer is selected.
If this customer has not been assigned a notification set, then the default active notification set is used.

22890

Add External ID at the category level for RESALE items

image-20241129-163540.png

 

The External Id field added to category, max length is 68 characters, numbers, alphabetical characters, "-" and "_" are allowed . Also fixed a bug on categories page. When search category not all data was shown.

22878

API Get All Assets Endpoint Timeouts every request

Recomplete option has been added to the stored procedure.
Execution time decreased several times.

22859

Asset<PUT> response is 400, when doing scrapped assets back to not-scrapped

The changing of assetWorkflowStep from Scrap back to other by PUT /api/v1/Asset/{uId} api was fixed. The commodity and recyclingWorkflowStep fields can be omitted in request or should be empty.

22852

Email Notifications not sending to Primary Contact

Fixed getting primary contact email for a Load is Scheduled notification, Razor allows only one Primary User per account.

22842

Add Location Prefixes

The pallet prefixes: LL, DH, DL, MB, BH, LH, and BR were added

22833

API Request Failure with Status Code 400 Bad Request

Optimized the procedure and now the request has become much faster

22829

Update Recycling Order Sales Report to pull from DELIVERY Date 

 

image-20241129-163602.png

 

Added two new fields
Scheduled Date
Shipped Date

22828

API call does not return correct data. 

image-20241129-163757.png

The ExpectedSealNumber and ActualSealNumber fields were added to GET /api/v1/InboundOrder/all

22808

Removed Drives Count 

 

image-20241129-163825.png

 

Filling the data in Removed Drives Count field was fixed in Report Designer.

22803

Settlement Issue - only the first line item gets deleted rather than all the items selected.

image-20241129-163840.png

 

Added a checkbox to select multiple services.

22798

Print/Download new reports error

 

image-20241129-163914.png
image-20241129-164000.png

 

Error when generating large reports, because each time you generated a document that contained 1500 tables with 1500 records (about 2.2 million records). The duplicates are due to the fact that you had an enumeration set in your report for the entire report and separately for the table. Cleared the Data Member in the report properties and now it is generated.

22797

Inventory Details Label Print settings. 

 

Added serach field to the printers drop-down.
Format dropdown list styling has been edited.
The format selection window now closes automatically when changing the format.

22791

Outbound Order settlement date

Added Settle Date in Recycling Sales report to outbound orders API endpoints.

22751

Weird text and character on Orders page

Weird text and character was removed.

22687

Environmental Report metrics do not work in the dashboard

Fixed, Total Pickups changed to Total Orders as total inbound orders count instead of total assets count.

22664

Recycling SO report not pulling all information 

 

image-20241129-164143.png

 

Sales Order field changed to contain resale SO number.
For recycling SO were added fields:

Recycling Sales Order

Subtotal - Recycling Sales Order

Recycling Sales Order Created Date

Recycling Received Price

22659

Field added to Sales Order page

 

image-20241129-164152.png

 

Added a new field Shipping Date

22641

Add a Method to API Swagger UI

Added a new endpoint
/api/v1/sorting/shredding/analysis/lots/input/all

22589

Please update Recycling Order Sales Report to pull from DELIVERY Date

Added the Delivery date column to report

22477

Offsetting Charges and Purchase 

image-20241129-164210.png

 

image-20241129-164254.png

 

We have replaced “Settlement AR+AP” logic flag in the system settings by a dropdown.

The “ask” option makes a new confirmation dialog to appear on the IO and OO settlement.

22588

Client portal API: add methods to create inbound order

Added all necessary endpoints

22408

Add extra fields to Fast search

 

image-20241129-164305.png

 

Columns added:

Asset #
Asset UID
Sales Order #

Filters added: Sales Orders:

22367

Actual Arrival Time not populating properly

Fixed. The problem was with null value datas.

22326

Sales Channel Changes

Add a separate Warehouse filter to the feeds (1st tab of the feed editor), apply it to the feed data source. It may contain from 0 to all warehouses of the company as ids.

Add a column to the grid to output which wharehouses the feed in the row is applicable to

Add a filter for the user to be able to show only warehouses he needs:

Warehouses: any - show unfiltered

Any of mine - all feeds with the warehouse filter empty or containing at least 1 of the warehouses assigned to the user

All of mine - all feeds with the warehouse filter empty of containing at least all warehouses assigned to the user

22300

Asset Tag 

image-20241129-164323.png

 

Added a text field tag for inventory
if it is inventory - then the field is saved in inventory table
if it is an asset - then the field overwrites asset tag

21572

Needing to quickly identify locations marked as resell channels

image-20241129-164338.png

The field has been added to following tabs.

21486

New Inbound Order isn't showing Tare Weight when receiving goods in 

 

image-20241129-164409.png

 

Added the button for setting the default weight from the Package to the Tare weight field in case when the Package has the default weight. If the Tare weight field is empty and we are selecting the Package with default weight this weight will be allocated to the field.

21041

Add new column to inventory detail page

 

image-20241129-164423.png

 

Added new column
total price = net * inbound price

23244

Inbound report reference increase characters

Increased the number of characters allowed for Reference 2 and Reference 3 up to 128 characters

23018

Add Mobile Number as an option in Recycling order - inbound datasource 

 

image-20241129-164433.png

 

image-20241129-164444.png

 

Option to add mobile number on contacts.

22997

Email-based MFA has been implemeted.

 

image-20241129-164459.png

Groups count - count of groups of characters in the one-time password separated by hyphens.

image-20241129-164521.png

 

image-20241129-164540.png

 

 

image-20241129-164556.png

 

If MFA is enabled for the company, “One-Time Password Options” section appears in General Settings to configure one-time password settings.

Group length - count of characters in each group.

Lifetime in seconds - time during which the generated one-time password is valid.

Maximum count of attempts - the maximum count of attempts to enter the password. If this number is exceeded, the password becomes invalid and a new password should be generated.

Also on the Users page it is possible to enable or disable MFA for selected users. Now only delivery of generated one-time password to email is implemented.

What changes for users if they have MFA enabled?

When logging in, the user enters username and password as usual and clicks sign in. After that, instead of logging in to the default page, the user is taken to the login confirmation page with a one-time password.

User should generate new one-time password by clicking the “Send one-time password” button. The password will be sent to email. The user enters the received password into the confirmation form and clicks the “Confirm” button. If the password is entered correctly, the user will be considered authenticated. Otherwise, the user will be notified about entering an incorrect password or expiration of the password life time.

Important! Users with MFA enabled should have a correct email in their profile, otherwise their one-time password will not be sent to their email and users will not be able to sign in.

22950

Weight Remaining column from Audit was added to Inventory Detail page 

image-20241129-164614.png

Completed lot weight is calculated in same way as on the audit page

21898

Global Notes column was added to inventory detail and consignment items pages

image-20241129-162607.png



Added Global Notes to Inventory → Inventory Detail and Inventory → Consignment Items

21087

Recycling Inbound Order Summary date on schedule date

Added "pickup date" date filter

22826

New Settlement column additions

Added ServiceType field in the recycling settlement api.

API endpoint: [POST] /recycling/api/settlement/page

List of service types can be get from this endpoint:
'/Services/RecyclingService.asmx/ListServiceTypes'

22902

Sales orders sometimes missing the address in the API

Added the default Billing address and contact output in the SO API in the case if it’s not provided in the order.

So it will return the Main Bill to Address and the Main contact of the Customer of the SalesOrder/Quote if it’s not set in the SalesOrder or if the SalesOrder is a Recycling one.

22720

Calendar is showing incorrect time zone

 

image-20241129-164637.png
image-20241129-164704.png

 

“Current user” and “Order Warehouse” are now set to the same time zone.

22574

Master item, Audit tool, Import.

Before substitute entries were applied only for main asset model and manufacturer. Now they also will be applied to hard drives model and manufacturer. The category is applied only for newly created master items.

22535

Audit: order overview tab is blank

Fixed. js files were returned to the bundle file.

22528

Label Designer Additions:

The following data points were added to the label designer:
-Under Inbound Order section order work instructions, order received date, and lot received date were added,
-Under Inventory section the asset reference field was added,
-Under Inbound Order section net, gross, and tare weights for lots received were added.

22504

Sales Order allocation changing weight of assets to 0

The bug was fixed. Now the asset weight will not be updated when importing from Excel file if the "Weight (Kilos)" column is missing, or its value is empty or 0. The Sold Disposition Type is not proper condition for disabling weight edit because Disposition Type is set to Sold when asset goes to the Resale workflow step. At that time the asset can be actually not sold yet and can be editable. So we’d better follow the logic from Audit Page. Now the weight is not allowed to be edited if Inventory status is Allocated, Sold or RMA Pending.

22234

"Actual Pick Up Time" in Client Portal not generating anything.

image-20241129-164719.png

Added column pickup date

22688

Obtain expenses through API

 

image-20241129-164736.png

 

Added new fields for assets

 

For any concerns, feel free to email us at help@razorerp.com

This build report is compiled by:

  1. Anna Bocharova - Development Team Lead

  1. Rome Agregado - Service Desk Director

  1. Josephine Nicolas - Service Desk Specialist

  1. Romnick Catapang - Service Desk Specialist