R47011 - Orders with Over 1,000 Lines

[pfaloney]

We are integrating one of our divisions into JDE. One of the requirements is that they will feed Invoices (in the forms of 820 inbound) into our system once a month from their customized sales system.

However, there are a few Customers who have so much activity for the month that the number of lines go over 1,000.

We have been able to load the lines into the F47011 and F47012. However, when we go to run the R47011, we get the following error for all the lines 101 and above (we are incrementing by .1 for the line number):
---------------------------------------------
Insert into table F40UI74 failed:

Informational: Call From : FALONEY, PATRICK K
Contact :
Phone Number :
Tickler Date : 11/18/2011
Subject :
CAUSE . . . . The record being inserted into table F40UI74 already exists or you do not have authority to insert records into this table.
RESOLUTION. . Verify that the record being added doesn't already exist and that you have proper authority. Check the JDE.LOG and JDEDEBUG.LOG for additional information.
--------------------------------------------------
Is there a line limit for the number of physical lines a sales order has?

 

[Ralph de Joode]

Yes there is a limit of 999 sales order lines per sales order. You can build a function when you import the EDI document that it will be split when it has more than 999 detail lines or modify the R47011 that it split the order when it has more than 999 detail lines.

Good luck!

 

[pfaloney]

The problem is that the orders are coming from the division in question and cannot be split. They are not gonna like this.

 

[DBohner-(db)]

Patrick,

Can't the EDI Document Number be incremented every 999 Records and the line number be reset to 1?

Even if an organization has 10K lines, it only makes sense to break them down to 'something' that the sales team can manage (999 lines per Document).

When the organization is actually invoiced, you invoice for the total of all open 'Lines' regardless if there are actually 100 open Sales Documents.

Am I missing something? Maybe I'm just having a grey moment?

(db)