Topic Options
#30678 - 01/27/12 12:03 PM DIC - Invalid Vendor
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
I imported two receipts throught the import function yesterday and received no errors. I ran a DIC today and it gave me the following error:
Receipt 1 contains an invalid vendor. Must be corrected manually.
Receipt 2 contains an invalid vendor. Must be corrected manually.

Both receipts have the same vendor and the vendor is in the AP module. I looked at the receipts and they did not have a vendor - I'm sure it was listed in the import file; and wouldn't I have gotten an error if they hadn't been there? I went to edit the receipts but can't access the vendor field. Any suggestions?

Adagio Inventory 8.1c (110713)
Adagio Payables 8.1c (110729)

Thanks
Mike
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#30686 - 01/28/12 06:47 AM Re: DIC - Invalid Vendor [Re: MikeS]
Retired_Guy Offline
Adagio Master

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

Can you send me a backup ZIP of your Inventory data and the receipt file you imported? You can upload it here. I'd like to take a look both at the import and at the DIC error.

Thanks
_________________________
Andrew Bates

Top
#30689 - 01/29/12 07:40 AM Re: DIC - Invalid Vendor [Re: Retired_Guy]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
Hi Andrew,
Uploaded the three files as requested.

Thanks
Mike


Edited by MikeS (01/29/12 07:42 AM)
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#30691 - 01/29/12 08:47 AM Re: DIC - Invalid Vendor [Re: MikeS]
Retired_Guy Offline
Adagio Master

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

We're going to need the AP too.
_________________________
Andrew Bates

Top
#30695 - 01/30/12 06:37 AM Re: DIC - Invalid Vendor [Re: MikeS]
Retired_Guy Offline
Adagio Master

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

Can you check what verion of IC you're running? I'm not getting a problem with V8.1C (111012).

I did note that your import template is defaulting the vendor name, not the Vendor number.


Edited by Andrew Bates (01/30/12 07:40 AM)
Edit Reason: Added tested version.
_________________________
Andrew Bates

Top
#30696 - 01/30/12 07:56 AM Re: DIC - Invalid Vendor [Re: Retired_Guy]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
File sent.

Adagio Inventory 8.1c (110713)
Adagio Payables 8.1c (110729)

I tried the vendor name in the import file but it gave me an error (I think - not sure now) so I used the default field.
Is that a problem? Actually, now that I think about it, I had problems with other imports when I placed the vendor/customer name as the last field in the import file. It would go away when I moved the field to another location.
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#30697 - 01/30/12 08:28 AM Re: DIC - Invalid Vendor [Re: MikeS]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3612
Loc: Toronto ON, Canada
Mike:
The imports that have a header and detail format (ie IC Receipts, OE Orders) want the Header columns first, followed by the Detail columns. That's probably what you encountered there.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#30698 - 01/30/12 08:37 AM Re: DIC - Invalid Vendor [Re: MikeS]
Retired_Guy Offline
Adagio Master

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

OK - I've recreated the problem with now that the Payables data is in the directory.

However, if you change the template to default the Hdr-Vendor Number to VIKMFG everything is fine.

We'll address the DIC complaint in a future Service Pack. At the moment, you can safely ignore the error.
_________________________
Andrew Bates

Top
#30699 - 01/30/12 08:41 AM Re: DIC - Invalid Vendor [Re: Retired_Guy]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
Thanks, I'll make the change for the next time.
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#30700 - 01/30/12 08:51 AM Re: DIC - Invalid Vendor [Re: MikeS]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
You can also Enable the option Allow invalid vendors under Edit | Company profile | Processing/Report Options to get rid of the DIC error.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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