3 Replies Latest reply on May 9, 2013 8:34 AM by philmodjunk

# Different Job Types and Invoice Calculations

### Title

Different Job Types and Invoice Calculations

### Post

Hi Everyone,

I work for a fine art printing company and am trying to create a system that incorporates our affiliate sales and also our custom printing jobs in the same system. I am running into trouble trying to figure out the best way to handle invoicing calculations to accomodate for both of these different job types.

With our affiliates we have a set number of sizes with their corresponding costs. So in my affiliates table I have the sizes with their prices in the same table , so I can use related value lists and calculated value fields to pull in that information and then sum them in a subtotal field

But when we have a custom client come in, we evaluate the pricing based on the custom size of their prints. So i'll have a field for width and height and then the subtotal field should use those fields along with our price per sq. inch costs to come to a total.

My question is should the subtotal and grand total fields be conditional calculations or should I have 2 different subtotal and grand total fields (1 for either a affiliate sale or a custom sale) that evaluate based on the layout or something along those lines.

Any insight will be appreciated.Thank you in advance..

• ###### 1. Re: Different Job Types and Invoice Calculations

Are you sure that you can't use the same set of tables, relationships and fields for both?

If you have set this up so that auto-enter settings copy the pricing data from related tables into number fields, you also can simply edit the same fields to enter data for a custom job and with the right relationships, you could, if necessary, prevent values from looking up when you designate the job as "custom" by selecting a value in a field.

• ###### 2. Re: Different Job Types and Invoice Calculations

Well, I wanted to have 2 different layouts, 1 for an affiliate order and 1 for custom orders, since some fields for affiliate sales are irrelevant for custom sales and vice-versa. But then I run into the issue of the "evaluate this calculation from the context of" layout issue, since there will be two different layouts. Do you have any advice for this?

• ###### 3. Re: Different Job Types and Invoice Calculations

You can use two different layouts and still use the same fields for your pricing data.

The context of drop down is specific to a Tutorial: What are Table Occurrences?, not a layout so the layout is not a factor in how the calculations evaluate, both layouts can have the same table occurrence.