Payment Batch Import Into Sage 300

Question

Hi, 
 
 Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. 
 Could someone share some key pointers on how to do payment batch import into Sage please ? 
 
 Thank you 
 Shashank

wheumann · Answer

Sage also sometimes interprets numbers as blank, so be sure your invoice numbers in Excel are text (apostrophe prefix to be sure). If the first one is interpreted as text, you might not have to change all rows. This differs from one type of import to another. 
 When you export a batch, you'll find over 450 fields on 7 pages. If you just want to a simple import of invoice payments (single currency, no discounts, no taxes, etc), you need only these 16 fields: 
 Payments_Adjustments tab : BTCHTYPE,CNTBTCH,CNTENTR,IDRMIT,IDVEND,AMTRMIT,DATERMIT 
 Applied_Payments tab : BATCHTYPE,CNTBTCH,CNTRMIT,CNTLINE,DOCTYPE,IDINVC,IDVEND,CNTPAYM,AMTPAYM

Jay Converse Acumen · Answer

Export an existing payment batch and make yours look like that.

Sage 300

Payment Batch Import Into Sage 300

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING