Sage 100

Crystal Reports Help. Customer does not do partial shipping, they only ship complete orders. I am trying to create an S/O report that will evaluate each line of an order for Qty on Hand. If all lines have sufficient Qty then print the lines of the order, if 1 or more lines have insufficient qty, do not print any of the order lines. TIA.

Unless your customer intends to print one order, invoice it and post it one at a time, you will need to write a program (VBScript, VB or VBA for example) that captures inventory levels and logically depletes them as orders meeting their criteria are selected and printed. I've created this solution for a client that still uses it after 13 years. They are currently on 2016. It also has the ability to prioritize by a given percentage parameter by which an order can be filled (100% in your case). Of course, logically depleting the inventory levels dynamically as orders are selected is essential.

Thanks @DanBurleson. I would love to get pricing, demo etc on this. Although this looks really good, they just want a report to go out every morning to give them a quick snapshot of the possible Shipable orders. Depleting quantities is not a concern. It's more for staffing and getting an idea of many people they will need that day. But please do send pricing as this might be the only option if I can't get the report they want.

Maybe I wasn't clear. An example: If they have 100 of a particular item in stock and 10 single line orders for 100 of those items each, how many orders should print? If the answer is 1, then your solution would need to _logically_ deplete items; otherwise all orders would print. I can imagine doing this in Crystal for a limited number of items by using a sub report to load shared variables and deplete them in another sub report in the report (or group) footer, but one would still have to somehow reduce quantities available as sales orders are selected. Am I missing something? If you think you will use the depletion feature, I'll send you some pricing based on the features your client would use.

Dan, I understand the depletion logic but we were going to go without it just to get a rough idea of what can ship. The report was not going to be used for selecting orders. But I see that you program is a much better solution. Yes, please send me pricing. Thanks,