AP Alt Address

[tdeast]

How does the alt address in ap relate with the other module in macola does it filtrate throughout macola as with the alt address in the arcusfil and the item master or what?

 

[MacolaHelp]

It's similar to AR. You can use the alt address for PO generation as in OE generation with alt address in AR. You may send the PO to one location, but the accounting people in your office may need the address information for the invoicing contacts. No link to the item master files unless you were to add a user defined field or something. Is there something you want to do w/alt address, or is this a general information question?

 

[tdeast]

I would like to somehow enter the commodity codes in the ap and have them also link in with the item master.

 

[MacolaHelp]

You can put commodities in the vendor master & commodity in the item master. You'll have to do a join to link the 2 files together since you can have 5 commodity codes in vendor master. Does this help?

 

[tdeast]

how do i do a join to link the 2 files.

 

[dgillz]

Link by the Commodity Code field.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[tdeast]

Im not up on exactly how to do a link from one file to another. does macola have help files on how to do this. is it pretty self explanatory.

 

[dgillz]

You are talking about writing a report are you not? If not, lets start over.

If so, what tool are you using to write the report? Crystal?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[tdeast]

no eariler you said to link the 2 files by linking the commodity code field and I asked how that was done because I was not familiar on hosw that could be. ,

 

[dgillz]

OK then, lets start over, as suggested. What exactly are you trying to accomplish, and why?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[MacolaHelp]

I had indicated to join the apvendor & imitmdix on commodity field assuming that tdeast understood that the files can't be linked. I thought it was understood that you would need to generate a report on the linked files or use something like vb or flex to do something while in the user interface.

 

[tdeast]

I was under the assumption that you was stating that 2 file or tables could be linked somehow thru macola and i was missing that somewhere. I know that thru Crystal most usually you can link 2 tables if there are 2 compatible fields.

 

[dgillz]

tdeast-

What if you could do this? What are you trying to accomplish?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[MacolaHelp]

You could probably create a view in either pervasive or sql to those 2 files, then run a VB app or (not my personal fave) flex to do something inside macola to query that view. As Don indicated, what are you trying to accomplish?