Upload PO/SO Receipts 1

[SiriusBlackOp]

Has anyone here ever found a way to Update a PO or SO Receipt?

Is the SO Business Object available in 4.10 able to do this for a Sales Order?

Regardless of that, is there a way to do this using any method currently made available to 3rd Party Developers?


So far I have found with MAS90/200 that getting data out is easy... but getting data in has some very limited options.

Any bits of info welcome. Thanks.


Senior Software Developer

http://www.scoutsft.com

 

[rainxking]

I assume you are talking abour Receipt of goods?

GEtting Data in... is not easy but it is not hard. Guessing the funds driving your solution. You will use VI to import the new records. There is a certain order you need to go in dependant on the data you are bringing in.

Use the TRSG to find out tables need to get hit.

Also... do all this in a test environment until it works.

From what you describing anf amount of transactions, Id go with VI and use your best MAS/Database guy working for you.

RK

 

[SiriusBlackOp]

We are a little new to MAS90/200 here... but from what I have read about VI so far, I understand that VI can only import "new" rows and is not capable of updates.

So, are you telling me that I can receive goods into MAS90/200 from a PO by only inserting new rows into the MAS90/200 DB (and not making any Updates to existing rows)?

By the way... what is TRSG? (like I said... new to MAS here)


Senior Software Developer

http://www.scoutsft.com

 

[BigLouie]

Sirius, could you be a little more clear on what you are doing. Are you trying to update a receipt of goods through a process other than the recipt of goods in MAS? Are you bringing in the data from an outside source?

If you are a software company that is trying to develop a third party application to work with MAS then you need to talk with Sage about the Master Developer program.

From the sound of it you really need to go to some classes on MAS. It sounds as if you do not have even the basic knowledge of how MAS operates. I would suggest the Data Files class first.

The TRSG is the Technical Reference and Support Guide. It is a CD that comes with all installs of MAS.

 

[BigLouie]

You can upload a receipt of goods and have it post correctly if you include the line index from the PO2 file. MAS files are indexed files and as such you need to have the line index.

 

[SiriusBlackOp]

Thanks for the response BigLouie... I thought this thread was going to get nothing but the sound of chirping crickets. lol.

To answer your questions: I wish that the PO Business object was complete, but apparently it is not due for release for another year or so.

What we have is a third party application that adds a great deal of accuracy to tracking assets and inventory. Our software handles all of the receiving of goods(PO), shipping of goods(SO), and internal warehouse moves(Our System Only) via our code running on wireless WinCE handheld scanning devices. Generally there are a set of integration objects available that would allow us to tell an system like MAS that the items were received or that the items were shipped... but with the PO object incomplete and unavailable I'm forced to look for alternative methods.

In short, we are not developing a 3rd party app... we already have one and we have integrated it to other systems in the past... just never with MAS before.

I'm not sure what the Master Developer Program has to offer us, but I'm willing to give it a second look.

I'll look for the support guide today. Thanks.


I have a feeling that VI will not be adequate for the tasks I have at hand... and I'm not even sure if it is possible without the PO Business Object.

Any Thoughts?


Senior Software Developer

http://www.scoutsft.com

 

[BigLouie]

Well you could always learn ProvideX and write an interface that will write to MAS. Go to

http://www.pvx.com

 

[SiriusBlackOp]

I think I would sooner wait a year for the PO Object and deal with the nightmare that could ensue from writing a ProvideX interface to MAS. I know little of MAS and less of ProvideX. lol. ... Ugh.

Anyway.. you said earlier: "You can upload a receipt of goods and have it post correctly if you include the line index from the PO2 file. MAS files are indexed files and as such you need to have the line index. "

Does this mean that I can completely/correctly receive goods into MAS by inserting new lines into the PO2 table using VI? Our software will have the PO data from MAS... so I should be able to provide the line index.


Senior Software Developer

http://www.scoutsft.com

 

[BigLouie]

If you have an existing purchase order in MAS and you want to import a receipt of goods for that purchase order using VI you would need to have the line index of the item from the PO2 file in your import.

You cannot import into existing PO2 lines, you can only create new ones.

 

[SiriusBlackOp]

That should work for us and will likly be the solution we use.

Thanks a lot for your help BigLouie!

Senior Software Developer

http://www.scoutsft.com

 

[BigLouie]

Here is a tip. You can use ODBC to pull the PO1 and PO2 data into your application if it a common database such as Access, or SQL and then create a table with all the data and then through code in your application call the VI routine and have it read by ODBC your table an run unattended. Someone would have to post it in MAS but it would go in by itself, as if by magic!

 

[SiriusBlackOp]

Ok... Cool!

I'm in process with the integration component (a 2005 VB.NET windows service application) that is going to periodically look for changes in MAS using ODBC. This part is already working an loading data into our 3rd Party Application's SQL DB... so this solution should work.

Can I find the call syntax for VI in the TRSG?

Also... Confused... Can VI directly use an ODBC connection.... we were thinking of having to output to a text file and have VI pick it up, but if VI can use an ODBC connection to SQL then that would obviously be much more efficient, not to mention safe.

Does VI have it’s own language, or does it use a common script language like VBScript?

Senior Software Developer

http://www.scoutsft.com

 

[BigLouie]

Look in the help files for VI for the text.

Yes VI can use ODBC as a data source. do it all the time. VI is written in ProvideX.

For 3.71 the code to run the VI from another application would be:

ChDrive "M"
ChDir "M:\Mas90\HOME"
Shell ("M:\MAS90\HOME\PVXWIN32.EXE ..\LAUNCHER\SOTA.INI ..\SOA\MAS90 -ARG ..\VI\VIWI0F W O DIRECT MANUAL HHA")

For 4.00, 4.05 and 4.10 it would be a bit different but is similar and is detailed in the Help files..

 

[SiriusBlackOp]

Wonderful!!

Thanks once again for all of your help!

Senior Software Developer

http://www.scoutsft.com

 

[BigLouie]

Please note that HHA at the end of the last line is the three digit company code. Manual indicates manual intervention. If you want it to run unattended you would have AUTO.