Skip to content


Playables transaction

Davel asked 9 years ago

I have a payables transaction map which imports information in to GP from an SQL table. when the transaction is created it is not picking up the "Tax Scedule ID" from the Creditor card. 

The "Tax Schedule ID" in the Map is set to be a source column, is this the correct setting to have the information defaulting from the Creditor Card?

Thanks in advance
Best Answer
lorren answered 9 years ago

The tax schedule id does not default from the Vendor Card, so you will have to provide it.  if you don't have the value, you can create a SQL Lookup column to get the Tax Schedule ID from the Vendor.

To get it to automatically grab the Tax Schedule ID would require a change to the Microsoft eConnect procedure. 

Davel replied 9 years ago

Thanks for the reply Lorren. 

I have managed to use the SQL lookup column, however this does not populate the figures within the Tax Payables Tax Entry. Would I need to enter that information through the Payable Map that I have already set up or should it automatically pick up the information?


If you would like to submit an answer or comment, please sign in to the eOne portal.