Small and medium business | Business Central, N...

Where Physical Inventory Order Gets its Expected QTY

(0) Share

Report

Posted on by MahGah

15,433

When I create Physical Inventory Order in Expected QTY I can see some Serial numbers as available SN. But when I check Item Ledger Entries those SN has remaining QTY as 0.

Where does Physical Inventory Order gets these numbers? I mean which table? It is not Item Ledger Entry for sure. But I cannot find the correct table.

Any information about Physical Inventory Order and related table will be greatly appreciate it.

Thanks

All responses (4)

Answers (0)

MahGah 15,433 on at

Like (0)

Report

RE: Where Physical Inventory Order Gets its Expected QTY

@Marco Mels

Thanks for your help

For sure

Go to "Physical Inventory Order" Then create a new one. Then "Calculate Line" and select one item with SN. Make sure "Calculate Qty. Expected" is on.

Now in Lines -> Line -> Item Tracking Lines select Expected Tracking Lines

You can see all SN here. But I do not know where BC pulls these SN. I mean which table BC uses to populate this table?

Thanks again
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Where Physical Inventory Order Gets its Expected QTY

Hello,

I ran the scenario in standard CRONUS. SN's remain empty after finishing and posting unless I follow documentation:

docs.microsoft.com/.../inventory-how-count-inventory-with-documents

Maybe you can provide me with a small scenario in standard CRONUS.

Thanks.
MahGah 15,433 on at

Like (0)

Report

RE: Where Physical Inventory Order Gets its Expected QTY

@Marco Mels

Hi Marco

Thanks. We are in SaaS.

I did that and it use table "Exp. Phys. Invt. Tracking (5886)" but I do not know these data populate to this table from which table. Seems like it uses Table 339 "Item Application Entry" instead of table 32 "Item Ledger Entry" but I am not sure here.

Any help will be greatly appreciate it,

Thanks
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Where Physical Inventory Order Gets its Expected QTY

Hello,

Is this in BC SaaS or OnPrem. You can inspect pages via help to see what tables it accesses.

Thanks.