Why Receiving Non-Inventory Items in PO Will Cause General Ledger Inventory Account Out of Balance?

Q: We received an item that had been on a PO. The message we got was "The following item is not in the item file," but Receivings Processing did distribute the value of the item to both Inventory and the Receiving Accrual Account. Stock status shows none on hand. I wonder why Receivings Processing allowed this posting, because now the G/L balance in inventory is higher than what the Frozen Stock Status will figure based on counts of items times their average cost. This is such a small amount that we will just write it off, but I was curious that it could have happened at all. What do you think? Thanks,

A: The purchase order system is designed to allow purchasing of inventory items (item file) and non-Inventory items (i.e., a computer, copier, stationery etc.) in the PO module. In the PO Line Item Screen, you should change field, "5. Account No" from a regular Inventory account to a proper account (like fixed assets or expense accounts) if you order non-inventory items from a PO. The GL Account to distribute during receiving is decided from this field. If it is a real inventory item, instead of answering "Yes" to "Item not on file - Is this OK?," you should add the new inventory item to the Item Master File. Otherwise, the system is going to treat this as a non-inventory item. 

• Related Articles

• COMPRESS General Ledger Processing Compress General Ledger TRX File

  Compress General Ledger Trx File Application Overview The Compress General Ledger Transaction File application will consolidate General Ledger transactions according to the account's compression code in the G/L Account file for all transactions dated ...

• Create PO Receiving Event to Trap Negative Qty on Hand Problem

  Q - Sometimes our receiving department is behind with their tasks in updating received quantities in the Elliott inventory. As a result, it creates a negative quantity on hand in Elliott. The items sold during the period use the old average cost. ...

• Can Journal Ledger Be Imported to General Ledger?

  Q - Can the General Journal ledger be imported from a spreadsheet into the General Ledger as opposed to manually entering it? A - Yes. You can go to General Ledger -> Processing -> Interface from Other Package -> CSV Import. See sample screen below. ...

• Canceled PO Line Items Still Exporting on EDI

  Released Date: 11/7/2022 Version: 8.5 & Up Q - We’ve seen this happen twice in the last month. We create a purchase order, then cancel line items on it. When we export the EDI document again, it still contains the cancelled line items on it, which we ...

• CPISSULS Customer Order Processing Issue Serial/Lot Component Items

  Issue Serial/Lot Component Items Application Overview After posting invoices to Accounts Receivable which includes a line item which is non-stocked and controlled and has a product structure which contains Serial/Lot components, a record for each one ...