How to import counting journal with Excel in Dynamics 365?

In the This post, we talk about import movement journal via excel.

 Some people thought counting cannot be imported because the system locks item for transactions and calculates the on hand online.

In Fact,

for the first point, 

system lock item for transaction based on your setup
so if you activate lock items during the count.




so, if this parameter not activated, you can make any transaction during the counting

and excel validate this parameter also as the below 

I am trying to import item already counted in another open  journal



For the second point 

the system will calculate the onhand when you publish counting journal from excel.

How to import counting journal?

Just go to inventory management /journal entries / item counting / counting


click new and select your journal


click Ok to open journal lines


go to open in excel and select inventory journal lines


click download


open the downloaded sheet and enable editing


Fill the required Data like item number, line number, site, warehouse, counted,..etc




Leave onhand column blank


click publish

after publishing succeed, the system calculates the onhand and refresh it in your sheet as the below



back to counting journal again and refresh your page to see the published data


as you see:: on hand and quantity calculated automatically 

Comments

Popular posts from this blog

Warehouse Management System in AX 2012-Set Up & Configuration

Create Item/Product and Product master in Dynamics AX 2012 R2

D365: Request for quotations (RFQ). Process RFQ overview