To search by article number, enter #123

Article #44 How can Damaged and Expired Inventory be Partially Written Off as Credits are Received?

Answer: Damaged and expired inventory returns from Solid Sales Pro will automatically be sent to that mobile cost center's damaged stock adjust to cost center, as set in Solid Business Central in [Datafile / Cost Center / View]. As credits are received for damaged and expired product from suppliers, it may be desirable to track what has been received by performing inventory write offs for those credited items. This can be done by using Solid Sales Pro to create a delayed inventory count for the items being credited, and then finalizing that delayed in Solid Business Central as a partial write off.

Creating a write off for any adjustment cost center in Solid Route Accounting – Enterprise Edition is a two step process. The first step is to create a delayed inventory count for the items that have been credited. The second step is to apply that delayed count as a partial inventory write off. Note that if all the inventory in an adjustment cost center is to be written off, then it’s easier to do a full write off instead.

Step 1: Create a Delayed Inventory Count

  1. Log into Solid Sales Pro on a handheld computer as an administrator and navigate to [Stock Operations / Inventory Count / Create Inventory Count] and change the ‘Counted For’ field to whichever adjustment cost center needs to be partially written off.
  2. Tap on the [Count Inventory] button, to be taken to the '2310 Count Inventory' screen, and add all inventory being credited. Note that when entering the 'Present Count', to subtract the amount being credited from the 'Qty on Hand' value. For example, if the 'Qty on Hand' value is 25, and the amount being credited is 4, then in the 'Present Count' field enter 21 since that’s how much damaged and expired inventory has not yet been credited.
  3. When all the items have been added, use the [OK] button on the '2310 Count Inventory' screen to return to the '2305 Create Inventory Count' screen. From here, tap on [Save & Print] to display the 'Save Options', and from this list, select [Delayed Inventory Count]. Answer [OK] to the confirmation, and print the inventory count if you’d like.
  4. Once saved, sync the handheld computer back to Solid Business Central.

Step 2: Apply Delayed Count as a Partial Write Off

  1. Once the handheld computer has synced successfully, in Solid Business Central navigate to [Datafile / Cost Center / View], and display the adjustment cost center that the delayed inventory count was created for. Note that adjustment cost centers should have the ‘Num’, ‘Adj_To’, and ‘DamagedStk Adj_to’ fields all set to the same number.
  2. While viewing the adjustment cost center, use the [F6 - Finalize] key to review the partial inventory count. Use [CTRL+END] to save and continue.
  3. The adjustment cost center record should now be displayed once again with the ‘Options to Save Changes’ menu showing along the bottom. As indicated, use [F4 - Save to Count Sheets & Finalise to Inventory].
  4. The choice will then be given to 'Save as Partial or Full count'. Use [F3 - Save as Partial Count], and at this point Solid Business Central will realise that this cost center adjusts to itself. Solid Business Central will then advise, “This will create a Write off via Product Receipt! Ok to proceed?”
    Select 'Y-Yes' to continue.
  5. The 'Finalized Delayed Inventory Cost Report' can then be printed, and the adjustment cost center’s ‘Inventory Value’ should now reflect the amount written off.

Last modified on Tuesday, 20 February 2018 10:52

Additional Info

  • Software Components: Solid Business Central, Solid Sales Pro
Rate this item
(0 votes)
Login to post comments