Automate list of invoices and credit notes in AS/400 system

15 pts.
Tags:
AS/400
I have a list of invoices and credit notes to offset. Is there a function to automate this process, instead of manual input?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Yes, the function is generally called "programming". But a lot of other methods might be used.

    It all depends on what experience you have, what authorities you have, what features are installed on the server, what kinds of devices you use to connect to the server and, if any of your devices are programmable, such as a PC, what's installed on that PC.

    It's possible that someone else in the world has created a process that is close enough to exactly what you need so that you could use it with minimal changes. But there are too many unknowns.

    First, we don't know what you mean by "list". Did someone hand you a printed report with invoice numbers and credit notes? Are they rows in a MS Access table? Is it a .CSV file? A LibreOffice spreadsheet? A web page?

    And what does "to offset" mean? It must mean some kind of update function, but what? I'd normally think that it referred to a value that would be added to or subtracted from some account balance, but it doesn't quite match up with "credit note"?

    And what is the "manual input" process?Do you type into a terminal emulator? Into a web form? Something else? Do you simply type in the list? Or do you have to do some manual calculation of some "offset" value?

    The answer to your question is probably "Yes." But we can't know what is possible. Maybe remote data access is restricted on your server. Maybe it can only be done through allowed interfaces. Maybe you only have a non-programmable terminal. Maybe you use an emulator that doesn't have enough macro capability.

    Or maybe your management simply doesn't allow this.

    So, probably "Yes, but we can't know for sure if it can be done nor how it might be done without a lot for info."
    35,130 pointsBadges:
    report
  • ToddN2000
    What programming package is you AS/400 (iSeries) running? Every software vendor has their own ways for extracting data. We need some more info. The alternative is to write your own SQL / QUERY / PROGRAM to do the job.
    132,760 pointsBadges:
    report
  • kwekhga

    I am not technically train as im the end user trying to find a solution to make work easier. Unfortunately to have my IT department come up with something will take a long time.


    My AS 400 is V7R1M0 not sure

    Was wondering there is just any external tools to use or some simple macro for me to run and net off

    that is ask system to automatically net off Eg Invoice no 1234 $100 with Credit note 456 $100 if I have all these data already available in the spreadsheet instead of now manually clearing them.

    15 pointsBadges:
    report
  • TheRealRaven
    It's almost certain there is no such tool. But it's likely that there are many ways to create one. We have no way to know how you might do it without more info about your system interfaces.

    If it would take your IT group "a long time", then the interfaces are highly restricted or the databases have I/O requirements that a simple tool possibly can't handle or other possible obstacles are in the way. It could simply be that design and implementation issues are a mess.
    35,130 pointsBadges:
    report
  • ToddN2000
    I agree with Raven. I do not think you will find anything on-line that will do this with the accuracy you need dealing with financial data. Your IT staff would have to write something. As long as the have access to the data and connections needed, it could be done in a few days depending on the complexity.
    132,760 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: