Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with Creating Sales Invoice from VI in MAS90 4.10

Status
Not open for further replies.
Aug 15, 2007
29
PK
Hello all,

I am creating a Sales Invoice using Visual Integrator(VI) in MAS90 but when i tried to import job (in some items) it is giving me an error
"All lines have not been distributed".

After doing an R&D i have found out that the main problem is that it keeps a record of distributed items in "SO_InvoiceTierDistribution".
I think first of all i have to import items and then execute a job of Distribution but the main problem is HOW can i do it because it is not importing the items?

Can anyone tell me the solution for this problem?
 
You can work with your reseller. If you have to ask this question you need a LOT more class room work on MAS data files and VI.

When you sell Lot or Serial items, when you create an invoice, you need to distribute the items. That is enter the lot or serial number before you can do anything. Currently there is NO logic within VI to distribute lot or serial even if you have it as part of your import file. With the Bar Code module you can import a file into Invoice Data Entry with a lot or serial number as part of the file and it will distribute to the right file. If you wanted to import you would need to extract the line index from the invoice line detail file and build a file for import into SO_InvoiceTierDistribution because the line index is the only link between the two.
 
Hello all,

The problem that i am facing is that i made a Customer Export job and tested it manually.It is running fine.But when i tried to call this job by writing its credendials that are as follows by making the shortcut of pvxwin32.com

"C:\Program Files\Sage Software\MAS 90\Version4\MAS90\Home\pvxwin32.exe" ..\LAUNCHER\SOTAPGM.INI ..\SOA\STARTUP.M4P -ARG DIRECT UION salman 123 ABC VIWX08 AUTO

then it is not executing however if change AUTO to Manual then its execution Window appears infront of me.
However,I have also made and called some other jobs of items,vendors but i don't found any problem in them but with customer it is creating problem.


Waiting for ur response
Reagards
 
Exporting with VI is the LEAST prefered method of extracting information. It is the slowest and hardest. Most people use Access, SQL or Excel to pull the data. Faster and easier.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top