RE: What is the limit of line items on a Purchase Order?

I have a project that is going to require very large quantities of individual items on purchase orders.  Does anyone know the limit of items a single PO can contain?

KAJ710 Rookie Asked on October 31, 2019 in Purchasing.
Add Comment
3 Answers

Out of curiosity, I tried this from a dev console to see how many I could add and I found that using the following code:

 

var rec = record.create({type: record.Type.PURCHASE_ORDER})
rec.setValue({ fieldId: 'entity', value: 24})
rec.setValue({ fieldId: 'trandate', value: new Date()})
for(var i = 0; i < 200; i++){
    rec.setSublistValue({
        sublistId: 'item',
        line: i,
        fieldId: 'item',
        value: 9931
    });
    rec.setSublistValue({
        sublistId: 'item',
        line: i,
        fieldId: 'cost',
        value: 1
    });
}
rec.save();

 

I successfully made 200 and 400 line item orders, but 600 never popped out the order. Now this is from the console, so it might be different in a script, but at least that might give you a ball park.

FYI, the time difference between 200 and 400 was a few minutes, and the page loads for bringing the purchase orders up wasn’t pretty.

Beginner Answered on October 31, 2019.

Scratch that 600 did save; it just took a solid 20 minutes. To be honest, I’m not going to sit around waiting for 800 or 1000, but feel free to try it yourself just replacing the item id and the integer in the for loop for testing.

on October 31, 2019.

Thank you sir!  We actually have a script that will be creating the massive orders… from another source.   So a wait time for big ones won’t be an issue!

I almost forgot…. THANK YOU!!!! 

on October 31, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.