kevinp2
Member
Hi,
I have looked around a lot, but cannot seem to find an answer for this.
I am a Business Intelligence developer and am writing a report that starts with the GL. For a given GL record, typically a sale, I can obtain the Bill To address easily enough (GLAN8). Is it possible to look up other tables to find the Ship To address for the transaction in question? I have tried joining to F03B11 (Accounts Receivable) but that table does not seem to contain any Ship To fields.
Any help is appreciated! I am a backend developer and am far from an expert on JDE's workings
I have looked around a lot, but cannot seem to find an answer for this.
I am a Business Intelligence developer and am writing a report that starts with the GL. For a given GL record, typically a sale, I can obtain the Bill To address easily enough (GLAN8). Is it possible to look up other tables to find the Ship To address for the transaction in question? I have tried joining to F03B11 (Accounts Receivable) but that table does not seem to contain any Ship To fields.
Any help is appreciated! I am a backend developer and am far from an expert on JDE's workings