Hi,
I have an addon that is creating orders within SAP B1.
A problem I have is that some customers don't send a quantity but just a total price.
What I am trying to do is create a formatted search in the RDR1.Quantity that does a calculation for me based on the info it fills in.
So I would like it to take the total price (RDR1.U_ZSPS_BuyerPrice) and divide by the business partners special price for the item number.
Can anyone assist?
Regards
Lance