/
Entering Inventory Transactions in Job Cost
Document toolboxDocument toolbox

Entering Inventory Transactions in Job Cost

Owned by Documentation Reviewer
Last updated: Nov 25, 2019

If inventory items are used on a job, you can enter an inventory transactions with Job Cost detail. Unlike accounts payable transactions, you must enter a separate inventory transaction for each job you distribute amounts to. The Inventory module must have been purchased to enter inventory transactions. 

Step 1: Complete the item transaction entry window

  1. Choose Transactions > Inventory > Transaction Entry.

  2. Complete the window. See the Microsoft Dynamics GP Inventory Control Manual for more information. 

    You cannot use recurring batches with job inventory transactions. Only single-use batches are allowed.

  3. In the Trx Type field, choose the Job Cost radio button.
  4. Enter a Job Number. The Inventory Transactions window opens.

  5. Enter a Cost Code. If you enter more than one item on the transaction, you can choose Apply All to apply all inventory items to the same cost code. 

    To edit a transaction in the Inventory Transactions window, you must choose the Cost Code field to choose another cost code using the lookup button. If the Cost Code field is not selected, the lookup button will be disabled.

  6. Choose OK in the Inventory Transactions window. Transaction amounts distribute automatically to the posting account you assign to the cost code. Offsetting posting accounts for the inventory item are assigned based on the Microsoft Dynamics GP posting accounts entered when the item was set up.If you are using the Cost Code posting option, you can change the general ledger posting accounts on an inventory transaction. Do this by choosing an item number in the Item Transaction Entry window, choosing Distributions, and entering the accounts.
  7. In the Item Transaction Entry window, choose Save.

Step 2: Print an edit list

We recommend that you print an Inventory Transaction Edit List before posting to verify the accuracy of the transactions you entered. If you identify errors, correct the errors and post. For more information on posting, see the Microsoft Dynamics GP Inventory Control Manual.

  1. To print the Inventory Edit List with Job Cost detail, choose Reports > Job Cost > Edit Lists > Inventory Edit List.
  2. Choose the appropriate Batch ID.
  3. Choose Print.
For inventory transactions, the job number and cost element will display with the general ledger account distribution associated with the transaction wherever account distributions are displayed. This applies only if the journal entry for inventory transactions is set up to be created per transaction, and not per batch. You must also be posting inventory by batch to the general ledger and have marked the posting options to post to and post through the general ledger for inventory transactions.