Search results for query: *

You need to work with your reseller. Rebuild key files and sort files will have absolutely no effect on the balances. DO NOT use DFDM to manually change the amounts as you will run into major problems with updating. Note that you are on v3.71 for which all support have ended.

In the open invoice file there is a field called "Paid Today". It is my guess this is set to "Y" when it should be "N". You would need to use DFDM to change the value. If you do not understand what I am talking about then DO NOT attempt on your own but have your reseller assist. Just takes a...

Does it show as having a balance in Vendor Inquiry? Also what version of MAS are you on.

You cannot. MAS records the cost by serial number in the Item Costing file. As each serial number is purchased a cost is assigned to the serial based on the purchase cost. Read the help files on the hierarchy of cost to see how a cost is assigned in other cases.

Did you write an entirely new job? It is my understanding that the "/" has to be in the source file now. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

Imports into IMB is particularly tricky because of the multi-key nature of the file. You best option is to setup one item as you want and then pull with Excel and see how the record looks. Note that with Excel it is common for leading zeros to be stripped out. If 0123 is an item number it might...

IF they are doing shipping data entry in SO why would you look at the AR tables? Dawn is correct as always. You should be working with their rreseller. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

There are no separate data tables for shipping data entry. Shipping data entry is just another front end for invoice data entry and uses the same tables. Plus there are already shipping log tables. What version are they on? Are you a reseller or just a programmer? Visit Sage's Online Community...

If you use FIFO and serial there is no way an item can have an incorrect cost. Also you did not answer my question. Does the inventory trial balance tie to the GL? If you adjust out an item and then bring it back in at a different cost this will be reflected in all reports. Visit Sage's...

You cannot. The Inventory Trail Balance is meant to balance to the GL. In your case does it? The Inventory Valuation report is NOT meant to balance to the GL. It is a live report, meant to show valuation as of the moment you run the report. Also pricing, that is the price you sell it at has...

What version of MAS are you on. I am assuming you mean the GL has the wrong info. Is this correct? Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

I suspect it is because you are trying to give it a batch number when you should not be. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

VI is a module that is used to import data into MAS. It replaced Import Master. BOI is a built in feature of MAS that allows you to use VBScript to write to MAS. One does not need the other. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

One option is to just use the float bar in MAS and not the tree view. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

Import Master was discontinued back in 3.70 I believe. If you are to import it would be best to work with your reseller or take a class on VI. You will have fewer mistakes and will get the job done faster if you do either. Visit Sage's Online Community...

The system will automatically assign a batch number for you. Over on the Sage Community BigLouie has posted examples of how to do SQL Specific Pass Through Queries with log in. Do a search. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

Did you know that you can actually do a SQL Specific Pass Through Query in Access to read the Sales Order files without having to do an export? Are you trying to assign a value to the batch number? Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

Try this, manually create a sales order in MAS. Add a freight amount. Create an invoice based on the sales order. Tell me what happens to the freight field. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

You have not mentioned what files you are attempting to import into. So Invoice Data Entry? SO Invoice Tracking? If you cannot get /M to import then you probably do not have the records tab setup correctly. VI will not update existing lines in the table you are importing into. It will only add...

You can set this in Customer Maintenance. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc