Administration, Core Financials, and Project Accounting

[jimnichols]

We currently import AR Invoices into Pending AR Invoice batches via DataPorter.    We have thousands to import each month; consequently, this is taking way too much time.     We do not own Data Migrator (not sure if that would help or not?), so we are currently trying to use the Import AR Data task.       Has anyone used this before?    We've created a sample import file attempting to import 1 dummy invoice with the least amount of data populated in the file, i.e.. just the required fields to test.    We keep getting errors stating the minimum number of required fields are not included, so the import fails.    Determining which of the 84 detail lines needs to be populated is a bit much!      We'd appreciate any suggestions.  Thanks.

[LouDavis]

If you have a compentent SQL Server developer on hand, you do not need to own Data Import Manager in order to use its functionality.  You can develop your own routines to use the stored procedure sparAPICreatePendInvc to create pending AR invoices in MAS 500.  This is the stored procedure Data Import Manager uses.  This will be much more efficient than using the Import AR Data task especially if you have a lot of data to import.. 

If you do not have anyone with the necessary SQL programming skills, you should contact your reseller to see if they can create a solution for you.

[jimnichols]

I've managed to get this working, but without the Batch record.   The format for that is not listed in the documentation.  I've found reference to this in the KB, but the resolution is to wait untl v7.4 where this batch record layout is specified.    Version upgrade to get a file import format that should have been listed in the documentation...odd.

[jimnichols]

Thanks for the heads up on the sproc API.