web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

How to create sales quote if my customer is blocked in business central

(0) ShareShare
ReportReport
Posted on by 289
Hi Guys,
 
As a standard functionality, if particular customer is blocked then system will not create the sales quote.
but ,I want if this particular customer is blocked then it will create the sales quote for that blocked customer.
Is any way to do this.
 
I have the same question (0)
  • Suggested answer
    Kamal Khakhkhar Profile Picture
    1,282 on at
    Hii There,
    as per your question you need a loop hole in validation. as per that you need to create a table and fir that table you need to specify a codeunit event as per that you need to compare Customer & Custom table value and apply a logic of skip the record. so you can create operation for that customer.
     
    Event Name:- OnBeforeCheckBlockedCust
    Table Name:- Customer
     
    Thank you.
    Kamal Khakhkhar.
  • Test user Profile Picture
    289 on at
  • Verified answer
    Govinda Kumar Profile Picture
    2,304 Moderator on at
    Hi Nilam Bhor,

    Yes, you can use the blocked customer to create a sales quote. To allow sales quotes for either all blocked customers or for a specific one, you need to modify the code. I've tested this in Business Central, and it works..
    Here's the blocked customer status:
     
     
    You can create a sales quote for a particular blocked customer like this
     
     
    Please note that even after creating the sales quote, the blocked status of the customer won't change. To implement this in my codeunit I used the event mentioned by Mr. Kamal Khakhkhar... Here's a simple code snippet you can add and publish..
     [EventSubscriber(ObjectType::Table, Database::Customer, 'OnBeforeCheckBlockedCust', '', false, false)]
        local procedure OnBeforeCheckBlockedCust(Customer: Record Customer; Source: Option; DocType: Option; Shipment: Boolean; Transaction: Boolean; var IsHandled: Boolean);
        begin
            if ((DocType = 0) AND (Customer."No." = '50000')) then begin
                IsHandled := true;
            end;
        end;

    I hope this information is helpful.
     
    Best Regards,
    Govinda Kumar

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans