Sage X3

Question

Hi 
 We have a client who is using v7 X3 and would like to do partial shipments of orders as the stock is available. 
 They have requested that the delivery show the original ordered qty and then if a particular line cant be shipped the value of delivered Qty be 0. This showing that there are products still on backorder. 
 I have searched the parameters and cant seem to locate anything like this, every time I do a deliver it wont allow you to leave qty as 0 for any items we are not actually delivering. 
 So in simplet terms, client wants the order in the system, but each delivery to reflect the original order qty for all lines and then a delivered Qty. 
 
 Has anyone worked a way around this. 
 Thanks 
 Stacey

RegularGuy · Accepted Answer

Depending on your level of experience with crystal reports: 
 I think I would probably edit the Delivery document (BONLIV) and use the corresponding fields from SORDERQ, 
 SORDERQ.SHTQTY shows the number "backordered". You'd probably have to change the grouping to SORDERQ instead of SDELIVERYD so that on BONLIV you could loop through the SORDERQ records, additionally if you don't want to reprint completely fulfilled lines, use a suppress filter. 
 Best of luck

Lexi Morton · Answer

In our case, no, we wanted 
 Example 1: 
 - Customer orders 10 widgets from site NA012 
 - 0 widgets exist in site NA012 
 - The ordered quantity stays at 10, the quantity on the shipment would reflect 0 shipped. 
 Example 2: 
 - Customer orders 10 widgets from site NA012 
 - 5 widgets exist in site NA012 
 - The ordered quantity stays at 10, the quantity on the shipment would reflect 5 shipped. 
 Example 1: We need a way to show the customer that we received their order and we don't have stock to fulfill it. We always have to refer back to order table from shipment or invoice (depending where we are looking or document we are printing) to see what was ordered if we don't have any stock available. In example 2, the partial shipment of 5 is fine when the 5 ships, but if we have a second shipment/invoice fulfilling other backorder items and these widgets aren't in stock, there is nothing to reflect that they are still on backorder. Only way around this that we found was altering crystal reports to reflect accordingly.

Delamater · Answer

@Lexi: Thanks, that makes sense to me. I checked to see if we have an enhancement on it already, I didn't see one already in place. This link is how you can get that enhancement built: www5.v1ideas.com/.../Top 
 This enhancement makes a lot of sense. 
 Bob

Sage X3 - Backorders

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING