Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

How to apply validation to my return/replace foekd

(0) ShareShare
ReportReport
Posted on by 75

Here I have quantity 2 and when I ship /invoice 1 quantity, I should only return sales order for remaining two quantity,

Screenshot_5F00_20230510_2D00_102224_5F005F00_01.jpg

In my field when I enter quantity 2 or more i should get error,

Because I have only one quantity left so I should send return for that, i have done validation for more that 2 quantity, but need for quantity Shipped and remaining quantity only need to send, please need help in this part.

This is my code:

trigger OnValidate()

var

cu_ItemVatCalculation: Codeunit ItemVatCalculation;

rec_Item: Record Item;

itemVat: Decimal;

rec_SalesLine: Record "Sales Line";

enum_DocumentType: Enum "Sales Document Type";

begin

Rec.VAT := Rec."Unit Price" * Rec."Return/Replace";

if (Rec."Return/Replace" > rec.Quantity) or (Rec."Return/Replace" < 0) then begin Error('Please provide valid Return/Replace quantity');

end;

  • Suggested answer
    Govinda Kumar Profile Picture
    Govinda Kumar 2,203 Super User 2024 Season 1 on at
    RE: How to apply validation to my return/replace foekd

    Hi Shankar,

    Based on your code, an error will only be triggered if the return/replace quantity more than original quantity. As your original quantity is 2 and you have already shipped 1, entering 2 in the return/replace field will not get an error.

    for that you should set the return/replace quantity to be greater than shipped quantity, as suggested by Kaspars..

    Rec."Return/Replace" > Rec."Quantity Shipped"

    Regards

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,962 Super User 2024 Season 2 on at
    RE: How to apply validation to my return/replace foekd

    Then adjust this place:

    if (Rec."Return/Replace" > rec.Quantity) or (Rec."Return/Replace" < 0)

    Change Quantity to Shipped Quantity

  • Shankar Profile Picture
    Shankar 75 on at
    RE: How to apply validation to my return/replace foekd

    I need to compare ship quantity , if my ship quantity is 1  and I enter 1 in my return replace field, i should not get error ,but if I enter more than 1 in return replace field then I should get error,

    So how to do that in al/code

    Please help.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,962 Super User 2024 Season 2 on at
    RE: How to apply validation to my return/replace foekd

    I am not a Developer, but from what I can see Your quantity is 2, and in the Return/Replace You also Enter 2.

    Error is given only when Return/Replace is higher than Quantiy or below 0.

    So adjust Your code there. I guess You need to compare the Shipped Quantity not Quantity.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans