Best way to do this

[feeple]

So, I'm brand new to Great Plains (8.0) and am attempting to import some data into Payables Management. I've gotten the Integration Manager to work pretty well and have succeeded in loading ~800 vouchers. However, the checks that were used to pay these invoices are proving more difficult to load history for.

I've looked at hitting the tables directly the way the SDK says one should, that looks pretty tedious and is plagued with pitfalls. eConnect is a bit easier, but not much. The integration manager falls down completely as there's no destination for AP checks. What seems to work right now is:

-------------------------------
Private Sub Window_AfterOpen()

For i = 1 To 10
Amount.Value = 456 + (0.01 * i)
VendorID.Value = 128
'.......blahblah..........
Save.FocusSeg 1
Save.Value = Chr(13)
Next i

End Sub
-------------------------------

I added the PayablesManualPaymentEntry form to my VBA project and used the above.

Again, I'm brand new to this. DO NOT assume this is a good or prudent way to do it, it just worked for me. Suggestions welcome as to a better way.

Site:

http://www.feeple.com

Location: SF Bay Area

 

[RobertC22]

Another way to get your 'cheques' loaded using Integration Manager is two step.

1. A payables document integration to load the cheques as CREDIT Notes.

2. A Bank transaction integration to load the actual cheque so it hits the Chequebook Management module.

Use a common GL account between both for the matching transaction.

When loading the Credit Notes, it may be possible to apply them to the Payables Invoice loaded in a previous stage.


------
Robert