[INV] Inventory Onhand History (Daily)

There is a way to trace back the history onhand quantity for certain item code.Go On-hand, Availability->Inventory Positions->Build, we can build a image of item onhand history by given it a name (Data Set), we can view it online and also save it. Bucket size can go down to Hour level, it means it shows history onhand by hour.Thanks for Mohammad's input.

[SYS] Time Zone Conversion

I created a sale order, checked order header record history, the "Update Date" is differs from the last_update_time in oe_orders_headers_all, why?Check the system profile values for Client Timezone and Enable Timezone Conversions, any time zone setup in these profiles will get reflected in the front-end display of time related records.Note: Backend time is always consisitent.

[INV] Wrong Item Code Used in IR, ISO had been Shipped, How?

Wrong Item Code, ISO been shipped, but receiving for IR is not done yet. Anyway quick way to fix?First of all, there is no RMA and RTV functions available for IR-ISO, this is a very BIG design gap.Workaround 1:Receive the wrong Item Code. Create a reversal IR-ISO.Workaround 2:Miscellaneous Receipt back quantity to Shipping Organization, make sure Credit Account is correct. Final Close the IR.

[OM] No Delivery Detail Found

After Ship-Confirm action, shipping line status is Closed, Interface Trip Stop program completed Warning, with warning message "No Delivery Detail Found" in the log file.

Where to rectify this?

Ans: Go Inventory responsibility, Transactions->Transaction Open Interface, check for any errors in the shipping organization. Rectify from there.

[OM] Pick Release in Shipping Transactions Form

This is an alternate way to perform pick release at a place other than Release Sales Ordersform.

Shipping->Transactions

Only Lines/LPNs tab is enabled, other tabs like "Delivery", "Path by Stop" & "Path by Trip" are disabled as picking is not done yet. Go "Action" LOV, choose "Launch Pick Release", clickGo button.

[OM] Internal Requisition Approved, Internal Sales Order Created and Picked, Need to Cancel All, How?

Ans: First perform backorder for ISO, cancel the ISO, then cancel the IR. Do remember to move back the inventory from staging to picking.

[OM] Cancel Order Does Not Appear on Shipping Transaction Form

Cancelled order does not have Pick-Up date attached. That's why when user enters Pick-Up date as parameters, no record shown.

[OM] Ctrl+Click and Shift+Click

At the Order Organizer form, we can perform multiple lines selection at the line level using hot key Ctrl+Click and Shift+Click.

This is useful if we need to perform the same Actions across all order lines. E.g. I wanted to release multiple order line holds all at one go. I click on the first row, move my mouse to the end row, press Shift+Click, all order lines will be selected with highlight color blue. Then, I proceed to Actions button to perform Release Holds action. This action will be applied to all selected order lines.

[PO] RCV: Processing Mode

System Profile "RCV: Processing Mode" decides the processing mode for receiving transactions, it can be either in "Batch", "Immediate" or "On-line" modes. It is reflected in RCV_TRANSACTIONS_INTERFACE.PROCESSING_MODE_CODE field.

[INV] Lot Expiry Date Maintenance

Yes, we can change the item lot Expiry Date without having to transact out and transact in the same item.Go On-hand, Availability->Lots in Inventory responsibility.

[BOM] Why Material Appears in Work Order, but Not In BOM?

A very common "overlook" - Should check the Indented Bill of Material, it should appear in another level.