[Axapta-Knowledge-Village] Grish solution for invoice update of delivery notes

Mon, 30 May 2005 21:57:09 -0700

Title: Message
 
-----Original Message-----
From: Girish Bhatkal [mailto:[EMAIL PROTECTED]
Sent: 24 March 2005 07:51
To: development-axapta@yahoogroups.com
Subject: RE: YNT: [development-axapta] SalesFormLetter_invoice from salespackingslipfor.


Hi Cenk,

I am not sure if the below is the complete solution which you are looking
for. I had sometime back had the same requirement (but for purchase
invoicing) for a client and here is what is suggested and created.
  Their requirement was that they wanted to invoice by delivery note
numbers.
   During invoicing of the Sales order by selecting ALL you will see in the
lines that all the uninvoiced sales lines are displayed. But if you delete
some of the lines/ make the deliver Now quantity of some as zero then only
the lines remaining with no zero qty are invoiced. We can use this to
achieve what we want.

   You create a new table with fields like Sales Id; parmId; packing slip
Id, delivery date and Mark (enum: yes/no). you may need to modify the class
SalesFormLetter/createParmTable . In this method you know the salesId and
you need to select all the Packing Slip Id for the order from
custPackingSlipTrans table and insert these delivery notes in the new table.


Add this new table in the SalesEditLines form/ datasource. Display the
records in a grid in a new tab. Here you could add a button. In the grid all
the delivery notes will be displayed. Now you can mark the ones you want
(put validation to see that the line is not previously invoiced). After
selection is made you click the created button (here you should write the
code to update the deliver Now qty and the validations).

   I am not sure if this would help you. Good luck,

Cheers,
Girish

-----Original Message-----
From: Amit Jain [mailto:[EMAIL PROTECTED]
Sent: 23 March 2005 14:36
To: development-axapta@yahoogroups.com
Subject: Re: YNT: [development-axapta] SalesFormLetter_invoice from
salespackingslipfor.



Hmmmm

yes there is no salestable but salesparmtable or salesparmline. but as you
want to have the quantities also, you can do one thing

add a new field in the salesparmline table and update it during updatenow
method, when salesparmline is updated. Also add a range to the Salesparmline
datasource in the saleseditlines form.

hope it helps


Cenk Ince <[EMAIL PROTECTED]> wrote:


Hi Amit

There is no salestable in saleseditlines form. So i can't join it.
My aim is to bring qty of packingslip to salesparmline.

Thanks.

________________________________

Kimden: Amit Jain [mailto:[EMAIL PROTECTED]
Gönderilmiş: Sal 22.03.2005 14:32
Kime: development-axapta@yahoogroups.com
Konu: RE: [development-axapta] SalesFormLetter_invoice from
salespackingslipfor.





i think you do not require to code this. only thing you have to do is to add
another datasource custPackingSlipJour, in the query in SalesEditLines form,
and link it with the salestable.

You can select the range packingslipid and see the selected records.

Regards

Amit

Gülden Saylan wrote:


Hi,

Yes, it is possible,

You can do it by coding in SalesFormLetter Class.

-----Original Message-----
From: Cenk Ince [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 10:29 AM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] SalesFormLetter_invoice from
salespackingslipfor.



Hi all;

My customer wants it to be possible select some packingslip and directly
invoice it.
But on salestable if i select that salesorder all packing slips not invoiced
comes to saleseditlines form.
My customer wants to select some packingslips from custpackingslip form and
there should be a button like posting/invoice and saleseditlines should be
opened in this way, with quantities of selected packingslips.

Is it possible to do something like this. How can i do this?

Thanks.



[Non-text portions of this message have been removed]







Yahoo! Groups Links













Yahoo! Groups Links









---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!

[Non-text portions of this message have been removed]







Yahoo! Groups Links











[Non-text portions of this message have been removed]







Yahoo! Groups Links








           
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.

[Non-text portions of this message have been removed]







Yahoo! Groups Links













Sharing the knowledge on Axapta.


Yahoo! Groups Links

Reply via email to