Premise: the system is set to receive in three steps (receiving, inspection, and warehouse receiving)
Q: When can I perform the transfer operation?ProgramWhat should I do?
In the receiving process of a purchase order, after completing the first step of receiving (receive), you can perform transfer (transfer) before performing the second step of inspection-simply select the target type as the receiving;
After the second step of the test, you can also perform another transfer (transfer)-the operation method is the same as above. If the transaction is performed with the program after use, in this case, the transfer must be distinguished, because the transaction can be performed only when the parent_transaction_id is obtained.
Multiple transfer and multiple tests can be performed in the system, and the results of Multiple tests can be different.
If you want to retrieve records that have not been inspected or that have not been checked in the database, you only need to retrieve the number from the rcv_supply table in the intermediate process. The system automatically calculates the number of records during transaction processing, records with 0 records will be deleted. use rcv_transaction_id to correspond to transaction_id in rcv_transactions.
Select Rs. shipment_line_id,
Rs. quantity,
Rs .*
From rcv_supply RS,
Rcv_transactions RT
Where Rs. rcv_transaction_id = Rt. transaction_id
And Rt. transaction_type in ('receive ', 'transfer ');
The shipment_line_id group method is used for transaction processing.