Unable to import Miscellaneous Receipt with Inventory Transaction FBDI

Summary:

Hello,

We have items dual UOM in KGs and BLY. These items also have item-based lots which increase one by one. I am attaching the Excel which was generated as CSV and uploaded through Scheduled Processes as below:

Load Int. -> Create Inventory Transaction -> Select the zip file -> Manage Inventory Transactions

After these two jobs are completed successfully I get no error messages but at the same time the item does not increase in stock and the lot I expect to see is not there in Manage Item Quantities.

Could you please assist? (The file I am attaching is the Excel version of it. I can't attach a VBA here)