Cost of Sales

Kinetic ERP
1

Hello Epiusers … I am trying to create a cost of sales by item report. I would like to report:

Name of Sales Kit 1
- Sales Kit1 Item 1
- Sales Kit1 Item 2
- Sales Kit1 Item 3

Name of Sales Kit 2
- Sales Kit2 Item 2
- Sales Kit2 Item 2

The report layout consists of other columns like Qty Sold, Avg price, Avg Cost and so on.

The challenge I am having is I am not able to identify the necessary tables to retrieve this info in a similar format as listed above. How can this be done?

Thanks

2

Use field help to identify what tables you need.
image

1 Like
3

Normally InvcDtl would be your go-to…except I don’t see any fields in the data dictionary that refer to kits.

4

Thanks I see this…the kit component is where I am also stumped …how to associate a kit, with child components…

5

Maybe tie back to OrderDtl? I see some Kit fields in there.

(We don’t use them so I’m not kit-fluent…hopefully someone will chime in.)

6

Tracing kit components through can be difficult. If you are set for parent pricing, the data will be at the Parent and not at the component. If you have it on component, then the price and cost will be on each kit part.

The kit flag isn’t in InvcDtl, you have to join InvcDtl to OrderRel, OrderRel to OrderDtl. OrderDtl KitFlag of “P”= parent, “”= not a kit, “C” = component. You can join OrderDtl to another OrderDtl(Parent) on OrderNum, OrderLine and KitParentLine = OrderLine if that helps.

4 Likes
7

Thanks…this has been incredibly helpful…I will use this info …

1 Like
8

Be mindful of the Price type on the kit setups.

Join erp.invcdtl to erp.orderdtl via the key fields then filter on kitflag <> ‘’