TheInfiniteJDEst
Member
Hi all,
Sorry if this is a very basic/silly question.
The Goal
I'm looking (in the JDE 910 Schema) for either:
I've been unable to find anything that directly corresponds to a 'Net Sales' column in www.jderef.com. So I suppose I need to follow the approach in (2) and calculate this field?
Using:
[Net Sales] = [Gross Sales] - [Item Returns] - [Item Allowances] - [Item Discounts]
I set out to try and find columns corresponding to everything in the right hand side of the equation.
These are my results thus far:
All the best,
Sorry if this is a very basic/silly question.
The Goal
I'm looking (in the JDE 910 Schema) for either:
- A table and column corresponding to Net Sales for items sold; OR (if a single Net Sales column does not exist)
- Tables or columns that would contribute to the calculation of Net Sales.
I've been unable to find anything that directly corresponds to a 'Net Sales' column in www.jderef.com. So I suppose I need to follow the approach in (2) and calculate this field?
Using:
[Net Sales] = [Gross Sales] - [Item Returns] - [Item Allowances] - [Item Discounts]
I set out to try and find columns corresponding to everything in the right hand side of the equation.
These are my results thus far:
- Gross Sales: F4201.SHOTOT
- Item Returns: F0029.TFSRET (I'm not sure about this one.)
- Discounts: F4201.SHTRDC
- Allowances: (I couldn't find anything unfortunately.)
- Rebates: F4078.RHRBAM or F4079.RHRBPA
All the best,
Last edited: