Transfer in receipt of purchase orders (transfer)

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.