Home Page link  

Import Physical Inventory Count

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Import Physical Inventory Count Richard 07-30-2007
Posted by Richard on July 30, 2007, 4:46 am
Please log in for more thread options
 When trying to import a file into the physical inventory count in store
manager, I am getting the following error:

Cannot resolve the collation conflication between 'Latin1_General_C1_AS' and
'SQL_Latin1_General_CP1_C1_AS' in the equal operation.

Does anyone know how to resolve this without changing the collation of the
database or the server.

Thanks


Posted by Akber Alwani on July 30, 2007, 7:42 am
Please log in for more thread options
 HI Richard, how you are importing it through ASCII file if so then make sure
you have 3 columns itemlookupcode, qty, time , the time is optional column if
you have something else let me know

"Richard" wrote:

> When trying to import a file into the physical inventory count in store
> manager, I am getting the following error:
>
> Cannot resolve the collation conflication between 'Latin1_General_C1_AS' and
> 'SQL_Latin1_General_CP1_C1_AS' in the equal operation.
>
> Does anyone know how to resolve this without changing the collation of the
> database or the server.
>
> Thanks
>

Posted by Richard on July 30, 2007, 8:24 am
Please log in for more thread options
It's a CSV file, which looks something like this:

1000, 1
101, 10



"Akber Alwani" wrote:

> HI Richard, how you are importing it through ASCII file if so then make sure
> you have 3 columns itemlookupcode, qty, time , the time is optional column if
> you have something else let me know
>
> "Richard" wrote:
>
> > When trying to import a file into the physical inventory count in store
> > manager, I am getting the following error:
> >
> > Cannot resolve the collation conflication between 'Latin1_General_C1_AS' and
> > 'SQL_Latin1_General_CP1_C1_AS' in the equal operation.
> >
> > Does anyone know how to resolve this without changing the collation of the
> > database or the server.
> >
> > Thanks
> >

Posted by Laurie on August 1, 2007, 6:16 pm
Please log in for more thread options
Hey Richard please email me i would love to talk to about making a program
using the csv files. windman at .suddenlink.net

"Richard" wrote:

> It's a CSV file, which looks something like this:
>
> 1000, 1
> 101, 10
>
>
>
> "Akber Alwani" wrote:
>
> > HI Richard, how you are importing it through ASCII file if so then make sure
> > you have 3 columns itemlookupcode, qty, time , the time is optional column
if
> > you have something else let me know
> >
> > "Richard" wrote:
> >
> > > When trying to import a file into the physical inventory count in store
> > > manager, I am getting the following error:
> > >
> > > Cannot resolve the collation conflication between 'Latin1_General_C1_AS'
and
> > > 'SQL_Latin1_General_CP1_C1_AS' in the equal operation.
> > >
> > > Does anyone know how to resolve this without changing the collation of the
> > > database or the server.
> > >
> > > Thanks
> > >

Similar ThreadsPosted
physical count inventory March 1, 2007, 6:46 pm
Physical Inventory Count August 17, 2007, 10:27 pm
Physical Inventory Count??? March 25, 2008, 7:28 am
physical inventory count sheets September 15, 2006, 5:30 pm
Physical Inventory Count / Software August 9, 2007, 4:39 pm
Physical Inventory Count Date Error June 21, 2005, 9:09 am
Problems with Physical Inventory import April 5, 2006, 3:52 pm
Bug in Physical Inventory Import Procedure February 13, 2007, 12:42 am
physical count questions May 31, 2005, 3:32 pm
physical count of serialized items April 9, 2008, 12:38 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap