Topic Options
#4204 - 07/26/04 04:04 PM A/P Invoice Imports
Sandra Offline
Adagio Guru

Registered: 03/21/02
Posts: 119
Loc: Vancouver
We enter a number of our invoices, for various reasons, outside of the accounting system. These invoices are then imported to the a/p system, up until now, ACCPAC, via a comma delimited ASCII file, for final processing and payment.

I am trying to replace the ACCPAC import with Adagio, and need to confirm with someone more experienced than me how the specifications need to be set up so that we get expected results.

My test seems to indicate that Adagio is treating each line in the import as a record. If my first line is the header record for the invoice, and subsequent lines are the detail records for the same invoice, I receive an error that suggests that I need a header record for each detail line. Since many invoices have only one header, but many detail lines, this issue has me somewhat puzzled. Thoughts or suggestions from anyone would be greatly appreciated.

Thank you.

Sandra


Top
#4205 - 07/26/04 05:22 PM Re: A/P Invoice Imports
Sandra Offline
Adagio Guru

Registered: 03/21/02
Posts: 119
Loc: Vancouver
Me again. I tried a few more tests and think I have this working. I suspect the extraneous fields I deleted may have contributed to the problem. So there you go. All happy!!

Top
#4206 - 07/26/04 06:09 PM Re: A/P Invoice Imports
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Sandra,

Glad we were able to help!


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 193 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14484 Topics
70731 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31