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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Unable to Set Sales Price to Zero in Sales Order

(4) ShareShare
ReportReport
Posted on by 134
Hi Community,
 
Is it possible to have a Sales Order with multiple lines where one line has a sales price of zero but still carries a cost (COGS)? 
 
The system currently requires a value in the sales price field. I've reviewed the Sales & Receivables Setup but couldn't find any option to disable this requirement. Is there a standard way to allow zero-value sales lines?
 
Goal is to create a sales order with multiple lines but one of the lines has sales price of zero but when invoiced COGS will have value for that zero price line item.
I have the same question (0)
  • Suggested answer
    Aziz Skhiri Profile Picture
    393 on at
    Hello there is two ways to solve this :
    1. Best & Cleanest method
      Set the Line Discount % to 100% instead of putting the Unit Price to 0.
      This way the net price becomes zero, but the cost is still recorded normally when you post the invoice. COGS will appear correctly.
    2. Alternative
      If you really need the Unit Price to show as 0.00:
      • Go to the line → click on Unit Price → choose “0” and confirm.
      • If it still refuses, temporarily set “Prices Including VAT” to No on the Sales Order header, enter 0, then switch it back.

    There’s no setup in Sales & Receivables Setup to completely disable the check, but the 100% discount trick is the standard and cleanest workaround used by most people. This will give you zero revenue on that line while still posting the correct COGS.

  • Suggested answer
    Rajvi Shah Profile Picture
    127 on at
    Hello,
    Aziz's Answer is correct,
     
    You can True the Boolean of "FOC" which is Free of Cost, By clicking this Boolean system will automatically apply 100% in Line Discount.
     
    Eighter you can put the unit price as 0 or you can apply line discount as 100% for particular that item.
     
     
    I hope this will help you.
  • Suggested answer
    Teagen Boll Profile Picture
    1,518 Super User 2026 Season 1 on at
    Hello, 
     
    With standard functionality you should be able to set the unit price as 0$ on the line and post:
     
    This will also post to COGs:
     
    As Aziz mentioned the alternative option if the above doesn't work is to just use a 100% discount either on the line or the invoice itself. You can set the discount account to a specific GL Account (such as a revenue account called discount) or set it as the same GL Account as your "Sales" Account in the general posting setup:
     
    Best,
    Teagen
    Catapult ERP
     
  • Suggested answer
    YUN ZHU Profile Picture
    99,220 Super User 2026 Season 1 on at
    Orders can be posted as long as the total amount is not less than 0, even if a sales line is negative.
    Thanks.
    ZHU
  • Suggested answer
    OussamaSabbouh Profile Picture
    13,168 Super User 2026 Season 1 on at
    Hello,
    Yes standard BC should allow a sales line with Unit Price = 0, and if it’s an item line, posting can still create COGS from the item cost, so your scenario is valid. There’s no standard toggle in Sales & Receivables Setup to “allow zero price” because zero-price lines are generally already allowed; if your system blocks it, that’s usually due to customization or validation logic, not base Business Central. Also, entering 0 is different from leaving the field blank. So in short: zero sales amount with non-zero COGS is possible in standard BC for item lines.
    Regards,
    Oussama Sabbouh

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,894 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,086 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 626 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans