Good morning everyone. I am trying to create a new bom with a business event using a GI and an import scenario on a schedule. I am getting the error “The last error was Cannot generate the next number for the BOM sequence.”. To diagnose it easier, I exported the GI to excel and made a data provider, new import scenario, and used import by scenario to upload. i used the community post below to find a solution that worked. This post used option 1 in the below screenshot. It worked fine and created a new bom with the next autonumber with everything correct on it. I then made the change to the business event subscriber import scenario and I got the “cannot generate next number” error. I then tried option 2 below and the business event history shows that it ran successfully with no errors but it didnt actually create the bom. I saw another post where someone could only get the header to get created and had to add materials later so I tried making the GI as simple as possible and use only the inventoryitem table and only try to create a bom header also. It still didnt work. I know that business events with import scenarios can be a little finnicky sometimes, so I tried different combinations and different orders for the steps but i havent been able to get it to work. Does anyone have any suggestions?
