Sage 100

I have a customer that would like the extension amount in Sales Order Entry to be reduced by the backordered amount. So instead of ordered x price = extension, they would like ordered - backordered x price = extension. Is there a way to do it?

They want this on the panel or on paper? On the panel, I would go with a UDF that is filled by a script. By changing the actual extension field, you are impacting a ton of reports. What is the business reason given?

They give the sales order to the customer instead of the invoice (they make invoice number = sales order number). They use the sales order because they deliver liquids and sometimes they can't fill a tank with the quantity ordered. I suggested using Invoices, but then I got all the reasons that wouldn't work (COD deliveries and no one there to give a check so delivery not made, etc). Suggested just changing the Crystal form to a formula that would show the reduced amount, but hiccup could be the calculation of sales tax. I was hoping there was a setup option I was missing.

Does the sales tax amount vary by customer location or is it all one? You can still modify the form so that the sales tax field that appears is based on the UDF extended amount. True you MIGHT run into a rounding difference but charge that off to discount or something. I think want they want is doable with just modifying the Crystal form. I have client delivering eggs. They do something similar. SO is the invoice. SO # is bar coded on paper so when the SO comes back in, creating the Invoice number is via scan. Paperless e-mailing of invoices?? How about xKZero's route delivery software? Print out the invoice at time of delivery. Sometimes the client wants you to move a mountain when the goal could be obtained by moving a pebble with your toe.

I think my pebble is the Crystal form. At least it is worth a try!