We're trying to migrate sales invoices with inventory records from QuickBooks Desktop 2022 to Business Central. We attempted to use the Data Exporter Tool, but it's only compatible with QB 2017 and 2018. To work around this, we created a custom extension to import sales invoices, which includes creating sales headers and lines.
However, we're running into an issue with sales lines of type ITEM, as they require a warehouse location, which was not used in QB but is required in Business Central. When we try to post the imported sales invoices, we receive an error due to insufficient inventory.
One possible solution we're considering is importing purchase invoices first and then dealing with sales invoices. They are also dealing with BOMs
Is this the correct approach, or are there alternative solutions or best practices for importing sales invoices with inventory records into Business Central?
Any guidance or advice would be greatly appreciated!
