Steps
- Catalog –> Get to columns and filters.
- Change defaults tab to criteria
- save as
- give a proper name for result
- change all columns and filters as necessary.
- save again
- go to results then.
- export results. if > 2500 : export to csv.
- Edit the sheet
RMS Sales recon
Tran data
- In tran_data we have item, units, tran_code as major fields.
- if it belongs to a pack, then it has a ref_pack_no which is a packitem object.
Packitem
- It has pack_no and seq_no as main fields: seq_no for multiple items in a pack and make it unique.
- it has item inside it
- item_parent if available.
- either item has to be there or item_parent has to be there. Both can’t be null.
- pack_qty has quantity of items.
Packitem breakout
- pack may contain a pack, if so the nested pack and it’s items are inside packitem breakout table.
- similar to packitem
- COMP_PACK_NO: Contains the inner pack item number if a pack item is added to an outer pack.
- COMP_PACK_QTY: This field is null if comp_pack_no is not populated. Else if comp_pack_no is
populated then this field contains the quantity of comp_pack_no in a pack_no.
- pack_item_qty –> has quantity of each item in pack: if item_parent assoc with pack with no inners directly multiplying pack_qty of item_parent with quantity of item in pack template. if item_parent is assoc to pack that has outer pack –> outer_pack * inner_pack * qty of item in pack template.