Share
Report
290I have the data in a csv file and would like to import it to the SOP module in GP thru Integration Manager. I was able to create a batch and map the customer ID, but it won't map the item number, invoice quantity, unit price, GL distribution and the tax details. Within the SOP$Items in the IM, I had the item number use constant $ZZZ-1ST-0010$, Quantity use constant $1$, Unit Price use source field pointing to the csv file sources, billed quantity use constant $1$, quantity use constant $1$ and unit cost use source field pointing to the file. The field that I use constant because it won't change and it is a constant value. Under the distributions, I had the account number, distribution type, debit amount, credit amount and distribution reference pointing to the csv file. Under the sales tax detail summary, I have the tax detail ID, tax amount and the total sales pointing to the csv file as well. Am I doing this right? I don't understand it won't plug in the item number, tax and the GL distributions. Appreciate for any advices.. thank you
*This post is locked for comments
All responses (
Answers (
