I'm working on transforming purchase orders into partial vendor bills but am encountering an issue with setting the correct quantity to invoice. My approach is to loop through the items in the purchase order (PO), removing any that aren’t included in the vendor bill, and setting the invoice quantity to the partial amount we intend to bill. Here's the code I'm using:

// Process each item in the Vendor Bill based on vendorBillData
for (var i = bill.getLineCount({ sublistId: 'item' }) - 1; i >= 0; i--) {
    bill.selectLine({ sublistId: 'item', line: i });
    var itemId = bill.getCurrentSublistValue({ sublistId: 'item', fieldId: 'item' });

    var itemData = vendorBillData.items.find(function(item){
        return item.item == itemId;
    });

    if (itemData) {
        // Set quantity to invoice if it's different from the full quantity
        var fullQuantity = bill.getCurrentSublistValue({ sublistId: 'item', fieldId: 'quantity' });
        var quantityToInvoice = Math.min(itemData.quantity, fullQuantity);
        log.debug("@fullQuantity", fullQuantity);
        log.debug("@itemData.quantity", itemData.quantity);
        log.debug("@quantityToInvoice", quantityToInvoice);
        bill.setCurrentSublistValue({ sublistId: 'item', fieldId: 'quantity', value: quantityToInvoice });
    } else {
        // Remove the line if not found in vendorBillData.items
        bill.removeLine({ sublistId: 'item', line: i });
    }
}

However, despite setting the quantity to invoice, it’s still billing the total amount for each item in the PO instead of the specified partial quantity. Any insights on why this might be happening or how to ensure the correct quantity is invoiced?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you're encountering a common issue when trying to create partial vendor bills from purchase orders in NetSuite. The problem seems to be related to the way NetSuite handles the quantity field when transforming a purchase order into a vendor bill. In the first thread, the user was trying to create a vendor bill with a quantity less than the quantity on the purchase order line. They were getting an error message stating "The total inventory detail quantity must be 40." Despite trying to hardcode the quantity and disabling other scripts and workflows, the error persisted. The user found a workaround by modifying the item receipt lines quantity to be the same as the vendor bill. In the second thread, the user was trying to change the quantity of a line item in a vendor bill based on values in the corresponding purchase order. Despite correctly calculating the values and using

forceSyncSourcing

, the quantity field was not updating as expected. In the third thread, a user was looking for a way to do partial billing based on amount rather than quantity. A suggestion was made to swap the quantity and rate fields in the purchase order to handle partial receipts and billings later on. Based on these discussions, it seems like there might be some limitations or quirks in NetSuite's handling of quantities when transforming purchase orders into vendor bills. You might need to experiment with different approaches, such as modifying the item receipt lines quantity or swapping the quantity and rate fields, to find a solution that works for your specific use case. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******