When settling sales from shopify in business central, the cash receipt journal is used to balance the transactions and post to the GL. Currently, all the transactions are synced but our company settles per device per staff member. There's filters available for the transactions but not the device ID or Staff name fields required for the above functionality.

As of the 01-2026 API release, Shopify has included these fields to the transactions however, they aren't included in business central as yet. I setup the dev environment to make the changes to the query, table, pages and submit the pull request but I can't test because I'm having issues authenticating to shopify from the BC container and would probably be too much work to fix currently.

The file with the query is the ShpfyGQLOrderTransactions.Codeunit.al file and the corresponding table and pages objects would need to be modified. Then maybe the filter modal on the cash receipt page.

I think this would benefit more companies as well working with Shopify POS with regards to settlements.

If anymore has additional requests on this topic, please share them as well.