How to upload excel upload to whse.physical inventory journal

Dear Experts, 

We had a stock counting in our advanced warehouse (bi enabled). 

I have the stock count result in a Excel file with 4500 lines. How can I upload the data into the whse.physical inventory journal? 

When i tried the rapit service package, Table 7311, there is an error "Phys. Inventory must be equal to 'Yes'  in Warehouse Journal Line: Journal Template Name=PHYSINVT, Journal Batch Name=DEFAULT, Location Code=DC001, Line No.=20000. Current value is 'No'

Thank you, 

Tsevelmaa

Related
Recommended