Matching Batch Number to Invoices in MAS 90

[cfcanter]

Good morning!

I am trying to write a crystal report extract against our MAS 90 database. From the G/L I have the following data:

Acct Period Date Journal Batch Dr Cr
3010 12 1/31/06 SO-R0966 BTCH:R031_ 1000

I am trying to pull all the invoices that went into the batch for audit support. I've spent a couple of days looking for the table that has the batch history (which hopefully includes the invoice data).

All suggestions as to where to get the data is appreciated and desperately needed.

Craig Canter
Controller
Elgin IL

 

[Blorf]

Hi.

Just guessing here, but Journal is SO type, so I think you want A/R invoices yes?

If yes, then in Table ARN_InvHistoryHeader.

Link to SOSourceJournal (Contains SO for SO Invoices) and SOGLBatchNo, contains the Batch number from SO Invoicing.

Detail records for the invoices are in ARO_InvHistoryDetail.

This is for Mas Version 3.71

Hope this helps,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[cfcanter]

Oops. We are on MAS 200. My apologies

I cannot find the SOSourceJournal or SOGLBatchNo. Could they be called something else?

Craig Canter
Controller
Elgin IL

 

[Blorf]

Hi.

Are you able to find the tables I referenceed, ARN_InvHistoryHeador?

If so, a quick look at the table will show you fields that have source types, IE SO, AR,... and right next to them is usually a batch number. It is possible that your version eliminates the SO specific fields, which are silly anyway.

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[BigLouie]

Are you on 4.10 by any chance? In that case the field and table names will be a bit different. And what GL table are you using? In the AR file it would be source journal and JournalNoGLBatchNo