Dear All,

I 'am trying to upload PO in SSA erp6.1. I have been using session tdpur4100m000( multi- occ. display session) where i press the insert button to move to tdpur4100m900 ( single occ).
I'am using the stpapi.synchronize.dialog option and getting a return value of 1, but at the insert command it gives the error ' editable syn. dialog not started'..
I have gone through the baanboard regarding same error...but that didn't help.

Also there is a point in AFS doc. that for syn. dialog, insert command should be issued to the multi-occ. session while, put command should be issued to the single-occ session. But this also doen't help .

Plz, suggest what can be done in this case.Plz find the attached part of the script.

ret = stpapi.synchronize.dialog("tdpur4100m000", "add", error.msg)
if ret then
stpapi.put.field("tdpur4100m900", "tdpur400.otbp", "S"& tmp40.suno)
stpapi.put.field("tdpur4100m900", "tdpur400.cotp", "P01")
stpapi.put.field("tdpur4100m900", "tdpur400.orno", str$(10))
stpapi.put.field("tdpur4100m900", "tdpur400.cofc", "P01")
|stpapi.put.field("tdpur4100m900", "tdpur400.ddat.segment.1", string.set$("0", 8-len(trim$((str$(tmp40.ddat)))))& trim$(str$(tmp40.ddat)))
| stpapi.put.field("tdpur4100m900", "tdpur400.ddat.segment.2", "0")
| stpapi.put.field("tdpur4100m900", "tdpur400.ddtc.segment.1", string.set$("0", 8-len(trim$((str$(tmp40.ddtc)))))& trim$(str$(tmp40.ddtc)))
| stpapi.put.field("tdpur4100m900", "tdpur400.ddtc.segment.2", "0")

ret = stpapi.insert("tdpur4100m000", true, error.msg)
if not ret then
ret = stpapi.recover("tdpur4100m900", error.msg)
endif
endif
stpapi.get.field("tdpur4100m900", "tdpur400.orno", m.orno)
stpapi.end.session("tdpur4100m900", error.msg)
stpapi.end.session("tdpur4100m000", error.msg)

Dear Sir

pl'z check that wether your AFS Codes support that BaaN Version

and if all fine then pl'z clarify me the problem

Darpan

Why are you using AFS for purchase orders?

The most simple way to create PO is this (to my opinion):

function create.purchase.order(
domain tccom.bpid i.buy.from.bp,
domain tccotp i.order.type,
domain tcitem i.item,
domain tccwar i.warehouse,
domain tcqrd1 i.ordered.quantity,
domain tccuni i.order.unit)
{
long ret.val

db.retry.point()

|* Create PO Header
dal.new.object("tdpur400")
dal.set.field("tdpur400.otbp", i.buy.from.bp)
dal.set.field("tdpur400.cotp", i.order.type)
...
ret.val = dal.save.object("tdpur400")

|* Create PO Line
dal.new.object("tdpur401")
dal.set.field("tdpur401.orno", tdpur400.orno)
dal.set.field("tdpur401.item", i.item)
dal.set.field("tdpur401.qoor", i.ordered.quantity)
dal.set.field("tdpur401.cuqp", i.order.unit)
...
ret.val = dal.save.object("tdpur401")

commit.transaction()
}
Above example is may be too simple. Error handling is not in place. But that can be handled very easily.

Too my opinion AFS is only used to overcome the problem that user interface scripts contains lot of logic. However, since ERP LN 6.1, more and more logic is moved to the dals. Defaulting and disabling / enabling of fields is all part of DAL2. Purchase Orders is completely handled via DAL2. This is enough to generate and/or edit a purchase order.

The things that remain in the user interface are things that are really user interface related as for example: displaying form fields, import fields from other sessions, applying filters, handle zooming to sessions, handling form commands.

Why do you think DAL is better than AFS?

Isn't AFS "safer" ?

- George

When it is not needed anymore to use AFS, why still using it? That's the question.

When a dal is completely DAL2, AFS is not safer. Instead, in that situation an AFS is more complex to use, because you have to skip the user interactions, such as ask.enum, etc., that are (of course) still in the UI.

The session for the "insert" must be "...m900", not "...m000". May be, that ist the reason.

Holger

The sentence more and more functionality is moved to the dal have to be taken serious! It is very depending on the programmer if this is really the case, and for sure it is not yet trustable done!

As you're on LN you can search for a dll wich creates an PO

tdpurdll1234 - Gernerate Purchase Order

Afs does not work on MMT Sessions

regards

Try using the DAL. I don't know how it's with purchase, but in ERP LN 6.1 you can generate sales orders and sales order lines with less and safer code when you use the DAL instead of the AFS.

Uli

You can use dal2 functions also for purchase orders!

Hi,

AFS will not work with Multi Main Table Session. That's why we have to use DALconcept.

Regards,
Sanjay Kathuria

can any body have any documents on DAL script.

yashwant

http://www.baanboard.com/programmers_manual_baanerp_help_functions_dal_overview

it's not the latest one.
DAL 2 functions are not (yet?) described.

Hi,

All functions related to DAL & DAL2 are available in Use SSA ERP LN 6.1 Programming Guide.

Regards,
Sanjay

Hi ,
Is there any solution to upload sales Orders ? This is needed to avoid the entry. User can upload a sales order details with minimum information like BP code ,Order Type , Item code , Quantity .

How to achieve this through DAL ? Has anyone tried this before ?

Thanks
Nilesh

hi...
Can anybody give me the code of the dll tdpurdll1234 or tdslsdll1234 ?

I recommend contacting infor for the code. Any such code posted here will have to be removed.

Thanks