Available quantity validation and product balances

When you enter a product on an issue, the Net Available quantity from the Product Warehouse Product Setup-Costs record in Distribution SX.e is retrieved. It is displayed in the Available field.

When quantity is available for issue, the sales order lines are designated with a 'C' or 'Customer', or 'D' or 'Distributor', inventory type. Lines with customer-owned products do not have a price or cost associated with them. Lines with distributor-owned products are billable. When quantity is not available for issue, you can create a back order to obtain the product. Back-ordered lines are designated with the D inventory type.

As customer- and distributor-owned inventory is issued, the balances are updated on Product Warehouse Product Setup records. Inventory transaction records are created for each type of order line in separate internal tables. The ICET table is updated for distributor-owned transactions, and the ICETC table is updated for customer-owned transactions. Because of the separate tables, you can inquire on C or D transactions in Product Inquiry.

These measures prevent over-issue of products:

  • Net Available validation at issue submission

    To prevent over-issue of products by users in multiple browsing sessions, the Net Available quantity for the products is retrieved again when you submit the issue. If the quantity retrieved during submission does not equal the quantity retrieved when you entered the line, an error occurs. You are informed which line contains the discrepancy. The Requested and Issued quantities are set to zero, and the Available amount is updated with most recent value from Distribution SX.e.

  • Multiple line restriction per product

    If you attempt to add a product to an issue that is already included on the issue, you are redirected to the Requested field for the existing line so you can change the amount. If you increase the requested quantity and it exceeds the available quantity, you can create a back order or send unavailable quantity to lost business.

    This restriction prevents you from requesting amounts that as individual lines do not exceed the available quantity, but as combined amounts, exceed the quantity available.