Skip to Content
0
Former Member
Feb 11, 2011 at 10:04 PM

Invoice Plan and Quantity Discrepancy

231 Views

I'm not sure if this belongs on this forem or the financial forum but since it involves POs and an MM transaction(MIRO) I decided to post it here.

We have an IR Only Purchase Order with multiple line items. The PO Order Quantity varies from 1 EA up to 6 EA on 34 different line items. An invoice plan manual invoice plan sing "Sample Partial Invoice Plan(20) as the Invoice Plan Type. The payments are split 30% - 30% - 30% - 10% with each payment due on a specific date.

So here is the problem:

When the first invoice was processed for 30% it assigned a "quantity of 1" on each line item in the invioce. This is affecting the Commitment dollars left on the order. For example for the line item with 4 EA in the PO quantity, the commitment dollars only dropped 25% of the 30% total for that line. So let's say the line item wa for $100,000 it should have reduced the commitment amount by $30,000. Instead since the invoice quantity defaulted to 1 it only reduced the commitment amount by $7,500.

This same ratio type posting occurred on each line item that had more than 1 EA on the PO. It appears that when processing the MIRO it will not allow one to change the quantity to the PO Order Quantity. Does anyone know how to change the quantity on the Invoice or is there a way to get the whole line item quantity to default onto the invoice when a payment is due?

Thanks in advance for your help,

Dan