I’ve been tasked with putting a check in the system for AR Invoices that are posted with zero values on part numbers.
The simplest way I can think of is to put a check on the posting stage and if the criteria isn’t met, chuck it back (or at least that’s the idea I have in my head)
Does someone know where I’d need to put this check in the system? i.e. if I can do it via Method Data Directive, what Service / Directive would I need to be looking for?
It’s only my second time trying to put validation into the system, so the learning curve is quite steep!
Do you mean lines with a price of $0 or cost of $0 or quantity of 0 or ???
Wouldn’t it be simpler to figure out where the zeros are coming from and solve the problem further upstream?
Not all lines do. It’s a quirky business to say the least. But the idea is that if the customer has a price list it pulls through the necessary price, but if they don’t, it comes through at 0 and is then amended at invoice before posting
Why couldn’t the pricing be corrected earlier in the process? Like during sales order entry? Doesn’t this mean your invoices don’t match your sales order acknowledgements and that all your sales reporting is wrong, if prices are being modified only on the invoice?
Just to update. Found an alternative solution that works.
Set it up so that the person raising the groups, when they try and post, it sends an email to an approver (notifies the user this has been done) with the group name and value, for them to review, and post.
Essentially it changes process from one person being accountable and responsible, to segregating it.
