Question

Apply a portion of Customer Advance Payment to Invoices

  • 10 August 2022
  • 4 replies
  • 414 views
V
Rank
Userlevel 2
Badge +6

Hello,

In IFS Apps 10, when the customer makes an Advance payment, the advance is applied to the subsequent invoices to pay them in full until the advance is fully consumed.  We need to be able to apply a portion or percentage of the advance to the subsequent invoices.

For example, an advance payment is made on an advance invoice for $100, the subsequent invoice for delivered goods is $100, we would need to apply $50 from the advance and the customer would be responsible for the remaining $50.  The same is done on the next invoice.  Instead, IFS applies the full $100 advance to the first invoice. 

We looked at trying to do this in the Installments window but there is no option to apply a portion of the advance to the invoice.

4 replies

M
Rank
Badge +1

This option is available in the Instant Invoice Module ( i checked in IFS 9 )where you can  amortize the portion of Advance amount (partially ) to all the Subsequent Invoices.

 

 

V
Rank
Userlevel 2
Badge +6

Thank you for the reply.  Does this work for Customer Order connected Advance Invoices?  When the subsequent shipments are made on the customer order and invoicing can be done, what is the process for using an Instant Invoice to apply the advance?  Instant Invoices are not order-connected and we need a solution for applying a portion of the advance invoice/payment to the subsequent CO shipment invoices.

A
Rank
Badge +2

HI @VCook 

did you find out any solution to this? we have similar issue and i dont think we have any standard functionality available currently. 

V
Rank
Userlevel 2
Badge +6

We had to use a complicated work around:

1. Enter Customer Order.
2. Create Adv Invoice from Customer Order screen for total amount of customer prepayment.
3. Create Payment on Account equal to the prepayment amount (not connected to the previously created AD invoice).  Use Mixed Payment or other method to create the CUPOA for the customer’s account.
4. Release Order line 1 and Deliver/Close Shipment.
5. Create Customer Offset to apply portion of CUPOA to the ADV Inv.
  -Enter CUPOA 1st (Series ID, Inv # and change amount to the desired prepayment amount to apply to next invoice as negative amount)
  -Enter AD Inv in next line (Series ID, Inv # and change amount to prepayment amount as positive amount)
  -Remaining amount should be $0

 -System will automatically create a CUPIA to apply to the next customer invoice.

6. Create customer Invoice. System will automatically apply the CUPIA to the invoice which is visible on the printout.

Net open amounts are visible by RMB on the Invoice to Installments.

CUPOA should = AD invoice amount in Customer Analysis. This represents remaining available Prepayment to apply to next invoices on the order.

Reply


Terms & ConditionsCookie settings