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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Integration Manager

Status
Not open for further replies.

terpster73

IS-IT--Management
Feb 4, 2008
19
0
0
US
Integration Manager GP - Payables

Can someone give me an example of the basic fields and file set up that they use for using Integration Manager for accounts payables.

These are the fields we are trying to enter right now.
vendor ID
Account
DESCRIPTION
amount
dr_cr amt
doc date
document number
doc type

Question about the document types.. Sometimes they will be issuing credits and we would want to be able to have all of this entered into the same file for integration.

Thanks for your assistance.

Lori

 
Hi

We use GP9 and integrate all the PM invoices \ credit notes. I have screen shots of our integration setup but can't work out how to upload them - go figure.

Our integration file uses the following fields

Payable Transactions
[ul square]
[li]Voucher No.[/li]
[li]Document Type[/li]
[ul circle]
[li]1 = Invoice[/li]
[li]4 = Credit Note[/li]
[/ul circle]
[li]Description[/li]
[li]Batch ID[/li]
[li]Doc. Date[/li]
[li]P.O. Number[/li]
[li]Vendor ID[/li]
[li]Currency ID[/li]
[li]Document Number[/li]
[li]Tax Schedule ID[/li]
[li]Purchases[/li]
[li]Tax[/li]
[/ul square]

Distributions
[ul square]
[li]Distribution Account[/li]
[li]Distribution Type[/li]
[li]Debit Amount[/li]
[li]Credit Amount[/li]
[li]Distribution Reference[/li]
[/ul square]

Tax Details
[ul square]
[li]Tax Detail ID[/li]
[li]Tax Amount[/li]
[li]Total Purchases[/li]
[/ul square]







Take it Easy
Man with one chopstick go hungry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top