Hello. I'm currently using VendTrans table from D365 FO but it only shows CLOSED transactions, is there another table where i can get OPEN transactions with the same info as the VendTrans table or a specific configuration i need to perform for it to be able to register CLOSED and OPEN transactions?.
I already found the solution, you can close this. It was simple, the column CLOSED of the VendTrans Table isn't just an empty string but a placeholder date like 1900-01-01. So the ones that had that date of Closure should still be OPEN.
Was this reply helpful?YesNo
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.