Hi Asanka - thanks so much for the advice. That has really helped clarify things. Tom
Hi Asanka Thanks so much for the help. In our Apps 9, I don’t see this option. I only see the following under Enterprise, Basic Data: There is an “Address Set-up per Country” screen (see below) but no Address Setup like yours? I don’t think we ever applied the final patch/release to our Apps 9. I wonder if Address Set-up was included in that?Any ideas?ThanksTom
In case anyone stumbles on this… I found another question on the forum that has the solution. SQL JOIN between inventory transactions and invoices | IFS Community
Typical 5 mins after posting I found customer_order_delivery_join view.This is where SOURCE_REF5 comes from in INVENTORY_TRANSACTION_HIST2So I think that solves my links from shipment/delivery to GL cost of sales Still trying to figure out unique link from delivery line to invoice line… Can’t be far off finding it.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.