Hi All,
I am encountering a situation where reconciling Shopify payments seems to be a challenge. We are a custom furniture manufacturer that sells entirely on Shopify, and we're switching to Business Central from QuickBooks Desktop. I've read and understood the passage in Microsoft learn where you set up an interim (in our case, a bank account) account for orders to go into, and then from there you deduct from that account into your bank account and merchant fee G/L account when the payout hits the actual bank account.
Our issue in this scenario is that it takes us weeks from the time of order to shipping out the product, so I cannot hit post-> ship and invoice, or else it will mark it as shipped, and it wouldn't be. I've tried to just post -> invoice, and I repeatedly get the error that there is nothing to invoice, and I'm unsure how to get past it. We currently have it set up to create each order as a sales order and have it released, so I have it figured out up to that step of the process.
Our ideal situation is that the order would be created as a sales order, we would then invoice it (so it would hit the "SHOPIFY" bank account), then when we go to ship it out it would allow us to mark it as shipped, then the last step would be when the payout hits, we just go in and deduct from the "SHOPIFY" bank account and add to our bank account and merchant fee GL account. This all seems like it is unable to work due to the issue I'm encountering when trying to just POST -> Invoice the order.
Am I doing something wrong here in the setup, or is there an easier way of doing this? I'm new to Business Central and have a good understanding, but I feel like I'm just missing something while setting this up. Please let me know if there is anything you need to know about our setup, and I appreciate all of the help!!!
