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...
Suggested Answer

Special item price is not enabled with recurring sales invoices

(0) ShareShare
ReportReport
Posted on by 46

Hi all,

I have a problem with special prices in relation to recurring sales invoices.

I have an item in Business Central which does not have a fixed unit price, rather it is very unique and it depends on the customer that we sell it to. It is some sort of contract which has a different price depending on the arrangements made with the customer and therefore it also has a special item price. Hence, I have set up the special price for this item at every customer card for the customers we sell this 'item' to.

Now, this item is invoiced monthly (it is a monthly contract) so I have enabled 'Recurring sales invoices' for these invoices. However, when these invoices are automatically created every month, the special item price for some customers is not always filled in at the sales invoice lines. The 'Unit price' field for this item is left entirely blank. This is a large concern for me, as sometimes I accidentally post and send these invoices to our customers when there is no unit price filled in for this item.

The odd thing here is that it does only occur for some customers and not for all of them...

If anyone could help me out with this and knows how to solve this, then that would be very much appreciated!

Kind regards

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    133 on at

    The comment around it works for some customers and not for others makes me think it’s setup. If you raise a manual invoice or sales order for one of the customers this happens with do you get the same result? Once the pricing has been verified as an extra safety net you might want to add an approval request. This is assuming you create a single line invoice where you can check if the total is 0 then an approval is needed. This might act as the extra user prompt to be “hey, why is an approval needed?!”

  • CU17101358-0 Profile Picture
    46 on at

    Hi,

    If a raise a manual sales invoice/sales order and select the item for one of these customers, the special price does load perfectly. However, if I manually make a new sales invoice/sales order and select the periodic sales invoice card which includes this item, then the special price does not load..

    I like your idea with the workflow, but unfortunately this does not work for me as other items are also included on these invoices, so the total price will always be more than 0.

  • Suggested answer
    Marco Mels Profile Picture
    on at

    Hello,

    I ran the scenario in CRONUS company (SaaS release), but I am not able to reproduce. Is there customization involved or is this reproducible in an unmodified CRONUS company?

    Thanks.

  • CU17101358-0 Profile Picture
    46 on at

    Hi,

    Thanks for your reply. No I don't have any customizations in my Business Central environment, hence I think it is reproducible in an unmodified CRONUS environment. However, it may be hard to reproduce the issue in a test environment as, like I mentioned, the problem is very random and it only does only occur for some customers.

    Maybe the only solution for me may be to delete the current recurring sales invoices and make new ones, and find out whether that does still give me issues or not.

  • Suggested answer
    Marco Mels Profile Picture
    on at

    Hello,

    That is correct, these are the hardest ones to resolve when it does not happen all the time. Feel free to raise it if a new recurring one does have the same experience.

    It could be a very well hidden bug that shows up under specific circumstances.

    Thanks.

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,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans