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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VI\Sales Order\Totals 1

Status
Not open for further replies.

burokio

Programmer
Feb 10, 2003
13
UA
I am trying to import a CSV file to the MAS 90 SO.ORDER table and I am stuck with Totals Salels Order information.
It seems that line items are imported correctly and when I open an imported SO Total Amount is shown correctly on the Line Items tab. But when I open the "Totals" tab "Taxable Amount", "Non taxable amount" and "Net Order" fields are empty (contain zero ammounts).

How should I populate these fields? Can MAS 90 populate these fields for me? Is it possible that I am missing some "perform" logic in my import job?
 
There are two job perform logic. Manual and Calc. With Manual VI expects you to give it the totals, with Calc VI will do the calculation. On the main panel of the job click on Perfom. You should see this if you want VI to calculate the totals.

../so/sowvip;SO_ORDER_CALC

If it is ../so/sowvip;SO_ORDER_MANUAL then you would need to change.
 
Thank you!
Changing perform to "_CALC" solved the isssue.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top