Sage X3 - Backorders

SOLVED

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

Parents
  • 0

    I'm confused. Are you asking to diminish the original ordered quantity on the item should the quantity available for that product / site record be insufficient to ship?

    Example:

    - Customer orders 10 widgets from site NA012

    - 0 widgets exist in site NA012

    - Set the ordered quantity to 0

    Is that what you are asking or am I completely misunderstanding?

    Can you give a simple example please?

    Thanks,

    Bob

  • 0 in reply to Delamater
    verified 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.

  • 0 in reply to Lexi Morton

    >>Only way around this that we found was altering crystal reports to reflect accordingly.

    This thread is very old but it appears this is still an issue.

    On partial shipments and invoice on shipment, Items that are on a sales ordered but back ordered, and have no shipment of that item on that  invoice, do not show up on the invoice.  So it might be natural for the customer to question if the items "missing" are still on order.

    We are thinking of a modification to push ALL lines of a Sales Order to an invoice every time the invoice is created or perhaps a switch on the customer record to show back ordered unshipped item on invoices per customer preference. 

    Has anyone resolved this?  Someone mentioned that might have modified crystal to produce this. 

  • 0 in reply to Stephen

    Did you ever get this modification done? I have a need for the same requirement.

Reply Children