veyant
16th July 2004, 08:29
Hi,

I created an AFS for Sales Order and it is creating Sales orders But the problem is that it is not considering localisation while calculating Net Rate & Line Amount. It is simply calculating Line Amount as - Qty & Base Price.

Well, While working on AFS , it was not inserting quantity and was creating order with 0 quantity. But some how after putting update, it started updating Quantity and i also got the base price updated by some work arround. But now it is not adding Sales Tax / Excise / VAT or Service taxes Amount in Line Amount.

Is there any way after creation of line, i can get the Line Amount & net Rate recalculated to remove the problem.

pls help.
Sandy

SriksAdi
16th July 2004, 08:54
Hi,
Can you send me the series of sessions which are executed manually to achive your functionality.

Let me check if I could help you out.

I am on IS5, there sesms to be lot of difference in IS3 and IS5.



regards
Sriks

veyant
16th July 2004, 09:27
I supplied data thru AFS to following sessions sequentially

1 . tdsls4101m000 - Sales Order Header ----------- successfully created header
2. tdind0270s000 - Extension to Sales Order Header ------ success

3. then called tdsls4105s000 - Maintain Sales Order Lines [ Wholesale]
--- on stpapi.insert - it created lines with 0 quantity. So i again passed quantity by using

stpapi.put.field("tdsls4105s000","tdsls041.oqua",value) followed by
stpapi.update
now it updated the quantity. But it still doesn't picked up price. so i picked up price from tdsls030 and then updated theu SQL to following tables - tdsls041,tdind017,tdsls051,tdind203

Now i called tdind0271s000 - Extension to Sales Lines --- Passed values.

Now i called session tdsls4810m000 - recalculate discount & prices.

Now if i go to New generated sales order and see the line it shows, qty , price correctly. But the Net rate = basic price & Line Amount = qty * basic price.

actually it has not calculated Net Rate by considering sales Tax/ or Other Taxes. If i tab on price and go to tdind0271s000 manually and then just click ok or cancel to come out of session it calculates the Net.Rate correctly.

But i want this thing to be done thru AFS not thru manually go to each line.

pls advice.


thanks
sandy