You’re offline. This is a read only version of the page.
Announcements
34
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
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.
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.
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.
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.
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?!”
#1
André Arnaud de Cal...
294,208
Super User 2025 Season 1
#2
Martin Dráb
232,970
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
