Sage 100

 View Only
  • 1.  VI Batch Names

    Posted 24 days ago

    When importing into JC_JobpostingHeader. I am auto assigning the batch number it the job, so it is picking up the next batch number with no issues.

    Does anyone know of a way to change the batch comment. Currently it is VI Import: VI Job Name.  

    I think I have do another VI job going into the GL_ActiveBatch, but was hoping to do this in one VI job.

    I was looking for something on like "H.BatchComment", but I do not see anything like that in the data tab of the VI job.

    Thank you

    Michael



    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    ------------------------------


  • 2.  RE: VI Batch Names

    Posted 24 days ago

    https://communityhub.sage.com/us/sage100/f/personalization-customization-and-productivity-tools/145291/trying-to-set-po-rog-batch-as-private-through-scripting/383238 

    David's post above might help.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: VI Batch Names

    Posted 24 days ago

    Here's an old Perform Logic method someone told me about once a long time ago:

    Script (one for each batch name you want to use).

    S E a tchNoF o r Imp ort $ 
"KEVIN" 
( ort$ 
r e t Val 
coEusIness' SelectNebÜEatch 
EXIT 
, "Automated 
hatch,

     

    Set up the Perform logic.

    Perform 
Key Fields 
Job Name 
alntenan 
Perform Type 
File Type 
Table Name 
Column Name 
Sequence 
Before Assign 
Header 
GL GeneralJournaIHeader 
aatchNo 
Command miCMEcriptiPvtaatch pl 
Accept 
Detauts 
Cancel

     

    Set the BatchNo field to be first in the list, and to the variable named in the script.

    mpo 
Column Name 
Operation 
Source 
Record 
Table Name 
Column Name 
Detaut 
Prompt 
Date Mask 
Calculation 
Condtional 
aatchNo 
Substring D Stan pos 
Substring D Stan pos 
%aatchNoForImpod$ 
File Type 
Recalc 
Field Type 
Standard 
Accept 
Cancel

     

    Run the VI job, and rejoice.

    s 
G/L General Journal Entry Batch 
Batch Number 
Comment 
Private Batch 
Automated batch, do not edt!l 
Status 
Available 
Created ay 
Modified ay 
Renumber m 
01 '300018 am 
01 '300018 am



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------