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