Prerequisites

  • PartsLedger
  • An open ServiceTrade job with committed inventory

Procedure

Open the work order in PartsLedger

  • Copy the ServiceTrade job number
  • Open PartsLedger and navigate to Projects → Work Orders
  • Paste the ServiceTrade job number into the Search bar and hit Enter
  • Open the work order by clicking View on the right side of the search result

Reverse the inventory assignment

  • Scroll down to the section of the work order titled Materials Used To Date. This table represents all the committed parts on the job, including the journal entry transaction number, GL Tx, for this commitment
  • Copy the the GL Tx number on the right side of the table for the part in question. This number represents the ledger entry for this inventory commitment
  • Scroll up to the blue navigation bar and navigate to General Ledger → List Transactions → All
  • Paste the journal entry number into the search bar and hit Enter or click Search
  • Click on the IntOrg Tx ID link to view more details about the transaction and confirm you're looking at the correct entry
  • Click the Reverse button to void the inventory assignment and put the parts back into inventory
  • Open the ServiceTrade job and delete the line item that corresponds to the transaction you've just reversed and click Save

Create a new inventory assignment with the correct data

  • Add a new line item for the part number, quantity, and warehouse source that matches your desired intentions, and click Save. PartsLedger will create a new journal entry for this assignment
  • Navigate back to the Materials Used to Date section of the work order in PartsLedger and verify that the bad line item now says VOID next to the GL Tx number, and that the table includes a row for the new, correct inventory assignment

Notes

The Accounting Transaction Details page contains a lot of information that you can use to verify you're looking at the correct entry:

  • Check the transaction description to confirm this is an inventory assignment for the job you're interested in.
  • Check the line item description to verify the part number, quantity, and cost
  • Check the credit and debit accounts to verify costs are moving between your inventory account and your WIP account
Did this answer your question?