I am having some trouble finding the best solution for this. I am trying to use eConnect schema in VS, VB .Net, but can't figure out what the entire process needs. I would prefer to have a purchase order, receipt, and some sort of payment. We are using a report that is downloaded from our banks online site. I have written a windows app to get the excel spreadsheet into a dataset. We don't have project accounting yet, but will be getting it setup within a few monthes, so we will need to get our project id into the PO once we have PA installed.
So, as of now, I have created a PO, then a receipt (shipment/invoice), then a manual payment, but the manual payment is remaining unapplied. We need to apply the amounts, but do not want to do this manually as it will take our accounting person quite a long time to do all transactions. I have also created a payable transaction, but this will not enable us to use project accounting properly when we get it setup. I planned on using batches to post everything uploaded, so that we can keep user interaction at a minimum.
So, how can i get the Pcard transactions into Dynamics with minimal user interaction needed, once the transactions are uploaded?
*This post is locked for comments