×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

VI job to import into AP

VI job to import into AP

VI job to import into AP

(OP)
Hi,
I have created a VI job which imports invoices into Accounts Payable module.

When I run the job, it says its successful and I can see the data in the MAS tables.

But I cant view these invoices from the Invoice Registry
[MAS --> AP module --> Main --> Invoice Register]

Thats is probably becasue these imported arent assigned any batch number.

What is the best way to automaticallu assign a batch number (for all the records imporetd via the VI job)

RE: VI job to import into AP

I use "TEST" for the batch number, over and over, because everything is sorted by register number which is assigned later, so batch number doesn't really matter.  In fact, using batches vs not is optional.

ChaZ

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

http://www.thelegacyreturns.com/

RE: VI job to import into AP

(OP)
Thanks much for looking into this query ChaZ.

I will check my team - who process these records in MAS - if this will work for them.

Do you know if the batch number can be any string or does it need to follow the pattern set in the MAS program.

If it can be any string, then I can even pass my own batch numbers [Batch001, Batch002 etc] - in case records imported need to be easily identified by the team who work in MAS.

RE: VI job to import into AP

(OP)
I am on MAS V4.0

I tried to send "TEST" as batch number but with no success
I tried to create a batch number from the MAS UI and pass it in input to VI job, same result [these invoices arent visible in the registry]

Please let me know if you ahve any suggestions here.

RE: VI job to import into AP

In your source file have a blank column. In your VI job point the batch number to this blank column. VI will create the batch.

RE: VI job to import into AP

(OP)
I have batch number field in the source table which is set to blank. In the VI job I pointed the batch number column to the above field.

Still It didnt create batch

PS: When I print invoices in all batches, I can see the imported records

RE: VI job to import into AP

(OP)
These are my settings in the
AP module --> Setup --> Accounts Payable Options --> Additional tab

A) Allow batch Entry is checked
B) Password for batch entry override is empty

RE: VI job to import into AP

Maybe post the job?  There can be a variety of problems with the job that will cause this.  Header record vs detail records not being handled correctly and so forth.

ChaZ

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

http://www.thelegacyreturns.com/

RE: VI job to import into AP

(OP)
Sure, please find the job in the attachment

Note: In the batch number columnd you will see 15438, I have kept it for testing. I have tried using a blank as well

Please let me know if you have any more questions

RE: VI job to import into AP

Two things stand out.

1) First page, it looks like you have two invoice records with the same invoice number.  This makes me think that you are importing invoice detail into the invoice header table.

2) I can't verify line 1 because you did not include the configuration tab.  Is header and detail combined in your import file?

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

http://www.thelegacyreturns.com/

RE: VI job to import into AP

(OP)
Yes header and details are combined in the import file

RE: VI job to import into AP

Thanks for the Star.  Did you solve it?

ChaZ

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

http://www.thelegacyreturns.com/

RE: VI job to import into AP

(OP)
One part of the issue is solved, where in - now I am able to import multiple line items to AP module. Earlier I had some challenge doing it.

But the issue with batch number still exists.
I tried sending "blank", "string", "integer" and I tried to generate batchnumber in MAS application and used it here.
None worked.

Please let me know if you have any more ideas to fix this

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close