Hello All,
I have been working on this for a while and wondering if anyone has any direct info that would help. We have a particular customer who sends us a statement in which they take different discounts and rebates which will apply to different GL accounts as well as specific invoices. I am trying to build out an Integration to import this and save the valuable time of our office staff as these statements could have hundreds of lines. I am handling the data preparation in excel with VBA but I am a bit confused with respect to IM, especially as the field mapping names do not 100% coincide with the naming conventions inside GP. I have found this thread and read through it several times, however after further examination have found that it seems to really only apply to cash receipts. Because we have more than cash receipts being captured in this situation, I feel that the Receivables Transaction integration is closer to what we need but I am not sure how to set this up. If anyone could give me an example of the mappings required to accomplish this I would be forever grateful. I assume at a minimum we will need a header source and a distribution body source file. Thanks