I think I know the answer to this, but I thought I would put it out there. Some months ago, we enacted a price increase for one of our customers. We created orders, shipped and invoiced all at the new prices. However, the customer continued to pay the invoices at the previous (lower) price leaving a large number of invoices under-paid. For some reason, this was allowed to continue. This has apparently caused the gross margin on the affected parts to be inflated (I believe they are costed off the shipped price or invoice price). Though the discrepancy may be addressed in the G/L, the users want the gross margins on the parts to be 'fixed' as well. The long process would be to delete the invoices (and any payments) and correct the price on the shipments and re-invoice. Or do a return on those shipments and re-invoice at the correct price. The number of invoices affected is in the 100s.
I wonder if anyone else has run into this situation and might have a less complicated approach. We have been in consultation with Infor on this.
Any input would be appreciated.
Mike Lavarnway
