VI job to import into AP 1

[shri33]

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)

 

[Blorf]

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/

 

[shri33]

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.

 

[shri33]

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.

 

[BigLouie]

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.

 

[shri33]

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

 

[shri33]

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

 

[Blorf]

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/

 

[shri33]

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

 

[Blorf]

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/

 

[shri33]

My bad, here you go
Please find ghe configuration tab in this attachment

 

[shri33]

Yes header and details are combined in the import file

 

[dfeller]

Your records tab isn't correct; you are not specifying a GL account type line.

What is your perform logic on the job (tab 1)?

Dawn

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[Blorf]

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/

 

[shri33]

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