Comments
Peter's idea would be great or adding a new Price List Line Type of “Price List”, allowing one price list to reference another (similar to how Production BOMs can reference other BOMs). Base logic would still work properly where the system finds the "best price".We maintain a base price list assigned to 'All Customers' as a catch-all, then apply multiple discount layers based on the volume of business with each customer. While the current combination of base price list, customer price group, and item discount group covers most scenarios, it falls short for some of our larger customers.
For CPA Australia, we raised this issue because running the Accounts Payable Foreign Currency Revaluation process updated the vendor balances which triggered an update in the payment status details on the underlying expense reports. This is not the correct behaviour because no payment has been made to the employee.Additionally, because of the initial update to the Expense Reports, when the real vendor payment was made and posted, the Expense Report details would not display the correct payment date and voucher because the system is recognising multiple payment/settlement transactions linked to the expense report/s.Our organisation operates in a multi-national / multi-currency environment with revaluations occurring for both local accounting currency ledgers and reporting currency ledgers as well, so the impact is widespread for us when there are un-paid expense reports at the end of the month.It would be of great benefit for us to not have to compromise our accounting policies for how and when we run revaluations in order to get around this issue.