255
I am attempting for the first time to import sales invoices using integration manager.
My question is to create an import for invoices would I need a SOP header file, SOP items file and SOP line file in order to accomplish this?
*This post is locked for comments
'Amount Received' and 'Trade Discount'. Allow distributions to default. You'll also need to specify a checkbook to post the amount received to.
can you please let me know, what fields are required to accomplish this with receiving amount and trade discount , how would I set my distribution?
As long as all the information is there you could have the data in one file or multiple files. The trick will be in the query relationship and the grouping. Personally I prefer to dump everything into SQL and then have an indicator column that you flip after a successful import. I believe if you look at the query helper in IM it will provide an example.
I've been importing sales invoices for several years.
It's possible to do this using a SOP Header and SOP Line Item file.
You will need SOP header, SOP Items and SOP Distributions, Commissions are optional
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (