Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

AS400 Serial Number Tracking

Posted on 2016-09-16
3
Medium Priority
?
121 Views
Last Modified: 2016-10-05
Hi there All,

I need some assistance with a problem that we experience on our AS400 system. We import goods and sell them locally. As means to track warranty, we want to include the serial number as part of the invoice when selling to customers. Is this possible on the AS400. Can the serial numbers of the items sold be linked with the AS400 invoice.

Kindly assist with feedback on the process to implement.
Regards,
Matt
0
Comment
Question by:Matt Botha
2 Comments
 
LVL 100

Assisted Solution

by:John Hurst
John Hurst earned 1000 total points (awarded by participants)
ID: 41801488
AS/400 does not provide any built-in Retail or Inventory package. You must have installed a third party package. You do not need the AS/400 machine number to add to your invoice.

What package do you have (or did you write your own)?  
Can you record the serial number of the goods for resale on the purchase order for the goods (when you buy them)?
Then retrieve the serial number when you prepare the invoice for sale.
1
 
LVL 36

Accepted Solution

by:
Gary Patterson earned 1000 total points (awarded by participants)
ID: 41801795
Matt,

The short answer is "yes" - there is always a way.

As John already explained, "out of the box", ther AS/400 doesn't come with any business software.  Just like with your desktop computer, you have to install software on an AS/400 to perform specific business functions.  There are lots of different software packages for the AS/400 that provide order management functions like the ones you use.  Also, some companies like yours have written their own software (in which case you probably have a programmer on staff who could answer this question for you).

For example, my company uses Quickbooks for accounting - we had to buy that and install it on a Windows PC in order to perform accounting functions.  Same thing is true of the AS/400 - someone in your company either purchased a software package or had programmers write software to provide order management functions like inventory management and invoices.

If your AS/400 business software already supports serial number tracking, you may just need to enable the feature.  In some systems there is an option (perhaps in Item Maintenance) to enable serial number tracking.  You may want to talk to the person or company that created the software that you are using, and ask them if the software supports serial number tracking - or just take a look through end user-documentation or item-related menu options.

If you are unable to determine if your software supports serial number tracking, or of you have determined that it doesn't, then you will probably need to engage the services of an experienced AS/400 programmer to help you determine the cost and complexity of adding the support that you require.  Be aware that adding something like this to a system that doesn't already provide serial number tracking support it is not trivial.  Often a project like this would include:

Modifying the database to provide a place to store serial numbers, and to add an attribute to the item database tables to flag if serial numbers are required for that item.

Adding a way to capture serial numbers - usually when an order is packed.

Modifying the packing list and/or invoice to include serial numbers.

Do you have an IT department in your company, or an outside IT service provider?  If so, that's probably your best place to start.  If not, and you can identify the software package that you are running, you should probably contact the company that supports that software.  In commercial software, there is usually some identifying information on the splash screen when you first log in, or on the main menu.  

Also, if you want to post a screen shot of the main menu of your order management system, we may be able to help you identify it.

Finally, if you don't have access to anyone who can help you, you'll want to contact IBM, or your local IBM Business Partner, or find an AS/400 expert.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you a startup company? Being a startup, you may be using shared hosting, or maybe even dedicated hosting. But have you ever given a thought to using cloud computing now? Yes, don’t be surprised, it is possible for startups to opt for cloud compu…
The article explains the process to deploy a Self-Service password reset portal I developed a few years ago. Hopefully, it will prove useful to someone.  Any comments, bug reports etc. are welcome...
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question