While posting Manual Entry for Materials, You get the following error message:
Material XYZ stock qty. XX ea - ref. quantity YY ea is too big (set of books ABC).
Reproducing the Issue
- Go to General Ledger work center.
- Go to Journal Entries View.
- Go to Journal Entry Voucher sub-view.
- Create a New Journal Entry Voucher with type 087 — Manual Entry for Materials.
- Select the screen variant as 630 – Manual Write-Up/Write-Down for Materials.
- Enter the relevant details and Post the Journal Entry Voucher.
You then get the error message: Material XYZ stock qty. XX ea - ref. quantity YY ea is too big (set of books ABC).
While posting the Manual Write-Up/Write-Down for Materials ,you need to specify the Reference Quantity to which the Charge/Credit refers. The Reference Quantity must be less than the material inventory quantity. This ensures that you do not charge for or credit any materials that are no longer available.
You are trying to post the manual entry with the Posting Date DD.MM.YYYY and correctly entered the Reference Quantity which was available as of the Key Date DD.MM.YYYY. However system checks for the quantity in the period end rather than on a particular key date. Hence system throws the error message that Reference Quantity cannot be greater than actual inventory quantity.
System works as expected and check the Inventory Quantity on period end. In this case, you can allocate the Credit/Charge to the available quantity at the period end, and include another line item with price difference of the remaining amount.
KBA , manual entry for materials , SRD-FIN-CLM , Cash and Liquity Managment , How To