Search results for query: *

Just create a formula that includes: left({objecivefield.month},17) If the formula is called Test, place the following statement in your Record Selection Formula {@Test} in {?Monthly Objective} If your "Monthly Obective" parameter is a range,the "in" operator will cause formula results in...

Use a Pass-thru query, and include the user name and password in the ODBC connect string.

Goto Job Cost, Main, Job Posting Entry. Enter the Job, Cost Code, units/dollars to the job you are moving the amount to. Enter similar information for the job you are moving from as a negative amount.

If you have not applied the credit/debit memo against the invoice, Go to Manual Check Entry. Enter a Check No of APP000 where "000" can be any number up to 999 (This stands for "APPLY"). Enter a zero check amount. On the lines page, apply the check against the credit/debit first. Then apply...

You can go to Invoice Payment Selection and slect "Clear". Then reselect the 3 vendors with invoices. You could also go into check maintenance, click on the flashlight, select each vendor that you DO NOT want to process, and delete the check entry.

I think you mean SO8, the Shipping Rate file. Record type D stands for Detail. It is in the flie layout section of the TRSG.

You can't. Mas 3.41 is not supported on XP. It is also about 15 years old.

I agree with Jamor, Unless you have hardware/network issues, you seldom get errors.

That's strange. There are around 70,000 installs of MAS90. I wonder why they are not supporting it. They still sell it. If you have not used the software in years, the data probably is not relevent anymore.

Aaron, Link to the ship-to file with a left outer join. There will not always be a record in the ship-to file and an equal join will cause any record on SO1 without a shipto code in SOB to be excluded from the selection. Also, go to File, Report Options and check "Convert Null field value to...

Hopefully you have found the answer by now, but if not, you can do the following. The item can be set as TX, NT, or you can add user defined categories in Inventory Item Maintenance. Once this is done, you go to Modules, Librar Master, Common and setup tax codes (i.e. State, County, City or...

Look at the SO5 in your TRSG. S="standard", Z="Deleted".

Do you mean tax_schedule for the customer, or tax_class for the item? Either can be removed from the validation routine in import job maintenance. Go to validation and remove the field that does not require validation.

Call Best directly. 800-854-3415. They will fax an authorization form for an authorized signor of the company to complete and fax back. They will then walk you through a back door.

I think there is a typo in your error message. There is a PO_20 file, but it should be followed by the 3 character company ID then .soa. You show only two. If it is the PO_20 file, you should be able to clear the error by reinitializing PO_20, PO_21, and PO_25. These are crystal files that...

Ossymoon, What is the exact mesage you are getting?

Pat, You might check the system activity log to see when the last period end close took place, and if anyone changed the setup parameters for AR or SO. Any transactions posted with a module or application date consistent with the current period in your AR or SO setup will post to the PTD...

Do you have a current virus scanner running? If so, and if it does not appear that you have any viruses, try temporarily disabling it to see if performance improves. If it does, at a minimum, exclude the MAS90 directory and subdirectories from the scan. Where is MAS90 loaded? It is not Mas...

lachesis, Me again. I just re-read your second post and caught the bit about an order with no quote. In that case you would need the third table mentioned above.

lachesis, Sorry for the confusion. In my original response, replace the first one-to-many with one-to-one. The rest of the reply still stands. A one-to-many relationship from the Quote file to the Sales Order file where I am assuming the quote is unique, is a left-outer join. If you setup...