Picking List is missing, then Stock value not tally to Stock aging and GL

(1) Share

Report

Posted on by Community member

Hi all,
I have an issue where Picking List is missing, it then caused Subledger does not match to GL amount, and Stock value also not matched to Stock aging. Below explanation for the issue:

I have done the reconciliation and found out that a picking list is posted in the Inventory module but not in GL.
Hence when I pull the stock value report, the picking list (and its amounts) is existing, but the amount not reflected in GL.

When examined backwards, discovered for the picking list journals, there is additional lines of material (with negative physical cost); but this line was not reflected in the picking list journal itself in production control modules.

May I know what may cause this error, is it coming from manual entries or from missing or wrong steps in production picking list process?

Appreciate any help form ya'll. Thank you!

All responses (2)

Answers (0)

Community member 2 on at

Like (0)

Report

Picking List is missing, then Stock value not tally to Stock aging and GL

Hi Andre,

Thanks for reaching out!

These are some the issues I am trying to follow through.

Stock transactions:

Checking picking list info:

Checked the Pick List and found voucher no. for RP8102 is PLI-020461.

Below the voucher PLI-020460 pulled from Stock value report (3 transactions posted using this voucher).

However, GL only posted 1727.85 (1445 + 272.85), with yellow line missing, causing SL not matching with GL.

When checked to prod journals, also noted there is no line for the item on voucher PLI-020460.

Based on the above would you know what may have gone incorrect?
André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at

Like (0)

Report

Picking List is missing, then Stock value not tally to Stock aging and GL

Hi Community user,

Can you clarify your question with some examples, e.g. screenshots? First, you say that a picking list is missing, but then you also mention that you found it, but nothing posting in GL. I'm currently not able to understand the exact scenario.