If the payment conditions for a customer are the same each time, I could imagine creating two a payment conditions. "Will be deducted from your bankaccount" and "Request payment within X days". Then have payment conditions printed on sales orders and invoices. This would still not print customer bankdetails, but the customer knows his accountnumber so I think that is not a major problem? However, if the same customer one time pays himself and next time will be autodeducted from his bankaccount, this is not going to work. In that case the A/R portfolio will be a heck to handle one way or the other anyway.
BTW I allways try to look at workarounds or solutions that do not require programming or custom script files. That is mainly because I am not a programmer, and external guru's have a tendency to present unpleasant pricetags. If you are a programmer or have resources I suggest you look at the suggestions Steve Doerr made. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Stumbaum, Rainer Sent: vrijdag 5 juli 2002 14:36 To: [EMAIL PROTECTED] Subject: RE: [SL] Data upload customer/sales order Maybe I expressed myself wrongly. The goal is to tell the customer on the invoice-document if either -- he will have to transfer the amount from his bank account to the stated bank account or -- we will deduct the amount from his here stated bank account. So the note will depending on the customer either contain some text and our bank details or some text and his bank details. This works fine in the process: sales order is created within the customer, so the note is copied automatically from the customer to the sales order. From within the sales order the invoice is created, so the note blablabla. Problem now with the data take-on is now, how to create the sales order using the command line interface from within the customer and as well the already in reality existing invoices. Hope it got clear now... Cheers Rainer Stumbaum > -----Original Message----- > From: Dr Default [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 05, 2002 1:34 PM > To: [EMAIL PROTECTED] > Subject: RE: [SL] Data upload customer/sales order > > > There MIGHT be a way to import the notes to payment condition fields, > otherwiese I suggest to NOT import the notes and manually enter the > payment conditions in the proper way, being as a payment condition > rather than as a note? > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of > Rainer Stumbaum > Sent: donderdag 4 juli 2002 22:50 > To: [EMAIL PROTECTED] > Subject: [SL] Data upload customer/sales order > > > Hi, > > unfortunately the customer base I have to upload is > quite big, so I already created the following script > to upload a �-separated file: > --- > #!/bin/sh > USER=bla > PASSWD=blablabla > export IFS=� > cat KundenSQL.csv | while read NAME FIRMA STRASSENO > PSTLZORT LAND CONTACT TELNO FAXNO EMAIL NOTES > do > echo ${NAME} > ./ct.pl > "login=${USER}&path=bin/mozilla&password=${PASSWD}&action=save_c > ustomer&name=${NAME}&addr1=${FIRMA}&addr2=${STRASSENO}&addr3=${P > STLZORT}&addr4=${LAND}&contact=${CONTACT}&phone=${TELNO}&fax=${F > AXNO}&email=${EMAIL}¬es=${NOTES}&taxaccounts=1775&tax_1775=1" > done > --- > This worked out fine, but now I have a problem with > creating the already existing sales orders in SL: > The notes in the customer contain the info on how the > payment has to be done. As soon as I create a sales > order from within the customer this is automatically > copied to the sales order and from there into the > invoice, where it then appears on the printout. This > actually means I have to modify my script so it not > only creates the customer, but within the same process > as well creates the salesorder with maybe more than > one line item. > > Has anyone done this before??? > I am a little bit stuck right now... > > Best regards > Rainer Stumbaum > > > __________________________________________________________________ > > Gesendet von Yahoo! Mail - http://mail.yahoo.de > Yahoo! pr�sentiert als offizieller Sponsor das Fu�ball-Highlight des > Jahres: - http://www.FIFAworldcup.com > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Caffeinated soap. No kidding. > http://thinkgeek.com/sf > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Bringing you mounds of caffeinated joy. http://thinkgeek.com/sf > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Bringing you mounds of caffeinated joy. http://thinkgeek.com/sf ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Got root? We do. http://thinkgeek.com/sf
