Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AP Check issues when linking AP_23_VendorRemitTo table

Status
Not open for further replies.

pdsmas

Technical User
Apr 1, 2009
5
US
Hello,
I am trying to do something that I thought was very basic but it isn't turning out that way. I am using MAS90 version 4.0 and Crystal Reports version 8.5. All I am trying to do is have the AP Check Form pull Remit To information versus the standard AP address information. I've tried two different kinds of linking:

1)I linked the AP_23_VendorRemitTo table to the AP1_VendorMaster using equal links between Division and VendorNumber. If I add fields and generate the check, nothing apears.

2)I linked the AP_23_VendorRemitTo table to the AP_20CrystalCheckHeader using equal links between Division and VendorNumber. If I add fields and generate the check, I get the following error message: "Unable to access Database or field. For the specific error, run the report directly from Crystal Reports (click on Form or Design).

I've tried re-creating the forms from the standard templates but the lack of data or Crystal errors still occur. This seems like a very quick MAS90 task like with any other linking so I'm not sure why this is happening. I expected 5-10 minutes but it's been 2-3 hours. Any help is greatly appreciated!!

-Ray
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top