Hello,
I am trying to create a report that will show all companies that have "Pay on Account" as a payment method selected. I see that this is under the sales_order_payment table. But that is not an option on my report builder.
Hello @haley_crusch
I think this will need custom extension to be developed or some custom development need to be done to fulfill your requirements.
Contact any certified Magento developer or Magento Agency who can build this for you.
If you want only the records then you can do one thing.
Just create a php script on the root folder and get all the companies who has selected "Pay on Account" as a payment method and run the script on the browser using yourdomain.com/phpfile
This ways you get all the data and you can copy the data from there.
Thanks