I am trying to insert data into great plains. I am familiar with Integration Manager but it is not a long term solution as we are needing to automate a nightly import into Great Plains from another system.
Below is what I am trying to run. I import all the data in the excel file into a table i created in the database called dbo.[head]
I am trying to import into the PM10000 table (or I think its supposed to be that) (Basically I need to be able to see vendor payments)
INSERT INTO PM10000 (VCHNUMWK,VENDORID,DOCNUMBR,DOCAMNT,DOCDATE,PYMTRMID,DUEDATE,TAXAMNT,FRTAMNT,PORDNMBR,PSTGDATE)
SELECT VCHNUMWRK,VENDORID,DOCNUMBER,DOCAMNT,DOCDATE,PYMTRMID,DUEDATE,TAXAMNT,FRTAMNT,PONBR,POSTPERIOD FROM dbo.[head]
I have attached the interface where the data should go and it is not showing up. Does anyone know if I am missing or completely incorrect on which table in the Great Plains database it is suppose to go to appear on this interface?