Parts Journal Report

The PAR044 report provides details of the parts costs of sales and parts inventory G/L allocations generated from the billing runs (when the parts system is active) for the current G/L month.

All parts sales fall into one of these categories, and all of these types of entries are shown on the report:

  • TRF.(T) ¯ Transfer—All transactions using non-stock code "T".

  • EST.(E) ¯ Estimate—All transactions with a NET COST on the Parts Profile tab (for that part number) that is less than .06 cents. Uses the cost percentage from the G/L chart of account maintenance screen for the sales account on that part number.

  • ACT.(A) ¯ Actual—AVERAGE COST on the Parts Profile tab for that part number.

The detailed report is sorted by: Company, Division, Inventory Account, Cost of Sales Account, Part# with totals for each Company/Division/GL Account/Type (T, E or A).

The IntelliDealer Parts Billing system performs the automatic costing of parts (relieves parts from inventory when sold). If the default cost of sales percentage is set up wrong, or if the wrong sale account is set up on a part number, then the wrong dollar amount will be relieved from inventory when the part is sold.

The Parts Billing system logic is:

  1. When the part is sold and the part number has an average cost of "5 cents or more", the inventory G/L account is credited at average cost.
    CO/DIV/BR/PARTNUMBER/STA...........01/01/01/T19044/A
    NET COST............................................irrelevant
    AVG COST............................................6 cents
    ON HAND.............................................irrelevant
    The Parts Store Priorities screen (for 01/01/01)...............01/01/02,01/02/01

  2. When the part is sold and the part number has an average cost of "1, 2, 3, or 4 cents", the inventory G/L account is credited at the default cost of sales % (on the sale account). CO/DIV/BR/PARTNUMBER/STA..........01/01/01/T19044/A
    NET COST...........................................irrelevant
    AVG COST...........................................4 cents
    ON HAND............................................irrelevant
    The Parts Store Priorities screen (for 01/01/01)..............01/01/02,01/02/01 54D 0

  3. When the part is sold and the part number has an average cost of "0 cents" either:

    • If the net cost is "5 cents or more" then the inventory G/L account is credited by the net cost on that part.
      CO/DIV/BR/PARTNUMBER/STA..............01/01/01/T19044/A
      NET COST...............................................6 cents
      AVG COST...............................................0 cents
      ON HAND................................................irrelevant
      The Parts Store Priorities screen (for 01/01/01)..................01/01/02,01/02/01

    • If the net cost is "less than 5 cents" then the inventory G/L account is credited by the default cost of sales % (on the sale account).
      CO/DIV/BR/PARTNUMBER/STA...............01/01/01/T19044/A
      NET COST................................................4 cents
      AVG COST........................................................0 cents
      ON HAND........................................................irrelevant
      The Parts Store Priorities screen (for 01/01/01)...................01/01/02,01/02/01

  4. When the part is sold out of a store that doesn't stock the part (part number does not exist in file PARTMAST for this CO/DIV/BR) then the inventory G/L account is credited by the net cost of this part in the next divison/branch according to the Parts Store Priorities screen even with a zero on-hand value. CO/DIV/BR/PARTNUMBER/STA....................N/A
    NET COST.....................................................?
    AVG COST.....................................................?
    ON HAND......................................................?
    The Parts Store Priorities screen (for 01/01/01)........................01/01/02,01/02/01

    CO/DIV/BR/PARTNUMBER/STA....................01/01/02/T19044/A
    NET COST.....................................................6 cents
    AVG COST.....................................................irrelevant
    ON HAND......................................................irrelevant

  5. When the part is sold out of a store that doesn't stock the part and the same part number is loaded in another division/branch (with a status 'D'), the part is still costed out at the net cost of the part in the other division/branch. The Parts Store Priorities screen decided which alternative division/branch it looks at first.
    CO/DIV/BR/PARTNUMBER...................N/A
    NET COST.............................................?
    AVG COST.............................................?
    ON HAND..............................................irrelevant

    The Parts Store Priorities screen (for 01/01/01)................01/01/02,01/02/01 CO/DIV/BR/PARTNUMBER/STA............01/01/02/T19044/D
    NET COST.............................................6 cents
    AVG COST.............................................irrelevant
    ON HAND..............................................irrelevant