Importing Cash Receipts

Hi 

we are running MAS90  V4.5.4.0, 

I get a excel spreadsheet from customer, they supply PO#, check description, doc date, gross amt, disc amt, net amount paid. Currently someone manually enters into cash receipts, we have 1000s of entrys, the customer does not supply the invoice number which i think is a problem too.

but my first issue is, can someone describe how i would go about importing the excel spreadsheet, or do i need to change layout to csv? what table would i import to? sorry, i have many questions as our company does not have this process setup and i am new to SAGE MAS90.

please help with detailed information for a newbie :)

Geeked

  • 0

    I created a VI job to table AR_CashReceiptsHeader , the user creates the deposit manually before, and then i am trying to load an excel spreadsheet with a list of invoices against this check.

     i keep getting an error when i run the job.  

    HS Record Invalid or Write Failed.  The record is not in an editable state.

    This is my first Cash receipt import and very new to this process. any help would be appreciated.

  • 0 in reply to stircrazy08

    I got the Cash Receipts to load, but have a question if someone knows.  right now, the file fails if the deposit balance does not equal the invoice totals for that batch/Check.  is there a way to load it when it is out of balance , the invoice totals dont match the deposit total??