Purchase order import problem

[ewinger]

I wrote a program that gathers data from an excel spreadsheet and calls visual integrator to import the data into the PO.ORDER table. The data I am importing contains the header and line information in each record. The data gets imported with no problem and when a user opens the po in the purchase order module the totals tab agrees with the lines tab. The problem we have is whenever we go onto the lines tab to enter a comment and save it, the totals are zero and when the po prints, it shows as out of balance. Before we enter a comment, the totals are correct and the po prints correctly, so I must be missing something in the import. Anyone have any ideas?

 

[Blorf]

Hi.

Check under the records tab and make sure your logic for the correct type of record is in place. IE Item/misc or what ever type you are importing.

If your header includes the totals, it would force the data there even if the lines aren't going in correctly.

Chaz