Laurie Baldwin
Forum Replies Created
-
I was actually just complaining about this recently, we experience the same issue and I do have to run the delete invoiced purchase orders which I haven’t set up in a job queue yet but I run it once per month. I’d also like to have the system automatically consider a PO received/invoiced after a majority of the lines have been received but I haven’t figured out how to do that. We have one PO with one line that has a quantity of 25 left and our of 1,050 on the line and about 2,000 total on the order and the only way I have found to get rid of it is to manually delete it which is not ideal.
-
Joseph – Looks like no one replied to this however back when we went live in 2023 I ended up coming across this exact question on a different forum and unfortunately there just are not great out of the box reports for Business Central that include lot number. Our financial reporting expert was able to create a Power BI report for our inventory team with the fields you mentioned here and I think that is likely the only way it can be done. Including a screenshot of the tables he included that he made relationships between. We have multiple companies in Business Central which is why there are a few General Ledger Entries tables here and I’m not entirely sure why he included them all as inventory transactions only flow through one company currently but I assume he did this in case anything changes in the future. If you have other questions let me know I can try to help or ask him to see if he can provide a quick answer.
