Skip to main content
Question

Inventory Adjustments/Issues correct Line Number or Impor scenario to all lines.

  • 19 June 2024
  • 0 replies
  • 31 views

Hello, 

I’m creating an Import Scenario to update the warehouse on Inventoy Adjustments / Issues at a line level depending on the Branch ID, the problem I have is that when i try to get the line number fron the INTran table it returns worng number, so I cannot use this value on the import scenario

Is there a fromula to get the correct line number from the transaction grid?.

 

Another solution would be to inspect the entire document line by line and use the IIF statement to update the warehouse, the problem I have for this solution is that the import scenario is only applied to the first document line, here is the mapping I’m currently using: 

 

Thanks in advance

Be the first to reply!

Reply