Our business accepts returns of empty pallets and we issue a Credit Memo to the customer, because these pallets could be from multiple orders and we don’t know which ones we never include a Sales Order or Ref Invoice in the CM. When Epicor runs the ‘Process Finance/Late Charges’ it looks at the invoices that are late and produces a Finance Charge invoice for that customer. These Fin Charges are too high due to the credit the customers have on account but without having each CM referencing an invoice the process doesn’t take it into account, even with the CM checked off in the FC settings.
I made a query to do the math and only take into account the invoices we want, this works well but then we went to update the UnitPrice in these FC invoices and there’s an error, it won’t let us change the UnitPrice on FC invoice types.
I guess my question is, what should i do, am i missing something?