Error "Unable to generate next number for ARINVOICE sequence"

Hi @mohamed1walha ,

Can you please verify below details configured for IN order type in Order Types screen ?

 

Hi @mohamed1walha,

To confirm the shipment, can you please try with the below code and try to create invoice. If the above is NOT same as this?

Please ignore this code, if it is same as above
 

SOShipLine sOShipLine= PXSelect<SOShipLine, Where<SOShipLine.shipmentNbr, Equal<Required<SOShipment.shipmentNbr>>>, OrderBy<Asc<SOShipLine.shipmentNbr, Asc<SOShipLine.sortOrder>>>>.Select(soShipmentGraph, soShipmentGraph.Document.Current.ShipmentNbr);
                            SOShipLineSplit sOShipLineSplit = PXSelect<SOShipLineSplit, Where<SOShipLineSplit.shipmentNbr, Equal<Required<SOShipLine.shipmentNbr>>, And<SOShipLineSplit.lineNbr, Equal<Required<SOShipLine.lineNbr>>>>>.Select(soShipmentGraph, soShipmentGraph.Document.Current.ShipmentNbr, sOShipLine.LineNbr);
                            PXAutomation.CompleteSimple(soShipmentGraph.Document.View);
                            PXAdapter adapter2 = new PXAdapter(new DummyView(soShipmentGraph, soShipmentGraph.Document.View.BqlSelect,
                                                 new List<object> { soShipmentGraph.Document.Current }));
                            adapter2.Menu = "Confirm Shipment";
                            adapter2.Arguments = new Dictionary<string, object>();
                            adapter2.Arguments.Add("actionID", 1);
                            soShipmentGraph.action.PressButton(adapter2);
                            TimeSpan timespan;
                            Exception ex;
                            while (PXLongOperation.GetStatus(soShipmentGraph.UID, out timespan, out ex) == PXLongRunStatus.InProcess)
                            { }

@mohamed1walha, How you are creating a shipment? is it through code level or screen level.

if it is code level, can you please share the code here?

@mohamed1walha I’m NOT sure, why you are getting that issue. We are using the below code to Create and Confirm the Shipment and the code is working as expected.

Please find the code here

private void CreateAndConfirmShipment(int? siteID, string orderNbr, SSShipNotice shipNotice, SSSetup settings, SSLoggerProperties loggerProperties)
        {
            SOShipmentEntry newshipmentGraph = CreateInstance<SOShipmentEntry>();
            DocumentList<SOShipment> created = new DocumentList<SOShipment>(newshipmentGraph);
            SOOrder order = PXSelectReadonly<SOOrder, Where<SOOrder.orderNbr, Equal<Required<SOOrder.orderNbr>>, And<SOOrder.behavior, Equal<SOOrderTypeConstants.salesOrder>>>>.Select(newshipmentGraph, orderNbr);
            newshipmentGraph.CreateShipment(order, siteID, Accessinfo.BusinessDate, false, SOOperation.Issue, created);

            SOOrderEntry soOrderGraph = CreateInstance<SOOrderEntry>();
            order = PXSelectReadonly<SOOrder, Where<SOOrder.orderNbr, Equal<Required<SOOrder.orderNbr>>, And<SOOrder.behavior, Equal<SOOrderTypeConstants.salesOrder>>>>.Select(soOrderGraph, shipNotice.OrderId.Text);
            soOrderGraph.Document.Current = order;
            PXAutomation.CompleteSimple(soOrderGraph.Document.View);
            soOrderGraph.Save.Press();
            string ShipmentStatus = string.Empty; 

            ConfirmShipment(created.FirstOrDefault().ShipmentNbr, out ShipmentStatus);

        }



 private void ConfirmShipment(string ShipmentNbr, out string status)
        {
            var graph = CreateInstance<SOShipmentEntry>();
            graph.Document.Current = graph.Document.Search<SOShipment.shipmentNbr>(ShipmentNbr);
            graph.lsselect.UnattendedMode = false;
            PXAutomation.CompleteSimple(graph.Document.View);
            PXAdapter adapter = new PXAdapter(new DummyView(graph, graph.Document.View.BqlSelect,
                                 new List<object> { graph.Document.Current }));
            adapter.Menu = SSConstants.ConfirmShipments;
            adapter.Arguments = new Dictionary<string, object>();
            adapter.Arguments.Add(SSConstants.Action, 1);
            graph.action.PressButton(adapter);
            TimeSpan timespan;
            Exception ex;
            while (PXLongOperation.GetStatus(graph.UID, out timespan, out ex) == PXLongRunStatus.InProcess)
            { } 

            if (graph.Document.Current.Status == SOShipmentStatus.Open)
            {
                bool? iscompleted = false;
                foreach (PXResult<SOOrderShipment, SOOrder> result in graph.OrderList.Select())
                {
                    SOOrder order = result;
                    if (order.Status == SOOrderStatus.Completed)
                        iscompleted = true;
                }
                if (iscompleted == true && graph.Document.Current.Confirmed == true && (graph.Document.Current.ShipmentType == INDocType.Issue && graph.Document.Current.UnbilledOrderCntr > 0 && graph.Document.Current.BilledOrderCntr == 0 && graph.Document.Current.ReleasedOrderCntr == 0 || graph.Document.Current.ShipmentType == INDocType.Transfer))
                {
                    graph.Document.Current.Status = SOShipmentStatus.Confirmed;
                    graph.Document.Update(graph.Document.Current);
                    graph.Save.Press();
                }
            } 
        }

Sure. But we do not have any issues with above. You can try and verify and create the Invoice because this code is working for us.