Search results for query: *

Thanks everyone! Got it figured out! The zeroes in ShipQty are like Djang just said because basically 0 had been used from that layer since it was still on the previous layer. It's going to be tough to reconstruct this all (we have to take out our customs charges since those will be separate...

Ahh...I didn't think ICCOST was correct because there weren't that many more records than we have items. So it basically just keeps the available layers in there? At a quick glance I mostly only saw one record per item. I saw a few items with a second line but the Ship QTY and Cost were...

Hello, Does AccPac keep FIFO cost layers in a table? I am converting one of our companies from AccPac to another system and would like to preserve the cost layers if possible. I have looked around at the tables and some posts on here. I first looked at the ICCOST table but that didn't seem...

Yeah, it's those type of things that make me think this might be some new Windows feature. For security or something. If she goes into XP Mode she can see the drives so I did check the GP compatibilty with Win 7 initially. Thanks for the extra info. Until this point I hadn't gotten anyone...

Yes, that's what I mean. I have GP on my Windows XP machine. The controller at this company used to also have XP but now has Windows 7. When I click the folder next to File Name and then click the Save in drop down, I see my local drives as well as my network drives. The controller used to...

Okay, cool, thanks! I'm not on location right now but I will check it out. I used Pervasive years ago and used to do connections to it so I think it will come back to me. Thanks for pointing me in the right direction!

I think this is ctree or something though. Pervasive would be .btr files right? Or can they be .dat files? Thanks!

Hi Victoria, They are on Windows 7 Professional 32 bit. They can see network drives elsewhere. When they are printing a report (or inquiry) and click the destination button then then click File, the drop down only shows their local drives. It's not really a client...I'm a customer. :)...

I've seen an issue where users cannot see network drives when printing a report to a file. I haven't really bothered to troubleshoot because the user (IT staff) upgraded to Win 7 without asking me first. :) If anyone has an easy answer to that, I'd appreciate it. Also, last I heard you could...

Dumb question...Where/how are you running these queries? I'm trying to get item cost layers from AccPac to import into a new system. I think I've found the right files but I'm not sure how to connect to them. I'm very familiar with MS SQL but usually just connect to SQL databases. I don't...

I don't think either of those solutions work. I looked at Indirect and it just gives you the end result value. I need to use a cell just to determine the row number of a formula; the column will always remain the same for each section. The second would work in a round about way but the...

I apologize if this has been answered. I tried using the Search here and on Google but may be using the wrong keywords. I have two workbooks: one comes from someone and is updated all the time, the other is mine to gather the information out of the first that is relevant to me. I have decided...

They used to have a MCFIX tool that could change it. It was created because customers would send data files to MS or their partner for one reason or another and then get Currency codes in the table. Then when you went to set up Multicurrency it would not let you select a functional currency...

Unless it's changed in version 9, the document will no longer show on the report after 999 days past due. The field size will only hold 3 digits so you won't be able to put 9999. Their suggested work around is to void the document and re-enter it on a later date.

You just void the payments under Transactions-Purchasing-Void Historical then you can reselect them for payment.

Thanks for responding again. I got the group suppression right (yes, I was only displaying group sections, not details). The three sections you posted about alternating colors I'm a little confused on. Is that 3 different formulas? Where do I place the formulas? Thanks

Wow! Late night and somehow I figured most of it out! I reread this thread a few times and also the FAQ on manual cross-tabs. The only two things I have left to do I believe is the alternate line shading and ommitting zero lines. I need to suppress all lines where all 4 columns (I did...

Was out of town so I'm just now getting back to this. I'm still confused on how to do a manual crosstab. I did the first part of your instructions lbass but got lost at: "Then insert a running total for each year which uses a sum of {table.sales}, evaluate based on a formula:" My table does...

Hmm, it didn't seem to resize but I'll look at that other thread. I discovered another problem. For some reason it doubles the amount that should show in the grid. If the sales was $1000 it shows $2000. If I make it average it comes out but then my totals are average also. So, really I...

Hi, Sorry it took me a little bit to respond. I had to print this and go over it a few times. Thanks so much for the detailed post! I'm using version 10...I should have mentioned that before. I followed your instructions and I think I got the data I want. I'm having difficulties formatting...