You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a link from CST to CMR tables for transfer order related transactions?

Summary:

Trying to show receipt and cost accounting records that should be linked by a transfer order number.

Content (required):

I'm trying to create a query that shows receipt accounting data for transfer order picks and deliveries. I need to show the locator that shows in the completed transactions screen and the receipt accounting data and I don't see how to link the cmr tables to either inv_material_txns or cst tables for related transfer order transactions. Basically I need to show data from the completed transactions screen for transfer orders but I need to pull the GL entries and cost from receipt accounting. Can anyone help me out?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!