Export VI Job

Question

Good day; 
 
 Newbie here, any help is greatly appreciated. I created a VI job to export the previous day invoice no,, day, customer number, customer name. I am exporting this data from table "AR_InvoiceHistory Header". No management wants me to also add the This part of the job is working great. 
 
 Now management wants me to add so batch no and the user that created the batch, I under stand this is not possible since once the invoice is posted to the GL the so batch no goes is not stored in any table (so i was told by a consultant). 
 For this reason i decided to add to the job "JournalNoGLBatchNo",now my dilemma comes trying to get the name of the user that posted the invoice. 
 Any help or guidance is greatly appreciated. 
 RudyM

David Speck · Accepted Answer

JournalNoGLBatchNo should get you the batch number. 
 However, do you want to know who created the batch or who posted the batch? If the latter, then the UserCreatedKey contains the user key of the user who posted the batch. You can create a VI table link to SY_User so you can get the user logon or name from SY_User, i should have an example of how to do this on this forum. 
 If the former, off the top of my head, one way to do this is to create a UDF in SO_InvoiceHeader to hold the values you want to push into AR_InvoiceHistoryHeader, such as the user who created the batch. You would then need a script on SO_InvoiceHeader's pre-write event to populate the UDFs.

Sage 100

Export VI Job

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING