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

Parents
  • 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.

Reply
  • 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.

Children