x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 6 replies
  • Subscribers 118 subscribers
  • Views 1518 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
47
topics
95
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
965
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
E.Leale

VI Import for SO Invoice - Misc and Charge items from SO not importing

Posted By

I need to know if there is a script or perform logic that can help my situation. 

- I have a VI Import Job importing Invoices from Sales Orders

- The source file does NOT contain the Misc or Charge items from the SO 

Can this be done without the lines not living in the source data?  Is there a script I can run or perform logic that can pull everything on write? 

Sage 100 v2016 premium with ACS multi-bin, Dm2/PDI software

Thank you! 

Parents
  • 0

    I don't know about script / perform logic options, but this is how we've dealt with this problem for one customer:

    Import into a UDT, and write a SQL View to merge the UDT data with the open SO lines for those orders... and then do a second import from the SQL view.

Reply
  • 0

    I don't know about script / perform logic options, but this is how we've dealt with this problem for one customer:

    Import into a UDT, and write a SQL View to merge the UDT data with the open SO lines for those orders... and then do a second import from the SQL view.

Children

*Community Hub is the new name for Sage City