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

Cashbook Payment Import

Status
Not open for further replies.

Ben80

IS-IT--Management
Jan 9, 2007
6
ZA
Hi

Does anyone know how to Import a Payment to the Cashbook in Dynamics GP 10?

I am able to import the Bacth header, but cannot get the line detail in.

Does anyone use ERM Import Payment utility at all?

THX,
Benjamin
 
Resolved.

HDR and LINE fields in the import file must denote what data is header and what data is line information.

Example of .csv type import

HDR,date,description,check amount,LINE,account no,amount
HDR,date,description,check amount,LINE,account no,amount
HDR,date,description,check amount,LINE,account no,amount

Remember that one cannot leave a blank line behind the last line in the import file - will continue to run without doing anything (need to terminate the application).

Cheers,
Benjamin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top